<help!>SHUTDOWN: waiting for logins to complete
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: <help!>SHUTDOWN: waiting for logins to complete

  1. #1
    Join Date
    Dec 2009
    Posts
    1

    Exclamation <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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well you have a connection that needs to be killed - if its a problem just kill the process

  3. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    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 11:47 AM.
    lucky

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Cool 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

  5. #5
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    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
  •  



Click Here to Expand Forum to Full Width