Re: Urgent help: strange DB_LINK problem...

From: Bob Metelsky <bobmetelsky_at_comcast.net>
Date: Fri, 30 Jul 2004 23:53:34 -0400
Message-ID: <410B17BE.3090405@comcast.net>

Hi

Can you connect to the remote database using sqlplus username/password_at_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_at_fnd_remote;
>select * from global_name_at_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_at_freelists.org 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
-----------------------------------------------------------------

Received on Fri Jul 30 2004 - 22:50:42 CDT