try the option 'abort'
Sam Jordan <sjo_at_spin.ch> schreef in artikel <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 - 04:54:56 CDT
