DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DB SHUTDOWN IMMEDIATE

  1. #1
    Join Date
    Sep 2000
    Posts
    77
    I am trying to shutdown database with immediate option and it is taking 3 to 4 minutes. Meanwhile client programmes are trying to connect to Database via SQL*PLUS and spawing OS processes on unix box.
    Probably Listener is spawing the OS processes on UNIX box. Within this 3 to 4 minutes approximately 500 clients will try to connect to Database, but if the shutdown is taking more than 5 minutes the number of connection requests will be more and it is shutting down the unix box due to lack of memory. Can anyone suggest how to avoid idle OS processes while shutdown is in process.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Shut the listener down first.
    Jeff Hunter

  3. #3
    Join Date
    Sep 2000
    Posts
    77
    Jeff,
    I am trying to simulate a real-time situation. But in real time by the time I stop the listener many connection request might have hit the DB. If the DB shutdown is in process it won't allow any new connections but I am seeing it is spawing some OS processes on UNIX box. Please correct me if I am wrong.
    Thanks

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Shutdown the listener before you shutdown the database. When the listener is down, no new requests will be serviced.
    Jeff Hunter

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