| Shutdown normal [message #251618] |
Sun, 15 July 2007 09:46  |
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 #252639 is a reply to message #251628] |
Thu, 19 July 2007 08:49  |
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 #252646 is a reply to message #251677] |
Thu, 19 July 2007 09:12 |
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 |
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 #252787 is a reply to message #252639] |
Fri, 20 July 2007 00:21 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
