This discussion is archived
11 Replies Latest reply: Sep 13, 2013 8:27 AM by Pradeepcmst RSS

listener_scan1  could not find service name

nraju Newbie
Currently Being Moderated

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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    Hi Raju,

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

     

     

    Regards,

    Pradeep. V

  • 8. Re: listener_scan1  could not find service name
    nraju Newbie
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points