Home » RDBMS Server » Networking and Gateways » ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154: TNS:could not resolve the connect identifier specified [message #197502] Wed, 11 October 2006 08:51 Go to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

Hi,

I created a seperate oracle 10.1 database for our application successfully on Fedora Linux OS Hat.
Currently, I access to remote database server through putty SSH.
I can connect also our database successfully but when I tried it to connect through service name it gives
me the following error message.


ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

When I tried to check it from the OS prompt as below, it gives me this error message

tnsping db1

TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 11-OCT-2006 15:09:46

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.1.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name


I have defined the following in the concern network file

SQlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

Tnsnames.ora

DB1.POLO=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 117.159.154.15) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB1.polo)

I've specified the follwing concern parameters in the initDB1.ora file as below:


db_domain=polo
db_name=DB1
instance_name=DB1

Do I need to define the value of the parameter db_unique_name?


Do I need to create a service name using oradim or something else is wrong to connect successfully through
service name or connect descriptor?


Thanks in advance.

Jay




Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #197509 is a reply to message #197502] Wed, 11 October 2006 09:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
edit sqlnet.ora.
comment all entries.
try again.
Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #197511 is a reply to message #197509] Wed, 11 October 2006 09:15 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
and
>>tnsping db1
but your tnsentry states as
>>DB1.POLO=
So,
you must be trying
tnsping db1.polo
Previous Topic: INSTANCE BLOCKED
Next Topic: ORA-12154 (SQL+ works, web page doesn't)
Goto Forum:
  


Current Time: Thu Dec 08 04:21:53 CST 2016

Total time taken to generate the page: 0.22226 seconds