ITPub博客

首页 > 数据库 > Oracle > linux下单实例数据库开机自启动设置

linux下单实例数据库开机自启动设置

原创 Oracle 作者:wangyiou1988 时间:2015-09-11 13:08:10 0 删除 编辑
1、修改/oratab

root@org54 ~]# vi/etc/oratab --把N改为Y,如下提示

# This file is used by ORACLEutilities. It is created by root.sh

# and updated by the Database ConfigurationAssistant when creating

# a database.

# A colon, ':', is used as the fieldterminator. A new line terminates

# the entry. Lines beginning with a pound sign, '#', arecomments.

#

# Entries are of the form:

# $ORACLE_SID:$ORACLE_HOME:<N|Y>:

#

# The first and second fields are thesystem identifier and home

# directory of the databaserespectively. The third filed indicates

# to the dbstart utility that the databaseshould , "Y", or should not,

# "N", be brought up at systemboot time.

#

# Multiple entries with the same$ORACLE_SID are not allowed.

#

#

#game:/u01/app/oracle/product/10.2.0/db_1:N --dbca创建库时注册的默认信息

--格式:$ORACLE_SID:$ORACLE_HOME:<N|Y>

--<N|Y>选项代表开机是否自启动

instance_name:/u01/app/oracle/product/10.2.0/db_1:Y



2.编辑/dbstart
 

[oracle@org54 bin]$ cd$ORACLE_HOME/bin

[oracle@org54 bin]$ ls-ll |grep dbstart

-rwxr-xr-x 1 oracle oinstall 10415 Jan 1 2000 dbstart

[oracle@org54 bin]$ vi dbstart

--dbstart为开机自启动脚本,让系统开机就去执行dbstart脚本文件,它会去读oratab文件,读到Y就会把对应的实例开机自启动

找到并修改ORACLE_HOME_LISTNER=$ORACLE_HOME根据设置的监听调整路径

3.编辑/rc.d/rc.local

[root@org54 ~]# vi/etc/rc.d/rc.local --添加如下两行信息,启动实例、启动监听

#!/bin/sh

#

# This script will be executed *after* allthe other init scripts.

# You can put your own initialization stuffin here if you don't

# want to do the full Sys V style initstuff.

touch /var/lock/subsys/local

modprobe hangcheck-timer hangcheck_tick=30hangcheck_margin=180

su - oracle  -c " /u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start"

su - oracle  -c " /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart"

4.重启验证一下
 
 #reboot

小结:

linux下设置实例自启动有关脚本:

oratab:实例是否自启动的注册信息

dbstart:开机启动脚本文件会读取oratab信息

rc.local:开机后立即要做的文件


 

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/25116248/viewspace-1797173/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-12-21

  • 博文量
    91
  • 访问量
    1261621