| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: shutdown immediate
Hello,
You might take a look at Doc ID 49100.999 in Metalink.
We had some similar problems. Over here they were caused by stored
procedures that were being executed and hadn't finished before the Shutdown
Immediate.
The database won't go down if there is an Intelligent Agent or some process
like this running.
Please check whether any user running any background job(nohup) on database
as shutdown immediate is unable to shut down database and wait for that
session to complete processing....
I've heared that another possible reason is the existence of "stuck" DBMS_JOB's tasks. Do you use DBMS_JOB ?
So try :
shutdown abort
startup restrict
Shutdown immediate for thread recovery
Hope this help
Good luck,
Henrik
Henrik Ekenberg Anoto AB Direct +46 (0)8 406 79 24 Vasagatan 7 Mobile +46 (0)733 745 624 111 20 Stockholm, Sweden www.anoto.com Switchb. +46 (0)8 406 79 00 E-mail :henrik.ekenberg_at_anoto.com Fax +46 (0)8 406 7950
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Roy
Ferguson
Sent: den 6 december 2000 01:36
To: Multiple recipients of list ORACLE-L
Subject: shutdown immediate
hello all...I've been asked about an issue with a database not shutting down
after executing shutdown immediate. over 6 hours later the database is
still
not down...what should I look at?
running solaris 7
all help is appreciated.
Roy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Roy Ferguson
INET: rferguso_at_level1.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Dec 06 2000 - 01:30:56 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |