-
Hi,
I'm using Oracle 8.1.7 with Solaris 2.6. I am not able to select data using a db link. Heres what i've done - Using SQL client for WinNT.
SQL> conn system/pw@srv
connected.
SQL> create databae link etslink connect to system
identified by pw using 'ETS';
SQL> /
Database link created.
SQL> select * from dba_tables@etsllink;
select * from tab@etsvollink
*
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
I have both the DB settings set up in TNSNAMES.ORA and am not using SQLNET.ORA. Secondly, I'm able to ping to the other server as well. What could b the problem ? I can also connect to both the DBs without DB link.
Cheers,
Vinit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|