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
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
2. UNIX for Advanced & Expert Users
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
3. Shell Programming and Scripting
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
4. UNIX for Dummies Questions & Answers
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
5. UNIX for Advanced & Expert Users
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
6. Shell Programming and Scripting
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
7. UNIX for Advanced & Expert Users
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
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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
rsh(1M) System Administration Commands rsh(1M)
NAME
rsh, restricted_shell - restricted shell command interpreter
SYNOPSIS
/usr/lib/rsh [-acefhiknprstuvx] [argument...]
DESCRIPTION
rsh is a limiting version of the standard command interpreter sh, used to restrict logins to execution environments whose capabilities are
more controlled than those of sh (see sh(1) for complete description and usage).
When the shell is invoked, it scans the environment for the value of the environmental variable, SHELL. If it is found and rsh is the file
name part of its value, the shell becomes a restricted shell.
The actions of rsh are identical to those of sh, except that the following are disallowed:
o changing directory (see cd(1)),
o setting the value of $PATH,
o pecifying path or command names containing /,
o redirecting output (> and >>).
The restrictions above are enforced after .profile is interpreted.
A restricted shell can be invoked in one of the following ways:
1. rsh is the file name part of the last entry in the /etc/passwd file (see passwd(4));
2. the environment variable SHELL exists and rsh is the file name part of its value; the environment variable SHELL needs to be set in the
.login file;
3. the shell is invoked and rsh is the file name part of argument 0;
4. the shell is invoke with the -r option.
When a command to be executed is found to be a shell procedure, rsh invokes sh to execute it. Thus, it is possible to provide to the end-
user shell procedures that have access to the full power of the standard shell, while imposing a limited menu of commands; this scheme
assumes that the end-user does not have write and execute permissions in the same directory.
The net effect of these rules is that the writer of the .profile (see profile(4)) has complete control over user actions by performing
guaranteed setup actions and leaving the user in an appropriate directory (probably not the login directory).
The system administrator often sets up a directory of commands (that is, /usr/rbin) that can be safely invoked by a restricted shell. Some
systems also provide a restricted editor, red.
EXIT STATUS
Errors detected by the shell, such as syntax errors, cause the shell to return a non-zero exit status. If the shell is being used non-
interactively execution of the shell file is abandoned. Otherwise, the shell returns the exit status of the last command executed.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
intro(1), cd(1), login(1), rsh(1), sh(1), exec(2), passwd(4), profile(4), attributes(5)
NOTES
The restricted shell, /usr/lib/rsh, should not be confused with the remote shell, /usr/bin/rsh, which is documented in rsh(1).
SunOS 5.10 1 Nov 1993 rsh(1M)