RE: DBLINK problem

RE: DBLINK problem

 

  


Thanks for all the feedback so far.

What is puzzling is that it works from sqlplus on the box but not from
sqlplus via sqlnet.

Jimmy



-----Original Message-----
From: Buyiswa Mnyani
[mailto:oracledba-ezmlmshield-x2244594.[Email address protected]
Sent: Friday, 25 February 2005 10:10 AM
To: LazyDBA Discussion
Subject: Re: DBLINK problem


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



--------
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


==================================================================
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

Oracle LazyDBA home page