Tuesday, 12 July 2016

Database & Application Start Stop Script for Application 12.2.X and Database 11gR2

====================================================================
                                                        Script for Database Start
====================================================================

vi db_start.sh

. /db/hubprod/PROD/tech_st/11.2.0/PROD_furqan.env
export ORACLE_SID=PROD
/db/hubprod/PROD/tech_st/11.2.0/appsutil/scripts/PROD_furqan/addlnctl.sh start PROD
sqlplus sys/Oracle as sysdba <<eof

startup

eof

====================================================================
                                                        Script for Database Stop
====================================================================

vi db_stop.sh

. /db/hubprod/PROD/tech_st/11.2.0/PROD_furqan.env
export ORACLE_SID=PROD
/db/hubprod/PROD/tech_st/11.2.0/appsutil/scripts/PROD_furqan/addlnctl.sh stop PROD
sqlplus sys/Oracle as sysdba <<EOF

shutdown immediate

EOF


====================================================================
                                                        Script for Application Start
====================================================================

vi apps_start.sh

. /apps/fs1/EBSapps/appl/APPSPROD_furqan.env
export ORACLE_SID=PROD
/apps/hubprod/PROD/fs1/inst/apps/PROD_furqan/admin/scripts/adstrtal.sh apps/apps <<EOF
weblogic
EOF

====================================================================
                                                        Script for Application Stop
====================================================================

vi apps_stop.sh

. /apps/fs1/EBSapps/appl/APPSPROD_furqan.env
export ORACLE_SID=PROD
/apps/hubprod/PROD/fs1/inst/apps/PROD_furqan/admin/scripts/adstpall.sh apps/apps <<EOF
weblogic
EOF

No comments:

Post a Comment