Re: shutting down Orale6 SuSe6.3 linux

Oracle will hang if there are pending transactions (uncommitted inserts, updates, or deletes) or open sessions. You need to kill all open sessions first or change your shutdown parameters.

Run the dbshut from the command line. If it works, then you know the program is fine. If not, query v$session for open sessions. If you find some, kill them and try again. The command is

alter system kills session '<sid>,<serial#>';

When you know dbshut works, change the online parameter to "immediate" to force a shutdown when you want it. You might have a daemon or some other process grabbing a session and hanging on. Web servers will often grab a session and hang on to it.

Christopher Weiss
Professional Services Division
Compuware Corporation

Sandy Pittendrigh <sandy_at_nervana.montana.edu> wrote in message news:37A5FC9E.C3D8EE40_at_nervana.montana.edu...
> I have an oracle 8 running successfully on an SuSe6.3 linux box.
>
> the tnslistener and server start up fine on reboot,
> via a link in /sbin/init.d/rc5.0/link-to -> ../startoracle.sh
>
> which contains:
>
> su - oracle -c /path-to-oracle/bin/dbstart &
> su - oracle -c "/path-to-oracle/bin/lsnrctl start" &
>
> But I can't get the shutdown to work on reboot.
> SuSe Linux has a script called /sbin/init.d/halt.local that belongs to
> root.root
>
> in it I have:
>
> su - oracle -c /path-to-oracle/bin/dbshut &
> su - oracle -c "path-to-oracle/bin/lsnrctl stop" &
>
> in halt.local I added a debugging message
> echo `date` > /tmp/misery
> which puts a date in /tmp/misery, so halt.local runs, but does not stop
> oracle.
>
>
> The rebooting process locks up with an RPC sndmesg error 101 and
> never seems to time out.
> So I have to stop oracle manually before rebooting.
>
> How do I make this work?
> Send email please. I'll post any succesfull solution.
>
>
> --
> /* Sandy Pittendrigh >--oO0>
> * sandy_at_nervana.montana.edu
> * http://www.nervana.montana.edu/~sandy
> */
Received on Mon Aug 02 1999 - 15:40:13 CDT