| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Error creating listener on new RAC node
Jason, did you create the 2nd instance on the new node and is it running
ok? Did you use DBCA or oradim to create the 2nd instance? Are you using
a shared ORACLE_HOME directory or local to each node?
What is your remote_listener and local_listener set to in v$spparameter?
select sid, name, value, isspecified, ordinal
from v$spparameter
where name like ('%listener%')
order by 1
Jason Heinrich <jheinrich_at_pcci.edu>
Sent by: oracle-l-bounce_at_freelists.org
12/01/2005 06:23 PM
Please respond to jheinrich
To: Oracle-L Freelists <oracle-l_at_freelists.org>
cc:
Subject: Error creating listener on new RAC node
I am getting my feet wet with RAC. Platform is Oracle 10g R2 on Windows 2000. I’ve setup a 1-node test cluster, and now I’m attempting to add a second node. However, when I try to create the listener on the new node, netca fails with the error below:
ServiceAliasException: Could not initialize Service Alias: TNS-04404: no
error
caused by: oracle.net.config.ConfigException: TNS-04414: File error
caused by: TNS-04612: Null RHS for "TCORE1.PCCI.EDU"
"TCORE1" is the database instance on the first node. Following the instructions given in every piece of documentation I’ve read so far, I ran netca on the new node, did a cluster configuration, and chose only the new node from the list. Thinking that something on node 1 might be causing the problem, I even dropped the listener from that node and attempted to create both at once from node 1, with the same results. So now I’m getting the error on both nodes.
I was able to setup and started the listeners manually, but I don’t know how to register them with the clusterware so they can be controlled via srvctl. I’ve got a TAR — sorry, SR — submitted to Oracle Support, but I was wondering if anyone in the Oracle community has seen this error and/or has an idea as to what I can do about it.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 02 2005 - 08:36:25 CST
 |
 |