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

[dbajay]

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

[davey23uk]

tnsping db1.polo

[user52]

change ur (SERVICE_NAME = DB1.polo) to DB1

[davey23uk]

that will solve nothing apart from making things not work