Can we invoke sqlldr command remotely.
When I try rsh command in machine 10.1.65.116, it's failed on sqlloader command. However, nothing wrong on the shell scripts or environment setting of the remote environment, I able to execute in the scripts in remote machine.
in machine 10.1.65.116
$ rsh 10.1.65.176 -l ciopr01 ksh sqlldr.ksh
Result : sqlldr: not found
<<<Dun not understand why >>>
in machine 10.1.65.176
$ ksh sqlldr.ksh
Result : Data successfully loaded
All the paths inside sqlldr.ksh is hardcode and I'm able to execute the script in machine B (10.1.65.176).
I failed execute the scripts via remotely in machine A (10.1.65.116)
However, I encounter I dun have privilege to print all the path of remote host from local host.
RESULT:
Oracle= /oracle/product/10.1.0.4/CIDM
DATA_PATH=/recovery/dmprod/prepaid_loading/input/inp/
CTL_FILE=/recovery/dmprod/prepaid_loading/scripts/control/TRANSNT_SRC_LOG_INP.ctl
/usr/bin:/usr/ccs/bin:/usr/bin/X11:/usr/contrib/bin:/usr/local/bin:
Func_Sqlldr[18]: sqlldr: not found
CONNECTION_STRING="${USER_ID}/${PASSWORD}@${DATA_SOURCE_NAME}"
for PROCESS_FILE in `ls -1 *`
do
DATA_FILE="${DATA_PATH}${PROCESS_FILE}"
echo $PATH
echo "I am in sqlldr"
echo "PROCESS_FILE ==${PROCESS_FILE}"
Second, I try to hardcode the env path of sqlldr
Func_Sqlldr() {
CONNECTION_STRING="${USER_ID}/${PASSWORD}@${DATA_SOURCE_NAME}"
for PROCESS_FILE in `ls -1 *`
do
DATA_FILE="${DATA_PATH}${PROCESS_FILE}"
echo $PATH
echo "I am in sqlldr"
echo "PROCESS_FILE ==${PROCESS_FILE}"
However, encounter a new error message again
�Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL�