By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.