Re: Starting Oracle on Unix Reboot

audrey wrote:

> Thanks for the info Billy, I checked the SID and it's the name of the
> database that we are running and it is the same as the SID indicated
> in the listener.
> Is that what it is supposed to be?

Yes.

To recap - dbstart does not work when the machine boots, right?

I'm using my own startup and shutdown scripts and these are at times called from cron. Often when called by an "external shell process" the .profile is not executed. Like the case when a sh script is called from cron.

You thus need to make sure that the environment is correct in the startup/shutdown script, before attempting to run something like Oracle's server manager (or sqlplus).

I usually check for ORACLE_HOME and if it is not set, I ran $HOME/.profile in the script to set the environment, before continuing.

The bottom line is that you can not simply run a script from a shell command line and expect it to work when being called by cron or the rc.d startup scripts.

To be on the safe side, set the complete environment in the startup script, i.e. set ORACLE_HOME, ORACLE_SID, make sure that the user is Oracle, and only then attempt to bring up the database.

--
Billy