Home » Server Options » RAC & Failsafe » Listener went offline during network issue (Oracle 11gr2,Linux 5)
Listener went offline during network issue [message #594486] Thu, 29 August 2013 02:28 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Hi,

Recently we had faced network issue due to which node3 server was inaccessible.After the network issue got resolved , node3 was accessbile.So once the issue got fixed , i did a post validation in database and cluster and found listener , network1.org on node3 went offline.

When i try to start listener on node3,i got following error.
grid@RAC3 ~]$ srvctl start listener
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-2674: Start of 'ora.net1.network' on 'RAC3' failed

[grid@RAC3 ~]$ srvctl status vip -n RAC3
VIP RAC3-vip is enabled
VIP RAC3-vip is not running
[grid@RAC3 ~]$ srvctl status vip -n RAC2
VIP RAC2-vip is enabled
VIP RAC2-vip is running on node: RAC2
[grid@RAC3 ~]$ srvctl start vip -n RAC3
PRKO-2420 : VIP is already started on node(s): RAC2
[grid@RAC3 ~]$ srvctl status vip -n RAC3
VIP RAC3-vip is enabled
VIP RAC3-vip is not running
[grid@RAC3 ~]$ srvctl status nodeapps
VIP RAC1-vip is enabled
VIP RAC1-vip is running on node: RAC1
VIP RAC2-vip is enabled
VIP RAC2-vip is running on node: RAC2
VIP RAC3-vip is enabled
VIP RAC3-vip is running on node: RAC2
Network is enabled
Network is running on node: RAC1
Network is running on node: RAC2
Network is not running on node: RAC3
GSD is disabled
GSD is not running on node: RAC1
GSD is not running on node: RAC2
GSD is not running on node: RAC3
ONS is enabled
ONS daemon is running on node: RAC1
ONS daemon is running on node: RAC2
ONS daemon is not running on node: RAC3


Please help me to bring up the listener on node3

Thank you

[Updated on: Thu, 29 August 2013 02:29]

Report message to a moderator

Re: Listener went offline during network issue [message #594491 is a reply to message #594486] Thu, 29 August 2013 03:11 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
srvctl stop vip -i rac3-vip -v
srvctl start vip -i rac3-vip -v
Re: Listener went offline during network issue [message #594508 is a reply to message #594491] Thu, 29 August 2013 05:31 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Hi John,

Can you tell me what this srvctl command would do exactly ?
Would there be impact to database and application by restarting vip on node3?
Can we restart vip at any time or should we do this during maintenance window ?

Thank you

[Updated on: Thu, 29 August 2013 05:33]

Report message to a moderator

Re: Listener went offline during network issue [message #594513 is a reply to message #594508] Thu, 29 August 2013 06:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can you tell me what this srvctl command would do exactly ?


srvctl

Regards
Michel
Re: Listener went offline during network issue [message #594536 is a reply to message #594513] Thu, 29 August 2013 12:40 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Hi Michel,

Thank you for the link.

Could you answer my other 2 questions ? also could you confirm vip stop and start command?

srvctl stop vip -i vip_name -v

srvctl start vip -i vip_name -v

Thanks

[Updated on: Thu, 29 August 2013 12:40]

Report message to a moderator

Re: Listener went offline during network issue [message #594537 is a reply to message #594536] Thu, 29 August 2013 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No I can't, John far better knows RAC than me, just wait a while, maybe it will be tomorrow for you.

Regards
Michel
Re: Listener went offline during network issue [message #594561 is a reply to message #594537] Fri, 30 August 2013 02:52 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Michel,
i forgot to add john in my previous post.

John,

could you answer my other 2 questions?

Thanks
Re: Listener went offline during network issue [message #594572 is a reply to message #594561] Fri, 30 August 2013 03:15 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
No-one has ever told me the answers to your questions, but you can deduce the answers as I did if you think about for what a VIP is used.
It is a listening address through which a user process contacts a database listener. Then the listener establishes a session for the user process to a server process, through the VIP. RAC complicates the issue bit, because there is an initial request to a SCAN listener followed by a redirection to the VIP, but the end result is the same.
Re: Listener went offline during network issue [message #594596 is a reply to message #594572] Fri, 30 August 2013 11:16 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

John,
Thanks for your explanation about VIP.

could you explain me why you are suggesting me to restart VIP for this issue ?

Thank you
Re: Listener went offline during network issue [message #594598 is a reply to message #594596] Fri, 30 August 2013 11:22 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I give up.
Re: Listener went offline during network issue [message #594629 is a reply to message #594598] Sat, 31 August 2013 07:09 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

John,

Quote:
I give up.

what does it mean ?
Re: Listener went offline during network issue [message #594630 is a reply to message #594629] Sat, 31 August 2013 07:13 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
It means that I have come to the conclusion that you can lead some folks to knowledge, but you can't make them think.
Previous Topic: RAC DB instance
Next Topic: RMAN Backup
Goto Forum:
  


Current Time: Thu Mar 28 06:18:45 CDT 2024