Automatic Startup/Shutdown under Solaris

From: <corcodilos_at_r2d2.bms.com>
Date: Thu, 13 Jan 1994 19:01:00 GMT
Message-ID: <13JAN199414014878_at_r2d2.bms.com>

Oracle Netters,

I have been unsuccessful at getting my Oracle database to start/stop automatically when my Sparc 1000 running Solaris 2.3 boots/halts.

Here's what I've tried... The following file K20oracle resides in the directory /etc/rc0.d

---

#ident _at_(#)K20oracle 1.0; 93.12.08;
#!/usr/bin/sh
# put this file in /etc/rc0.d directory

su - oracle <<END

ORACLE_SID=IMGE
ORACLE_HOME=/u01/home/oracle/product/7.0.15.4
ORACLE_BASE=/u01/home/oracle

TWO_TASK=P:
PATH=${PATH}:${ORACLE_HOME}/bin
export ORACLE_SID ORACLE_HOME ORACLE_BASE TWO_TASK PATH echo 'Shutting ORACLE Database(s) down' >/dev/console 2>&1 tcpctl stop >/dev/console 2>&1
dbshut >/dev/console 2>&1
END

---

The shutdown file S80oracle resides in the directory /etc.rc2.d

---

#!/usr/bin/sh
#ident _at_(#)S80oracle 1.0; 93.12.08;
# put this file in /etc/rc2.d directory!

su - oracle <<END

ORACLE_SID=IMGE
ORACLE_HOME=/u01/home/oracle/product/7.0.15.4
ORACLE_BASE=/u01/home/oracle

TWO_TASK=P:
PATH=${PATH}:${ORACLE_HOME}/bin
export ORACLE_SID ORACLE_HOME ORACLE_BASE TWO_TASK PATH echo 'Starting ORACLE Database(s) up' >/dev/console 2>&1 tcpctl start >/dev/console 2>&1
dbstart >/dev/console 2>&1
END

---

I'd appreciate hearing from anyone who has successfully implemented this and is willing to share their scripts or comment on mine. I'd prefer e-mail and will post summary to group.

Thanks in advance,

Joanne Corcodilos

|-----------------------|----------------------------------|------------------|
|Joanne Corcodilos      | Bristol-Myers Squibb             |corcodilos_at_bms.com|
|Database Administrator | Pharmaceutical Research Institute|                  |
|                       | Post Office Box 4000             |   609-252-6818   |
|                       | Princeton, NJ 08543              |                  |
|-----------------------------------------------------------------------------|-

Received on Thu Jan 13 1994 - 20:01:00 CET