Home » RDBMS Server » Server Administration » Shutdown normal
Shutdown normal [message #251618] Sun, 15 July 2007 09:46 Go to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Hi seniors,

I know that when we use shutdown normal oracle will wait for all users lgged in to log out then shut process will happnen.right?if im wrong please correct me.

My problem is i after i issue shutdown normal after a long time there is nothing happening but when i try to connect with another session it gives me database is shuttidn down..Why is this happening?And when can i use shutdown normal command.

Looking forward to your reply...

Thank you
unus
Re: Shutdown normal [message #251621 is a reply to message #251618] Sun, 15 July 2007 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
after i issue shutdown normal [...] when i try to connect with another session it gives me database is shuttidn down

Isn't it the state you are in? You are currenlty shutting down.

Quote:
when can i use shutdown normal command.

Every time you want to shut down the database as soon as they are all logged off.

Regards
Michel
Re: Shutdown normal [message #251622 is a reply to message #251621] Sun, 15 July 2007 10:10 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
No one is logged in except user sys who is the one shutting down the database.it has been 15 minutes since i issued shutdown normal still nothing happening.
Re: Shutdown normal [message #251623 is a reply to message #251622] Sun, 15 July 2007 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No one SEEMS to be logged.
But may be you have an agent (SMTP, db console, grid...).

Regards
Michel
Re: Shutdown normal [message #251624 is a reply to message #251623] Sun, 15 July 2007 11:21 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Is there a command or script utility to check and stop all services like(SMTP, db console, grid...).i have oracle installed both in linux and win xp.
Re: Shutdown normal [message #251626 is a reply to message #251618] Sun, 15 July 2007 12:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I suggest that you always use SHUTDOWN IMMEDIATE & then you don't need to worry about which sessions are active in DB.
Re: Shutdown normal [message #251628 is a reply to message #251624] Sun, 15 July 2007 13:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I agree with Ana there are more and more Oracle processes each version. "shutdown immediate" should be automatically used.

Regards
Michel
Re: Shutdown normal [message #251677 is a reply to message #251628] Mon, 16 July 2007 01:17 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
Thanks a lot Michel and Ana.

Blessings
unus
Re: Shutdown normal [message #252639 is a reply to message #251628] Thu, 19 July 2007 08:49 Go to previous messageGo to next message
somavamshi
Messages: 17
Registered: July 2007
Location: bangalore
Junior Member
Hi ...

I have the same problem.. I used while creating the database. Its taking long time but not shutdown.

Here is the message in the alert log file
output :
Active process 5955758 user 'oracle' program 'oracle@servername (TNS V1-V3)'
SHUTDOWN: waiting for logins to complete.

Can you tel what can i do for this... with out any crash.

Please help me its very critical position....
Re: Shutdown normal [message #252643 is a reply to message #252639] Thu, 19 July 2007 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Kill the process if you don't know to who it belongs and can ask him/her to disconnect.
I'm afraid this is the only way other than a shutdown abort.

Regards
Michel
Re: Shutdown normal [message #252646 is a reply to message #251677] Thu, 19 July 2007 09:12 Go to previous messageGo to next message
somavamshi
Messages: 17
Registered: July 2007
Location: bangalore
Junior Member
Hi I have done using startup force and its restarted successfully but when i shutdown immediate and startup normally getting the following error.. pls resolve this I have deleted the orapw file and recreated. even though not opening.

ORA-01990: error opening password file
'/usr/opt/oracle/product/db9.2.0/dbs/orapw'
ORA-27037: unable to obtain file status
Re: Shutdown normal [message #252647 is a reply to message #252646] Thu, 19 July 2007 09:26 Go to previous messageGo to next message
somavamshi
Messages: 17
Registered: July 2007
Location: bangalore
Junior Member
Disable ODM in either of two ways:

1. Reset the symbolic link to the original stub:

$ cd $ORACLE_HOME/lib
$ rm libodm9.so
$ ln -s libodmd9.so libodm9.so
2.) Disable the use of ODM with a hidden parameter :

_DISABLE_ODM = true

Remark :

Setting REMOTE_LOGIN_PASSWORDFILE = NONE disables the use of the passwordfile: only local OS authorized SYSDBA connections are possible.

Re: Shutdown normal [message #252671 is a reply to message #252646] Thu, 19 July 2007 10:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Create a new topic this is not the same case.

Regards
Michel
Re: Shutdown normal [message #252787 is a reply to message #252639] Fri, 20 July 2007 00:21 Go to previous messageGo to next message
orafan23
Messages: 13
Registered: December 2005
Junior Member
Shutdown all the applications that are connected to the database.I have seen this happening if you have Oracle applications.
Sometimes after a session is killed ,the associated process from OS would be still hanging in there.If it is a Prod DB ,we can`t keep waiting for hours for Normal shut down.I have tried waking up the PMON etc. to get rid of that killed session, but it would not.

Dear Senior Members,
In such cases where there is a process that is hanging and not getting killed, would you suggest a Shutdown Abort.

Please advice.

Thanks.
Re: Shutdown normal [message #252800 is a reply to message #252787] Fri, 20 July 2007 01:06 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As I said, you can kill the PROCESS.

Regards
Michel
Previous Topic: Find-Out the Oracle Schedule Jobs logs
Next Topic: Problem In Permission
Goto Forum:
  


Current Time: Thu Dec 05 13:18:33 CST 2024