Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2007

    Unanswered: SHUTDOWN: waiting for logins to complete in oracle

    Hi Gurus,
    I getting this error message from last two months when I try to shutdown the database in a normal mode for a cold backup in the month end.

    For shutting down the databases and to take a back up we have one script runs in the back ground. After the shutdown command in the script for every five minutes i keep on getting the error message "SHUTDOWN: waiting for logins to complete." in .trc file and database doesn't shuts.

    The DB Version is 7.3.4 running on HP-Unix 10.20 and we make use of Host-UNIX openVMS to connect to the databases.

    Please find the attachment of the alertlog file enclosed in this mail.

    I assume that there was no users logged in at that time except the sysdba.

    How can i find out who all are logged in at that point of time on oracle

    Could you please help me in understanding this thing.

    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    Select Username, Osuser,machine From V$session;

    Alternatively I always use
    Last edited by anacedent; 12-09-07 at 14:25.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    I agree with anacedent, I never use shutdown normal which will wait for every user to complete, which could be forever. I use shutdown immediate with will rollsback any uncommitted transactions and disconnects everyone.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Dec 2007
    Thanks to all.

    In addition to this i want to know all possible reasons for the delay in the shut down.

    Plese clarify.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts