Sunday, 24 June 2012

Shell script for startup & shutdown of database

Shutting Down and starting up of Oracle Database using shell scripts:-


1.       vi dbstop.sh
export ORACLE_HOME=/u01/oracle/product/11.1.0/db (Path of Oracle Home)
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=
SID
lsnrctl stop SID
sqlplus "/ as sysdba"<<EOF
shutdown immediate
EOF

2.       vi dbstart.sh
export ORACLE_HOME=/u01/oracle/product/11.1.0/db
export PATH=$ORACLE_HOME/bin:$PATH
lsnrctl start  SID
export ORACLE_SID= SID
sqlplus "/ as sysdba"<<EOF
startup
EOF

1 comment:

  1. New Orleans Casino to close after nearly 3,800 slots and more
    New Orleans Casino, also 과천 출장안마 known as 군산 출장안마 the Hard Rock 김제 출장안마 Hotel & Casino, will close after more than 부천 출장마사지 3,800 slots and more than 사천 출장샵 1,600 of them will be

    ReplyDelete