Re: HELP - Querying remote server
Date: 15 Sep 2000 15:02:21 GMT
Message-ID: <8ptdlt$m47$1_at_news.gte.com>
SQL> select data1 , data2 from schema.table_at_name; select data1 , data2 from schema.table_at_name
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
SQL> !tnsping name
TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.1.6.0.0 - Production on 15-SEP-2000 09:51:39
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(Host=<ip address>)(Port=<port num>)) OK (110 msec)
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
$ sqlplus username/password_at_name
SQL*Plus: Release 8.1.6.0.0 - Production on Fri Sep 15 09:52:17 2000
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle7 Server Release 7.3.2.3.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.3.2.3.0 - Production
In article <8ptc9a$rtk$1_at_nnrp1.deja.com>, Ed.Stevens_at_nmm.nissan-usa.com says...
>
>In article <8pt9of$m24$1_at_news.gte.com>,
> remigius.muforo_at_telops.gte.com (Ramey Muforo) wrote:
>> In Oracle 7.3
>> I can do the following
>>
>> *from local server running oracle 7.3 and it works:
>>
>> select data1, data2, data3, data4
>> from schema.table_at_tnsname;
>>
>> but I can not do the same from local server running oracle 8.1.6:
>> I can login into the remote servers (7.3 and 8.0.5) successfully from
>> local server running 8.1.6
>> sqlplus name/password_at_name
>> tnsping is OK
>> Am I missing something or setting.
>>
>> Thanks in advance for your help.
>>
>> ramey Muforo
>>
>>
>
>--
>What kind of response *do* you get? Error messages? Do you get an ORA-
>nnnnn message?
>
>Ed Stevens
>(Opinions are not necessarily those of my employer)
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Sep 15 2000 - 17:02:21 CEST