Linux下Oracle隨機自動啟動指令碼設定

11g  :

#set oracle environment

ORACLE_HOME=/u01/product/oracle;export ORACLE_HOME
ORACLE_SID=hunetapp; export ORACLE_SID

su oracle -c "/u01/product/oracle/11.2.0/db_1/bin/sqlplus  /nolog <connect / as sysdba
startup;
exit
EOF"

su oracle -c "/u01/product/oracle/11.2.0/db_1/bin/lsnrctl <start
exit
EOF"

 

----------------------------------------------------------------------------------------------- 

 

10g  : 

#set oracle environment

ORACLE_HOME=/u01/product/oracle;export ORACLE_HOME
ORACLE_SID=mpsprd;export ORACLE_SID

su oracle -c "/u01/product/oracle/bin/sqlplus /nolog <connect / as sysdba
startup;
exit
EOF"

su oracle -c "/u01/product/oracle/bin/lsnrctl <start
exit
EOF"