Rsh & Sqlldr Post: 302154821

Sponsored Content

Top Forums Shell Programming and Scripting Rsh & Sqlldr Post 302154821 by epall on Wednesday 2nd of January 2008 02:40:37 AM

01-02-2008

Registered User

Actually, I'm able to print all the paths of remote host. Therefore, I can conclude that the env setting should be correct.

<<In remote host>>
$ echo "Oracle= ${ORACLE_HOME}"
RESULT:
Oracle=/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/usr/contrib/kwdb/bin:/usr/bin/X11:/opt/graphics/common/bin:/opt/upgrade/bin:/usr/contrib/bin/X11:/opt/ipf/bin:/opt/resmon/bin:/opt/perf/bin:/opt/prm/bin:/opt/ignite/bin:/opt/aCC/bin:/opt/sec_mgmt/bastille/bin:/opt/caliper/bin:/opt/gnome/bin:/opt/mozilla:/opt/wbem/bin:/opt/wbem/sbin:/opt/mx/bin:/opt/sec_mgmt/spc/bin:/opt/langtools/bin:/oracle/product/10.1.0.4/CIDM/bin:.

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

<<my script>>
echo "Oracle= ${ORACLE_HOME}"
Func_Sqlldr "${DATA_PATH}" "${CTL_FILE}"

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}"

sqlldr\
userid=${CONNECTION_STRING}\
control=${CTL_FILE}\
data=${DATA_FILE}\
log=${SQLLDR_LOG_FILE}\
bad=${SQLLDR_BAD_FILE}\
errors=${REC_ERROR_ALLOW}\
rows=${ROWS}\
bindsize=${BINDSIZE}\
direct=${DIRECT}\
silent=${SILENT} 2> ${SQLLDR_ERROR_FILE}
echo "complete"
done

}

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}"

/oracle/product/10.1.0.4/CIDM/bin/sqlldr\
userid=${CONNECTION_STRING}\
control=${CTL_FILE}\
data=${DATA_FILE}\
log=${SQLLDR_LOG_FILE}\
bad=${SQLLDR_BAD_FILE}\
errors=${REC_ERROR_ALLOW}\
rows=${ROWS}\
bindsize=${BINDSIZE}\
direct=${DIRECT}\
silent=${SILENT} 2> ${SQLLDR_ERROR_FILE}
echo "complete"
done

}

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�

epall

View Public Profile for epall

Find all posts by epall

10 More Discussions You Might Find Interesting

1. 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. 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...

3. 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...

4. 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 ? ...

5. 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...

6. Shell Programming and Scripting

sqlldr end of file

7. 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...

8. 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...

9. 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...

10. 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...

LEARN ABOUT LINUX

lint

lint(1B)                                             SunOS/BSD Compatibility Package Commands                                             lint(1B)

NAME

       lint - C program verifier

SYNOPSIS

       /usr/ucb/lint [options]

DESCRIPTION

       /usr/ucb/lint  is  the  interface  to  the  BSD  Compatibility  Package  C  program  verifier.   It  is  a  script  that looks for the link
       /usr/ccs/bin/ucblint to the C program verifier. /usr/ccs/bin/ucblint is available only with the SPROcc package, whose default  location  is
       /opt/SUNWspro.  /usr/ucb/lint  is  identical to /usr/ccs/bin/ucblint, except that BSD headers are used and BSD  libraries are linked before
       base libraries.  The /opt/SUNWspro/man/man1/lint.1 man page is available only with the SPROcc package.

OPTIONS

       /usr/ucb/lint accepts the same options as /usr/ccs/bin/ucblint, with the following exceptions:

       -Idir           Search dir for included files whose names do not begin with a slash (/) prior  to  searching  the  usual  directories.  The
                       directories for multiple -I options are searched in the order specified. The preprocessor first searches for #include files
                       in the directory containing sourcefile, and then in directories named with -I options (if any), then  /usr/ucbinclude,  and
                       finally, in /usr/include.

       -Ldir           Add  dir  to  the  list  of  directories  searched  for  libraries  by  /usr/ccs/bin/ucblint.  This  option  is  passed  to
                       /usr/ccs/bin/ld. Directories specified with this option are searched before /usr/ucblib and /usr/lib.

       -Y P, dir       Change the default directory used for finding libraries.

EXIT STATUS

       The following exit values are returned:

       0               Successful completion.

       >0              An error occurred.

FILES

       /usr/lint/bin/ld        link editor

       /usr/lib/libc           C library

       /usr/ucbinclude         BSD Compatibility directory for header files

       /usr/ucblib             BSD Compatibility directory for libraries

       /usr/ucblib/libucb      BSD Compatibility C library

       /usr/lib/libsocket      library containing socket routines

       /usr/lib/libnsl         library containing network functions

       /usr/lib/libelf         library containing routines to process ELF object files

       /usr/lib/libaio         library containing asynchronous I/O routines

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE         |      ATTRIBUTE VALUE        |
       +-----------------------------+-----------------------------+
       |Availability                 |SUNWscpu                     |
       +-----------------------------+-----------------------------+

SEE ALSO

       ld(1), a.out(4), attributes(5)

SunOS 5.10                                                          1 Feb 1995                                                            lint(1B)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

rsh & rlogin

Discussion started by: Inbal

2. UNIX for Advanced & Expert Users

rcp & rsh

Discussion started by: dfrangidis

3. Shell Programming and Scripting

sqlldr help

Discussion started by: systemsb

4. UNIX for Dummies Questions & Answers

how to know sqlldr error?

Discussion started by: DILEEP410