Home » RDBMS Server » Networking and Gateways » ERROR:ORA-12514
ERROR:ORA-12514 [message #306852] Mon, 17 March 2008 01:59 Go to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

iam getting below error wheni connecting to oracle 11g
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.



tnsnames:
=====================================================
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kdharanidh1.asiapacific.hpqcorp.net)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
===========================================================
below is hte sqlnet.ora
=============================
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)
#NAMES.DIRECTORY_PATH= (EZCONNECT, TNSNAMES)
====================================================

below is the lsnrctl status

==========================================================
C:\Documents and Settings\dharanid>lsnrctl

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 17-MAR-2008 12:16
:22

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kdharanidh1.asiapacific.
hpqcorp.net)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Produ
ction
Start Date 17-MAR-2008 11:52:34
Uptime 0 days 0 hr. 23 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File c:\app\dharanid\diag\tnslsnr\kdharanidh1\listener\aler
t\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kdharanidh1.asiapacific.hpqcorp.net)
(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL>
============================================
log.xml file
==========================================
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


--------------------------------------------------------------------------------

Only one top level element is allowed in an XML document. Error processing resource 'file:///C:/app/dharanid/diag/tnslsnr/k...

<msg time='2008-03-09T13:35:23.311+05:30' org_id='oracle' comp_id='tnslsnr'
-^

======================================

can you please help me
icon10.gif  Re: ERROR:ORA-12514 [message #306864 is a reply to message #306852] Mon, 17 March 2008 02:25 Go to previous messageGo to next message
indiana
Messages: 10
Registered: February 2007
Location: China
Junior Member
hi,ddkdhar

Have you run the service for listener?

you can check computer management -> services and applications -> service -> %Oracle%Listener%(something like that)

make sure that service is started.


regards
Re: ERROR:ORA-12514 [message #306867 is a reply to message #306864] Mon, 17 March 2008 02:29 Go to previous messageGo to next message
ddkdhar
Messages: 68
Registered: February 2007
Member

thank you for your reply . I resolved thatprobelm but when i starting service of tnslistner . iam getting attached error


and now iam geeting following error

ERROR:
ORA-12518: TNS:listener could not hand off client connection


please help

[Updated on: Mon, 17 March 2008 02:30]

Report message to a moderator

Re: ERROR:ORA-12514 [message #306892 is a reply to message #306852] Mon, 17 March 2008 03:26 Go to previous message
indiana
Messages: 10
Registered: February 2007
Location: China
Junior Member
could you turn on listener tracing and re-execute the operation and put the log on?
Previous Topic: ORA-12518: TNS:listener could not hand off client connection
Next Topic: OID Unique Users Not Guests
Goto Forum:
  


Current Time: Mon Sep 01 15:04:42 CDT 2014

Total time taken to generate the page: 0.25018 seconds