Home -> Usenet -> comp.databases.oracle -> Problem with CREATE DATABASE LINK ...

Problem with CREATE DATABASE LINK ...

From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/10/25
Message-ID: <DH0E8y.EFI_at_mecati.mecasoft.ch>#1/1 






Hi folks,



I have a strange problem trying to connect with another database.
I have 3 local database: dbadm, test7 and prod7 (nice, isn't it?).
The NetV2 listener permit me to connect with any database with 
username/password_at_<db_name>, and all works fine...



I have to add, I have manually changed the files created with netman in
order to be able to work. The problem was with the DOMAIN. I don't have
used the default 'world' domain, but one created by me: muraltoCH.
I have changed two files in this manner:



listener.ora: old: (Host = nodesu.muraltoCH) new: (Host = nodesu)
tnsnames.ora: old: (Host = nodesu.muraltoCH) new: (Host = nodesu)


              (3 times, one for every database entry)



With this changes (leaving the domain name) the listener was able to
work, else not.



I have then logged in the dbadm database as user 'auditor' and 
defined two database links:




aud> create database link test7


  2    connect to system identified by ... using 'test7';



aud> create database link prod7


  2    connect to system identified by ... using 'prod7';




And, surprise surprise, the FIRST works, the second NOT !!




aud> select * from t01_at_prod7;


ORA-02085: database link PROD7.WORLD connects to PROD7.MURALTOCH



This will works with:




aud> create database link prod7.muraltoCH
  2    connect to system identified by ... using 'prod7';
aud> select * from t01_at_prod7.muraltoCH;



But I don't like to add my domain, and why one works and the other not???



I have also tryied to add the domain at the first one:




aud> select * from t01_at_test7.muraltoCH;
ORA-02019: connection description for remote database not found



aud> create database link test7.muraltoCH
  2    connect to system identified by ... using 'test7';
aud> select * from t01_at_test7.muraltoCH;
ORA-02085: database link TEST7.MURALTOCH connects to TEST7.WORLD
                               



Very strange, isn't it ????? Any suggestion welcomed!
Stefano



    
  
  •   INSTALLATION AT A GLANCE --------------------------

                                         




  ORACLE7 Server (RDBMS) 7.1.6.2.0    TCP/IP Protocol Adapter (V2) 2.1.6.1.0
            CORE Version 2.3.7.1.0           Oracle Server Manager 2.1.3.0.0
                SQL*Plus 3.1.3.7.1          Oracle Network Manager 2.1.6.0.0
                   Pro*C 2.0.6.0.0                 Multimedia APIs 2.0.5.4.0
               PL/SQL V2 2.1.6.2.0                     Oracle Help 2.1.1.0.0
              SQL*Net V2 2.1.6.1.0   Oracle Office Automation Core 2.1.3.0.0
                  SQLLIB 1.6.7.0.0                          NLSRTL 2.3.6.0.0
------------------------------------------------------------------------------
  Stefano Unternaehrer                                           Mecasoft SA
  Oracle DBA                                                    6600 Muralto
  PL/SQL, Pro*C, C, XWindow & Motif                       Switzerland Europe
  Software Developer                                    fax: +41 91 743 5507
  email: dba,unter_at_mecasoft.ch                        voice: +41 91 743 7444


Received on Wed Oct 25 1995 - 00:00:00 CET












Original text of this message