Login or Register to Ask a Question and Join Our Community


Linux

script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Linux script
# 15  
Old 09-22-2010
Hi

yes i have process id of a session in ${sqlplusoutputlog} file and it is in 19th line and i need to get that number assigned to a variable in a shell script
please provide me with a correct sysntax


Thanks...
# 16  
Old 09-22-2010
Quote:
Originally Posted by rocky1954
...
yes i have process id of a session in ${sqlplusoutputlog} file and it is in 19th line and i need to get that number assigned to a variable in a shell script
...
It's difficult to figure out a way of doing that unless you show us line number 19 of your log file.

tyler_durden
# 17  
Old 09-23-2010
What do you want to achieve?
What will have in the 19th line of ${sqlplusoutputlog}?

This command does nothing with ${sqlplusoutputlog} file, it only uses it to filter the "ps" command result.
Code:
pid=`ps -ef | egrep "${sqlplusoutputlog}"`

If you want the 19th line of the ${sqlplusoutputlog}, just:
Code:
# Example
# cat TestFile.txt
1
2
3
4
5
6
7
8
9
10

# Direct command
# awk 'NR==5{print $0}'
5

# Value in a variable
# lineValue=`awk 'NR==5{print $0}' TestFile.txt`
# echo ${lineValue}
5

# Your command
# lineValue=`awk 'NR==19 {print $0}' "${sqlplusoutputlog}"`
# echo ${lineValue}
<Your result: ???>

Regards!

---------- Post updated at 08:43 ---------- Previous update was at 08:41 ----------
Quote:
Originally Posted by felipe.vinturin
What do you want to achieve?
What will have in the 19th line of ${sqlplusoutputlog}?

This command does nothing with ${sqlplusoutputlog} file, it only uses it to filter the "ps" command result.
Code:
pid=`ps -ef | egrep "${sqlplusoutputlog}"`

If you want the 19th line of the ${sqlplusoutputlog}, just:
Code:
# Example
# cat TestFile.txt
1
2
3
4
5
6
7
8
9
10

# Direct command
# awk 'NR==5{print $0}'
5

# Value in a variable
# lineValue=`awk 'NR==5{print $0}' TestFile.txt`
# echo ${lineValue}
5

# Your command
# lineValue=`awk 'NR==19 {print $0}' "${sqlplusoutputlog}"`
# echo ${lineValue}
<Your result: ???>

Regards!
Quoting my own post!

Sorry! |Too late answer, but I will keep it here.

---------- Post updated at 08:43 ---------- Previous update was at 08:43 ----------
Quote:
Originally Posted by felipe.vinturin
What do you want to achieve?
What will have in the 19th line of ${sqlplusoutputlog}?

This command does nothing with ${sqlplusoutputlog} file, it only uses it to filter the "ps" command result.
Code:
pid=`ps -ef | egrep "${sqlplusoutputlog}"`

If you want the 19th line of the ${sqlplusoutputlog}, just:
Code:
# Example
# cat TestFile.txt
1
2
3
4
5
6
7
8
9
10

# Direct command
# awk 'NR==5{print $0}'
5

# Value in a variable
# lineValue=`awk 'NR==5{print $0}' TestFile.txt`
# echo ${lineValue}
5

# Your command
# lineValue=`awk 'NR==19 {print $0}' "${sqlplusoutputlog}"`
# echo ${lineValue}
<Your result: ???>

Regards!
Quoting my own post!

Sorry! Too late answer, but I will keep it here.
# 18  
Old 09-29-2010
HI Felipe,

No problem i have to thank you for your help to me

i have done with that script.

I have a question i am writing another shell script in that i am checking some process using ps -ef |grep
and if the process is not there i need to start that process
but the problem is the process has to start from root
how can i go to the root from oracle user in the shell script
it will ask for the password but i dont want to use that
is there any other way please let me know


Thanks..
# 19  
Old 09-29-2010
Quote:
Originally Posted by rocky1954
...how can i go to the root from oracle user in the shell script
it will ask for the password but i dont want to use that
is there any other way...
If you add oracle user to the sudoers list, then you can use the sudo command to start your process as root, with or without password.

There's a lot of material on sudo and sudoers out there on the Internet or on this forum. Google is your friend.

tyler_durden
# 20  
Old 09-30-2010
Hi,

I dont want oracle user to get access to the root with out having password

I need to run just only one command from oracle which actually has to run as root

how can i keep that command in the sudoers so that when i run that command from oracle wont ask for password


thanks
# 21  
Old 09-30-2010
Add this line to the /etc/sudoers (or run visudo as root):
Code:
oracle  ALL = (root) NOPASSWD: /<PathToYourScript>/<Script>.sh

Also, check this link for further information: UNIX man pages : sudoers (5)

Regards!
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My... (3 Replies)
Discussion started by: siegfried
3 Replies

2. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"... (2 Replies)
Discussion started by: Raj Roy
2 Replies

4. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies

5. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies
Login or Register to Ask a Question