11 Replies Latest reply: Sep 13, 2013 10:27 AM by Pradeepcmst RSS

    listener_scan1  could not find service name

    nraju

      Hi All,

       

      I have installed 11203 on 2 node RAC cluster. I have created 1 scan listener. when i give lsnrctl status LISTENER_SCAN1, I am getting below error

      TNS-01101: Could not find service name LISTENER_SCAN1

       

      Please give your suggestions and help on this issue.

       

      Thanks,

      NR

        • 1. Re: listener_scan1  could not find service name
          Pradeepcmst

          Hi Raju,

           

          Was you RAC installation a complete one without any error? Coz i installed RAC default listener and scan_listener were up by itself.

          And check Listener_scan1 status using srvctl utility since its RAC..

           

           

          Regards,

          Pradeep. V

          • 2. Re: listener_scan1  could not find service name
            nraju

            Hi Pradeep,

             

            Yes. My RAC installation is successful without any issues. I tried with srvctl and getting below issue,

             

            srvctl status listener -l LISTENER_SCAN1

            PRCN-2066 : Failed to retrieve cluster listener for LISTENER_SCAN1 because it has the type of Single Client Access Name Listener

             

            Thanks,

            NR

            • 3. Re: listener_scan1  could not find service name
              Pradeepcmst

              Hi Raju,

              Kindly use this command to check the scan listener

              srvctl status scan_listener -i <ordinal number>


              this link would be useful for u..

              http://docs.oracle.com/cd/E11882_01/rac.112/e16795/srvctladmin.htm


              Regards,

              Pradeep. V

              • 4. Re: listener_scan1  could not find service name
                nraju

                Hi Pradeep,

                 

                Thanks for the command and document.

                SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521 - This means my scan listener is working fine.

                I have another issue like, after I create database, the tnsnames.ora has only one entry with the DBNAME, I dont see any entires of the instances. Like ( TESTDB, but not TESTDB1,TESTDB2)

                I am able to connect to TESTDB using sqlplus, but not with TESTDB1 or TESTDB2.

                I tried to add these instances to tnsnames.ora file, but could not connect. Is something wrong ?

                 

                Thanks,

                NR

                • 5. Re: listener_scan1  could not find service name
                  Pradeepcmst

                  Hi Raju,

                  The concept is little different when it comes to RAC...  In TNSnames.ora file you will see only the database name which is TESTDB(according to your case). TESTDB1 and TESTDB2 are two instance on two machines. So if you have n number of nodes in a RAC environment, you will have n instances, each one on each systems. But database name will be same across same for all nodes. So if you connect the database using the TESTB(database), depending on the load, you will be redirected to one of the servers which is the feature of RAC.. Like wise for ASM also you will have N asm instances(like +ASM1, +ASM2, +ASM3.... and so on until N)  if you have N nodes.

                   

                   

                  Regards,

                  Pradeep. V

                  • 6. Re: listener_scan1  could not find service name
                    nraju

                    Hi Pradeep,

                     

                    Thanks for the detail explanation. I am aware of the DB and Instances on RAC system. In 10g I can used to connect specific instance either TESTDB1 or TESTDB2 if i make an entry in TNSNAMES.ora file with the VIP. We used to use this to make some service instances connect to specific instance.

                     

                    When we create database in 10g, the tnsnames.ora file will have DB entry and Instance entry and local listeners. But in 11g after I create database, I could only see entry just the TESTDB.


                    My question is, Is it possible to connect specific instance in 11g, by making an entry in tnsnames.ora file. I tried but could not connect.

                     

                    Thanks again for your timely help.

                     

                    Thanks,

                    NR

                    • 7. Re: listener_scan1  could not find service name
                      Pradeepcmst

                      Hi Raju,

                      kindly post the listner.ora and tnsnames.ora content..

                       

                       

                      Regards,

                      Pradeep. V

                      • 8. Re: listener_scan1  could not find service name
                        nraju

                        Hi Pradeep,

                         

                        Listener.ora

                        LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))        # line added by Agent
                        LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))            # line added by Agent
                        ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON            # line added by Agent
                        ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON          # line added by Agent

                         

                        Tnsnames.ora

                         

                        TBESTDB =

                          (DESCRIPTION =

                            (ADDRESS = (PROTOCOL = TCP)(HOST = scan_name)(PORT = 1521))

                            (CONNECT_DATA =

                              (SERVER = DEDICATED)

                              (SERVICE_NAME = TBESTDB)

                            )

                          )

                         

                        ( I am using only 1 scan, oonfigured in DNS).

                         

                        Thanks,

                        NR

                        • 9. Re: listener_scan1  could not find service name
                          Pradeepcmst

                          HI,

                           

                          Try to configure the tnsnames.ora in this format and let me know

                          if you are using load balancing , try

                           

                          TBESTDB =

                            (DESCRIPTION =

                              (ADDRESS = (PROTOCOL = TCP)(HOST = node1_vip)(PORT = 1531))

                          (ADDRESS = (PROTOCOL = TCP)(HOST = node2_vip)(PORT = 1531))

                          (LOAD_BALANCE = yes)

                          (CONNECT_DATA =

                          (SERVER = DEDICATED)

                          (SERVICE_NAME = TBESTDB)

                              )

                            )


                          And you can add below if you would like to  connect to specific instance


                          RAC1 =

                           

                           

                            (DESCRIPTION =

                           

                           

                              (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))

                           

                           

                              (CONNECT_DATA =

                           

                           

                                (SERVER = DEDICATED)

                           

                           

                                (SERVICE_NAME = rac.oracle.com)

                           

                           

                                (INSTANCE_NAME = rac1)

                           

                           

                              )

                           

                           

                            )

                           

                           

                           

                           

                           

                           

                           

                           

                          RAC2=

                           

                           

                            (DESCRIPTION =

                           

                           

                              (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))

                           

                           

                              (CONNECT_DATA =

                           

                           

                                (SERVER = DEDICATED)

                           

                           

                                (SERVICE_NAME = rac.oracle.com)

                           

                           

                                (INSTANCE_NAME = rac2)

                           

                           

                              )

                           

                           

                            )

                           

                           

                          Note: Replace the SID, Servicename, hostname, port etc according to your environment, And also make sure that the tnsnames.ora should be in a proper format(eg : even the opening and closing bracket should be in correct order. If u add additional space also it will throw error..)

                           

                           

                           

                          Regards,

                          Pradeep. V

                          • 10. Re: listener_scan1  could not find service name
                            nraju

                            Hi Pradeep,

                             

                            Now I am able to connect to specific instance. I already made entry in my tnsnames.ora file Instance specific. But I missed to change the service name to SID.

                            This is the reason I could not connect to specific instance. Thanks a lot for your continuous help.

                             

                            One last things :

                             

                            * Listener is created from grid user and listener.ora file is created under GRID_HOME/network/admin

                            * DB created using dbca from ORACLE_HOME, tnsnames.ora file created under ORACLE_HOME/nework/admin

                             

                            Could you please tell me whether this is proper ? if not please suggest me the recommended configuration.

                             

                            Thanks,

                            NR

                            • 11. Re: listener_scan1  could not find service name
                              Pradeepcmst

                              Hi Raju,

                               

                              I have also seen people setting separate listener for ASM alone under grid home, and separate database listener for databases under oracle_home.So it really depends upon our requirement. yes your configuration is correct.

                               

                               

                               

                              Regards,

                              Pradeep. V