-
<help!>SHUTDOWN: waiting for logins to complete
hello everyone
i shutted down a database for 1hour.But it doesn't work.
So i checked the alert file.show some messages belowed:
************************************
active process 1128 user 'sheffrong' program 'oracle@localhost.localdomain'
active process 1124 user 'sheffrong' program 'oracle@localhost.localdomain'
active process 1130 user 'sheffrong' program 'oracle@localhost.localdomain'
active process 29416 user 'sheffrong' program 'oracle@localhost.localdomain'
active process 8224 user 'sheffrong' program 'oracle@localhost.localdomain'
SHUTDOWN: waiting for logins to complete
************************************
Assuredly,i opened some browser to access the database by EM.
But i already closed these browsers.Is there possibility that i closed the browsers,but the processes are still alive?
please help me.
sheff
PS:sorry for the bad english
-
well you have a connection that needs to be killed - if its a problem just kill the process
-
which shutdown command did u use? As it seems, it is shutdown normal. So, either wait for all sessions to log off or if it is important, kill the oracle process. Oracle will be able to recover committed work using instance recovery.
Last edited by mahajanakhil198; 12-21-2009 at 12:47 PM.
lucky
-
Shutdown immediate.
WAIT! do this in the sqlplus session (as sysdba) where you executed the shutdown command:
Code:
{Ctrl-C}
SHUTDOWN IMMEDIATE;
-- Or if the shutdown does not work:
SHUTDOWN ABORT;
Kiiling the Oracle process is not advisable and should be use as last resort.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Right! new connection can't be made.
lucky
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|