Visit Our UNIX and Linux User Community


Rsh & Sqlldr


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Rsh & Sqlldr
# 1  
Old 12-31-2007
Rsh & Sqlldr

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
# 2  
Old 12-31-2007
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.
# 3  
Old 12-31-2007
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)
# 4  
Old 12-31-2007
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"

# 5  
Old 12-31-2007
am I specified the env wrongly?

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
# 6  
Old 12-31-2007
Quote:
Originally Posted by epall
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

# 7  
Old 01-02-2008
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
---

Previous Thread | Next Thread
Test Your Knowledge in Computers #753
Difficulty: Medium
The BIOS of the original IBM PC and XT had an interactive user interface.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Facing problem in the sqlldr & shell script

Guys i am facing two problems : (1) when i create the sql loader file the date format i m getting is this 28-DEC-11 12.03.14.107137 AM; for this i m using this script but unable to load the files trailing nullcols ( SERIALNO, AMOUNT, CLASS, MDN, VDATE "to_date(:TIMESTAMP, 'DD-MON-YY... (6 Replies)
Discussion started by: xal_kaushi
6 Replies

2. Shell Programming and Scripting

sqlldr in shell script

Hi I'm using SQL*Loader in shell script as below sqlldr $uname/$pword@$ORACLE_SID parfile=$test.par for e.g. if $test is 'file1' and getting the below error LRM-00109: could not open parameter file 'file1' LRM-00113: error when processing file 'file1' SQL*Loader: Release... (7 Replies)
Discussion started by: vinoth_kumar
7 Replies

3. Shell Programming and Scripting

Shell con sqlldr

Hola, Genere un proceso en proC que me inserta registros a oracle, el cual ejecuto desde un shell en Unix. Por otro lado tengo un sqlldr que me hace el trabajo en un 25 % de tiempo que mi proceso en C. Se que puedo ejecutar mi sqlldr desde un shell, pero no se como hacer, alguien tiene un... (0 Replies)
Discussion started by: marcoinxs
0 Replies

4. UNIX for Advanced & Expert Users

RSH or SSH & security

I am wanting to run backups to remote servers ie: A to B's tape drive and B to A's tape drive. Should I use rsh or ssh? It looks as those rsh opens up security issues (the backup has to run as root). Which one should be used and does someone have the links to set up allowed connections. In what I... (7 Replies)
Discussion started by: jphess
7 Replies

5. Shell Programming and Scripting

sqlldr end of file

Hi, I've a batch program that load data from a file like: 00000013|FERRAN|JULIAN|GONZALEZ|1| 00000014|FRANCESC|NARVAEZ|PAZOS|1| 00000015|INMACULADA|MAYOL|BELTRAN|2| I used the sqlldr command in this way: sqlldr userid=U/P control=$SCRIPTS/CTRL.WCT data=$DATA/FILE log=$LOGS/FILE.LOG... (2 Replies)
Discussion started by: raippl
2 Replies

6. UNIX for Advanced & Expert Users

Remote commands problem using RSH & Rexec

I have enabled the RSH and Rexec command in my HP-UX server but when i try to send any command to the server it returns Execute Permission Denied except commands like ls-l C:\rsh xxx.xxx.xxx.xxx -l mpac mxpkill 12 the mxpkill command work when I log to the server using telnet with the same... (0 Replies)
Discussion started by: fhuwaidy
0 Replies

7. UNIX for Dummies Questions & Answers

how to know sqlldr error?

Hi all, Can anyone know how to get the error codes from 'sqlldr' ?While am trying to load some 'ISO-8859-1' data file into 'utf8' oracle database,some records are rejected.I want to know the reason,whether it is due to charset mismatch or some other issues.How come i to know that ? ... (3 Replies)
Discussion started by: DILEEP410
3 Replies

8. Shell Programming and Scripting

sqlldr help

1.The below script works perfectly fine in dev. However, i have been told that i cannot hardcode the password into the file during production impementation. Is their way i could ask the user to enter the password when the script is executed 2. I have seven different files each of which needs to... (1 Reply)
Discussion started by: systemsb
1 Replies

9. UNIX for Advanced & Expert Users

rcp & rsh

Hi everybody, I have a problem with rcp & rsh command from Winnt 4 to an AIX machine. I would like to use rsh from Winnt on Unix but it works only with some machines of the domain. With the others, an error message appears and say : "myadress.com: rshd: 0826-826 The host name for your address... (2 Replies)
Discussion started by: dfrangidis
2 Replies

10. UNIX for Dummies Questions & Answers

rsh & rlogin

I'm trying to execute the next command: " rsh CompName date " which means i want to get the date from a machine which i have its CompName. but i get the answer : "Connection refused" what do i need to do ? how can i sign myself as user or guest in the other machine ? thanks in... (2 Replies)
Discussion started by: Inbal
2 Replies

Featured Tech Videos