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 DEBIAN
sylseg-sk-training
sylseg-sk-training(1) USER COMMANDS sylseg-sk-training(1)NAME
sylseg-sk-training - train the statistic for the syllabic segmentation
SYNOPSIS
sylseg-sk-training [--color] [--dl debug level] [--help] [<input file>]
DESCRIPTION
The sylabic segmentation is esential for some linguistic or speech recognition applications. Depending on the language either rule based or
statistical approach is beying used. For Slovak the statistical approach seems to be more suitable.
sylseg-sk-training creates the necessary data for one of the statistical approaches for the syllabic segmentaion. The input data are
expected to be word segmented into syllables. The syllabic separator should be "-". If no input file is specified, the standard input is
expected. The output is written in to the file. The filename is input filename with the extension ".statistics". If standard input is
used, then the output filename is syl_output.statistics.
The design of the sylseg-sk-training is language independent. Theoretically it should work for any language.
OPTIONS --color
Enable color output.
--dl Set the debug level. Control the amount of displayed information The debug level 0 displays nothing. The maximum level 5 displays
full debugging report. The default debug level is 1.
--help display a short help text
EXAMPLES
Use file aaa.txt as training input and set up debug level to 3:
sylseg-sk-training --dl 3 aaa.txt
EXIT STATUS
sylseg-sk-training returns a zero if the training succeeds
AUTHOR
Jozef Ivanecky (dodo (at) kanoistika.sk)
SEE ALSO sylseg-sk(1)version 0.4 September 9, 2006 sylseg-sk-training(1)