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

    Unanswered: SHUTDOWN: waiting for logins to complete in oracle 7.3.4.0.0

    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 7.3.4.0.0

    Could you please help me in understanding this thing.



    Thanks,
    Jannath
    Attached Files Attached Files

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

    Alternatively I always use
    SQL > SHUTDOWN IMMEDIATE
    Last edited by anacedent; 12-09-07 at 15: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
    Location
    Liverpool, NY USA
    Posts
    2,509
    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.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Dec 2007
    Posts
    2
    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
  •