About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

**=?ISO-8859-1?Q?ECDC_=A5=CE=AEa?=** · Jun 27 '08, 05:15 PM

Re: About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

kudos12@netian. com (Park Yeon Jo) wrote in message news:<d7fe264d. 0309052220.7423 77ba@posting.go ogle.com>...

About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME
given in connect descriptor
>
>
I installed Oracle 8.1.7 on Windows XP Professional.
>
and I wanto connect to that server from another client computer using
Net 8 Configuration.
>
But congiguration cannot be proceeded because above error .
>
What is the problem ?
I think there may be some problem in Oracle Database Server of Windows
XP.

Hi, Park Yeon Jo,

Here are my ORA files. My platform is Windows 98 and the Oracle client is 8.1.7.

C:\OraHome1\net work\ADMIN>cat sqlnet.ora

# SQLNET.ORA Network Configuration File:
# c:\OraHome1\NET WORK\ADMIN\sqln et.ora

SQLNET.AUTHENTI CATION_SERVICES = (NTS)

NAMES.DIRECTORY _PATH= (TNSNAMES)

SQLNET.CRYPTO_S EED = 4fhfguweotcadsf dsafjkdsfqp5f20 1p45mxskdlfdasf

C:\OraHome1\net work\ADMIN>cat listener.ora

# LISTENER.ORA Network Configuration File:
# c:\OraHome1\NET WORK\ADMIN\list ener.ora

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)

SID_LIST_LISTEN ER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\OraHome1)
(PROGRAM = extproc)
)
)

C:\OraHome1\net work\ADMIN>cat tnsnames.ora

# TNSNAMES.ORA Network Configuration File:
# c:\OraHome1\NET WORK\ADMIN\tnsn ames.ora

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)

Hope this can help.

Rgds,
S W

About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Comment