Home » Server Options » RAC & Failsafe » Listener issue in node2 (10G,RAC,Windows 2003)
Listener issue in node2 [message #428359] Wed, 28 October 2009 01:54 Go to next message
mamingui
Messages: 83
Registered: July 2006
Member
Hi,

I want to active archivelog in my RAC DB.
Actually all things seems to be OK in node1.
tnsping is Ok for instance1 and instance2
But listener doesn't see node2.
I use in init.ora file to restart node1 because database must be in mount step before to enable archivelog.
Actually, I can connect to node1 but not in node2 even if tnsping is working.

Someone can help me please ?

Thanks
Re: Listener issue in node2 [message #428385 is a reply to message #428359] Wed, 28 October 2009 03:19 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Please help

output of : lsnrctl status in attached file
Re: Listener issue in node2 [message #428427 is a reply to message #428359] Wed, 28 October 2009 06:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First, do not use init.ora in RAC. Make sure your local init.ora is pointing to spfile in shared area.
Second, use "srvctl" options to shutdown the database.
http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/rmanops.htm#i491246
Then mount the database in single instance mode.
Enable archive logging.
Regarding the listener issue, may be the listener.ora is not configured properly in second node.
copy the listener.ora in first node to second node and change the entries appropriately.
Apart from documentation, here is very nice informative writeup
http://www.dannorris.com/2008/07/21/tns-listener-configuration-for-oracle-rac/
Re: Listener issue in node2 [message #428452 is a reply to message #428359] Wed, 28 October 2009 07:04 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Thank you for your help.

You said : "Make sure your local init.ora is pointing to spfile in shared area."

Question : How to check this point ?

You said : "Second, use "srvctl" options to shutdown the database."

Here is the output of this command

srvctl status database -d mvdbcg
Instance MVDBCG1 is running on node cgtierdb01
Instance MVDBCG2 is not running on node cgtierdb02

Can I use directly this command to shutdown the database:

srvctl stop database -d mvdbcg

Regards
Re: Listener issue in node2 [message #428454 is a reply to message #428452] Wed, 28 October 2009 07:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Question : How to check this point ?
Your $ORACLE_HOME/dbs/init<sid>.ora in each node should point to spfile in shared area.
>>Instance MVDBCG2 is not running on node cgtierdb02
May be the second instance is down or the cluster services is just not seeing it. Manually check if those instances (asm, database and listener) are up and available in node 2.
>>Can I use directly this command to shutdown the database:
Provided both nodes are configured properly, yes.
With srvctl options you can individually control specific asm/database instances from any node.
For srvctl options look here
http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/srvctladmin.htm#RACAD5031

[Updated on: Wed, 28 October 2009 07:20]

Report message to a moderator

Re: Listener issue in node2 [message #428475 is a reply to message #428359] Wed, 28 October 2009 08:24 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Thanks,

First point is Ok (I'm using spfile)
output of crs_stat -t in node2 :

E:\oracle\product\10.2.0\crs\BIN>crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....G1.inst application ONLINE ONLINE cgtierdb01
ora....G2.inst application ONLINE OFFLINE
ora.MVDBCG.db application ONLINE ONLINE cgtierdb02
ora....SM1.asm application ONLINE ONLINE cgtierdb01
ora....01.lsnr application ONLINE ONLINE cgtierdb01
ora....b01.gsd application ONLINE ONLINE cgtierdb01
ora....b01.ons application ONLINE ONLINE cgtierdb01
ora....b01.vip application ONLINE ONLINE cgtierdb01
ora....SM2.asm application ONLINE ONLINE cgtierdb02
ora....02.lsnr application ONLINE ONLINE cgtierdb02
ora....b02.gsd application ONLINE ONLINE cgtierdb02
ora....b02.ons application ONLINE ONLINE cgtierdb02
ora....b02.vip application ONLINE ONLINE cgtierdb02
Re: Listener issue in node2 [message #428479 is a reply to message #428475] Wed, 28 October 2009 08:29 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Name Type Target State Host
------------------------------------------------------------
ora....G1.inst application ONLINE ONLINE cgtierdb01
ora....G2.inst application ONLINE OFFLINE
ora.MVDBCG.db application ONLINE ONLINE cgtierdb02
ora....SM1.asm application ONLINE ONLINE cgtierdb01
ora....01.lsnr application ONLINE ONLINE cgtierdb01
ora....b01.gsd application ONLINE ONLINE cgtierdb01
ora....b01.ons application ONLINE ONLINE cgtierdb01
ora....b01.vip application ONLINE ONLINE cgtierdb01
ora....SM2.asm application ONLINE ONLINE cgtierdb02
ora....02.lsnr application ONLINE ONLINE cgtierdb02
ora....b02.gsd application ONLINE ONLINE cgtierdb02
ora....b02.ons application ONLINE ONLINE cgtierdb02
ora....b02.vip application ONLINE ONLINE cgtierdb02


Looks Node 1 & 2 listener running. Start Node 2 database using SRVCTL.

srvctl start instance -d <name> -i "<inst_name_list>"


- Babu
Re: Listener issue in node2 [message #428482 is a reply to message #428359] Wed, 28 October 2009 08:37 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
output of : srvctl start instance -d mvdbcg -i mvdbcg2
PRkP-1001 : Error starting instance MVDBCG2 on node cgtierdb02
CRS-0215 : Could not start resource 'ora.MVDBCG.MVDBCG2.inst'.

Re: Listener issue in node2 [message #428486 is a reply to message #428482] Wed, 28 October 2009 08:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This is very generic message.
Post the relevant contents of crsd.log
Re: Listener issue in node2 [message #428489 is a reply to message #428359] Wed, 28 October 2009 08:50 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Ok,

Please find attached the crsd.log
  • Attachment: crsd.log
    (Size: 427.72KB, Downloaded 2118 times)
Re: Listener issue in node2 [message #428492 is a reply to message #428359] Wed, 28 October 2009 09:01 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
and the alertmvdbcg2.log
Re: Listener issue in node2 [message #428509 is a reply to message #428492] Wed, 28 October 2009 10:00 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


As per log check with metalink document id 605540.1

Or

Upgrade your database to 10.2.0.4

- Babu
Previous Topic: Transparent Application Failover(TAF) at Application Layer
Next Topic: RMAN ARCHIVING
Goto Forum:
  


Current Time: Thu Mar 28 12:55:45 CDT 2024