-
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.
-
Shut the listener down first.
Jeff Hunter
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|