Home » RDBMS Server » Server Administration » ORA-12514: tns:LISTENER COULD NOT RESOLVE service_name GIVEN IN CONNECT DESCRIPTOR
ORA-12514: tns:LISTENER COULD NOT RESOLVE service_name GIVEN IN CONNECT DESCRIPTOR [message #53524] Wed, 25 September 2002 12:20 Go to next message
Larry Freeman
Messages: 2
Registered: September 2002
Junior Member
I get this error when trying to connect in SQLPLUS, after installing Net8 Client on a Windows2000 machine, and configuring the client TNSNAME.ora file using Net8 assisstant.

The server is a Unix server, running Oracle 8.1.7

I can TNSPING succesfully, (and test successfully from within NET8 assistant) but can not connect to the database through SQLPLUS.

We already have Net8 client successfully installed on other Windows2k clients, and the TNSNAMES.ORA files are exactly the same.

# TNSNAMES.ORA Network Configuration File: C:oracleora81NETWORKADMINtnsnames.ora
# Generated by Oracle configuration tools.

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

What is the problem?
Re: ORA-12514: tns:LISTENER COULD NOT RESOLVE service_name GIVEN IN CONNECT DESCRIPTOR [message #53526 is a reply to message #53524] Wed, 25 September 2002 14:02 Go to previous messageGo to next message
Suresh
Messages: 189
Registered: December 1998
Senior Member
server_name??

It should be the service name of the instance from your init.ora file. Also make sure what you have in SQLNET.ora (like domain name, resolution method) are correct and matches the entry in the TNSNAMES.ora
Re: ORA-12514: tns:LISTENER COULD NOT RESOLVE service_name GIVEN IN CONNECT DESCRIPTOR [message #53529 is a reply to message #53524] Wed, 25 September 2002 14:23 Go to previous message
Larry Freeman
Messages: 2
Registered: September 2002
Junior Member
"server_name??

It should be the service name of the instance from your init.ora"

I will check those values. Thanks
Previous Topic: ORA-00600 fet$
Next Topic: Re: Help!! Cannot install oracle on P4
Goto Forum:
  


Current Time: Fri Sep 20 01:55:07 CDT 2024