TNSPING could not resolve name
Hello I have configured 1 listerner for 2 databases on port 1521,
when I use sqlplus sys/******@LISTENERC11 as sysdba I get
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 30 11:25:58 2011
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
listener.ora :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SAMEHOST.CPSHO.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME=/oracle/NPS/11202)
(SID_NAME=NPS))
(SID_DESC=
(SID_NAME=C11)
(ORACLE_HOME=/oracle/C11/11203)
)
)
ADR_BASE_LISTENER = /oracle
tnsnames.ora:
LISTENERNPS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
SAMESHOST)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = NPS)
)
)
LISTENERC11 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
SAMEHOST)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME= C11)
)
)
Please advice.
Thanks
ME.