Tuesday, June 21, 2011

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


1. source the APPS environment
i. go to $APPL_TOP folder where APPS is installed
ii. run file   . APPSORA.env or APPSSID_hostname.env
iii. check if the APPS environment was sourced:
echo $ORACLE_HOME

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

3. source the RDBMS environment
i. go to your RDBMS ORACLE_HOME $ORACLE_HOME
ii. source the _.env file
iii. check that the RDBMS environment was sourced
echo $ORACLE_HOME


4. 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
ii. run file    . APPSORA.env or APPSSID_hostname.env
iii. check if the APPS environment was sourced:
echo $ORACLE_HOME

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


Apps Dba Free Lance
Sukhwinder Singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

aquarium fishes