Wednesday, August 13, 2008

Steps to Run Autoconfig On Database Tier (DB-Tier)

1. Please source the APPS environment
i. go to $APPL_TOP folder where APPS is installed (ie. /oracle/testappl)
ii. run file.
APPSORA.env or APPSSID_hostname.env
iii. check if the APPS environment was sourced: echo $ORACLE_HOME should return the path to 8.0.6 ORACLE_HOME (ie:/oracle/testora/8.0.6)

2. Please stop Middle(APPS) Tier:
i. Go to "/admin/scripts/" folder
ii. run adstpall.sh

3. Please source the RDBMS environment
i. go to your RDBMS ORACLE_HOME (a folder like: "oracle/testdb/9.2.0/")
ii. source the _.env file
iii. check that the RDBMS environment was sourcedecho $ORACLE_HOME (ie: "oracle/testdb/9.2.0")
iv. Note: when APPS environment is sourced, "echo $ORACLE_HOME" should return the 8.0.6ORACLE_HOME (ie: /oracle/testora/8.0.6)

4. Please run Autoconfig on DB-Tier
i. go to /appsutil/scripts/ folder
ii. run ADAUTOCFG.SH

5. Check the Autoconfig log file
i. AutoConfig log files are stored under:

Application Tier
/admin//log/

Database Tier
/appsutil/log//
ii. if you have errors (check for ERROR or FAIL words in the log files), solve it.


NOTE: it is very important to solve ALL errors from Autoconfig log files before going further inusing the other AD tools (ie: adpatch, adadmin, etc.) or executing any administrative tasks.

6. Close the current TELNET/SSH/command window and open a new one where you will source the NEW environment you need (this must be done in order not to preserve old values from the old sourced environment)

7. Please source the APPS environment
i. go to $APPL_TOP folder where APPS is installed (ie. /oracle/testappl)
ii. run file
. APPSORA.env or APPSSID_hostname.env
iii. check if the APPS environment was sourced:echo $ORACLE_HOMEshould return the patch to 8.0.6 ORACLE_HOME (ie:/oracle/testora/8.0.6)

8. Restart the Middle (APPS) Tier
i. Go to "/admin/scripts/" folder
ii. run adstrtal.sh

No comments: