Oracle EBS Stop and start script
Database
cd ~; mkdir -p /u01/scripts; ln -s /u01/scripts scripts; cd ~/scripts touch stopdbTEST.sh ; touch startdbTEST.sh cat >> stopdbTEST.sh << EOF # soruce db env . /u01/TEST/oracle/product/db/12.1.0.1/TEST_ebs121db1.env sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh stop immediate sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh stop $ORACLE_SID EOF cat >> startdbTEST.sh << EOF # soruce db env . /u01/TEST/oracle/product/db/12.1.0.1/TEST_ebs121db1.env sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh start sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh start $ORACLE_SID EOF
Application
cd ~; mkdir -p /u01/scripts; ln -s /u01/scripts scripts; cd ~/scripts touch stopapPROD.sh ; touch startapPROD.sh; chmod +x stopapPROD.sh startapPROD.sh cat >> stopapPROD.sh << EOF # soruce AP env . /u01/PROD/apps/apps_st/appl/APPSPROD_ebs121ap1.env sh $ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps EOF cat >> startapPROD.sh << EOF # soruce db env . /u01/PROD/apps/apps_st/appl/APPSPROD_ebs121ap1.env sh $ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps EOF
