TNS-01101: Could not find service name for LISTENER_SCANx (Doc ID 1064628.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

"srvctl status scan" and "ps -ef | grep tns" shows SCAN1 listeners are enabled and running, but "lsnrctl service" command doesn't work against SCAN listener without setting TNS_ADMIN environment.

 

[grid@node1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node node1
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node node2
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node node3

[grid@node1 ~]$ ps -ef| grep tns
grid 6230 1 0 Mar25 ? 00:00:18 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit

 

 1. Without setting TNS_ADMIN

[grid@node1 ~]$ lsnrctl service LISTENER_SCAN1

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-FEB-2010 15:58:00

Copyright (c) 1991, 2009, Oracle. All rights reserved.

TNS-01101: Could not find service name LISTENER_SCAN1

 

 2.  With setting TNS_ADMIN to $GRID_HOME/network/admin

$ export TNS_ADMIN=$GRID_HOME/network/admin

[grid@node1 ~]$ lsnrctl service LISTENER_SCAN1
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-FEB-2010 17:26:03

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
Services Summary...
Service "k1" has 1 instance(s).
  Instance "k11", status READY, has 1 handler(s) for this service...
  Handler(s):
  "DEDICATED" established:0 refused:0 state:ready
   REMOTE SERVER
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521)))

Changes

11gR2 Grid Infrastructure is installed as a user different from the existing oracle database user. TNS_ADMIN environment variable is unset and 3 SCAN Listeners are running out of GRID_HOME. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms