| 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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
