Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Get the tnsnames.ora alias for a given service name Post 303046188 by MadeInGermany on Monday 27th of April 2020 02:06:31 PM
Old 04-27-2020
Quote:
Originally Posted by kpg
...

I think the first line skips over the tnsnames.ora until it finds a pattern 'variable ='. So this will give us the left hand side in $1?
The second line searches for the SERVICE_NAME entry, where the value matches s, which is set on the command line to be 'pri'.
You store this in $1 ....but didn't we keep the left hand side there?

... I do not understand the third line at all.
I forgot that ( is special in ERE, that awk uses. You found it: needs to be escaped. An alternative would be [(].

Each code line is a condition { action }.
All three code lines are run for each input line.
If the condition in the 2nd code line is true it performs the action: print variable a.
This is set in the 3rd code line to field#1, if it does not have a ( at the beginning.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to capture the service name from tnsnames.ora and create connect string

ghkjkjoj (4 Replies)
Discussion started by: chetankelvin
4 Replies

2. UNIX for Dummies Questions & Answers

ORA-12154: TNS:could not resolve service name

Hi everyone, when i run ; sqlplus -s username/password@TTTEST @umt.sql i take "ORA-12154: TNS:could not resolve service name" i want to run "umt.sql" query and also see result. thanx for your helping. (6 Replies)
Discussion started by: temhem
6 Replies

3. UNIX for Dummies Questions & Answers

find tnsnames.ora in unix

Can we find out what is the location of tnsnames.ora file used by the hp unix. (3 Replies)
Discussion started by: Sudipshib
3 Replies

4. Solaris

maxuprc and maxusers - ORA-27300, ORA-27301, ORA-27302

Hi all, Am intermittently getting the following errors on one of my databases. Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302:... (1 Reply)
Discussion started by: newbie_01
1 Replies

5. Shell Programming and Scripting

sed: parsing tnsnames.ora

All: Can sombodoy help me out with a sed command? Assume I have the following: PRI = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.3.7)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pri) ... (3 Replies)
Discussion started by: BeefStu
3 Replies

6. UNIX for Advanced & Expert Users

grep all ORA errors except one ORA error

Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command? In following "grep" command I want to exclude "ORA-01653" error grep -i ORA alert.log >>/tmp/ora_errors.txt ... (7 Replies)
Discussion started by: Mansoor8810
7 Replies

7. Shell Programming and Scripting

Tnsnames.ora

Hi, I would like to modify, in script schell, the line right above (DESCRIPTION and check three cases : if line contain ".world" then line=line-".world" concat "," concat line if line dont contain ".world" then line=line concat "," concat line concat".world" else line=line Keep in... (10 Replies)
Discussion started by: elcaro
10 Replies

8. Shell Programming and Scripting

Removing section from tnsnames.ora

Hi, I am trying to write a script or command to remove a section from tnsnames.ora file in the following example I would like to remove tns_alias2 section $ cat tnsnames.ora tns_alias1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host1 )(PORT = 1521)) ... (3 Replies)
Discussion started by: ynixon
3 Replies

9. AIX

I cannot find dsn and TNSNAMES.ora on UNIX

Where can I find dsn and TNSNAMES.ora on UNIX AIX Thanks for contribution (3 Replies)
Discussion started by: digioleg54
3 Replies

10. Red Hat

Ora-27603:ora-27626:

Hi, User claim that job is running slow from their end. I DBA found in database the below errors in alert log file. ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576 ORA-27626: Exadata error: 2201 (IO... (2 Replies)
Discussion started by: Maddy123
2 Replies
AWK  is  a  programming  language devised by Aho, Weinberger, and
Kernighan at Bell Labs (hence the  name).   Awk  programs  search
files for specific patterns and performs actions for every occur-
rence of these patterns.  The patterns can be regular expressions
as used in the ed editor.  The actions are expressed using a sub-
set of the C language.	The  patterns  and  actions  are  usually
placed	in  a rules file whose name must be the first argument in
the command line, preceded by the flag -f.  Otherwise, the  first
argument  on  the command line is taken to be a string containing
the rules themselves. All other arguments are  taken  to  be  the
names  of text files on which the rules are to be applied, with -
being the standard input.  To take rules from the standard input,
use -f -.  The command: would read the patterns and actions rules
from the file rules and apply them to  all  the  arguments.   The
general  format  of  a	rules  file is: ~~~<pattern> { <action> }
~~~<pattern> { <action> } ~~~...  There  may  be  any  number  of
these  <;pattern>  {  <action> } sequences in the rules file.  Awk
reads a line of input from the current input file and applies ev-
ery <;pattern> { <action> } in sequence to the line.  If the <pat-
tern>; corresponding to any { <action> } is missing, the action is
applied  to  every line of input.  The default { <action> } is to
print the matched input line.  The <;pattern>s may consist of  any
valid C expression.  If the <;pattern> consists of two expressions
separated by a comma, it is taken to be a range and the  <;action>
is  performed  on all lines of input that match the range.  <;pat-
tern>;s may contain regular expressions delimited by an @  symbol.
Regular  expressions  can be thought of as a generalized wildcard
string matching mechanism, similar to that used by many operating
systems  to  specify file names.  Regular expressions may contain
any of the following characters:
  x    An ordinary character
      The backslash quotes any character
  ^    A circumflex at the beginning of an expr matches  the  be-
       ginning of a line.
  $    A  dollar-sign at the end of an expression matches the end
       of a line.
  .    A period matches any single character except newline.
  *    An expression followed by an asterisk matches zero or more
       occurrences  of	that  expression: fo* matches f, fo, foo,
       fooo, etc.
  +    An expression followed by a plus sign matches one or  more
       occurrences of that expression: fo+ matches fo, foo, fooo,
       etc.
  []   A string enclosed in square brackets  matches  any  single
       character  in  that  string,  but no others.  If the first
       character in the string is a  circumflex,  the  expression
       matches any character except newline and the characters in
       the string.  For example, [xyz] matches xx and zyx,  while
       [^xyz] matches abc but not axb.	A range of characters may
       be specified by two characters separated by -.
Actions are expressed as a subset of the C language.   All  vari-
ables  are  global and default to int's if not formally declared.
Only char's and int's and pointers and arrays of char and int are
allowed.   Awk allows only decimal integer constants to be used--
no hex (0xnn) or octal (0nn). String and character constants  may
contain  all  of  the special C escapes (
, 
, etc.).  Awk sup-
ports the if, else, while and break flow of  control  constructs,
which  behave  exactly as in C.  Also supported are the following
unary and binary operators, listed in order from highest to  low-
est precedence:
  Operator	 Type	      Associativity
  () [] 	 unary	      left to right
  ! ~ ++ -- - * &	      unaryright to left
  * / % 	 binary       left to right
  + -		 binary       left to right
  << >> 	 binary       left to right
  < <= > >=	 binary       left to right
  == != 	 binary       left to right
  &		 binary       left to right
  ^		 binary       left to right
  |		 binary       left to right
  &&		 binary       left to right
  ||		 binary       left to right
  =		 binary       right to left
Comments are introduced by a '#' symbol and are terminated by the
first newline character.  The standard /* and */  comment  delim-
iters  are not supported and will result in a syntax error.  When
awk reads a line from the current input file, the record is auto-
matically  separated  into fields.  A field is simply a string of
consecutive characters delimited by either the beginning  or  end
of  line,  or  a field separator character.  Initially, the field
separators are the space and tab character.   The  special  unary
operator  '$'  is used to reference one of the fields in the cur-
rent input record (line).  The fields are  numbered  sequentially
starting  at  1.   The	expression $0 references the entire input
line.  Similarly, the record separator is used to  determine  the
end of an input line, initially the newline character.	The field
and record separators may be changed programatically  by  one  of
the  actions and will remain in effect until changed again.  Mul-
tiple (up to 10) field separators are allowed at a time, but only
one  record  separator.   Fields behave exactly like strings; and
can be used in the same context as a character array.  These  ar-
rays  can be considered to have been declared as:      char ($n)[
128 ]; In other words, they are 128 bytes long.  Notice that  the
parentheses  are  necessary  because the operators [] and $ asso-
ciate from right to left; without them, the statement would  have
parsed	as:	 char $(1[ 128 ]); which is obviously ridiculous.
If the contents of one of these field arrays is altered,  the  $0
field  will  reflect  this change.  For example, this expression:
     *$4 = 'A'; will change the first  character  of  the  fourth
field to an upper- case letter 'A'.  Then, when the following in-
put line:      120 PRINT  "Name 	 address	 Zip"  is
processed,   it   would  be  printed  as:	120  PRINT  "Name
Address        Zip"; Fields may also be modified with the strcpy()
function  (see below).	For example, the expression:	  strcpy(
$4, "Addr." ); applied	to  the  same  line  above  would  yield:
     120  PRINT  "Name		Addr.	      Zip"  The following
variables are pre-defined:
   FS	       Field separator (see below).
   RS	       Record separator (see below also).
   NF	       Number of fields in current input record (line).
   NR	       Number of records processed thus far.
   FILENAME    Name of current input file.
   BEGIN       A special <pattern> that matches the beginning  of
	       input text.
   END	       A  special <pattern> that matches the end of input
	       text.
Awk also provides some useful built-in functions for  string  ma-
nipulation and printing:
   print(arg)  Simple  printing  of  strings  only, terminated by
	       '
'.
   printf(arg...)Exactly the printf() function from C.
   getline()   Reads the next record and  returns  0  on  end  of
	       file.
   nextfile()  Closes  the current input file and begins process-
	       ing the next file
   strlen(s)   Returns the length of its string argument.
   strcpy(s,t) Copies the string t to the string s.
   strcmp(s,t) Compares the s to t and returns 0 if they match.
   toupper(c)  Returns its character argument converted to upper-
	       case.
   tolower(c)  Returns its character argument converted to lower-
	       case.
   match(s,@re@)Compares the string s to the  regular  expression
	       re  and	returns the number of matches found (zero
	       if none).
Awk was written by Saeko Hirabauashi and Kouichi Hirabayashi.
All times are GMT -4. The time now is 09:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy