This discussion is archived
2 Replies Latest reply: Nov 6, 2012 7:46 AM by 934646 RSS

TNS-01101: could not find service name

934646 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    oracle home set to database home..need to set to grid_home

Legend

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