2 Replies Latest reply: Nov 6, 2012 9:46 AM by 934646 RSS

    TNS-01101: could not find service name

    934646
      Hello all,

      My env: windows 2008 server R2 with oracle two node RAC (11.2.0.3)

      we are using SCAN. and when i check the lsnrctl status LISTENER it shows the status, but when i check lsnrctl status LISTENER_SCAN1 it gives TNS-01101 error. When i check ed the listener file which is in the grid location I can see the entry in the listener file.

      My listener looks like this:

      LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))          # line added by Agent
      LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))          # line added by Agent
      LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))          # 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_SCAN2=ON          # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON          # line added by Agent
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON          # line added by Agent


      C:\Users\dbadmin>srvctl status scan_listener
      SCAN Listener LISTENER_SCAN1 is enabled
      SCAN listener LISTENER_SCAN1 is running on node xxxxxx
      SCAN Listener LISTENER_SCAN2 is enabled
      SCAN listener LISTENER_SCAN2 is running on node xxxxxx2
      SCAN Listener LISTENER_SCAN3 is enabled
      SCAN listener LISTENER_SCAN3 is running on node xxxxxx2



      Thanks,

      Edited by: 931643 on Nov 6, 2012 7:26 AM
        • 1. Re: TNS-01101: could not find service name
          934646
          LSNRCTL> status LISTENER
          Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
          STATUS of the LISTENER
          ------------------------
          Alias LISTENER
          Version TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
          Start Date 24-OCT-2012 14:27:37
          Uptime 12 days 21 hr. 2 min. 50 sec
          Trace Level off
          Security ON: Local OS Authentication
          SNMP OFF
          Listener Parameter File C:\Oracle\11.2.0\grid\network\admin\listener.ora
          Listener Log File C:\Oracle\11.2.0\grid\log\diag\tnslsnr\listener\alert\log.xml
          Listening Endpoints Summary...
          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\LISTENERipc)))
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xx)(PORT=1521)))
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xx)(PORT=1521)))
          Services Summary...
          Service "+ASM" has 1 instance(s).
          Instance "+asm1", status READY, has 1 handler(s) for this service...
          Service "SAM.example" has 1 instance(s).
          Instance "gisprd1", status READY, has 1 handler(s) for this service...
          Service "SAMXDB.example" has 1 instance(s).
          Instance "gisprd1", status READY, has 1 handler(s) for this service...
          The command completed successfully
          • 2. Re: TNS-01101: could not find service name
            934646
            oracle home set to database home..need to set to grid_home