Re: Oracle refuses to shutdown

Sam,
  have you tried to
    SHUTDOWN ABORT
    STARTUP
    SHUTDOWN Regards
Dante

In article <374E2AFE.8AA2E83D_at_spin.ch>,   sjo_at_spin.ch wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri May 28 1999 - 08:31:51 CDT