| From: BROKE::BITHER "Please reply to [email protected]" 26-FEB-1997 14:58:21.86
To: MEMORMAN
CC: BITHER
Subj: New STARS Article
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
\
\ CONTRIBUTORS:
\
\ Technical: Diane Bither
|