启动数据库
#!/bin/bash
ORACLE_BASE=/dbora/oracle
ORACLE_HOME=/dbora/oracle/product/10.2.0/db_1
ORACLE_SID=ora1
PATH=$PATH:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$ORACLE_HOME/OPatch;
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
su - oracle -c "sqlplus /nolog << EOF
conn /as sysdba
set timing on
#shutdown immediate;
startup;
exit;
EOF"
关闭数据库
#!/bin/bash
ORACLE_BASE=/dbora/oracle
ORACLE_HOME=/dbora/oracle/product/10.2.0/db_1
ORACLE_SID=ora1
PATH=$PATH:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$ORACLE_HOME/OPatch;
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
su - oracle -c "sqlplus /nolog << EOF
conn /as sysdba
set timing on
#startup ;
shutdown immediate;
exit;
EOF"
#more /etc/hacmp/dbstart.
su - oracle <<EOF
lsnrctl start
sqlplus /nolog
conn / as sysdba
startup
exit
exit
EOF
#more /etc/hacmp/dbstop.sh
su - oracle <<EOF
ps -ef|grep tnslsnr|grep -v grep|awk '{print $2}'|xargs kill -9
sqlplus /nolog
conn / as sysdba
shutdown immediate
exit
exit
EOF