| ERROR:ORA-12514 [message #306852] |
Mon, 17 March 2008 01:59  |
|
|
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
|
|
|
|
|
|
| Re: ERROR:ORA-12514 [message #306867 is a reply to message #306864] |
Mon, 17 March 2008 02:29  |
|
|
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
