Re: Urgent help: strange DB_LINK problem...

Hi

Can you connect to the remote database using sqlplus username/password@ORCL
 on the server where you are creating the db link?

Try creating the db link with the full connect descriptor in the 
-using-  parameter
remove all spaces as well.

drop the existing link and recreate it

  Example

  Create database link ORCL
  connect to username identified by password
  using' (DESCRIPTION 
=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.54.100.231)(PORT = 
1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL)))'

fwiw -- the pertinant tables
select name from  all_db_links;
user_db_links
dba_db_links
sys.link$;

hth
Bob

>And, now... and type:
>
>SQL> select * from global_name@fnd_remote;
>select * from global_name@fnd_remote
>                          *
>ERROR at line 1:
>ORA-12154: TNS:could not resolve service name
>
>  
>

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: