Shell Programming and Scripting

Dear expert,

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


Regards

This is going to be a matter of env variables , at least u need to load the PATH to reach sqlldr inside the sqlldr.ksh script.

Regards.

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)

For verify the problem:

Code:

rsh 10.1.65.176 -l ciopr01 ksh "which sqlldr"

To solve you need to build a new script , ex Loader.sh , with to functions:

1) Load the var and export it.

2) Run the sqlldr.ksh

Then:

Code:

rsh 10.1.65.176 -l ciopr01 ksh "Loader.sh"

I have tried to put env setting below inside Sqlldr.ksh
"
LD_LIBRARY_PATH=/oracle/product/10.1.0.4/CIDM/bin/
export $LD_LIBRARY_PATH
"

But, it showed error message :
/oracle/product/10.1.0.4/CIDM/bin/: is not an identifier

remove the $ from your export line

Code:

export LD_LIBRARY_PATH

No, is still not working after removing the '$' sign from shell scriipt.
I still will get " sqlldr: not found" error message

I have try command below to check sqlldr env variables, but it still could not work.

$ ldd -s sqlldr
--
LD_LIBRARY_PATH=/oracle/product/10.1.0.4/CIDM/lib32:/oracle/product/10.1.0.4/CIDM/lib:/usr/lib
export LD_LIBRARY_PATH
---