Linux怎么自动启动Oracle服务和ArcSDE服务
Linux怎么自动启动Oracle服务和ArcSDE服务
其实这个问题最主要的是自动启动Oracle服务,在网上也有很多例子,但是根据例子走并不一定能实现成功,下面就根据我的实际操作来看一下在配置过程中有哪些问题需要注意的。1:修改Oracle系统配置文件/etc/oratab
- [root@localhost ~]# vi /etc/oratab
但是默认为:orcl:/opt/oracle/product/11.2.0/dbhome_1:N,我们只需要修改为Y如下所示即可
- # 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:/opt/oracle/product/11.2.0/dbhome_1:Y
我们可以首先创建一个Oracle配置文件,位置为:/etc/rc.d/init.d文件夹里面
然后进行编辑该文件
- [root@localhost ~]# vi /etc/rc.d/init.d/oracle
- #!/bin/bash
- #
- #chkconfig:345 99 10
- #description: StartupScriptfororacleDatabases
- #/etc/rc.d/init.d/oradbstart
- export ORACLE_BASE=/opt/oracle/
- export ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
- export ORACLE_SID=orcl
- export SDEHOME=/home/arcsde/sdeexe100
- export PATH=$PATH:$ORACLE_HOME/bin:$SDEHOME/bin
- case "$1" in
- start)
- echo "-----startup oracle-----">>/var/log/oracle11log
- su - oracle -c $ORACLE_HOME/bin/dbstart
- touch /var/lock/subsys/oracle11
- echo "-----startup oracle successful-----">>/var/log/oracle11log
- echo "OK"
- su - arcsde -c "sdemon -o start -p sde"
- ;;
- stop)
- echo "-----shutdown oracle-----">>/var/log/oracle11log
- su - oracle -c $ORACLE_HOME/bin/dbshut
- rm -f /var/lock/subsys/oracle11
- echo "-----shutdown oracle successful-----">>/var/log/oracle11log
- echo "OK"
- ;;
- *)
- echo "Usage:'basename$0'start|stop"
- exit 1
- esac
- exit 0
- export ORACLE_SID=orcl
- export PATH=$PATH:$ORACLE_HOME/bin
- case "$1" in
- start)
- echo "-----startuporacle-----">>/var/log/oracle11log
- su - oracle -c $ORACLE_HOME/bin/dbstart
- touch/var/lock/subsys/oracle11
- echo "-----startuporaclesuccessful-----">>/var/log/oracle11log
- echo "OK"
- ;;
- stop)
- echo "-----shutdwnoracle-----">>/var/log/oracle11log
- su - oracle -c $ORACLE_HOME/bin/dbshut
- rm -f /var/lock/subsys/oracle11
- echo "-----shutdownoraclesuccessful-----">>/var/log/oracle11log
- echo "OK"
- ;;
- *)
- echo "Usage:'basename$0'start|stop"
- exit1
- esac
- exit0
1:需要将用户自己的环境变量,名称进行对比进行修改
2:特别特别注意,有些用户看到这么多,就直接在Windows系统进行编辑,然后再传入到相关的Linux位置,这样做是有问题的。
请参考:
要么用户之间在Linux进行编辑,要么在windows编辑完使用编辑软件进行转换一下编码即可
也可以使用:dos2unix 文件名来进行转换
3:注意该文件的空格 比如 su - oracle ,echo "----
编辑完毕后,需要修改一下相关的权限
- [root@localhost ~]# chmod 755 /etc/rc.d/init.d/oracle
|
评论暂时关闭