Home » Server Options » RAC & Failsafe » How to remove listener entry for one Instance on RAC (10.2.0.3 [4 node RAC])
How to remove listener entry for one Instance on RAC [message #345449] Wed, 03 September 2008 11:54 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
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 #345467 is a reply to message #345465] Wed, 03 September 2008 13:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Only DBA's/folks with restricted session can connect.
Why would application users be granted with DBA roles?

As said before, it depends on how you have configured your listener. If each database is using its own listener, you can shut them down individually.
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 Go to previous messageGo to next message
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
Re: How to remove listener entry for one Instance on RAC [message #345488 is a reply to message #345485] Wed, 03 September 2008 16:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> So there is no way, ...
Again, it depends on how you have configured.
You have not posted anything on your configs/listener.

For example, If you are using listener.ora entries, probably you can use "reload" instead of stopping and restarting.

The straight method is to startup in restricted mode which requires no changes.
Re: How to remove listener entry for one Instance on RAC [message #347993 is a reply to message #345488] Mon, 15 September 2008 05:34 Go to previous message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
you can use

$srvctl stop listener -h ,

where it shows all the help options with respect to the listener .

It works.

Regards,
Raj
Previous Topic: Oracle failover server details
Next Topic: Cluster not starting
Goto Forum:
  


Current Time: Tue Mar 19 05:50:51 CDT 2024