设置oracle开机自启动
ORACLE 设置开机自启动说明:一般而言windows平台oracle服务器会自动启动,但linux不会,包括监听、数据库、控制台emctl 需要进行设置 可用方式:方式一:利用OS的服务:oratab 方式二:利用oracle自带的dbstart和dbshut 个人觉得两种方式没有特别大的区别,最后都是利用linux的服务来实现,本文结合自己生产操作,利用oratab举例说明 step 1 修改oratab设置路径:/etc/oratab,只有这样,Oracle自带的dbstart和dbshut才能够发挥作用。 vi/etc/oratab 格式:$ORACLE_SID:$ORACLE_HOME:<N|Y>: Example wind:/u01/app/oracle/product/11.2.0/dbhome_1:Y step 2 配置oracle服务Linux init 说明:
#!/bin/sh #chkconfig:358010 #description:Oracleautostart-stopscript. # #SetORA_HOMEtobeequivalenttothe$ORACLE_HOME #fromwhichyouwishtoexecutedbstartanddbshut; # #SetORA_OWNERtotheuseridoftheownerofthe #OracledatabaseinORA_HOME. ORA_HOME=/u01/app/oracle/product/11.2/dbhome_1 ORA_OWNER=oracle if[!-f$ORA_HOME/bin/dbstart] then echo"Oraclestartup:cannotstart" exit fi case"$1"in 'start') #StarttheOracledatabases: echo"StartingOracleDatabases..." echo"-------------------------------------------------">>/var/log/oracle date+"%T%a%D:StartingOracleDatabasesaspartofsystemup.">>/var/log/oracle echo"-------------------------------------------------">>/var/log/oracle su-$ORA_OWNER-c"$ORA_HOME/bin/dbstart">>/var/log/oracle echo"Done" #StarttheListener: echo"StartingOracleListeners..." echo"-------------------------------------------------">>/var/log/oracle date+"%T%a%D:StartingOracleListenersaspartofsystemup.">>/var/log/oracle echo"-------------------------------------------------">>/var/log/oracle su-$ORA_OWNER-c"$ORA_HOME/bin/lsnrctlstart">>/var/log/oracle echo"Done." echo"-------------------------------------------------">>/var/log/oracle date+"%T%a%D:Finished.">>/var/log/oracle echo"-------------------------------------------------">>/var/log/oracle touch/var/lock/subsys/oracle ;; 'stop') #StoptheOracleListener: echo"StopingOracleListeners..." echo"-------------------------------------------------">>/var/log/oracle date+"%T%a%D:StopingOracleListeneraspartofsystemdown.">>/var/log/oracle echo"-------------------------------------------------">>/var/log/oracle su-$ORA_OWNER-c"$ORA_HOME/bin/lsnrctlstop">>/var/log/oracle echo"Done." rm-f/var/lock/subsys/oracle #StoptheOracleDatabase: echo"StopingOracleDatabases..." echo"-------------------------------------------------">>/var/log/oracle date+"%T%a%D:StopingOracleDatabasesaspartofsystemdown.">>/var/log/oracle echo"-------------------------------------------------">>/var/log/oracle su-$ORA_OWNER-c"$ORA_HOME/bin/dbshut">>/var/log/oracle echo"Done." echo"" echo"-------------------------------------------------">>/var/log/oracle date+"%T%a%D:Finished.">>/var/log/oracle echo"-------------------------------------------------">>/var/log/oracle ;; 'restart') $0stop $0start ;; esac step 3 设置服务oracle开机自启动chmod755/etc/init.d/oracle chkconfig--level35oracleon ln-s/etc/init.d/oracle/etc/rc0.d/K01oracle----设置os关机、重启前先关闭oracle step 4 测试方式#serviceoraclestart//启动oracle #serviceoraclestop//关闭oracle #serviceoraclerestart//重启oracle #reboot (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |