Need help in scripting


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help in scripting
# 1  
Old 11-27-2013
Need help in scripting

Hello,

In a loop I am using below command for every database

Code:
crsctl status res | grep -E "ora\.$DATABASE\.(.+)\.svc"

and below is one of the sample output
Code:
NAME=ora.sgraphut.sgraphutxdb.svc

Now I want to extract just service name out of this string (that is sgraphutxdb) please help me how do I proceed?
Additionally,if I need to pass the node name as one of the parameters while calling this script
Let's suppose the script name is test_relocate.sh and I need to execute this like below:
Code:
test_relocate.sh -n node1

Now how do I recognize this inside the script in a loop



Best regards,
Vishal

Last edited by Scott; 11-27-2013 at 06:13 AM.. Reason: Please use code tags
# 2  
Old 11-27-2013
Let us consider the node name always occur at the point.

You can add this to the end
Code:
awk -F"." '{print $(NF-1)}'

so it would look like,
Code:
looop.....
NODE=$(crsctl status res | grep -E "ora\.$DATABASE\.(.+)\.svc" | awk -F"." '{print $(NF-1)}')
echo $NODE
test_relocate.sh $NODE
......loop

# 3  
Old 11-27-2013
Thank you.
Can you please help me understand what is NF here in $(NF-1)
Code:
crsctl status res | grep -E "ora\.$DATABASE\.(.+)\.svc" | awk -F"." '{print $(NF-1)}

Adding to this, let's suppose I also want to use $nodename in this command and its value would be fetched from the arugments when this script would be called

Assuming this script name would be status_res.sh and the user needs to use arguments nodename which would give results specific to one server
Code:
status_res.sh -n node1

Now how should I read this argument internally in the script since I would be using below command in script
Code:
crsctl status res -n nodenamw| grep -E "ora\.$DATABASE\.(.+)\.svc" | awk -F"." '{print $(NF-1)}

Best regards,
Vishal

Last edited by Scott; 11-27-2013 at 06:13 AM.. Reason: Code tags
# 4  
Old 11-27-2013
Try using
Code:
crsctl status res -n $2| ...

, as node1 is the second parameter to the script.
# 5  
Old 11-27-2013
Code:
status_res.sh -n node1

Now I want to check in the code if something is next to -n, only that should be considered as nodename irrespective of the position of argument

Suggestions please.


Best regards,
Vishal
# 6  
Old 11-27-2013
And what exactly are you trying to achieve? What's the reason for the manual service relocation?
# 7  
Old 11-27-2013
Quote:
Originally Posted by Vishal_dba
Thank you.
Can you please help me understand what is NF here in $(NF-1)
Code:
crsctl status res | grep -E "ora\.$DATABASE\.(.+)\.svc" | awk -F"." '{print $(NF-1)}

In awk, NF is the number of fields in the current record. $(NF-1) is the last-but-one field.

Quote:
Originally Posted by Vishal_dba
Code:
status_res.sh -n node1

Now I want to check in the code if something is next to -n, only that should be considered as nodename irrespective of the position of argument

Suggestions please.
Look at getopts.
This User Gave Thanks to CarloM For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Web Development

Perl scripting or shell scripting?

i am going to study any one of the scripting languages mentioned above(shell 0r perl scripting) . Which is having more scope for a fresher? (1 Reply)
Discussion started by: Anna Hussie
1 Replies

2. What is on Your Mind?

Shell Scripting vs Perl scripting

Gents, I have been working in a Solaris/Unix environment for about 9 months. I took some linux classses online before getting the job. But, I am not very good at scripting. I want to learn how to script. Do you think that I should start with Shell scripting or Perl? I wanted to continue with... (2 Replies)
Discussion started by: Pouchie1
2 Replies

3. Android

Android Scripting Environment: Shell Scripting and Android

I just upgraded to Android 2.2 from 2.1. The GPS issue that was troublesome in 2.1 seems to have been fixed. Some of web browsing seems faster, but it could just be my connection is better today ;) Flash works in some browsers but not very good and it is too slow for Flash apps designed for... (0 Replies)
Discussion started by: Neo
0 Replies

4. What is on Your Mind?

Shell scripting vs Perl scripting

Hi all, I would like to start developping some good scripting skills. Do you think it would be best to start with shell scripting or Perl? I already got a fundation, really basics, in perl. but I am wondering what would be best to be good at first. Can you please help me determine which one to... (14 Replies)
Discussion started by: Pouchie1
14 Replies

5. Shell Programming and Scripting

Call Shell scripting from Perl Scripting.

Hi How to call a shell scripting through a Perl scripting? Actually I need some value from Shell scripting and passes in the Perl scripting. So how can i do this? (2 Replies)
Discussion started by: anupdas
2 Replies

6. UNIX for Dummies Questions & Answers

Scripting Help

Hello all. Like Ive stated before, I am new to world of Unix. I was given the tast to create a script that will concatenate 20 files into one file. I know that the cat command is to be used but I am looking for something to get started on. Again, basically I need to wrtie a script that whill... (3 Replies)
Discussion started by: ndoggy020
3 Replies

7. UNIX for Advanced & Expert Users

Need help on scripting

in unix bc command is used as calculator and also for conversion, i want to convert 5f to decimal. but bc dont consider 5f as hex value it considers 5F as hex value. I get 5f from other iteration so i cant change that f to F...is there any way to convert 5f to decimal ot 5f to 5F :rolleyes: (2 Replies)
Discussion started by: abhinandantn
2 Replies

8. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies

9. Shell Programming and Scripting

scripting guru's pls help me with scripting on AIX

can someone pls help me with the script for a files coming from one system to a particular directory and i want to write a script to move those files to another directory on different system by renaming the files... pls someone help me on this... thanking in anticipation.... (1 Reply)
Discussion started by: thatiprashant
1 Replies

10. AIX

New to scripting

We have a scripting requirement, Background: On a particular path, we compress a load of log files into tar.gz. This is done on an hourly basis throughout the day and it produces files of the following format, 2005-08-05-00-021031.tar.gz as an example. This is done by a script. We need: ... (2 Replies)
Discussion started by: rajesh_149
2 Replies
Login or Register to Ask a Question