Database Administration (MOSC)

MOSC Banner

ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

edited Jul 8, 2016 7:35AM in Database Administration (MOSC) 8 commentsAnswered ✓

Oracle database 11g r2 32bit

Window server 2003 r2

C:\Documents and Settings\Administrator>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-MAY-2015 14:54

:17

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 32-bit Windows: Version 11.2.0.1.0 - Produ

ction

Start Date                24-MAY-2015 14:45:28

Uptime                    0 days 0 hr. 8 min. 50 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   E:\app\Administrator\product\11.2.0\dbhome_1\network\a

dmin\listener.ora

Listener Log File         e:\app\administrator\diag\tnslsnr\oracledg1\listener\a

lert\log.xml

Listening Endpoints Summary...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center