469,090 Members | 1,222 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

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
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.
Jul 19 '05 #1
1 38501
ku*****@netian.com (Park Yeon Jo) wrote in message news:<d7**************************@posting.google. 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\network\ADMIN>cat sqlnet.ora

# SQLNET.ORA Network Configuration File:
# c:\OraHome1\NETWORK\ADMIN\sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

C:\OraHome1\network\ADMIN>cat listener.ora

# LISTENER.ORA Network Configuration File:
# c:\OraHome1\NETWORK\ADMIN\listener.ora

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

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

C:\OraHome1\network\ADMIN>cat tnsnames.ora

# TNSNAMES.ORA Network Configuration File:
# c:\OraHome1\NETWORK\ADMIN\tnsnames.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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by sasimca007 | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.