Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent help: strange DB_LINK problem...
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
>
>
>
-- 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
![]() |
![]() |