Conference orarep::nomahs::dbstars

759.0. "using ext identified users w/rtg/ora" by BROKE::BITHER () Tue Apr 08 1997 14:28

Good article:

     <<< NOMAHS::DISK$NOMAHS1:[NOTES$LIBRARY]DBINTEGRATOR_PUBLIC.NOTE;2 >>>
                      -< DB Integrator Public Conference >-
================================================================================
Note 1145.0               OS identification to Oracle?                 3 replies
chsr38.ch.oracle.com::RROHR "The Packers did it!"    29 lines   4-APR-1997 10:17
--------------------------------------------------------------------------------
    I am having a hard time getting OS identification working with the Oracle
    gateway.
    
    My Oracle user (on the same machine) is identified externally, so I only 
    specify the type and node qualifiers. 
    
    Is there anything else I can look for?
    
    Also, the error message that comes back, is confusing. ORA-6401 is an
    SQLnet V1 message!! (No, I have not even installed V1). My earlier tests 
    today always gave this error message when either username or password 
    were wrong.  
    
    Sorry, text is a bit scrambled.
    
    %RDB-F-SYS_REQUEST, error from system services request
    -DBI-E-ATTACHERR, Error attaching database, Connect
    string='/type=oracle/node=t*
    -RDB-E-BAD_DB_FORMAT,
    /DBKEY_DEFAULT_MODE=NATIVE/MAX_LONG_SIZE=512/NODE=tcpemp3*
    -LDRV-E-CANT_CONNDB, Can NOT connect to database
    /DBKEY_DEFAULT_MODE=NATIVE/MAX*
    -LDRV-E-ORA_DB_SUPP, ORA-06401: (Cnct err, can't get err txt.  See
    Servr Msgs &*
    
    Thanks,
    Regina
    
    
================================================================================
Note 1145.1               OS identification to Oracle?                    1 of 3
BROKE::BITHER                                       164 lines   4-APR-1997 12:40
                           -< some causes of 06401 >-
--------------------------------------------------------------------------------
Hi Regina,

We've seen the 06401 a number of times and it has been caused for a
variety of reasons.  Below are 2 articles on this error.  Unfortunately
no situation was using an externally defined Oracle user.  But possibly 
the following may still help.  If none of the below help, could you
tell me how to define an externally identified user in Oracle and I
will try recreating the problem here.

Thanks, Diane

----------------
TITLE:      -LDRV-E-ORA_DB_SUPP, ORA-01005, ORA-01017, ORA-06039

PRODUCT:    Rdb Transparent Gateway to Oracle

OP/SYS:     OpenVMS VAX, OpenVMS AXP
            Digital UNIX

SOURCE:     Oracle Worldwide Customer Support


PROBLEM:

Attaching to Oracle using Rdb Transparent Gateway to Oracle and a
configuration file results in one of the following errors:

SQL> attach 'filename /type=oracle/config=oraconfig.dat';

  1.  -LDRV-E-ORA_DB_SUPP, ORA-01017
  2.  -LDRV-E-ORA_DB_SUPP, ORA-01005
  3.  -LDRV-E-ORA_DB_SUPP, ORA-06039
  4.  No error - the attach hangs.


SOLUTION:

Check the format of the configuration file.  Each qualifier should be on
a separate line:

/node=xxx
/user=xxx
/pass=xxx

The order of the above qualifiers does not matter as long as they 
are placed on separate lines.


ANALYSIS:

If the above qualifiers are placed on the same line in the configuration
file, one of the following errors will result depending on whether SQL*Net
or VMS mailbox is being used and depending on the order of the qualifiers:

1.  -LDRV-E-ORA_DB_SUPP, ORA-01017
   
This error translates to "invalid username/password; logon denied"

This error will occur if using VMS Mailbox and the configuration file has 
all the qualifiers on a single line in one of the following orders:
  /node=xxx/user=xxx/pass=xxx
  /node=xxx/pass=xxx/user=xxx
  /pass=xxx/user=xxx/node=xxx
  /pass=xxx/node=xxx/user=xxx

This error will occur if using SQL*Net and the configuration file has 
all the qualifiers on a single line in one of the following orders:
  /pass=xxx/user=xxx/node=xxx
  /pass=xxx/node=xxx/user=xxx


2.  -LDRV-E-ORA_DB_SUPP, ORA-01005

This error translates to "null password given; logon denied"

This error will occur if using VMS Mailbox and the configuration file has 
all the qualifiers on a single line in one of the following orders:
  /user=xxx/pass=xxx/node=xxx
  /user=xxx/node=xxx/pass=xxx


3.  -LDRV-E-ORA_DB_SUPP, ORA-06039

This error translates to "NETDNT: connect failed" (Connect failed due
to unexpected reason.)

This error will occur if using SQL*Net and the configuration file has 
all the qualifiers on a single line in one of the following orders:
  /node=xxx/user=xxx/pass=xxx
  /node=xxx/pass=xxx/user=xxx


4.  No error - the attach hangs.

This error will occur if using SQL*Net and the configuration file has 
all the qualifiers on a single line in one of the following orders:
  /user=xxx/pass=xxx/node=xxx
  /user=xxx/node=xxx/pass=xxx

------------------------------------------------------------------------
TITLE:    -LDRV-E-ORA_DB_SUPP, ORA-06401 Attaching to Oracle

PRODUCT:  Rdb Transparent Gateway to Oracle

OP/SYS:   OpenVMS VAX and AXP
          Digital UNIX

SOURCE:   Oracle Worldwide Customer Support


PROBLEM:

Attaching to an Oracle database using Rdb Transparent Gateway to Oracle
results in the following error:

SQL> attach 'filename /type=oracle/node=proto/user=scott/pass=tiger';
.
.
.
-LDRV-E-ORA_DB_SUPP, ORA-06401: Unable to open message file (SQL-02113).
or
%LDRV-E-ORA_DB_SUPP, ORA-06401: (Cnct err, can't get err txt.  See Servr Msgs 
& Codes Manual)


SOLUTION:

The definition of the ORA-06401 error is the following:

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

There have been several problems that we have seen that would cause this 
error.  All problems revolve around the tnsnames.ora file.  If you encounter
this error, check your tnsnames.ora file for the following possible problems:

1. On UNIX systems, tnsnames.ora must reside in the /etc directory in
   order for the Gateway to see it.  So rename or copy tnsnames.ora 

      FROM:   $ORACLE_HOME/network/admin/tnsnames.ora
      TO:     /etc/tnsnames.ora

   on the node where Rdb Transparent Gateway to Oracle resides.

2. We have also seen this problem when non-privileged accounts cannot access
   the tnsnames.ora file.  Ensure that tnsnames.ora has world read and execute
   file protections.

3. Be sure that the /NODE qualifier on your attach string is equal to a 
   service name defined in the tnsnames.ora file, not the physical node name 
   of the system where Oracle is installed.

4. Be sure that the tnsnames.ora file does not contain any errors when defining
   a service.  We have seen this error occur when there have been typographical
   errors included in a service definition, and that service is then used for 
   access.

5. Also be sure that the username issuing the attach statement has run the
   orauser.com file prior to issuing the attach.  ORAUSER.COM is used to set
   up the Oracle environment including the setup of a logical name that 
   points to the location of tnsnames.ora.


================================================================================
Note 1145.2               OS identification to Oracle?                    2 of 3
chsr38.ch.oracle.com::RROHR "The Packers did it!"    14 lines   7-APR-1997 00:59
                                -< Use SQLDBA >-
--------------------------------------------------------------------------------
    To define an external identifation (OS identifation).
    
    Use SQLDBA. Connect internal. F14 for menu, C for security, 
    alter user to OS id.
    
    Or, 
    SQLDBA lmode=true
    connect internal
    alter user RROHR identified externally
    
    Thanks,
    Regina
    
    
================================================================================
Note 1145.3               OS identification to Oracle?                    3 of 3
chsr38.ch.oracle.com::RROHR "Cajun? Zeydeco? Both!"   5 lines   8-APR-1997 11:31
                         -< REMOTE_OS_AUTHENT = TRUE >-
--------------------------------------------------------------------------------
    Turns out that if you want external identification AND access via SQL*net 
    then you have to set REMOTE_OS_AUTHENT in the db init.ora to TRUE.
    
    regards,
    Regina

RE: Good article:

Can we add this to the 6401 article??

I'd like to have all the reasons for this error in one article.

Renee