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>