| How to remove listener entry for one Instance on RAC [message #345449] |
Wed, 03 September 2008 11:54  |
sonumalhi
Messages: 62
Registered: April 2008
|
Member |
|
|
Hi Experts
We have 4 Node cluster environment.
Crs version 10.2.0.3
db version 10.2.0.3
We have 3 databases running on all the 4 nodes.
Recently we want to do some maintainence on one of our Database on the Cluster, So we decided to stop the listener so applications can't connect to that database.
But we have realised that if we stop the listener it will stop the application on ohter 2 databases that we don't want to.
In standalone we can remove database entries from listener but nor sure how can we do it in RAC.
I tried to remove tns entries from tnsnames.ora but of no use.
Is there any way to make listener stop listening to one of the database in the RAC cluster.
Thanks in Advance
thanks
Mehtab
|
|
|
|
| Re: How to remove listener entry for one Instance on RAC [message #345460 is a reply to message #345449] |
Wed, 03 September 2008 12:22  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
It will actually depend on your listener/RAC configs.
Use srvctl to shutdown all participating instances.
srvctl stop database -d dbName
Mount an instance in restricted mode. Do your maintenance.
export ORACLE_SID=dbName1
sqlplus /nolog
..
startup restrict
..
.. check if you can connect from clients. Unless it is been explicitly granted through roles, none except power users can connect.
..
do your stuff
shutdown
start datbases with srvctl again
[Updated on: Wed, 03 September 2008 12:47] Report message to a moderator |
|
|
|
| Re: How to remove listener entry for one Instance on RAC [message #345465 is a reply to message #345460] |
Wed, 03 September 2008 13:18 |
sonumalhi
Messages: 62
Registered: April 2008
|
Member |
|
|
Thanks for reply
Well I don't know whether we can use this solution as we have to partition some tables and we need to stop the connection from apps or some adhoc users to stop any DML acitity on our APPs user.
We would like to do something that only user can login from server not outside the server(via listener).
Mehtab
|
|
|
|
|
|
| Re: How to remove listener entry for one Instance on RAC [message #345485 is a reply to message #345467] |
Wed, 03 September 2008 15:38 |
sonumalhi
Messages: 62
Registered: April 2008
|
Member |
|
|
Mahesh
So if we have only one listener for all 3 databases only option is we have to startup in restricted mode until and unless we have separate listeners for all 3 databases.
So there is no way, we can make Listener to stop listening to database In RAC like in standalone we can easily remove listener entry.
thanks for your Views.
Mehtab
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
