OraFAQ Forum: RAC & Failsafe » Stop user connections to database

Home » Server Options » RAC & Failsafe » Stop user connections to database (Oracle 11gr2,Linux 6.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Stop user connections to database [message #600487]

Thu, 07 November 2013 03:48

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,

Report message to a moderator

Re: Stop user connections to database [message #600492 is a reply to message #600487]

Thu, 07 November 2013 05:45

John Watson
Messages: 8454
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.

Report message to a moderator

Re: Stop user connections to database [message #600503 is a reply to message #600492]

Thu, 07 November 2013 07:45

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

Report message to a moderator

Re: Stop user connections to database [message #600505 is a reply to message #600503]

Thu, 07 November 2013 07:52

John Watson
Messages: 8454
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.

Report message to a moderator

Re: Stop user connections to database [message #600508 is a reply to message #600505]

Thu, 07 November 2013 08:06

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Ok John.I will do that

Report message to a moderator

Previous Topic:	Startup sequence 10g RAC database with ASM?
Next Topic:	gsd unknown state

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 17 13:35:15 CST 2021