Solaris中设置oracle自启动
oracle自带了开启和关闭数据库的脚本$ORACLE_HOME/bin/dbstartup
$ORACLE_HOME/bin/dbshut
所以只需要利用这两个脚本 就可实现开机自启动
ORACLE_HOME路径为/export/home/oracle/product/10.0
首先需要修改这两个脚本,否则会出错
#vi $ORACLE_HOME/bin/dbstartup
将其中的ORACLE_HOME_LISTNER=$1更改为ORACLE_HOME_LISTNER=$ORACLE_HOME
同样修改dbshut文件
oracle数据库 默认是不会自动启动的,修改/var/opt/oracle/oratab文件
只一条语句,最后一句话
boway:/export/home/oracle/product/10.0:N
将最后的N改为Y
然后直接执行dbstart &
#dbstart &
1978
#Processing Database instance "boway": log file /export/home/oracle/product/10.0/startup.log
#
#ps -eaf | grep ora
oracle2110 1 0 20:13:53 ? 0:00 ora_p002_boway
oracle1431 924 0 20:04:51 pts/2 0:01 /export/home/oracle/product/10.0/bin/emagent
oracle2082 1 0 20:13:48 ? 0:00 ora_mman_boway
oracle 762 761 0 20:02:03 ? 0:00 /usr/lib/ssh/sshd
oracle2088 1 0 20:13:48 ? 0:00 ora_ckpt_boway
oracle 929 924 0 20:03:20 pts/2 0:31 /export/home/oracle/product/10.0/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=
oracle2188 769 0 20:14:01 pts/2 0:00 grep ora
oracle2187 769 0 20:14:01 pts/2 0:00 ps -eaf
oracle2102 1 0 20:13:48 ? 0:00 ora_s000_boway
oracle2084 1 0 20:13:48 ? 0:00 ora_dbw0_boway
oracle 580 1 0 20:01:52 ? 0:00 /export/home/oracle/product/10.0/bin/tnslsnr LISTENER -inherit
oracle2078 1 0 20:13:48 ? 0:00 ora_pmon_boway
oracle2080 1 0 20:13:48 ? 0:00 ora_psp0_boway
oracle2092 1 0 20:13:48 ? 0:00 ora_reco_boway
oracle2090 1 0 20:13:48 ? 0:00 ora_smon_boway
oracle 769 762 0 20:02:06 pts/2 0:00 -bash
oracle2100 1 0 20:13:48 ? 0:00 ora_d000_boway
oracle2086 1 0 20:13:48 ? 0:00 ora_lgwr_boway
oracle2094 1 0 20:13:48 ? 0:00 ora_cjq0_boway
oracle2098 1 0 20:13:48 ? 0:00 ora_mmnl_boway
oracle2096 1 1 20:13:48 ? 0:00 ora_mmon_boway
oracle 924 1 0 20:03:19 pts/2 0:00 /export/home/oracle/product/10.0/perl/bin/perl /export/home/oracle/product/10.0
oracle2184 1 0 20:13:59 ? 0:00 oracleboway (LOCAL=NO)
oracle2106 1 0 20:13:53 ? 0:00 ora_p000_boway
oracle2108 1 0 20:13:53 ? 0:00 ora_p001_boway
oracle2186 1 1 20:14:00 ? 0:01 oracleboway (LOCAL=NO)
oracle2114 1 0 20:13:56 ? 0:00 ora_qmnc_boway
+Done dbstart
#
可以看见监听进程和数据库都启动了
然后 再执行dbshut &
#dbshut &
2225
#Processing Database instance "boway": log file /export/home/oracle/product/10.0/shutdown.log
#
#ps -eaf | grep ora
oracle1431 924 0 20:04:51 pts/2 0:01 /export/home/oracle/product/10.0/bin/emagent
oracle2082 1 0 20:13:48 ? 0:00 ora_mman_boway
oracle 762 761 0 20:02:03 ? 0:00 /usr/lib/ssh/sshd
oracle2196 1 0 20:14:07 ? 0:00 oracleboway (LOCAL=NO)
oracle2088 1 0 20:13:48 ? 0:00 ora_ckpt_boway
oracle 929 924 0 20:03:20 pts/2 0:31 /export/home/oracle/product/10.0/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=
oracle2192 1 0 20:14:04 ? 0:00 oracleboway (LOCAL=NO)
oracle2102 1 0 20:13:48 ? 0:00 ora_s000_boway
oracle2084 1 0 20:13:48 ? 0:00 ora_dbw0_boway
oracle2274 1 0 20:15:27 ? 0:00 ora_emn0_boway
oracle2078 1 0 20:13:48 ? 0:00 ora_pmon_boway
oracle2080 1 0 20:13:48 ? 0:00 ora_psp0_boway
oracle2092 1 0 20:13:48 ? 0:00 ora_reco_boway
oracle2090 1 0 20:13:48 ? 0:00 ora_smon_boway
oracle 769 762 0 20:02:06 pts/2 0:00 -bash
oracle2100 1 0 20:13:48 ? 0:00 ora_d000_boway
oracle2086 1 0 20:13:48 ? 0:00 ora_lgwr_boway
oracle22712228 0 20:15:27 pts/2 0:00 sqlplus /nolog
oracle 924 1 0 20:03:19 pts/2 0:00 /export/home/oracle/product/10.0/perl/bin/perl /export/home/oracle/product/10.0
oracle2184 1 0 20:13:59 ? 0:00 oracleboway (LOCAL=NO)
oracle22282225 0 20:15:26 pts/2 0:00 -bash
oracle2276 769 0 20:15:37 pts/2 0:00 grep ora
oracle2225 769 0 20:15:26 pts/2 0:00 -bash
oracle2275 769 0 20:15:37 pts/2 0:00 ps -eaf
oracle22722271 0 20:15:27 ? 0:00 oracleboway (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle2186 1 0 20:14:00 ? 0:01 oracleboway (LOCAL=NO)
#
可以看见监听进程和数据库都关闭了
然后
#vi /etc/rc2.d/S99oracle
内容:
#!/bin/bash
su - oracle -c /export/home/oracle/product/10.0/bin/dbstart &
#vi /etc/rc0.d/K10oracle
#!/bin/bash
su - oracle -c /export/home/oracle/product/10.0/bin/dbshut &
#reboot
之后再看ps -eaf | grep ora#ps -eaf | grep ora
oracle 768 676 0 20:21:35 pts/2 0:00 -bash
oracle 477 1 0 20:21:19 ? 0:00 -bash -c /export/home/oracle/product/10.0/bin/dbstart
oracle 784 768 0 20:21:40 pts/2 0:00 ps -eaf
oracle 785 768 0 20:21:40 pts/2 0:00 grep ora
oracle 783 666 0 20:21:37 ? 0:00 oracleboway (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 617 477 0 20:21:23 ? 0:00 -bash -c /export/home/oracle/product/10.0/bin/dbstart
oracle 676 675 0 20:21:28 ? 0:00 /usr/lib/ssh/sshd
oracle 727 1 0 20:21:31 ? 0:00 ora_pmon_boway
oracle 729 1 0 20:21:31 ? 0:00 ora_psp0_boway
oracle 666 617 0 20:21:25 ? 0:00 sqlplus /nolog
oracle 580 1 0 20:21:23 ? 0:00 /export/home/oracle/product/10.0/bin/tnslsnr LISTENER -inherit
oracle 731 1 0 20:21:31 ? 0:00 ora_mman_boway
oracle 733 1 0 20:21:31 ? 0:00 ora_dbw0_boway
oracle 735 1 0 20:21:31 ? 0:00 ora_lgwr_boway
oracle 737 1 0 20:21:31 ? 0:00 ora_ckpt_boway
oracle 739 1 0 20:21:31 ? 0:00 ora_smon_boway
oracle 741 1 0 20:21:31 ? 0:00 ora_reco_boway
oracle 743 1 0 20:21:31 ? 0:00 ora_cjq0_boway
oracle 745 1 0 20:21:31 ? 0:00 ora_mmon_boway
oracle 747 1 0 20:21:32 ? 0:00 ora_mmnl_boway
oracle 749 1 0 20:21:32 ? 0:00 ora_d000_boway
oracle 751 1 0 20:21:32 ? 0:00 ora_s000_boway
#
页:
[1]