Re: Q: how to properly start up and shutdown Oracle?

Charles Chen wrote:
>>
>> Hi. I just finished installing Oracle 7.3.2.1.0 on Solaris 2.5.1 on a
>> Sparc10. It is currently up and running since I can go into SQL*Plus
>> and query the default EMP table. However, I would like to know how to
>> properly shut down Oracle both manually and by some automatic method.
>> In addition, I was wondering how to automatically start up Oracle when
>> the Sparc10 is rebooted. Thanks for any help you can provide.
>>

Hi there,

To shutdown oracle manually, do the following.

1. Logon as Oracle account (unix user)
2. SQLDBA lmode=y
3. connect internal
4. shutdown (or) shutdown immediate

I think in Oracle 7.3, you should use svrmgrl (server manager) instead of SQLDBA. To automatically startup Oracle when the system boots up, you need to add entries to /etc/rc (in digital box). It may vary for each of the OS. But there is a file in /etc directory in which you should call script dbstart which is present in $ORACLE_HOME/bin

Moreover add the Oracle instance in /etc/oratab file.

Hope the above info helps you..

Good Luck & Happy New Year

N.Prabhakar Received on Tue Dec 31 1996 - 00:00:00 CST