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

On Jul 31, 12:00 pm, zigzag..._at_yahoo.com 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.
> 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.

metalink Note:343978.1 help any?

jg

--
@home.com is bogus.
TV story said they went to the wrong gate and were backing up, hit a
curb, and... http://www.signonsandiego.com/uniontrib/20070730/news_1m30engine.html