Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> remote access

remote access

From: Ong Chin Hui <chong_at_hq.psa.com.sg>
Date: Fri, 20 Nov 1998 07:11:31 GMT
Message-ID: <3655161e.1317855994@butler.psa>


Hi, I am trying to access a remote database using database link but I keep encountering hitting some error messages. I will be glad if someone could point out my mistakes or how to troubleshoot them.

What I did:

SQL> create database link dlink using 'billusr01/billusr01_at_powprodb';

note: powprodb is the SID of the remote database.

SQL> describe user_tables_at_dlink;
ERROR:
ORA-12154: TNS:could not resolve service name Received on Fri Nov 20 1998 - 01:11:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US