suse linux 下自动启动、关闭数据库
软件版本
suse10
oracle11G
第一步:
以oracle账号进入系统,进入oracle目录中寻找查看启动与关闭指令是否存在
#cd $ORACLE_HOME/bin
# ls dbstart
# ls dbshut
orcl:/oracle/product/10.2/db_1:Y
./dbstart: Starting up database "orcl"Tue May 29 00:26:23 CST 2012SQL*Plus: Release 11.2.0.1.0 Production on Tue May 29 00:26:26 2012Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> Connected to an idle instance.SQL> ORACLE instance started.Total System Global Area 1653518336 bytesFixed Size 2213896 bytesVariable Size 1006635000 bytesDatabase Buffers 637534208 bytesRedo Buffers 7135232 bytesDatabase mounted.Database opened.SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
#vi start_shut //自定义名称#!/bin/sh ORACLE_HOME=/opt/oracle/product/10.2/db_1OPT_=$1case "$OPT_" instart)su - oracle -c "$ORACLE_HOME/bin/lsnrctl start"su - oracle -c "$ORACLE_HOME/bin/dbstart"chmod 1777 /tmpchown sys:sys /tmpexit 0;;stop)/bin/echo "$0:(stop)"su - oracle -c "$ORACLE_HOME/bin/lsnrctl stop"su - oracle -c "$ORACLE_HOME/bin/dbshut"exit 0;;*)/bin/echo ''/bin/echo "Usage: $0 {start|stop|}"/bin/echo ''exit 0;;esac
#chmod 775 start_shut#ls -l start_shut
#cd /etc/rc0.id
#ln -s /etc/rc.d/init.id /start_shut S99start_shut#ln -s /etc/rc.d/init.id /start_shut k01start_shut