Listener error not connecting
- by Sham
I have two database running on Port No : 1521.
When i m connecting to ORCL db it get's connected, but when i try to connect to another DB it gives me following error.
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor.
My Listener:
# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0 \dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
ADMIN_RESTRICTIONS_LISTENER = ON
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.1.1.1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app\Administrator
TNSNAMES.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.1.1.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
PARIVARTAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.1.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Parivartan)
)
)
Lsnrctl Result
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 14-DEC-2012 14:22:51
Uptime 0 days 0 hr. 19 min. 31 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Administrator\product\11.2.0\dbhome_1\network\a
dmin\listener.ora
Listener Log File c:\app\administrator\diag\tnslsnr\127.1.1.1\listener\al
ert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.1.1.1)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
Reply me soon....
