Shutdown abort: could not shutdown the database....



I am using Oracle 10.1.0.4 on Windows Server 2003. Today, in
production, no one could connect to database. They will just keep
waiting and may get an error:
ORA-25254: time-out in LISTEN while waiting for a message
ORA-06512: at "SYS.DBMS_AQ", line 577
ORA-06512: at "SYSMAN.EMD_NOTIFICATION", line 509
ORA-06512: at line 1

Aletrt.log had same message (i.e., problem was not because some folder
was 100%full lor no of processes exceeded).

I wanted to restart the database. Windows Service was up, so I
connected to database and ran:
Shutdown abort
However abort got hung as well. Waited for 10 minutes, then I tried
to restart Oracle Windows Service. Windows Service will not start.
Oradim.log did not have any useful information, same was true for
event log.

Eventually, I rebooted Windows Server and everything started working.

Can anything be done to avoid this problem other than moving off of
Windows Server which is not practical.
Thanks.
I am using Oracle 10.1.0.4 on Windows Server 2003. Today, in
production, no one could connect to database. They will just keep
waiting and may get an error:
ORA-25254: time-out in LISTEN while waiting for a message
ORA-06512: at "SYS.DBMS_AQ", line 577
ORA-06512: at "SYSMAN.EMD_NOTIFICATION", line 509
ORA-06512: at line 1

Aletrt.log had same message (i.e., problem was not because some folder
was 100%full lor no of processes exceeded).

I wanted to restart the database. Windows Service was up, so I
connected to database and ran:
Shutdown abort
However abort got hung as well. Waited for 10 minutes, then I tried
to restart Oracle Windows Service. Windows Service will not start.
Oradim.log did not have any useful information, same was true for
event log.

Eventually, I rebooted Windows Server and everything started working.

Can anything be done to avoid this problem other than moving off of
Windows Server which is not practical.
Thanks.

.

Relevant Pages

  • Re: Oracle 10.2G windows service started but instance is in nomunt mode
    ... Windows Server 2003 Version V5.2 Service Pack 1 ... Starting ORACLE instance (normal) ... what users are in the Administrators ... If the database was created with Oracle's DBCA, you may be able to use ...
    (comp.databases.oracle.server)
  • Re: Oracle 10.2G windows service started but instance is in nomunt mode
    ... Windows Server 2003 Version V5.2 Service Pack 1 ... Starting ORACLE instance (normal) ... what users are in the Administrators ... If the database was created with Oracle's DBCA, you may be able to use ...
    (comp.databases.oracle.server)
  • Re: Shutdown abort: could not shutdown the database....
    ... I am using Oracle 10.1.0.4 on Windows Server 2003. ... time-out in LISTEN while waiting for a message ... I wanted to restart the database. ... I rebooted Windows Server and everything started working. ...
    (comp.databases.oracle.server)
  • Re: How many Oracle9i Cluster manager required?
    ... What specific version and edition of Oracle are you running? ... We have two database on two different Windows server. ...
    (comp.databases.oracle.server)
  • Re: Samba limited to 32767 dirs?
    ... Database vendors tend to not handle this paricular system very well. ... the cost was astroniomical in terms of support and license, ... >> windows server they were using handled it just fine, but the drives were ...
    (comp.unix.bsd.freebsd.misc)