Dear David
How can I add to the script also these command as oracleas to stop ans start iAS
"Starting Oracle iAS" su - oracleas $OH/opmn/bin/opmnctl startall $OH/bin/emctl start iasconsole
"Stopping Oracle iAS" su - oracleas $OH/dcm/bin/dcmctl shutdown $OH/opmn/bin/opmnctl stopall
On Fri, Aug 29, 2008 at 10:36 PM, David Hrbác( hrbac.conf@seznam.cz wrote:
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