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

On Tue, 31 Jul 2007 12:00:38 -0700, zigzagdna@xxxxxxxxx wrote:



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.

Two things
- upgrade to a supported version of Oracle (10gR1 is desupported)
- alter system set aq_tm_processes = 0 prior to shutdown
- kill any jobs inside Oracle related to aq

Apart from that move to a scalable O/S
On Unix you would just find the process id of the dbwr and issue a
kill -9 on that and presto...

--
Sybrand Bakker
Senior Oracle DBA
.

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: 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: Shutdown abort: could not shutdown the database....
    ... time-out in LISTEN while waiting for a message ... I wanted to restart the database. ... Windows Service was up, so I ... I rebooted Windows Server and everything started working. ...
    (comp.databases.oracle.server)
  • 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: 2G limitation
    ... and has been installed 32-bit Versions of Windows Server 2003 standard ... Oracle can only recognize 2G memory when I have ... You may not be able to use all the available memory on the box.http://support.microsoft.com/kb/291988 ... Windows Server 2003, Standard Edition only in a production environment ...
    (comp.databases.oracle.server)
Loading