ku*****@netian. com (Park Yeon Jo) wrote in message news:<d7******* *************** ****@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