| Listener issue in node2 [message #428359] |
Wed, 28 October 2009 01:54  |
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 #428452 is a reply to message #428359] |
Wed, 28 October 2009 07:04  |
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 |
 |
Mahesh Rajendran
Messages: 10708
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 |
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 #428482 is a reply to message #428359] |
Wed, 28 October 2009 08:37 |
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'.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
