Error creating listener on new RAC node

From oracle-l-bounce@freelists.org Thu Dec 1 18:32:48 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jB20Wm63008974 for ; Thu, 1 Dec 2005 18:32:48 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jB20WgAX008956 for ; Thu, 1 Dec 2005 18:32:42 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53BC823E724; Thu, 1 Dec 2005 19:32:35 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22381-08; Thu, 1 Dec 2005 19:32:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BE28B23FB3D; Thu, 1 Dec 2005 19:32:34 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 01 Dec 2005 19:30:40 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D220B23E687 for ; Thu, 1 Dec 2005 19:30:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22181-08 for ; Thu, 1 Dec 2005 19:30:39 -0500 (EST) Received: from agminet01.oracle.com (agminet01.oracle.com [141.146.126.228]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 78FBF23FF25 for ; Thu, 1 Dec 2005 19:30:39 -0500 (EST) Received: from rgmgw2.us.oracle.com (rgmgw2.us.oracle.com [138.1.186.111]) by agminet01.oracle.com (Switch-3.1.7/Switch-3.1.7) with ESMTP id jB20kISM009617; Thu, 1 Dec 2005 18:46:18 -0600 Received: from localhost (localhost [127.0.0.1]) by rgmgw2.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with SMTP id jB20UaHn017656; Thu, 1 Dec 2005 17:30:36 -0700 Received: from us.oracle.com (dhcp-amer-whq-csvpn-gw3-141-144-83-63.vpn.oracle.com [141.144.83.63]) by rgmgw2.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id jB20UHxh016710; Thu, 1 Dec 2005 17:30:20 -0700 From: "Pete Sharman" To: "jheinrich@pcci.edu" , "Oracle-L Freelists" Cc: "Peter Ross Sharman" Subject: RE: Error creating listener on new RAC node Date: Fri, 2 Dec 2005 11:29:51 +1100 Message-ID: <20051202112951708.00000002644@psharman-au> In-Reply-To: X-Accept-Language: en-au, en MIME-Version: 1.0 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-Brightmail-Tracker: AAAAAQAAAAIX-Whitelist: TRUE X-archive-position: 28838 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: peter.sharman@oracle.com Precedence: normal Reply-To: peter.sharman@oracle.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.2 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE,MIME_HTML_ONLY autolearn=no version=2.63 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.

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jason Heinrich
Sent: Friday, 2 December 2005 10:23 AM
To: Oracle-L Freelists
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.

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

-- http://www.freelists.org/webpage/oracle-l