SQLPLUS Password Parameter file being used when logging in
Good day to everyone. This is my first time posting and just barely above basic Unix training. I think i have search thoroughly to ensure my question hasn't already been posted. But on the off chance the answer has been posted, please be nice as I am not 100% sure I know what I am looking for.
I am a sysadmin in training of a very large application sitting on a Unix environment. We grant very limited access to the vendor who has developed code to this unix box. However, i do have screen share session going with the vendor often which is why i am posting.
Many times I need to run a sqlplus SQL file in nohup or etc. To avoid the vendor from seeing the master DB password I created a parameter file within a directory of my home directory and changed the permissions to 600 and removed the directory from the snapshots. The thought being I could call the parameter file instead of having to input into the first command. However, all my attempts seem to fail.
I hear you can do some of this through KSH script writing but only through a few YouTube videos and half way through a book and have not seen anything. Any guidance anyone could provide would be greatly appreciated.
Moderator's Comments:
Please view this code tag video for how to use code tags when posting code and data.
Last edited by vbe; 09-11-2012 at 05:26 AM..
Reason: code tags..
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
I have a RHEL 5 server that I can log into with an LDAP account hosted on a server running Sun DSEE 6.3 with an ssh key pair but not with my username and password. When I try to login to the console I am given the "login incorrect" message as if I fat fingered my password. Other users with... (5 Replies)
Hi All,
I am writing a script where it updates a file in an unix account.
To update that file i need to be logged in as that account user.
say account name is ab01 and its password is passab01.
What i want to do is, my script should read login id and password from a parameter file and... (4 Replies)
hi All,
i m trying to pass a user choice paramter from unix to sqlplus connect command
here i want the user to enter the username and password he wants to connect in sql plus through read in unix and then automatically connect to that instance.
sqlplus -s $1/$2
where $ 1 and $2 will b... (2 Replies)
Hello,
I am currently working on a project that requires me to remote login into another UNIX system using different credentials. The problem is that progamatically I cannot simply feed the password into the UNIX system. Is there a way to feed the password within one command line statement.
I... (1 Reply)
Hi all,
I am fairly new to shell scripting and I am trying the following:
My shell script creates a tar file with files with the ending ~. The directory - where the files and sub directories are located - comes as a parameter when I call the script. Files that are archived will be written in... (1 Reply)
Hi All,
I'm new to Linux and scripting, apologies in advance for 'stupid' questions.
Please help... Im writing a script that calls a sqlplus script but the sqlplus requires inputs and i cant seem to get this to work.
here is my code.
#!/bin/sh
TERM=vt100
export TERM... (4 Replies)
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different.
343535435
365765767
343534543
343543543
i want to pass this file to sqlplus
and sql command is
... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies
LEARN ABOUT NETBSD
nohup
NOHUP(1) BSD General Commands Manual NOHUP(1)NAME
nohup -- invoke a command immune to hangups
SYNOPSIS
nohup utility [arg ...]
DESCRIPTION
The nohup command allows the specified utility to be protected from termination if the user should become logged out (for example, due to a
modem line or TCP/IP connection being dropped). To do this, nohup sets the SIGHUP signal(3) (``terminal line hangup'') to be ignored, then
executes utility along with any arguments.
If the standard output is a terminal, the standard output is appended to the file nohup.out in the current directory. If standard error is a
terminal, it is directed to the same place as the standard output. If the output file nohup.out cannot be created in the current directory,
nohup attempts to create the file in the user's home directory. If the file nohup.out cannot be created, either in the current directory or
the user's home directory, nohup will exit without invoking utility, with an exit value as described below.
ENVIRONMENT
The following variable is used by nohup.
HOME User's home directory.
EXIT STATUS
The nohup utility exits with one of the following values:
126 The utility was found but could not be invoked.
127 The utility could not be found or an error occurred in nohup.
Otherwise, the exit status of nohup will be that of utility.
SEE ALSO signal(3)STANDARDS
The nohup command is expected to be IEEE Std 1003.2 (``POSIX.2'') compatible.
BSD July 15, 2005 BSD