Home » Server Options » RAC & Failsafe » Stop user connections to database (Oracle 11gr2,Linux 6.4)
Stop user connections to database [message #600487] Thu, 07 November 2013 03:48 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

How to stop all user connections to database from application ? Should i have to stop listener in all nodes ?

when i give ps -ef|grep tns , i get output as below

LISTENER
LISTENER_SCAN1
LISTENER_SCAN2

means there are 3 listener configured for all 3 nodes.

Its a RAC database with 3 node cluster.

Thanks,
Re: Stop user connections to database [message #600492 is a reply to message #600487] Thu, 07 November 2013 05:45 Go to previous messageGo to next message
John Watson
Messages: 4610
Registered: January 2010
Location: Global Village
Senior Member
Stopping the scan listeners
srvctl status scan_listener
srvctl stop scan_listener

will not have any effect on existing sessions, but you won't get any new sessions.
You might want to stop the service instead, you can use -force to break existing sessions.
Re: Stop user connections to database [message #600503 is a reply to message #600492] Thu, 07 November 2013 07:45 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you John.

Quote:
srvctl status scan_listener
srvctl stop scan_listener

Should i run this srvctl command in all the 3 nodes or any one node will work ?

Quote:
You might want to stop the service instead, you can use -force to break existing sessions.

< srvctl stop instance -d crm -i crm1 -f >

Could you confirm the above command to stop service using -f command ?

Should this service also needs to be run on all the 3 nodes or any one node will work ?

Thanks
Re: Stop user connections to database [message #600505 is a reply to message #600503] Thu, 07 November 2013 07:52 Go to previous messageGo to next message
John Watson
Messages: 4610
Registered: January 2010
Location: Global Village
Senior Member
It is time you started to do a bit of reading, man. You could also try an experiment.
And in particular, you must be clear on the difference between and instance and a service.
Re: Stop user connections to database [message #600508 is a reply to message #600505] Thu, 07 November 2013 08:06 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Ok John.I will do that
Previous Topic: Startup sequence 10g RAC database with ASM?
Next Topic: gsd unknown state
Goto Forum:
  


Current Time: Tue Sep 30 17:20:58 CDT 2014

Total time taken to generate the page: 0.12356 seconds