Re: Oracle refuses to shutdown

Hi Sam,

    I had the same problem on NT and wound up changing my scripts so that I did a shutdown abort followed by a startup followed by a shutdown immediate. With Linux you could do a ps -ef, grep for Oracle users, and kill their processes at the OS level before shutting down and running the backup.

regards

Jerry Gitomer

Sam Jordan wrote in message <374E2AFE.8AA2E83D_at_spin.ch>...
>Hi
>
>I mentioned a similar problem some times ago. I'm using a script to make
>cold backups, which involves shutdown and startup of the database. The
>problem
>is, that Oracle refuses to perform the shutdown, if any transactions are
>still
>open, regardless of using normal, immediate or transactional parameter.
>It doesn't
>matter whether an SQLPLUS session is still open or whether a Java
>application has
>still JDBC connections open to the database. The result is a hang-up of
>the
>backup script, and the final result is, that the backup isn't done. As
>soon as
>I log out of SQLPLUS resp. shut down my applications which have
>connections open,
>the shutdown is performed soon.
>
>This problem is a severe one for me, since my applications hold DB
>connections open
>and count on exceptions beeing thrown, if the database is shut down and
>the
>connections become invalid.
>
>I'm using Oracle 8.0.5. for Linux. I heard that the shutdown command
>seems to
>have problems, but now I need a solution. At the moment all which comes
>me to
>mind is to switch to hot-backups, but I really don't like to do it.
>Additionally
>I would like to shutdown the db whenever I like to, not beeing dependant
>on
>any applications running on the db and not releasing database
>connections.
>And I don't think that Oracle behaves correctly in this case, at least I
>interpret
>this behaviour as non-consistent to the documentation.
>
>bye
>--
>Sam Jordan
Received on Fri May 28 1999 - 09:18:34 CDT