Unable to start SQL*LOADER session [message #19584] |
Fri, 29 March 2002 07:55 |
David Frankel
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
We are having an unusual problem. When we sign into our UNIX box as one user, and run a script to load an Oracle database, we get an error message. When we sign in as any other user, we are able to run the shell script successfully. We are hardcoding the Oracle username and password, which we know works, so why would the OS user have or make any difference? Remember, we are using the SAME Oracle ID and Password in BOTH runs... See the sysout below....
When running as the "bad user":
/home/rs43/edidevl> whoami
edidevl
/home/rs43/edidevl> /home/rs43/edidevl/load_char_stats.ksh
About to call SQL loader with the following id/password: ed06u0/ed06u0
ORACLE SID is: eddev2
SQL*Loader: Release 8.1.7.0.0 - Production on Fri Mar 29 12:51:37 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL*Loader-128: unable to begin a session
ORA-01017: invalid username/password; logon denied
When running as the "good user":
/home/rs43/edidevl> whoami
xxgvlqr
/home/rs43/edidevl> /home/rs43/edidevl/load_char_stats.ksh
About to call SQL loader with the following id/password: ed06u0/ed06u0
ORACLE SID is: eddev2
SQL*Loader: Release 8.1.7.0.0 - Production on Fri Mar 29 12:52:57 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Commit point reached - logical record count 36
|
|
|
|