oracle 10G在rhel5下开机启动启动设置

首先在/etc/init.d/目录下配置Oracle的服务文件.

 

1. touch oracle10g

 

2. chmod a+x oracle10g

 

[root@oracle10g ~]# vim /etc/init.d/oracle10g

# !/bin/bash

# whoami

# root

# chkconfig: 345 51 49

# /etc/init.d/oracle10g

# description: starts the oracle dabase deamons

#

ORA_HOME=/u01/app/oracle/product/10.2.0/db_1

ORA_OWNER=oracle

case "$1" in

start)

echo -n "Starting oracle10g: "

su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart" &

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"

su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole"

touch /var/lock/subsys/oracle10g

echo

;;

 

stop)

echo -n "shutting down oracle10g: "

su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut" &

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"

su - $ORA_OWNER -c "$ORA_HOME/bin/emctl stop dbconsole"

rm -f /var/lock/subsys/oracle10g

echo

;;

 

restart)

echo -n "restarting oracle10g: "

$0 stop

$0 start

echo

;;

*)

echo "Usage: `basename $0` start|stop|restart"

exit 1

 

esac

exit 0

 

[root@oracle10g ~]#cp oracle10g /etc/init.d/

保存文件,退出以后,

3.添加并启动察看服务.

1./sbin/chkconfig --add oracle10g

2./sbin/chkconfig --list oracle10g

3./sbin/chkconfig --level 345 oracle10g on

重新启动Linux的时候,如果看到启动项Oracle出现OK,代表Oracle成功随Linux启动了.

注意:

 

这样的脚本启动一般不会启动实例,如果想让实例也随脚本一起启动的话,就需要修改文件:/etc/oratab

如果这个文件不存在,那么就得运行脚本文件产生它root.sh(root身份运行)

#

# This file is used by ORACLE utilities.  It is created by root.sh

# and updated by the Database Configuration Assistant when creating

# a database.

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

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

#

# Entries are of the form:

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

#

# The first and second fields are the system identifier and home

# directory of the database respectively.  The third filed indicates

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

# "N", be brought up at system boot time.

#

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

#

#

orcl:/oracle/product/10.2.0/db_1:N

gzgi:/oracle/app/oracle/product/10.2.0/db_1:Y看设置,可以看出实例 gzgi 是自动启动的(表识是Y),orcl的表识是N,则不启动.只要在这里设置好后,在配合上面的脚本,即可实现开机自动启动oracle以及实例了.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值