设置oracle 随机启动,AIX上设置Oracle10g随机启动,随机关闭的步骤

AIX下设置Oracle10g随机启动,随机关闭的步骤

假如ORACLE_HOME为/opt/app/oracle/product/10.2.0/db_1.

1)修改/etc/oratab

$vi /etc/oratab

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

...

+ASM:/opt/app/oracle/product/10.2.0/db_1:Y

ORCL:/opt/app/oracle/product/10.2.0/db_1:Y

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

把Flag设置为Y表示可用dbstart来启动ASM实例,数据库实例和监听.

2)修改dbstart脚本

10.2.0.1以上版本无需做本步骤,10.2.0.1版本则修改dbstart第102行:

$vi $ORACLE_HOME/bin/dbstart

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

$ORACLE_HOME_LISTNER/bin/lsnrctl start LISTENER_NAME >> $LOG 2>&1 &

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

3)检查脚本

启动日志是$ORACLE_HOME/startup.log, 关闭日志是$ORACLE_HOME/shutdown.log

$dbshut/opt/app/oracle/product/10.2.0/db_1

$tail -f$ORACLE_HOME/shutdown.log

$dbstart/opt/app/oracle/product/10.2.0/db_1

$tail -f$ORACLE_HOME/startup.log

$ps -ef | grep tns | grep -v grep

$ps -ef | grep asm_ | grep -v grep

$ps -ef | grep ora_ | grep -v grep

4)增加Oracle相关进程启动脚本

#vi /etc/rc.oracle

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

#wangnc added

su- oracle-c "/opt/app/oracle/product/10.2.0/db_1/bin/dbstart/opt/app/oracle/product/10.2.0/db_1"

su- oracle-c "/opt/app/oracle/product/10.2.0/db_1/bin/emctl start dbconsole"

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

"emctl start dbconsole"那行是实现随机启动OEM, 根据实际需要决定是否加上.

#chmod +x/etc/rc.oracle

5)修改/etc/inittab实现随机启动

#vi /etc/inittab

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

oracle:2:wait:/etc/rc.oracle 2>&1

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

6)增加Oracle相关进程关闭脚本

#vi /etc/rc.shutdown

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

#wangnc added

su- oracle-c "/opt/app/oracle/product/10.2.0/db_1/bin/dbshut/opt/app/oracle/product/10.2.0/db_1"

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

#chmod +x/etc/rc.shutdown

AIX关闭前会自动执行rc.shutdown脚本.

7)测试随机启动

#shutdown -Fr

$more$ORACLE_HOME/shutdown.log

$more$ORACLE_HOME/startup.log

--END--