just go through this text:
ORA-12154: TNS:could not resolve the connect identifier specified
Cause: A connection to a database or other service was requested using
a connect identifier, and the connect identifier specified could not be
resolved into a connect descriptor using one of the naming methods
configured. For example, if the type of connect identifier used was a
net service name then the net service name could not be found in a
naming method repository, or the repository could not be located or
reached.
Action: - If you are using local naming (TNSNAMES.ORA file):-
Make sure that &quo;TNSNAMES&quo; is listed as one of the values of the
NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)-
Verify that a TNSNAMES.ORA file exists and is in the proper directory
and is accessible.- Check that the net service name used as the connect
identifier exists in the TNSNAMES.ORA file.- Make sure there are no
syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched
parentheses or stray characters. Errors in a TNSNAMES.ORA file may make
it unusable.- If you are using directory naming:- Verify that
&quo;LDAP&quo; is listed as one of the values of the NAMES.DIRETORY_PATH
parameter in the Oracle Net profile (SQLNET.ORA).- Verify that the LDAP
directory server is up and that it is accessible.- Verify that the net
service name or database name used as the connect identifier is
configured in the directory.- Verify that the default context being used
is correct by specifying a fully qualified net service name or a full
LDAP DN as the connect identifier- If you are using easy connect
naming:- Verify that &quo;EZCONNECT&quo; is listed as one of the values
of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile
(SQLNET.ORA).- Make sure the host, port and service name specified are
correct.- Try enclosing the connect identifier in quote marks. See the
Oracle Net Services Administrators Guide or the Oracle operating system
specific guide for more information on naming.
>>> "Jimmy Sanby (J) "
<oracledba-ezmlmshield-x49418450.[Email address protected] 02/25/2005
9:15:03 AM >>>
I have created a dblink from an Oracle 8 DB to an Oracle 9 DB.
When I connect via sqlplus on the unix box, the link works
Select * from [Email Address Removed] I connect via sqlplus from my PC the link fails with ORA-12154.
Any ideas??
Jimmy
==================================================================
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page