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 datab
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::
#
# 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:
--選項代表開機是否自啟動
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/oracle或ORACLE_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：開機后立即要做的文件
本條技術文章來源于互聯網，如果無意侵犯您的權益請點擊此處反饋版權投訴
本文系統來源：php中文網
)