| ORA-12514: TNS: listener does not currently know... [message #183123] |
Wed, 19 July 2006 07:49  |
Fistandantilus
Messages: 1
Registered: July 2006
|
Junior Member |
|
|
Hi,
If I try to connect to my db I get the above named error message. I have already used the search function to resolve my problem but without any success.
The db is 10.2 on WindowsXP SP1. This db runs on my laptop. Connection to other dbs on other servers is no problem.
It doesn´t matter if I use OEM, SQL+ or any other tool I always get the same error.
This is my listener.ora:
| Quote: |
# listener.ora Network Configuration File: C:\AMDApps\Oracle\Ora102\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\AMDApps\Oracle\Ora102)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DDNSKRIEHN)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
|
my sqlnet.ora:
| Quote: |
# sqlnet.ora Network Configuration File: C:\AMDApps\Oracle\Ora102\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# 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)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
|
and my tnsnames.ora:
| Quote: |
# sqlnet.ora Network Configuration File: C:\AMDApps\Oracle\Ora102\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# 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)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
|
tnsping nautilus2 delivers an 'OK'
I hope anybody can help me. This error really sucks. Almost a half day I already try to fix this 
Fistandantilus
[Updated on: Wed, 19 July 2006 07:59] Report message to a moderator |
|
|
|
| Re: ORA-12514: TNS: listener does not currently know... [message #183618 is a reply to message #183123] |
Fri, 21 July 2006 10:00  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Your tnsnames should have the sid and service name in it.
ie.
OS2T =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = solarsystem.deltacollege.edu)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = os2t)
)
)
OS2P =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = solarsystem.deltacollege.edu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = os2p)
)
)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
