OraFAQ Forum: Networking and Gateways » ORA-12154: TNS:could not resolve the connect identifier specified

Home » RDBMS Server » Networking and Gateways » ORA-12154: TNS:could not resolve the connect identifier specified

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12154: TNS:could not resolve the connect identifier specified [message #197502]

Wed, 11 October 2006 08:51

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

edit sqlnet.ora.
comment all entries.
try again.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Previous Topic:	INSTANCE BLOCKED
Next Topic:	ORA-12154 (SQL+ works, web page doesn't)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 16 22:55:36 CDT 2025