OraFAQ Forum: Server Administration » Oracle shutdown immediate hang

Home » RDBMS Server » Server Administration » Oracle shutdown immediate hang

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle shutdown immediate hang [message #126105]

Fri, 01 July 2005 00:09

jasony
Messages: 5
Registered: June 2005
Location: Toronto

Junior Member

I am new in Oracle database and now having a problem with the Oracle database 9.2.01, on Windows 2000 box. It gives me an error says: Can not allocate log, archival required.

So I logged onto Oracle Enterprise Manager Console, and changed the profile ‘LOG_ARCHIVE_START’ to ‘True’, and then click Apply and then Shutdown Immediate, then it hangs (keep runing, but no any CPU usage)

What should I do now? should I restart the machine to kill the process?

Thanks in advance.

Jason

Report message to a moderator

Re: Oracle shutdown immediate hang [message #126112 is a reply to message #126105]

Fri, 01 July 2005 01:32

rodionov
Messages: 6
Registered: June 2005

Junior Member

I don't exactly understand what have happened with your database. It'll be better if you say error code (ORA-XXXXX). Any way try this if you want to turn your database archivelog on:

enter command line on you server console (cmd from "Run" menu) in it write such commands:

sqlplus /nolog

connect / as sysdba
shutdown immediate;
startup mount exclusive;
alter database archivelog;
atler database open;
commit work;
shutdown immediate;
startup;

But it seems to me that prolem not in this. You'd better say me an error. My ICQ number is 273894510. My E-mail rodionov@redstar.kr.ua

Report message to a moderator

Re: Oracle shutdown immediate hang [message #126122 is a reply to message #126112]

Fri, 01 July 2005 02:35

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Hi

probably ur archiver process is struck & u need to manually issue the command for archiving current redo log files.

Regds
Girish

Report message to a moderator

Re: Oracle shutdown immediate hang [message #126206 is a reply to message #126105]

Fri, 01 July 2005 09:22

jasony
Messages: 5
Registered: June 2005
Location: Toronto

Junior Member

Thank you both Rodionov and Girish.

The problem is resovled now by runing the command: shutdown abort.

Thanks again.

Jason

Report message to a moderator

Re: Oracle shutdown immediate hang [message #126213 is a reply to message #126105]

Fri, 01 July 2005 10:11

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Doesn't shutdown immediate tell oracle to wait to finish all currently executing transactions? (even if finish means rolling back). Abort just says go down now, and fix everything the next time you startup.

Report message to a moderator

Re: Oracle shutdown immediate hang [message #126214 is a reply to message #126105]

Fri, 01 July 2005 10:15

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Yes, shutdown abort solved your problem, but I think it may only be short-term.

Next time you start the database and fill your online redo logs, you are once again going to hang because archiving is going to need to be done. There is an init.ora parameter LOG_ARCHIVE_START that needs to be set to TRUE. If it's already that way, then your ARCHIVE LOG START fixed your problem and you are ok.

It's also a possibility that you have run out of space on the filesystem where your archive log files reside.

Report message to a moderator

Re: Oracle shutdown immediate hang [message #378942 is a reply to message #126105]

Fri, 02 January 2009 18:22

anand_study
Messages: 2
Registered: November 2005
Location: USA

Junior Member

Question was very old....but my may help someone else.

If DB Control ot Oracle Grid control is configured and related process/service is running, first stop those processes before issuing "shutdown immediate".

Report message to a moderator

Previous Topic:	Transporting Datafiles from one server to another
Next Topic:	Oracle 6 DB Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:56:47 CST 2024