Home » SQL & PL/SQL » SQL & PL/SQL » Unable to start SQL*LOADER session
Unable to start SQL*LOADER session [message #19584] Fri, 29 March 2002 07:55 Go to next message
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
Re: Unable to start SQL*LOADER session [message #19586 is a reply to message #19584] Fri, 29 March 2002 09:16 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Most likely an environment variable issue. Try doing a "set" command to a file for both users and do a diff on the files. Check PATH and ORACLE_HOME for sure.
Previous Topic: About select into
Next Topic: ref cursor question
Goto Forum:
  


Current Time: Thu Mar 28 15:23:20 CDT 2024