Home » RDBMS Server » Networking and Gateways » ORA-12514: TNS:listener does not currently know of service requested (Oracle DB running on Microsoft windows server 2008)
| ORA-12514: TNS:listener does not currently know of service requested [message #570923] |
Sun, 18 November 2012 17:00  |
 |
alihhussain
Messages: 4
Registered: November 2012
Location: Canada
|
Junior Member |
|
|
I am getting the following error.
C:\>sqlplus sys/oracle@duptest as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 18 17:58:22 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
------------------------------------------------------------------------------
My tnsnames.ora is as follows:
# tnsnames.ora Network Configuration File: C:\app\Ali\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
DUPTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-LRTU6C15D75.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = duptest.localdomain)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-LRTU6C15D75.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localdomain)
)
)
----------------------------------------------------------------------------------------------------------
My listner.ora is as follows:
# listener.ora Network Configuration File: C:\app\Ali\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Ali\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Ali\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = orcl.WIN-LRTU6C15D75)
(ORACLE_HOME = C:\app\Ali\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = duptest.WIN-LRTU6C15D75)
(ORACLE_HOME = C:\app\Ali\product\11.2.0\dbhome_1)
(SID_NAME = duptest)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-LRTU6C15D75.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app\Ali
---------------------------------------------------------------------------
Lsnrctl Status is as follows
C:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-NOV-2012 17:55:11
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 18-NOV-2012 17:49:57
Uptime 0 days 0 hr. 5 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Ali\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File c:\app\ali\diag\tnslsnr\WIN-LRTU6C15D75\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-LRTU6C15D75)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "duptest" has 1 instance(s).
Instance "duptest", status BLOCKED, has 1 handler(s) for this service...
Service "duptest.WIN-LRTU6C15D75" has 1 instance(s).
Instance "duptest", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl.WIN-LRTU6C15D75" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun May 04 11:10:53 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
