Can you connect to the remote database using sqlplus username/password@(protected)
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.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@(protected);
>select * from global_name@(protected)
> *
>ERROR at line 1:
>ORA-12154 (See ORA-12154.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
