Mad Unix napsal(a):
> Hi
>
> I need a script to automatically Starting/Stopping an Oracle 10g DB on
> CentOS5.2 64bit i.e
> lsnrctl start/stop
> db start/stop
> emctl start/stop dbconsole"
> Any help?
>
>
I'm using this one.
David
#!/bin/bash
#
# chkconfig: 35 95 15
# description: init script to start/stop oracle database 10g, TNS
listener, EMS
#
#
# match these values to your environment:
# Source function library.
. /etc/rc.d/init.d/functions
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=/home/oracle/OraHome_1
export ORACLE_TERM=xterm
export PATH=/home/oracle/bin:/home/oracle/OraHome_1/bin:$PATH
#export NLS_LANG=''
export ORACLE_SID=orcl
export DISPLAY=localhost:0
export ORACLE_USER=oracle
prog="Oracle"
# see how we are called:
start() {
echo -n $"Starting $prog: "
su - "$ORACLE_USER"<<EOO
lsnrctl start
sqlplus /nolog<<EOS
connect / as sysdba
startup
EOS
emctl start dbconsole
EOO
touch /var/lock/subsys/ora10
}
stop() {
echo -n $"Stopping $prog: "
su - "$ORACLE_USER"<<EOO
emctl stop dbconsole
lsnrctl stop
sqlplus /nolog<<EOS
connect / as sysdba
shutdown immediate
EOS
EOO
}
case "$1" in
start)
start
;;
stop)
stop
;;
restart)
stop
sleep 10
start
;;
*)
echo $"Usage: $0 {start|stop}"
exit 1
esac
_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos
