Re: Shutdown abort: could not shutdown the database....
- From: joel garry <joel-garry@xxxxxxxx>
- Date: Tue, 31 Jul 2007 13:26:58 -0700
On Jul 31, 12:00 pm, zigzag...@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.
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
.
- References:
- Shutdown abort: could not shutdown the database....
- From: zigzagdna
- Shutdown abort: could not shutdown the database....
- Prev by Date: Recommendations sought for good RAC monitoring tool
- Next by Date: Re: Recommendations sought for good RAC monitoring tool
- Previous by thread: Re: Shutdown abort: could not shutdown the database....
- Next by thread: Recommendations sought for good RAC monitoring tool
- Index(es):
Relevant Pages
|
