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

kudos12_at_netian.com (Park Yeon Jo) wrote in message news:<d7fe264d.0309052220.742377ba_at_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 Received on Thu Sep 18 2003 - 12:43:04 CEST