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

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

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>选项代表开机是否自启动

game:/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]$ vidbstart

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

--调整或确认监听路径,如ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracleORACLE_HOME_LISTNER=$ORACLE_HOME根据设置的监听调整路径

 

 

3、编辑/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/10.2.0/db_1/bin/dbstart"

su - oracle -c"/u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl start"

--命令中-c代表执行脚本,脚本dbstart中指定启动的实例,脚本lsnrctl中启动配置的监听

 

4、重启验证

# reboot

[oracle@org54 ~]$ sqlplus‘/as sysdba‘

 

SQL*Plus: Release 10.2.0.1.0 - Productionon Fri Jul 4 10:40:57 2014

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 10g Enterprise EditionRelease 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Miningoptions

 

SQL> selectstatus,instance_name from v$instance;

 

STATUS      INSTANCE_NAME

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

OPEN        game

 

 

小结:

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

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

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

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





linux下数据库实例开机自启动设置,古老的榕树,5-wow.com

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。