ora9i =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = of18.orafact.com)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ora9i.of18.orafact.com)
)
)
................. to check tnswroking properly or not
[ora9i@of18 admin]$ tnsping ora9i
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 01-JUL-2008 14:36:45
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = of18.orafact.com)(PORT = 1523))) (CONNECT_DATA = (SERVICE_NAME = ora9i.of18.orafact.com)))
OK (30 msec)
................................................................................
note using netca we can configure the tnsnames.ora ....
listener.ora file
ora9i =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora9i.of18.orafact.com)
(ORACLE_HOME = /ora3/ora9i/9.2.0.4)
(SID_NAME = ora9i)
)
(SID_DESC =
(GLOBAL_DBNAME = ora9i.of18.orafact.com)
(ORACLE_HOME = /ora3/ora9i/10.2.0.4)
(SID_NAME = ora9i)
)
)
ora9i =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = of18.orafact.com)(PORT = 1523))
)
....................................................................................
The major diffferences are-
1.In 9i merge , insert all, case is introduced .
2.In 9i newdatatype called timestamp
3.In 9i you can moniter index using alter index
or
u can check user_objects table from system user.
4.In 9i new performance monitering tools called STATPACK .
5.In 9i You can dynamically change init ora parameter using alter system
6.In 9i new concept for undo transaction called UNDO tablespace
7.In 9i by default TEMP tablespace is considering while creating new oracle users (if we create default temporary tablespace is created it automatically allocated)
8.In 9i new partition called LIST
9.In 9i tablespace next extent can be managed automatically (extent managment local)
10. In 8i tablespace extent management dictionary by default
11.The biggest difference between Oracle8i and Oracle9i is that Oracle9i lets You resize the SGA memory areas dynamically i.e., the Database Buffer Cache DB_CACHE_SIZE or the SHARED_POOL_SIZE, etc., can be resized when the database is up and running. The same is not possible with Oracle8i. You can get more information from OTN
12. You can drop a column in oracle 9i using alter table command where as this is not available in oracle 8i
1) u have automatic undo management.
2)u have automatic segment space management
3)u got these locally managed tablespaces which is better than the dictionary managed tabespaces as u can avoid fragmentation with locally managed tablespaces.
4)u have a new dbms_metadata package to extract object definitions from database.
5)multi table insert is possible with 9i
6)importanly u have this spfile in 9i.
7) also u have dynamic memory mangement facility with 9i.
8) u have tuning advisories with 9i.
9) u have multi block size parameter with 9i and many more features like these..
10. Reduce segment header contention and wasted space within blocks by switching from using FreeLists to Automatic Segment Free Space Management.
11. Replace you existing rollback segments with self-tuning undo segments.
12. Oracle9i Data Guard is the new name for Oracle8i Standby Database incorporating a large number of new features.
..... http://www.oracle-base.com/articles/9i/DataGuard.php ...........
1. What are the scripts do you use while Apps Cloning?
adpreclone.pl prepares the source system to be cloned by collecting information about the database and creating generic templates of files containing source specific hardcoded values. Its location is $COMMON_TOP/ admin/scripts/ contextname/
adcfgclone.pl creates the new context file used to configure the target system.
2. What is Patch?
Patch is a program which fixes the bug. ÂÂ
3. Apps11i Post-Installation steps?
1) Shutdown all Oracle Application Processes
2) Apply Inter-Operability Patch(3830807)
3) Apply Discoverer Patch(3170128)
4) Relink all Oracle Appications executables
5) Restart Oracle Application Processes
4. Apps11i Post Cloning steps?
1)Update the profile options
2)Update the printer settings
3)Update workflow configuration settings
4)Verify APPLCSF variable
5)Update session_cookie_ domain in icx_parameter table
5. Types of Patches?
o One-off patch: This is the simplest type of patch. It is created to resolve a specific bug.
o Minipack patch: This is a collection of one-off patches and enhancements related to a particular module. Alphabetic characters denote the Minipack version for the module; for example, the product code for the Application DBA utilities is AD, and version Minipack I of this product would be called AD.I
o Family Pack patch: This is a collection of Minipack patches for a particular family group of application modules. Alphabetic characters denote the Family Pack version; for example, the J version of the Human Resources Suite Product Family would be HR_PF.J
o Maintenance Pack patch: This is a collection of Family Packs that serves as a point-level release upgrade; Oracle Applications Release 11.5.10 is an example of a Maintenance Pack.
6. Contents of a Patch?
Readme files
Driver files
Metadata files
Replacement files
7. Modes of Patching?
Test mode (apply=n), With the Test mode, we can see the effects applying the patch will have on your system before applying the patch.
Pre-install mode (preinstall= y), Pre-install mode of Autopatch is used when the version of Oracle Applications AutoPatch works with is different than the version of Oracle Applications in the database. We use this mode during upgrade process.
Non-interactive mode (adpatch defaultsfile= $APPL_TOP/ admin/
8. What are the drivers present in patching?
C driver copies the files and links executables
D driver runs the SQL scripts and programs that updates the database
G driver generates the forms, reports and message files
U driver is a consolidated driver containing all copy, database, and generate actions
9. Options of adpatch?
Novalidate
Prevents adpatch from validating all schema connections
Noprereq
Prevents adpatch from checking the existence of prerequisite patches
Nocompiledb
Prevents adpatch from compiling database objects
Nocompilejsp
Prevents adpatch from compiling JSP objects
Noautoconfig
Prevents adpatch from running autoconfig after the patch has been completed
Nogenerateportion
Prevents adpatch from compiling forms, menus, and plls
Hidepw
Prevents passwords from being displayed in log files
Hotpatch
Allows adpatch to be run when the instance is not in maintenance mode
10. Minipack naming convention?
11i.
11. Maintenance pack naming convention?
11.5.1, 11.5.2, 11.5.3
12. Family pack naming convention?
11i.
13. Difference between adpatch and Opatch?
adpatch is utility to apply Oracle Application Patches
opatch is utility to apply Database Patches
14. What is the prerequisite to apply Opatch?
Database should be down
15. What do you do if patch fails?
Review log file(s) to determine the cause of the error
Fix the cause of the error
Restart adpatch
Answer 'Yes' when adpatch asks if you want to continue the previous session
Adpatch will skip already completed jobs, and pick up from where it left off.
16. How to apply a pre-requisite patch when adpatch is running?
Shut down the workers using adctrl
Backup FND_INSTALL_ PROCESSES, AD_DEFERRED_ JOBS, restart files(.rf9)
Then, drop the above tables, restart files and apply the pre-requisite patch.
Restore the two tables and restart files from backup & run the adpatch.
17. If you know that the patch has been applied previously but patch is asking you to apply the existing patch as a pre-requisite?
adpatch options=noprereq
18. While applying Apps patch using adpatch, if you want to hide the apps password, how will that be possible ?
Use adpatch flags=hidepw while applying patches in apps to hide apps or system password being displayed on Users Screen.
19. How do you reduce patch timings?
Merging patches via admrgpch
Use various adpatch options like nocompiledb or nocompilejsp
Use defaults file
20. How you put Applications 11i in Maintenance mode ?
Use adadmin to change Maintenance mode in Oracle Apps. With AD.I you need to enable maintenance mode in order to apply apps patch via adpatch utility. If you don't want to put apps in maintenance mode you can use adpatch options=hotpatch feature.
21. How do you know that a patch has been applied?
Navigate to sitemap > patches patchhistory
(or)
Query AD_BUGS or AD_APPLIED_PATCHES
22. How do you find out which drivers have been applied?
Query the ad_patch_drivers;
23. How do you find out what patches have been applied on database?
$ opatch lsinventory
24. How to rollback the opatch?
opatch rollback
25. How to apply the patch?
opatch apply
26. How to go for the help on Opatch?
opatch help
27. Location of Patch History files?
$APPL_TOP/admin/ SID/javaupdates
$APPL_TOP/admin/ SID/adpsv
28. Where do you find adpatch log files ?
Patch log files will be in directory $APPL_TOP/admin/ SID/log
like adpatchXXX.log ( file name you mentioned while patching ), adworkXXX.log for worker log files
29. Location of Adpatch default logfile location?
$APPL_TOP/install/ log
30. Location of APPS password?
$IAS_ORACLE_ HOME/Apache/ modplsql/ cfg/wdbsvr. app
(or)
$8.0.6 ORACLE_HOME/ report60/ server/CGIcmd. dat
31. How do you know whether ur system is autoconfing enabled or not?
Run adcfginfo.sh contextfile= $APPL_TOP/ admin/contextnam e.xml
32. How do you determine whether your system is Rapid Clone enabled?
First, verify that your system is AutoConfig enabled. Then, Verify that the latest Rapid Clone Patch has been applied or not
33. If I have 5 databases, is it possible to point only to 1 bdump?
Keep the same location in 'background_ dump_dest' parameter for 5 databases in pfiles
34. How to retrieve recent files?
ls -ltr
35. How do you know the kernel version?
uname -r
36. Contents of pfile?
db_name
background_dump_ dest
user_dump_dest
core_dump_dest
control_files
undo_management
compatible
db_block_size
db_cache_size
db_domain
global_names
instance_name
max_dump_file_ size
remote_login_ passwordfile
service_names
shared_pool_ size
37. Contents of controlfile?
Database name & Identifier
Timestamp of database creation
Tablespace names
Names & locations of datafiles and redolog files
Current redolog file sequence number
Checkpoint information
Begin & end of undo segments
Redo log archive information
Backup information
38. Why do you set Kernel parameters?
Oracle uses UNIX resources such as shared memory, swap space and semaphores for interprocess communication.
So we modify the Kernel parameters in /proc/sys/kernel. To setup these parameters permanently is use /etc/sysctl. conf file.
If your Kernel parameter settings are insufficient for Oracle, you will experience problems during installation and/or instance startup.
39. What is the purpose of find?
if you are in present directory, how do you find? f ind .-name
if you are not in present directory, how do you find? find -name
40. How to enable a new language?
Through License Manager
41. How do you take backup in LINUX?
By using tar or cp or cpio
42. What is Generic Service Management(GSM) ?
GSM is an extension of concurrent processing which provides a powerful framework for managing processes on multiple host machines.
43. How to find out the version of a FORM?
f60gen------ --------- ---for FORM version
44. How do you find out if Form Server is running or not?
ps -ef |grep f60webmx
45. What is the Forms Server executable name?
f60srvm
46. What if the Form Server is slow?
Bounce the server
47. How to confirm if Report Server is Up & Running ?
ps -ef | grep rwmts60
48. What are Materialized views?
Materialized views are schema objects that can be used to summarize and distribute data.
49. What is deadlock?
When two processes waiting to update the rows of a table which are locked by an other process, then deadlock arises.
50. How do you create the user?
Navigate to Security-->user-->define
51. How do you delete an existing user in the applications?
Applications users cannot be deleted since records belonging to users are kept for security and monitoring purposes. The only thing to do is to invalidate the user by
assigning an end date to the effective period for the user.
Navigating path: Security -> User -> Define
52. How do you delete a responsibility from Oracle Applications?
Responsibilities cannot be deleted since those records are kept for security and monitoring purposes. However, responsibilities can be disabled by assigning an end date to the effective period
53. How do you tell what products are installed within Applications?
This information can be accessed within Applications from the Alert Manager Responsibility. Navigation Path: System--> Installations
54. What is Concurrent Manager?
Concurrent Manager is a program or process manager on application db server, that coordinates the concurrent processes generated by user’s concurrent requests.
55. What is Standard manager?
Standard manager is the default manager which accepts all kinds of requests. It has no predefined specialization rules and is active all the time.
56. What is Transaction manager?
A Transaction manager is started on concurrent processing server and periodically reads the pipe (concatenation of Application tier and Database tier) for incoming transactions. It occurs only in 11i RAC configuration.
57. What is ICM?
ICM is the manager which controls other managers. If it finds other managers down , it checks & try to restart them.
58. What is Confict Resolution Manager?
CRM resolves conflicts such as request incompatabilities.
59. What is incompatability with Concurrent request?
When a concurrent request is being processed and another concurrent manager is trying to process same type of request, there is an incompatability with concurrent request and is resolved by Conflict Resolution Manager.
60. How to start/stop the Concurrent Manager?
adcmctl.sh start/stop
(or)
$FND_TOP/bin/ startmgr
61. How do you define a Concurrent Manager?
Navigate to Manager --> Define
62. How do you check the current status of manager processes at OS level?
$FND_TOP/sql/ afcmstat. sql
63. How do you know whether Concurrent Manager is running or not?
ps -ef |grep FNDLIBR
64. Where do you see the requests?
Query the FND_CONCURRENT_ REQUESTS
65. How do you know whether Listener is up or not?
ps -ef |grep FNDFS
66. If Concurrent manager is not getting up, what might be the problem?
Apps Listener is not up
67. How do you determine whether the standard managers are up?
ps -ef |grep FNDLIBR (or)$FND_TOP/ sql/afimchk. sql
68. What happens, if Conflict Resolution Manager is down?
ICM will take over the jobs of CRM
69. If ICM is down, what happens?
All the other managers will keep working. ICM takes care of the queue control requests, which means starting up and shutting down other concurrent managers.
70. What happens if user kills ICM?
Applications will be down
71. What is PMON cycle? This is the number of sleep cycles that the ICM waits between the time it checks for concurrent managers failures, which defaults to 20. You should change the PMON cycle to a number lower than 20 if your concurrent managers are having problems with abnormal terminations.
72. What is Queue Size? The queue size is the number of PMON cycles that the ICM waits between checking for disabled or new concurrent managers. The default for queue size of one PMON cycle should be used.
73. What is Sleep Time? The sleep time parameter indicates the seconds that the ICM should wait between checking for requests that are waiting to run. The default sleep time is 60, but you can lower this number if you see you have a lot of request waiting (Pending/Normal) . However, reducing this number to a very low value many cause excessive cpu utilization.
74. Location of AutoConfig template files and its use?
AutoConfig uses template files to determine the basic settings that are needed. Its location is prod_top/admin/ template
75. What is Auto Config? How does AutoConfig know which value from the XML file needs to be put in which file?
Auto Config is a configuration tool that supports automated configuration of an Oracle Application file system. All of the information required for configuring an Applications file system is collected into a central repository, called the Applications Context; there is one Applications Context for each application tier, and one for the database tier. When you run AutoConfig, it reads the XML files and creates all the AutoConfig managed configuration files. For each configuration file maintained by AutoConfig, there exists a template file which determines which values to pick from the XML file.
76. How do you change the port values?
Port values can be changed in the context file with the help of ContextEditor and running AutoConfig.
Navigate to Sitemap > Context Editor
77. What is Snapshot?
Snapshot gives a picture of selected Application related files in a given APPL_TOP
78. Location of Snapshot Information? $APPL_TOP/admin/ SID/out/snapdnld .txt
AD_SNAPSHOT, AD_SNAPSHOT_ FILES, AD_SNAPSHOT_ BUGFIXES
79. What is the runaway process in CPU?
The process to which the memory assigned is not released is known as runaway process.
80. What is dbclone?
Creating same structure of existing database.
81. How do you know that you are in DbTier or AppsTier?
Through XML file, If DbTier=yes, you are in DbTier
82. How do you know the database has invalid objects?
Select * from dba_objects where status like 'invalid';
83. How do you compile invalid objects?
By running 'Validate APPS Schema' task in adadmin
(or)
Run utlrp.sql. Its location is $ORACLE_HOME/ rdbms/admin
84. Location of Apache logs?
$IAS_ORACLE_ HOME/Apache/ Apache/log
85. Why do you run catalog.sql, catproc.sql, pupbld.sql?
catalog.sql creates views and synonyms on data dictionary
Its location is $ORACLE_HOME/ rdbms/admin
catproc.sql creates the PL/SQL procedures and packages
Its location is $ORACLE_HOME/ rdbms/admin
pupbld.sql creates the product and user profile tables
Its location is $ORACLE_HOME/ sqlplus/admin
86. How do you drop the user including contents?
Drop user XXX cascade;
87. What is use InterOperability Patch?
We apply this patch for the compatability between OS and Oracle
88. How do you know the database growth?
Query dba_free_space
dba_segments
dba_extents
89. In which mode do you up the database after creating control file?
startup mount
90. What happens when you give ALTER tablespace begin backup?
Datafile headers will be freezed.
Undo information will be written into redo log files.
91. What if the database got crashed after giving ALTER tablespace xxx begin backup?
Startup the database in mount mode and give the command ALTER tablespace xxx end backup
92. When you kill a particular process id, it is again restarted. How to solve it?
Kill the parent process by this command
pkill pid
93. How do you findout the installation is single-node or multi-node?
adconfig.txt- --------- --------- ->$APPL_TOP/admin
(or)
Query FND_NODES
94. How to find Apache (web server) is running or not?
ps -ef | grep httpd.conf
95. If Apache is getting problems, which files do you look for to trouble shoot?
$IAS_ORACLE_ HOME/Apache/ Apache/conf/httpd.conf
$ IAS_ORACLE_HOME/ Apache/Jserv/ etc/jserv.properties
96. Location of HTML Cache in Oracle Applications?
$OA_HTML/_pages
97. Location of PL/SQL Cache in Oracle Applications?
$IAS_ORACLE_ HOME/Apache/ modplsql/ cache
98. How do you restart the Discoverer in Oracle Applications 11i?
addisctl.sh start
(or)
$ORACLE_HOME/ discwb4/util/ startall. sh
99. Location of audit traces?
$ORACLE_HOME/ rdbms/audit
100. What is the use of adutconf.sql?
adutconf.sql reports standard information about the installed configuration of Oracle Applications
101. How do you know the Jinitiator version?
Under $COMMON_TOP/ html/bin/ appsweb_SID_ HOSTNAME. cfg, search for entry like jinit_ver_name
(or)
Under $FND-TOP/resource/ appsweb_SID_ HOSTNAME. cfg, search for entry like jinit_ver_name
102. How to find opatch Version ?
$ORACLE_HOME/ OPatch/opatch version
103. How to find out database version?
select * from v$version;
104. How do you know the OUI version?
$IAS_ORACLE_ HOME/appsoui/ oui/oraparam. ini
(or)
grep -i version oraparam.ini
105. How do you the Apache version?
Type sqlplus after connecting to $IAS_ORACLE_ HOME
106. How do you find out the status and process id of the adworkers? ps –ef |grep adworker
107. How do you connect to RMAN?
rman target system/manager@ SID-----To connect remotely
rman target / ------------ --------- -------To connect globally
108. When you run the convert character set, adadmin creates 3 files in the APPL_TOP/admin/ SID/out. What are they?
admanifest_excp. lst
admanifest.lst
admanifest_lossy. lst
109. Location of Non-OAM context editor wizard?
COMMON_TOP/util/ editcontext- --------- --------- -----Application Tier
RDBMS_ORACLE_ HOME/appsutil/ editcontext- ----Database Tier
110. How to lock/unlock the scott/tiger account?
alter user scott account lock/unlock
111. Diff. between sys and system?
Sys owns data dictionary views
System owns the objects owned by oracle utilities
112. Diff. between sys and sysoper?
Sysoper can take backup of controlfile
Sys can take full backup of database
113. How to create a user through command prompt?
useradd -g groupname -d directory -p password username
114. What is softlink or hardlink?
A softlink is a file that points to another file. Syntax: ln -s filename linkname
A hardlink is a pathname that references an inode Syntax: ln filename linkname
115. How do you maintain multiple databases with single instance?
By sourcing the environment variables
116. What happens when you give commit statement?
Server process records the SCN & commit record in the redo log buffer
LGWR writes the redo log buffer entries & the SCN to redo log files
Oracle notifies the user that the commit is completed
Server process records that the transaction is completed & that the resource lock can be released
117. Multiplexing the controlfile using SPfile
Alter system set control_files= location
Shutdown the database
Create additional controlfiles
Startup the database
118. Multiplexing the controlfile using Pfile
Shutdown the database
Copy the existing controlfiles to a newname and location
Add the new controlfile name to pfile
Startup the database
119. Multiplexing the Redo log files?
If the log file is current, perform logswitch by using ALTER SYSTEM SWITCH LOGFILE
Copy the redolog file to the new location
Use ALTER DATABASE RENAME FILE xxx TO xxx to make the change in control files.
120. What are the storage clauses do you specify?
local, uniform, autoextend, dictionary
121. How to find out the file version?
adident Header
122. How do you mount the directories through NFS?
mount -t nfs hostname:source destination
123. How to recover clone data?
Recover database until cancel
124. What is the utility to upgrade from one version to another version?
dbua
125. Contents of APPL_TOP?
environment files and products
126. What does APPLCSF mean?
$COMMON_TOP/ admin
127. How to change the APPLTMP, APPLPTMP?
utl_file_dir should be edited in pfile
128. How do you know the product versions, patchset levels?
$AD_TOP/sql/ adutconf. lst
(or)
Query PRODUCT_COMPONENT_ VERSION table.
129. Location of JAR files?
$PROD_TOP/java/ jar------ --------- --------- --------- ----APPL_ TOP
$JAVA_TOP/oracle/ apps/
130. Location of US directory?
$APPL_TOP/au/ 11.5.0/reports/ us
131. What happens when you give open resetlogs?
log sequence no. will be reset
132. How do you know that the particular datafile belongs to particular tablespace?
Query v$tablespace, v$datafile
133. If .dbc file is corrupted, what happens? and What should you do?
autoconfig should be run
134. What are AutoPatch Restart files?
Restart files store information about completed processing in the event of a patch or system failure. They allow AutoPatch, AutoUpgrade, and AD Administration to continue processing at the point where they stopped. Its location is $APPL_TOP/admin/
135. How to check whether all the processes are running or not?
ps -ef |grep smon
136. How do you know which user has which privileges?
$DBA_SYS_PRIVS
137. How do you create Applications Context file?
Run $AD_TOP/bin/ adbldxml. sh, after sourcing APPL_TOP & ORACLE_HOME environment files.
Then, the following values will be prompted for
ORACLE_SID used to connect to database
Full path to the Rapid Install Configuration file
Full path to the JDK 1.3.1 installation
138. What is OraInventory?
The OraInventory stores information about all oracle software products installed in all ORACLE_HOMES and other non-oracle products such as the Java Runtime Environment( JRE). The location of the OraInventory is /etc/oraInst. loc which points the location of Global Inventory.
139. What is XML oraInventory?
Starting with OUI 2.x and 11.5.8, the informatio in the inventory is stored in Extensible Markup Language(XML) format. The XML format allows for easier diagnosis of problems and faster loading of data. The inventory is XML if the following file exists $ORACLE_HOME/ inventory/ ContextXML/ comps.xml Unlike the binary OraInventory, the XML inventory is divided into 2 distinct components.
Global Inventory or Central Inventory Local Inventory or Home Inventory
140. What is Global Inventory?
The Global Inventory is the part of the XML inventory that contains the high level list of all Oracle products installed on a machine. The Global Inventory records the physical location of Oracle products installed on the machine, such as ORACLE_HOME( RDBMS and IAS) or JRE. It does not have any information about the detail of patches applied to each ORACLE_HOMEs. The Global Inventory gets updated everytime you install or de-install an ORACLE_HOME.
Note: If you need to delete and ORACLE_HOME, you should always do it through the OUI de-installer in order to keep the Global Inventory synchronized.
141. What is Local Inventory? There is one Local Inventory per ORACLE_HOME. It is physically located inside the ORACLE_HOME at $ORACLE_HOME/ inventory and contains the detail of the patch level for that ORACLE_HOME. The Local Inventory gets updated whenever a patch is applied to the ORACLE_HOME, using OUI.
142. What does OUISetup.pl do? OUISetup.pl is included with the OUI patch, listed as a pre-requisite to Rapid Clone. It should be run as part of the OUI Patch installation and performs the following tasks: Register the OUI program in the Global Inventory
Register the JRE in the Global Inventory
Ensures that the ORACLE_HOME in which the patch is installed is properly registered in the Global Inventory.
143. How do you determine if your system is autoconfig enabled or not?
Run adcfginfo.sh contextfile= context
144. How do you determine if your system is Rapid Clone enabled or not?
First, verify that your system is AutoConfig enabled. Then, verify if latest Rapid Clone Patch has been applied.
145. Can you clone a multinode system to a singlenode system?
You can use Rapid Clone to merge multiple APPL_TOP and COMMON_TOP file systems into a single APPL_TOP and COMMON_TOP file system.
146. How does adcfgclone.pl know the target system values?
adcfgclone.pl will prompt for the values required to create the new context file used to configure the target system.
PROMPTS:
Database SID
Domain name
Prompts specific to the DBTier
Target system database name
RDBMS ORACLE_HOME directory
DATA_TOP path
Prompts specific to the AppsTier
Database server node
Does the target system have more than one applications tier server node(Y/N)?
Is the target system APPL_TOP divided into multiple mount points(Y/N)?
APPL_TOP mountpoint
COMMON_TOP directory
8.0.6 ORACLE_HOME directory
IAS ORACLE HOME directory
Location of JDK1.3.1
Prompts common to DB and AppsTier
Port Pool Number [0-99]
147. What is Port Pool?
The Port Pool provides a way to use a set of predefined server ports. There are 100 port pools.
Port Name Default port numubers
Web Listener Port 8000
Database Port 1521
RPC Port 1626
Reports Port 7000
Metric Server Data Port 9100
JTF Fulfillment Server Port 9300
148. What is .dbc file? and its contents? How do applications know the name of the dbc file?
dbc stands for database connect descriptor file used to connect to database.
Whenever java or any other program like forms want to connect to database, its uses dbc file. The application knows the name of the DBC file by using profile option "Applications Database Id"
Contents of dbc file:
GUEST_USER_PWD
DB_NAME
DB_HOST DB_PORT Location: $FND_TOP/secure
149. How to compile JSP in Oracle Applications?
Run ojspCompile. pl script
Location: $JTF_TOP/admin/ scripts
150. What is Web Listener?
Web Listener is web server listener which is listening for web services (HTTP) request. This listener is started by adapcctl.sh
151. What are the development technologies?
Java, D2K, HTML
152. How do you restart the installation?
rapidwiz -restart
153. Documents to be referred for installation?
Installation guide
Update Release notes
154. How do you set the path of /etc/oraInst. loc when it is not present and you dont have root access?
run ./rapidwiz -inventory_loc= 'location'
155. How to verify whether java is installed or not?
which java
156. How to findout the java version?
java -version
157. How to check whether the packages are available or not?
rpm -qa |grep ar/make/qa
158. Do you have to install JDK on all systems, when you are doing multinode installation?
Yes, mandatory
159. Location of installation log files?
$ORACLE_HOME/ appsutil/ log/contextname- --------- ---> on database
$APPL_TOP/admin/ contextname/ log------ --------- --------- -->on application
160. By using FNDCPASS, whose passwords can be changed?
Oracle------ ---Database tier
System------ --Application tier
User-------- ---Oracle user
161. How do you switch the logfile?
alter system switch logfile
162. How to force the checkpoint?
By setting FAST_START_MTTR_ TARGET parameter
(or)
alter system checkpoint
163. What is the purpose of adcfginfo.sh?
It shows whether the system is autoconfig enabled or not.
Location: $AD_TOP/bin
164. What is the difference between apps schema, applsys schema, applsyspub schema?
Apps schema contains only synonyms for other modules
Applsys schema contains all the fnd tables, administration schema
Applsyspub is the gateway to login to the application
165. Parameters regarding the performance tuning?
audit_trail= true
timed_statistics= true
max_dump_file_ size=10240
166. Why do you use scope=spfile, memory and both?
MEMORY: Set for the current instance only. This is the default behaviour if a PFILE was used at STARTUP
SPFILE: update the SPFILE, the parameter will take effect with next database startup
BOTH: affect the current instance and persist to the SPFILE. This is the default behaviour if an SPFILE was used at STARTUP
167. Steps to apply Patchset?
Patchset includes bugfixes for 9.2.0.4 – 9.2.0.6
1)Unzip the patchset in /stage directory and run the runInstaller
2)Select the 10G OUI and again run the runInstaller
3)Select patchset
4)Startup migrate
5)Run the script catpatch.sql
168. What is Shared Server?
In Shared Server environment, the server process handles the request of several user processes.
169. How to enable Shared Server?
Two parameters should be set in pfile.
shared_server= no. of predefined server processes
dispatchers= protocol of dispatcher and no. of dispatchers
Then, tnsnames.ora should be modified
170. What is Cost based optimization?
Cost based optimization is used to identify the shortest way to execute and retrieve data from an object
171. How do you change the database name?
Change SID in controlfile and parameterfile
In controlfile, set dbname=xxx, reuse=xxx
172. Difference between 8i and 9i?
In Oracle9i, DB_CACHE_SIZE or SHARED_POOL_ SIZE can be resized when the database is up and running. It is not possible with Oracle8i.
Time stamp facility is available in 9i whereas it is not available in 8i
You can drop a column in oracle 9i using alter table command where as this is not available in oracle 8i
In 9i, we call undo segments whereas rollback segments in 8i
173. What is Explain Plan?
Explain Plan parses a query and records the "plan" that Oracle devises to execute it. By examining this plan, you can findout if Oracle is picking the right indexes and joining your tables in the most efficient manner.
@?/rdbms/admin/ utlxplan. sql script will create the PLAN_TABLE
174. What is the use of utlrp.sql?
This script compiles the invalid PL/SQL modules. Its locations is $ORACLE_HOME/ rdbms/admin
175. Which initialization parameters do you set to effect the SGA size?
shared _pool_size
db_block_size
db_cache_size
log_buffer
176. Which parameters in pfile effect the database?
db_name
db_block_size
control_files
177. Tasks of Adadmin?
1. Generating Applications files
2. Maintaining the Applications database objects
3. Maintaing Applications files
178. AD Administration Prompts?
Is this the correct APPL_TOP [Yes]?
Logfile name [adadmin.log]
Email feature [No]
Batch size [1000]
Is this the correct database [Yes]?
Enter the password for 'SYSTEM' ORACLE schema:
Enter the password for APPLSYS schema
179. Ad Administration Preliminary Tasks?
Run the environment file
Verify the ORACLE_HOME is set properly
Verify the TWO_TASK identifies the correct database
Ensure that ORACLE_HOME/ bin and AD_TOP/bin are in path
Shutdown the concurrent managers when relinking
Ensure sufficient temporary disk space
Note: The temporary directories APPLTMP, APPLPTMP, REPORT60_TMP and the OS temporary directories, /tmp, /usr/tmp must each have atlease 50MB of free space
180. When do you run Relink Application Programs task in AdAdmin?
Run the Relink Application Programs after
Installing a new version of the database or a technology stack component
Installing another underlying technology component that Oracle Applications rely on
Applying a patch to the Applications technology stack
Applying a patch to the OS
Including a new or changed third party or custom code into Applications programs
181. What is the pre-requisite before running the 'Convert to Multiple Reporting Currencies' task in Ad Administration?
Always run the 'Validate APPS Schema' task before running the convert to MRC task
182. How do you know database version? Select * from v$sys.version
183. What is Password file?
Password file is created on a server side to store valid users and password. It is used for validating users and their passwords.
184. Purpose of Undo segments? Undo segment is used to save the old value when a process changes data in a database.
185. How many undo tablespaces should be there? We can have any no. of tablespaces but only one should be active.
186. Where does redo log information store?
In memory area
187. Explain the difference between a hot backup and a cold backup?
We take hot backup when database is up and running and it must be in archivelog mode. We take cold backup while database is shutdown and it doesnt need to be in archive log mode.
188. What is admrgpch?
It merges multiple patches into a single, integrated patch.
189. What is adadmin? It performs maitenance tasks on the Oracle Applications file system and database
190. What is adpatch? It applies patches and adds new languages and products.
191. What is adaimgr?
It upgrades to the latest version of Oracle Applications
192. What is adctrl?
It manages parellel workers in Autoupgrade, ADAdministration and AutoPatch
193. What is adrelink?
It relinks Oracle Applications executable programs with the Oracle Server Product Libraries
194. What is adsplice?
It registers off-cycle products
195. How do you determine howmuch virtual memory is being utilized?
Run the vmstat command
196. How to know which process is consuming more CPU resources?
Run the top command
197. How do you determine the blocklevel utilisation?
Run the iostat command
198. What for do you use the 'netstat' command?
Netstat reports on the contents of network data structures
199. How do you increase the datafile size?
By using ALTER DATABASE DATAFILE xxx RESIZE n
200. How do you bring datafile offline?
By using ALTER DATABASE DATAFILE xxx OFFLINE
201. Do we need to close the window after installing Jinitiator?
No need, if Internet Explorer is used
Need to be closed, if Netscape is used
202. Whats is difference between two env files in
APPS
203. What are main configuration files in Web Server (Apache)?
httpd.conf, jserv.conf, wdbsvr.app
204. What are various components in Application/ Middle Tier?
Web Server, Forms Server , Reports Server, Concurrent Manager, Admin Server & Discoverer Server.
205. What is Maintenance Mode?
Maintenance Mode is a new mode of operation introduced with Release 11.5.10, in which the Oracle Applications system is made accessible only for patching activities. This provides optimal performance for AutoPatch sessions, and minimizes downtime needed. Maintenance mode is only needed for AutoPatch sessions.
206. Difference between delete and truncate? If you delete a table, you can rollback but if you truncate a table you cannot rollback
Delete is a DML command whereas Truncate is a DDL command
207. What does OUI do?
OUI(Oracle Universal Installer) is used to install, upgrade or remove software components, and create database
208. Application Scripts?
adfrmctl.sh -------Form Server
adfmsctl.sh- ------Forms Metric Server
adfmcctl.sh- ------Forms Metric Client
adalnctl.sh- -------Listener
adrepctl.sh- -------Report Server
adcmctl.sh-- ------Concurrent Manager
adapcctl.sh- ------Web Server
addisctl.sh- -------Discovere r Server
adtcfctl.sh- -------TCF Socket Server
jtffmctl.sh- --------Fulfillm ent Server
209. Database Scripts?
addlnctl.sh- -------DB Listener Process
addbctl.sh-- -------DB Process
210. Difference between du and df?
du shows the used space for each and every directory and file
df shows the used and available space with mount points
211. In which mode the recovery is done?
mount mode
212. How do you increase the tablespace size?
By adding datafile to the tablespace or by resizing the datafile
ALTER TABLESPACE xxx ADD DATAFILE xxx RESIZE n
ALTER DATABASE DATAFILE xxx RESIZE n
213. Where does undo memory information store?
Redo log buffer cache
214. What happens when you use alter system archive log start?
To enable the automatic archiving
215. What happens when you use alter database archive log?
To keep the database in archivelog mode
216. How do you maintain security?
By creating users and assigning them roles and profiles
217. Why do you use Resetlogs, Set, Reuse?
If you reset the logs, log sequence number will be set 0
Set is for new SID
Reuse is for reusing the existing controlfiles
218. How to check the free space and used space in OS level?
df -h, du -h
219. How to check the top directories used space in OS level?
du -h --max-depth= 1
220. Which parameters effect the undo?
undo_management
undo_retention
undo_suppress_ errors
undo_tablespace
221. What is the purpose of cmclean.sql? and its location?
It will purge the concurrent manager logs and tables
222. What is JInitiator?
JInitiator provides the JVM on which Forms client Applet will run.
223. What for do we use shared, exclusive, none in password file?
shared is to allow the remote users
exclusive is only for particular database
If none is set, remote login is not allowed
224. What is datagroup?
Datagroup is the pairing of Oracle user and Application user.
225. What happens when the environment is sourced?
All the product top directories and necessary executables such as adadmin, adpatch are set into path.
226. Contents of COMMON_TOP?
admin/scripts, java, html, rgf, temp/txkValidateRol lup.html, util/jinitiator
227. Contents of ORA directory?
IAS_ORACLE_HOME and 806 ORACLE_HOME
228. What is checkpoint?
Checkpoint signals the DBWR to write the dirty buffers to datafiles
Updates the datafile headers and controlfiles with checkpoint information
229. What is there in httpd.conf?
This is a server configuration file which typically contains directives that affect how the server runs, such as user and group IDs it should use, and location of other files. Because the server configuration file is the main file that the server starts with, Oracle HTTP Server does not include any directive that says where to locate it. The location is passed on command line when the server starts.
230. What is RRA/FNDFS ? Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Apps 11i for viewing output files & log files
231. Where to check log files after autoconfig is executed ?
On database tier its under $ORACLE_HOME/ appsutil/ log/contextname/ mmddhhmm/ adconfig. log On Application tier its under $APPL_TOP/admincont extname/log/ mmddhhmm/ adconfig. log
232. What is location of Contexts file in 11i ? Database Context file is under Database $ORACLE_HOME/ appsutil Application Context file is under $APPL_TOP/admin
233. What is a responsibility? Responsibility is a collection of menus, request security groups and data groups. Menu is a collection of forms Request security group is a collection of programs Data group is a group of modules to be made accessible by the user through Responsibility
System admin-->security-->define Security-->user-->define
234. How do you troubleshoot self-service login problems? Which profile options and files do you check?
Check guest user/password in DBC file, profile option guest user/password. Check whether apache/jserv is up Run FND_WEB.PING, aoljtest etc
235. What could be wrong if you are unable to view concurrent manager log and output files?
Most likely listener is down. Look at the FND_CONCURRENT_ REQUESTS, FND_NODES table and FNDFS_entry in tnsname.ora
236. How do you change the apps password? Use FNDCPASS to change APPS password and modify manually wdbsvr.app/cgiCMD. dat
237. How do I check if Multi-org is installed? Select multi_org_flag from fnd_product_ groups;
238. How do I check the currently installed release of applications? Select realease_name from fnd_product_ groups;
239. How to find the name of a form? Navigate Help-->About Oracle Applications
240. How do you cancel a running concurrent request?
Navigate Concurrent Request Summary form, select a request. In character, do a Quickpick on the Status column. You can select Cancel or Hold
241. Why does Help-->Tools-->Examine ask for a password?
This profile option controls whether users can use the Examine utility
The password should be the APPS password
242. What are .lgi files?
It contains informational messages, such as files that were not applied
Its location is $APPL_TOP/admin/ SID/log
243. What is location of .cfg? and its purpose?
This file is defined by environment variable FORMS60_WEB_ CONFIG_FILE. This is usually in directory $OA_HTML/bin on forms tier. This file is used by any forms client session. When a user tries to access forms , f60webmx picks up this file and based on this configuration file creates a forms session to user/client.
244. Where would i find .rf9 file, and what exactly it does?
These files are used during restart of patch in case of patch failure.
Location is $APPL_TOP/admin/ SID
245. Whats US directory in $AD_TOP or under various product TOP's ?
US directory is default language directory in Oracle Applications. If you have multiple languages installed in your Applications then you will see other languages directories besides US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for arabic, simplifies chinese or spanish.
246. How to find Version of Apache used with oracle apps 11i ?
Go to location $IAS_ORACLE_ HOME/Apache/ Apache/bin and run this command ./httpd -version
247. How do you work with multiple oracle homes?
Whatever oracle home you want to work, Source that environment file
248. What is concurrent request?
When a user runs a report, a request will be generated. The command to run that report is called Concurrent request
249. How do you rebuild the oraInventory?
1) If inventory_loc is not there in oraInst.loc, create it manually
2) Rename the corrupted globale inventory with a different name
3) Apply OUI patch(5035661)
4) Run the OUISetup.pl script on both IAS_ORACLE_HOME & RDBMS_ORACLE_ HOME
5) Change the permissions of new OraInventory
6) Run the runInstaller. sh command on $ORACLE_HOME/ appsoui/oui/ install
250. What are .fmb and .fmx files?
When you execute .fmb files, these files will be converted into .fmx
251. What is the use of restore.sh?
When you run restore.sh, it will come to previous stage like how it was.
Location: $ORACLE_HOME/ appsutil/ out/contextname/ MMDDhhmm/
252. What is Pasta?
Pasta is the utility to install the printers.
253. How do you kill group processes?
By using awk command
254. What is yellow bar? How to solve?
Whenever the clients are accessing the forms, due to the security problems, we get yellow bar warning.
To solve this problem, copy identitydb.obj from production to test system and run Jinitiator.
255. What is the use of SYSAUX tablespace?
SYSAUX tablespace contains statistical data.(It reduces the burden of system)
256. What is PCTFREE & PCTUSED? PCTFREE: The percentage of space reserved for future update of existing data. PCTUSED: The percentage of minimum space used for insertion of new row data. This value determines when the block gets back into Free List table.
257. What does data block header contain? The header contains general information about the data; i.e. block address and type of segments (table, index, etc.). The header also contains information about the table and the actual row (address) that holds the data.
258. What is Row Migration? Oracle will try to shift the entire row from the current block to another block having 25 (10+15) units of free space.
259. What is Row Chaining? When a row is so large that it cannot fit into one free block, Oracle will span the data into a number of blocks so that it can hold all of the data. The existence of such data results in "Row Chaining". Row Chaining is the storage of data in a chain of blocks.
260. What is listener.ora & tnsnames.ora? listener.ora: To connect to database, clients first contact a listener process that typically resides on database server. It consists of listener, port, SID name, hostname. The listener logs will be $ORACLE_HOME/ network/log tnsnames.ora: It is located at the client side and it stores net service names. It contains description, host, port, protocol, servicename, address. The location of these two configuration files is $ORACLE_HOME/ network/admin
261. Types of checkpoints? Full checkpoint, Incremental checkpoint, Partial checkpoint
262. Why do we get snapshot too old error? If undo tablespace is having insufficient space, we get this error.
263. What is profile? Profile controls the behaviour of applications
264. What is the use of 3 Oracle Homes? There are three $ORACLE_HOME in Oracle Apps, Two for Application Tier (Middle Tier) and One in Database tier. 8.0.6 ORACLE_HOME: On Application Tier used to store 8.0.6 techstack software. This is used by forms, reports & discoverer. ORACLE_HOME should point to this ORACLE_HOME which applying Apps Patch.
IAS_ORACLE_HOME: On Application Tier used by iAS (Web Server) techstack software. This is used by Web Listener & contains Apache.
RDBMS ORACLE_HOME: On Database Tier used by Database Software usually 8i,9i or 10g database.
265. What is RDA?
RDA is a set of command line diagnostic scripts that are executed by an engine written in the Perl programming language. RDA is used to gather detailed information about an Oracle environment; the data gathered is in turn used to aid in problem diagnosis. The output is also useful for seeing the overall system configuration. Oracle Support encourages the use of RDA because it provides a comprehensive picture of the customer's environment. This can greatly reduce service request resolution time by minimizing the number of requests from Oracle Customer Support for more information. RDA is designed to be as unobtrusive as possible; it does not modify systems in any way, it only collects useful data for Oracle Customer Support.
266. How to manually change the APPLSYS, APPS and APPLSYSPUB passwords for Applications?
· All users should be log out of application.
· Shutdown the concurrent managers
· Login as Sys Admin
· Navigate to Securityà Oracleà Register
· At the same time, login as the SYSTEM user
· In the applications session, enter the new password for APPLSYS
· Save the changes
· ALTER USER
· In the same applications session, change the APPS and APPLSYSPUB password
· Save the change
· ALTER USER APPLSYS IDENTIFIED BY XXX; ALTER USER APPS IDENTIFIED BY XXX; ALTER USER APPLSYS IDENTIFIED BY XXX;
· Open a new session in applications, without closing the previous session, and login
· Restart the concurrent managers
267. In a Multi Node Installation, how will you find which node is running what Services?
Query the table FND_NODES and check for the columns
SUPPORT_CP for Concurrent Manager SUPPORT_FORMS for Forms server SUPPORT_WEB for Web Server
SUPPORT_ADMIN for Admin Server
SUPPORT_DB for database tier
268. Can FNDLIBR be restored if it is deleted?
Yes, you can restore FNDLIBR executables
run adadmin on concurrent manager node
select option 2. Maintain Applications Files menu
then select 1. Relink Applications programs
when prompts for
Enter list of products to link ('all' for all products) [all]
select FND
when prompt for
Generate specific executables for each selected product [No] ? YES
select YES
& from list of executables select FNDLIBR
This will create new FNDLIBR executables.
269. What are .odf file in apps patch?
odf stands for Object Description Files used to create tables & other database objects
No comments:
Post a Comment