Problem in shutting down database

Hi DBAs,
 
Please I need a clarification and a solution for this current status.
many times when I shutdown the database normal shutdown after connecting as 
sysdba & executing shutdown to be normal shutdown, the the session hangs and 
waiting for active processes to be completed, this can be for hours then fail 
to shutdown normal  then I have to shutdown immediate then  performing normal 
shutdown and it ends cleanly Or I restart the server.
 
Also there is no active connection running and no user logging into 
application, coz the middle tier is down.
 
Operating system: Win 2000
Instance:  11.5.10.2
Database: 9.2.0.8
Is this a bug?
 
this is the current status. Anyone has idea, permanet solution?
 
Mon Feb 16 17:29:18 2009
Beginning log switch checkpoint up to RBA [0x291a9.2.10], SCN: 0x0000.d5d338b1
Thread 1 advanced to log sequence 168361
  Current log# 3 seq# 168361 mem# 0: F:\ORACLE\PRODDATA\LOG03A.DBF
  Current log# 3 seq# 168361 mem# 1: F:\ORACLE\PRODDATA\LOG03B.DBF
Mon Feb 16 17:56:55 2009
Completed checkpoint up to RBA [0x291a9.2.10], SCN: 0x0000.d5d338b1
Mon Feb 16 17:57:58 2009
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 304
Mon Feb 16 18:02:58 2009
Active process 4680 user 'exora' program 'ORACLE.EXE'
Active process 5068 user 'exora' program 'ORACLE.EXE'
Active process 5556 user 'exora' program 'ORACLE.EXE'
Active process 5576 user 'exora' program 'ORACLE.EXE'
Active process 6208 user 'exora' program 'ORACLE.EXE'
Active process 5760 user 'exora' program 'ORACLE.EXE'
Active process 812 user 'exora' program 'ORACLE.EXE'
Active process 5168 user 'exora' program 'ORACLE.EXE'
SHUTDOWN: waiting for logins to complete.

 

Thanks alot
Good Day
Regards,
 
 


      

Other related posts: