Re: 8.1.7 shutdown

Alessandro wrote:
> Hi all,
> I'm in trouble with a 8.1.7 rdbms which fails to shutdown cleanly on a
> Win2000 server; in detail, when server is rebooted alert log shows a
> crash recovery, I tried to close db manually and it works well; I found
> this issue also on Metalink, but some unavailable patches are required.
> Is there any workaround and/or fix to this problem (before the db gets
> corrupted)?

There are situations where the db could be corrupted, even to the point where it cannot be brought back up, but they are rare and bug-dependent.

Since Microsoft and Oracle could never get together on a protocol to shut down properly, you need to create batch files that run when the OS is being shutdown. The problem was that the security.dll was unregistered before the 'net stop' command is given time to execute properly, therefore adherence to ORA_SID_SHUTDOWN in the registry cannot be forced. The batch files are controlled by using the Group Policy Editor of W2K. [See
http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=231495.1 ]

jg

--
@home.com is bogus.
http://www.ananova.com/news/story/sm_1527260.html