loopback connection

From: Carl Van de Casteele <cvandecasteele_at_tis.be>
Date: 1997/03/13
Message-ID: <3327d587.476694@news.innet.be>#1/1

Can somebody help in setting up a 'loopback connection' for testing distributed option with 1 instance and 1 database (selecting something from user2.table in a user1 session).

We tried several statements and got several different error messages :

• - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - SQL> create public database link mydb.world_at_zoeloe 2 connect to fina2 identified by fina2;

Database link created.

SQL> select count(*) from fina.skid_at_mydb.world_at_zoeloe; select count(*) from fina.skid_at_mydb.world_at_zoeloe

                               *

ERROR at line 1:
ORA-02019: connection description for remote database not found

• - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - SQL> create public database link mydb_at_zoeloe.world 2 connect to fina2 identified by fina2; create public database link mydb_at_zoeloe.world * ERROR at line 1: ORA-02083: database name has illegal character '.'
• - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - SQL> create public database link mydb.world 2 connect to fina2 identified by fina2; connect to fina2 identified by fina2 * ERROR at line 2: ORA-02082: a loopback database link must have a connection qualifier
• - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - SQL> create public database link mydb 2 connect to fina2 identified by fina2 3 using 'zoeloe.world'

ERROR at line 2:
ORA-02082: a loopback database link must have a connection qualifier

• - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - SQL> create public database link mydb 2* connect to fina2_at_zoeloe.world identified by fina2;

ERROR at line 2:
ORA-02082: a loopback database link must have a connection qualifier

• - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

We have an Oracle 7.3.2.1.1 RDBMS on a Novel Netware 4.1 server.

DB_NAME = mydb
DB_DOMAIN = world
in initora7.ora file

Thanks for all suggestions.

Carl Van de Casteele Received on Thu Mar 13 1997 - 00:00:00 CST