Startup & Shutdown process in Oracle Apps in R12.

Share via:

 Startup  & Shutdown process in  Oracle Apps in R12.

 

STARTUP PROCESS 

1.Start Database Tier Services
–Start Database Listener
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh start <listener_name>

–Start Database
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh start

or alternatively you can use
lsnrctl start/stop <listener_name >
sqlplus “/as sysdba”
SQL> startup
Then
2.Start Application/Middle Tier Services
cd $ADMIN_SCRIPT_HOME
sh adstrtal.sh apps/xxxxx

 

STOP PROCESS :

1.Stop Application/Middle Tier Services

cd $ADMIN_SCRIPT_HOME
sh adstpall.sh apps/xxxxx

Then
2. Stop Database Tier Services
–Stop Database immediately
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh stop immediately
–Stop Database <listener_name>
$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh stop <listener_name>

Log files for startup/shutdown scripts for application/mid tier in R12 are in $INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
(adalnctl.txt, adapcctl.txt, adcmctl.txt, adformsctl.txt, adoacorectl.txt, adoafmctl.txt, adopmnctl.txt, adstrtal.log, jtffmctl.txt )
Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...