9 Replies Latest reply on Aug 31, 2012 12:08 PM by 918424

    Can't configure LISTENER for CLUSTER -- Help

    581674
      I have a 2-node cluster running Oracle 10gr2 on RHEL 4.6 86_64. The CRS & RAC were installed without any problem but when trying to create LISTENER for the CLUSTER, it's working on node2 but not on node1. On node1 I am getting "ServiceAliasException: Could not save Service Alias: TNS-04406: Object already exists" and as a consequence, it's failing on node1. I checked (on both nodes) the /etc/hosts & network interfaces etc. but can't find anything wrong anywhere. I am totally confused!
      Can somebody please help?
      Thanks.
        • 1. Re: Can't configure LISTENER for CLUSTER -- Help
          516450
          1. What does "srvctl status nodapps -n <node_1>" indicate?
          2. Do you any differences in the listener.ora files on both the nodes?
          • 2. Re: Can't configure LISTENER for CLUSTER -- Help
            581674
            Here is some more information. I will really help any help you or anybody can provide. I am so confused & baffled by this problem -- tatally stuck! Please note that LISTENER is running on node2 but not on node1 although both the machines have 100% (as far as I understoood) compatibity in hardware, software & configuration -- the only difference I see is in interface eth0/eth0:1 -- where node2 has base addresses but node1 not -- not sure whether it has any meaning and how that happening!
            Thanks.

            netca

            Oracle Net Services Configuration:
            Configuring Listener:LISTENER
            ServiceAliasException: Could not save Service Alias: TNS-04406: Object already exists
            Default local naming configuration complete.
            node1...
            node2...
            Listener configuration complete.
            Oracle Net Services configuration successful. The exit code is 0

            Then a window pops up with the message:

            Problem in configuration: node1: LISTENER_NODE1 Listener start failed. Listener may already be running.
            CRS-0215: Could not start resource 'ora.node1.LISTENER_NODE1.lsnr'



            crs_stat -t
            Name Type Target State Host
            ------------------------------------------------------------
            ora....IN.lsnr application ONLINE UNKNOWN node1
            ora....min.gsd application ONLINE ONLINE node1
            ora....min.ons application ONLINE ONLINE node1
            ora....min.vip application ONLINE ONLINE node1
            ora....IN.lsnr application ONLINE ONLINE node2
            ora....min.gsd application ONLINE ONLINE node2
            ora....min.ons application ONLINE ONLINE node2
            ora....min.vip application ONLINE ONLINE node2

            NODE1:

            srvctl status nodeapps -n node1
            VIP is running on node: node1
            GSD is running on node: node1
            Listener is not running on node: node1
            ONS daemon is running on node: node1

            listener.ora

            LISTENER_node1 =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521)(IP = FIRST)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.103)(PORT = 1521)(IP = FIRST))
            )
            )

            SID_LIST_LISTENER_node1 =
            (SID_LIST =
            (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = /home/orahome/ora10grac)
            (PROGRAM = extproc)
            )
            )

            /etc/hosts
            # Do not remove the following line, or various programs
            # that require network functionality will fail.
            127.0.0.1 localhost.localdomain localhost

            # node1
            192.168.0.103 node1.systems.com node1
            10.0.0.11 node1-priv.systems.com node1-priv
            192.168.0.203 node1-vip.systems.com node1-vip

            # node2
            192.168.0.104 node2.systems.com node2
            10.0.0.12 node2-priv.systems.com node2-priv
            192.168.0.204 node2-vip.systems.com node2-vip


            ifconfig (only giving eth0/eth0:1)

            eth0 Link encap:Ethernet HWaddr 00:19:DB:55:21:02
            inet addr:192.168.0.103 Bcast:192.168.0.255      Mask:255.255.255.0
            inet6 addr: fe80::219:dbff:fe55:2102/64 Scope:Link
            UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
            RX packets:722 errors:0 dropped:0 overruns:0 frame:0
            TX packets:879 errors:0 dropped:0 overruns:0           carrier:0
            collisions:0 txqueuelen:1000
            RX bytes:101986 (99.5 KiB) TX bytes:113411 (110.7 KiB)
            Interrupt:201

            eth0:1 Link encap:Ethernet HWaddr 00:19:DB:55:21:02
            inet addr:192.168.0.203 Bcast:192.168.0.255      Mask:255.255.255.0
            UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
            Interrupt:201

            NODE2

            srvctl status nodeapps -n node2
            VIP is running on node: node2
            GSD is running on node: node2
            Listener is running on node: node2
            ONS daemon is running on node: node2

            listener.ora

            LISTENER_node2 =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521)(IP = FIRST)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.104)(PORT = 1521)(IP = FIRST))
            )
            )

            SID_LIST_LISTENER_node2 =
            (SID_LIST =
            (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = /home/orahome/ora10grac)
            (PROGRAM = extproc)
            )
            )


            /etc/hosts

            # Do not remove the following line, or various programs
            # that require network functionality will fail.
            127.0.0.1 localhost.localdomain localhost

            # node1
            192.168.0.103 node1.systems.com node1
            10.0.0.11 node1-priv.systems.com node1-priv
            192.168.0.203 node1-vip.systems.com node1-vip

            # node2
            192.168.0.104 node2.systems.com node2
            10.0.0.12 node2-priv.systems.com node2-priv
            192.168.0.204 node2-vip.systems.com node2-vip

            ifconfig (only giving eth0/eth0:1)

            eth0 Link encap:Ethernet HWaddr 00:19:DB:55:20:47
            inet addr:192.168.0.104 Bcast:192.168.0.255      Mask:255.255.255.0
            inet6 addr: fe80::219:dbff:fe55:2047/64 Scope:Link
            UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
            RX packets:1056 errors:0 dropped:0 overruns:0      frame:0
            TX packets:836 errors:0 dropped:0 overruns:0           carrier:0
            collisions:0 txqueuelen:1000
            RX bytes:121762 (118.9 KiB) TX bytes:114538 (111.8 KiB)
            Interrupt:201 Base address:0x2000

            eth0:1 Link encap:Ethernet HWaddr 00:19:DB:55:20:47
            inet addr:192.168.0.204 Bcast:192.168.0.255      Mask:255.255.255.0
            UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
            Interrupt:201 Base address:0x2000
            • 3. Re: Can't configure LISTENER for CLUSTER -- Help
              581674
              I believe I have figured it out -- it was fun diving into OS/Network and so on -- anyways, thanks to all.
              • 4. Re: Can't configure LISTENER for CLUSTER -- Help
                418671
                Hi user579671,

                Please can you share how you figured this out? I am having the same problem and cant seem to be making any headway.
                • 5. Re: Can't configure LISTENER for CLUSTER -- Help
                  640040
                  Please share as to how you figured this one out..- Manish (916)803-0011
                  • 6. Re: Can't configure LISTENER for CLUSTER -- Help
                    625450
                    Hi user579671,

                    Please share the solve. I am having exactly the same problem.

                    Help to the oracle's community.

                    Thanks
                    • 7. Re: Can't configure LISTENER for CLUSTER -- Help
                      Brian Lucas
                      I ran into this today as well and saw this post with no information so I thought I'd write how I solved it. It ended up being an ssh equivalence issue for node1. So, as the oracle user on node1, ssh and accept the certificate for the following: node1, node1-priv, node1-vip. Once I did that, I reran netca and all was well.
                      • 8. Re: Can't configure LISTENER for CLUSTER -- Help
                        104998
                        Thanks a lot Brian. This worked for me (ssh equivalence). I ran into this as we "lost" ssh equivalence when we changed the hostname.
                        • 9. Re: Can't configure LISTENER for CLUSTER -- Help
                          918424
                          I received exactly the same issue:

                          Problem in configuration: node1: LISTENER_NODE1 Listener start failed. Listener may already be running.
                          CRS-0215: Could not start resource 'ora.node1.LISTENER_NODE1.lsnr'

                          Solution in my case:_

                          In my case it is the gateway address issue. Actually, I don't have a gateway address for both of the nodes. So, during the VIP configuration I received an error based on the unconfigured gateway. Thus, I was supposed to edit the 'racgvip' file in /crs_home/bin location, ON BOTH NODES, to let it accept even without the gateway ip. But unfortunately, I did edit in only one node and not in the other. So, I am unable start the listener in that node! Finally, when I edited that node as well, I got my listener running in both of nodes.

                          -Vimal.