RE: Error creating listener on new RAC node

Haven’t seen that one before but it looks like either the listener.ora is malformed or some form of permission problem.  Try copying a known good listener.ora file into $ORACLE_HOME/network/admin as the DB kernel owner and see what happens.

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.

---------------
Jason Heinrich
Oracle Database Administrator
Pensacola Christian College