Saturday 23 June 2018

Oracle Database context file Information

https://dbissues.blogspot.com/2018/06/oracle-database-context-file-information.html


Database context file location :-
Database context file called the <CONTEXT_NAME>.xml contains the configuration information for the database tier & is located in /u01/oracle/PROD/db/tech_st
11.1.0/appsutil/Server_PROD.xml <---------(contextfile).
(context_file.xml).

Application context file location :-
Application context file called the <CONTEXT_NAME>.xml contains the configuration information for the application tier & is located in  /u01/oracle/PROD/inst/appl/admin/PROD_Server.xml. <-------(contextfile).

What Contextfile contains:-
 The context file contains host names,domain name , directory structure, port numbers used The AutoConfig feature of Oracle application manager(OAM)
 is used to update & manage context files.

You can check contextfile location by the following command:-
sqlplus!  select NAME,VISSION,PATH  from FND_OAM_CONTEXT_FILES;
Autoconfig work:-

The autoconfig script uses information from the context file to generate all applications configuration files & updates database profiles.

How to Run autoconf:-
Step 1 : Stop all services
$ $INST_TOP/apps/PROD_Server/app/admin/script/adstpall.sh APPS/<apps password>
Step 2:From same above location Run the autoconfig script, $adautocfg.sh .

How to run adconfig in datbase tier:-
/u01/oracle/db/tech_st/11.1.0/appsutil/bin/adconfig.sh <------location
adconfig.sh contextfile=/u01/oracle/db/tech_st/11.1.0/appsutil/PROD_Server.xml <-------(contextfile)

How to run adconfig in Application tier:-
/u01/oracle/apps/apps_st/appl/ad/12.0.0/bin/adconfig.sh <-------location
adconfig.sh contextfile=/u01/oracle/PROD/apps/apps_st/ad/12.0.0/bin/ PROD_Server.xml <---(contextfile)

Why we use adconfig.sh
The adconfig.sh would update the database with the XML entries and create the Listener and TNSNAMES.ora.

What is difference between ADpatch and Opatch:--
ADPATCH is utility to apply ORACLE application Patches whereas OPATCH is utility to apply database patches.

No comments:

Post a Comment