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 -> Re: Database link and BEQ protocol

Re: Database link and BEQ protocol

From: JHY <jhy_at_earthling.net>
Date: Mon, 29 Jun 1998 22:13:15 -0400
Message-ID: <6n9hjj$dpg@bgtnsc01.worldnet.att.net>


It should work if both databases are on the same server.

Sven Ubik CPS275 wrote:

> Is it possible to use a database link to connect to a database
> through the BEQ protocol? When I create a database link and try
> the following command:
>
> SQL> select * from tab1_at_dblink1;
>
> I get the following error code:
>
> select * from tab1_at_dblink1
> *
> ERROR at line 1:
> ORA-12668: Message 12668 not found; product=RDBMS; facility=ORA
>
> The database pointed to by dblink1 is running under Oracle 7.3.2 RDBMS in
> Digital UNIX 4.0b. The tnsnames.ora file contains the following entry:
>
> test.world =
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = beq)
> (PROGRAM = /fs2/app/oracle/product/7.3.2/bin/oracle)
> (ARGV0 = oracleTEST1)
> (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
> (ENVS = 'ORACLE_HOME=/fs2/app/oracle/product/7.3.2,ORACLE_SID=test1')
> )
> (CONNECT_DATA =
> (SID = test1)
> (GLOBAL_NAME = test.world)
> )
> )
>
> Thank you very much for any advice or recommendation.
>
> Sven Ubik E-mail: ubik_at_fsid.cvut.cz
> Czech Technical University
> Prague, Czech Republic
Received on Mon Jun 29 1998 - 21:13:15 CDT

Original text of this message

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