Conference orarep::nomahs::dbintegrator_public_public

1074.0. "LDRV-E-ORA_DB_SUPP, ORA-06401:" by CHSR36::JSUBRI (Focus on Open/Rdb++) Mon Jun 24 1996 08:58

DBI, gateway to Oracle "LORA V3.1-02A" , Oracle 7.1.3 and SQL*NET V2.1 the 
catalog in on Rdb V6.1 all run on the same node . I can't see ORACLE tables. 
SQLPLUS scott/tiger@prod1 works fine. I've see an article on DSN about the 
same error message, the solution was to copy tnsnames.ora to /etc ,
unfortunately I'm on Open/VMS AXP... I tried sys$system,sys$manager,
sys$share... no luck.

Probably I missed something !!!

Thanks
Jean-Luc

SQL> attach 'filename /type=dbi/dbtype=rdb/dbname=rdb$root2:[61]dbi_catalog';
SQL> create link oracle_prod1_link to '/type=oracle-
     /user=scott/pass=tiger/node=chsr36';
SQL> create table emp link to emp using oracle_prod1_link;
%RDB-F-SYS_REQUEST, error from system services request
-DBI-E-ATTLNKERR, Error attaching database, Link name='ORACLE_prod1_LINK',
Connect string='/type=oracle/user=scott/pass=<password>/node=chsr36'
-RDB-E-BAD_DB_FORMAT, /DBKEY_DEFAULT_MODE=NATIVE/MAX_LONG_SIZE=512/NODE=chsr36
/NOENFORCE_ALL_TXN/PASSWORD=/TX_MODE=WARN_1PC/TYPE=ORACLE/USER=SCOTT 
does notreference a database known to DEC DBI Gateway
-LDRV-E-CANT_CONNDB, Can NOT connect to database
/DBKEY_DEFAULT_MODE=NATIVE/MAX_LONG_SIZE=512/NODE=chsr36/NOENFORCE_ALL_TXN
/PASSWORD=/TX_MODE=WARN_1PC/TYPE=ORACLE/USER=SCOTT
-LDRV-E-ORA_DB_SUPP, ORA-06401: (Cnct err, can't get err txt.  See Servr Msgs 
& Codes Manual)

    

Hi Jean-Luc,

The error you are getting is:

06401, "NETCMN: invalid driver designator"
// *Cause:  The login (connect) string contains an invalid driver designator.
// *Action: Correct the string and re-submit.

You say that "sqlplus scott/tiger@prod1" works, but in the create link you have
"/node=chsr36".  Is the service named "prod1" or "chsr36" in your tnsnames file? 
Perhaps you should have "/node=prod1" in the create link statement.  If that isn't the
problem, it is possible that the service "chsr36" is not set up exactly right in the
tnsnames file.

Please let me know if this helps,
						Melanie Kalafatis

Melanie,

>You say that "sqlplus scott/tiger@prod1" works, but in the create link you have
>"/node=chsr36"
        
chsr36 is the physical node and prod1 the entry in tnsnames pointing to my
ORA db. It was a missunderstanding on my side of the "/node" qualifier.

Thanks
Jean-Luc