NT 816 shutdown immediate hangs

From: <Clive.Musgrove_at_lis.co.uk>
Date: Thu, 9 Nov 2000 15:41:03 +0000
Message-Id: <10675.121586@fatcity.com>

This is a multipart message in MIME format. --=_alternative 0050B180C1256992_=
Content-Type: text/plain; charset="us-ascii"

Anyone with experience of debugging Oracle 816 NT shutdown failures ?

Oracle 8.1.6 with 81611 & 81612 applied
NT4 Server (STD) + SP6a
80% of the time stopping an Oracle instance (OracleServicexxx) through net stop or Services:
Oracle.exe for the instance spawns a oradim.exe -shutdown -sid xxx -usrpwd xxx -shutmode i -log oradim.log
After a period of time (2+ minutes) a popup appears :

                        ORACLE.EXE  -Application Error
 
                        The exception Privileged instruction.
                        (0xc000O096) occurred in the application at location Ox60b4bf42.
                        Click on OK to terminate the application
                        Click on CANCEL to debug the application

Both the oradim.exe and the oracle.exe are still alive. killing the oradim is not allowed. killing the oracle.exe kills both oracle.exe and the oradim.exe.
The remaining 20% of the time it completes ok. The oradim.log shows ORA-12560: TNS:protocol adapter error Shutdown abort (through svrmgrl or by amending the NT OracleServicexxx Registry entry ORA_SID_SHUTDOWNTYPE to a) appears to work ok everytime. Occasionally when running shutdown immediate through svrmgrl , it gets to database closed then appears to lock up without returning control. No problems on startup either through services/svrmgrl No relevant messages in bdump.

That's about as far as my limited Oracle knowledge has taken me, but at least its only shutdown I am having problems with !!!!

TIA

Clive Musgrove

--=_alternative 0050B180C1256992_=
Content-Type: text/html; charset="us-ascii"

 Hi
 
 Anyone with experience of debugging Oracle 816 NT shutdown failures ?
 
 Oracle 8.1.6 with 81611 & 81612 applied
 NT4 Server (STD) + SP6a
 80% of the time stopping an Oracle instance (OracleServicexxx) through net stop or Services:
 Oracle.exe for the instance spawns a oradim.exe -shutdown -sid xxx -usrpwd xxx -shutmode i -log oradim.log
 After a period of time (2+ minutes) a popup appears :
                         ORACLE.EXE  -Application Error
                         
                         The exception Privileged instruction.
                         (0xc000O096) occurred in the application at location Ox60b4bf42.
                         Click on OK to terminate the application
                         Click on CANCEL to debug the application
 Both the oradim.exe and the oracle.exe are still alive.
 killing the oradim is not allowed. killing the oracle.exe kills both oracle.exe and the oradim.exe.
 The remaining 20% of the time it completes ok.
 The oradim.log shows ORA-12560: TNS:protocol adapter error
 Shutdown abort (through svrmgrl or by amending the NT OracleServicexxx Registry entry ORA_SID_SHUTDOWNTYPE to a) appears to work ok everytime.
 Occasionally when running shutdown immediate through svrmgrl , it gets to database closed then appears to lock up without returning control. 
 No problems on startup either through services/svrmgrl
 No relevant messages in bdump.
 
 That's about as far as my limited Oracle knowledge has taken me, but at least its only shutdown I am having problems with !!!!
 
 TIA
   

---------------------------------<br>

Received on Thu Nov 09 2000 - 09:41:03 CST