|ORA-12154: TNS:could not resolve the connect identifier specified [message #197502]
||Wed, 11 October 2006 08:51
Registered: September 2006
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.
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
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:
TNS-03505: Failed to resolve name
I have defined the following in the concern network file
(ADDRESS = (PROTOCOL = TCP) (HOST = 220.127.116.11) (PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = DB1.polo)
I've specified the follwing concern parameters in the initDB1.ora file as below:
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.