Replacing old TNS entries with New one in multiple files Post: 302902790

Sponsored Content

Top Forums Shell Programming and Scripting Replacing old TNS entries with New one in multiple files Post 302902790 by KDDubai333 on Thursday 22nd of May 2014 09:21:21 AM

05-22-2014

Registered User

Replacing old TNS entries with New one in multiple files

I have requirement to replace old TNS entries with New one in multiple files.
one file may contain more then one occurrence of tns.

Example: Below is the one of occurrence in a current file(s). i am interested to replace only red part.

Code:

<connection-pool name="Google_APP_CP" inactivity-timeout="20" initial-limit="10" max-connections="40" min-connections="10" validate-connection="true">
      <connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="APP1" password="oracle_app#@%$" url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apap1-vip.mydomain.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=apap2-vip.mydomain.com)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SID.mydomain.com)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))" commit-record-table-name=""/>
   </connection-pool>

After replace, It should be like below:

Code:

<connection-pool name="Test_APP_CP" inactivity-timeout="20" initial-limit="10" max-connections="40" min-connections="10" validate-connection="true">
      <connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="APP1" password="oracle_app#@%$" url="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS=(PROTOCOL=TCP)(HOST=mydomain-scan)(PORT=1621))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=NEWSID.mydomain.com)))" commit-record-table-name=""/>
   </connection-pool>

There should not be any change other then this replace, otherwise application will not read the file. (even 1 extra space is not tolerable )

KDDubai333

View Public Profile for KDDubai333

Find all posts by KDDubai333

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replacing multiple lines

i have a file : sample1.txt OBJECT="POINT" ACTION="REDEFINE" POINT_NAME="ABCD001G " GHYT_POPRIORITY_1="1" GHYT_POPRIORITY_2="1" GHYT_POPRIORITY_3="1" GHYT_POPRIORITY_4="1" GHYT_POPRIORITY_USER="1" HIGH_ALARM_PRIORITY_1="1" HIGH_ALARM_PRIORITY_2="1" HIGH_ALARM_PRIORITY_3="1" ...

2. Shell Programming and Scripting

renaming multiple files while replacing string

hi, i've found a few examples of scripts to do this but for some reason can't get them to work properly. basically i have some dirs with a few hundred files mixed in with a bunch of other files that were made with a typo in part of them. long-file-names-tyo-example.ext want to be able...

3. Shell Programming and Scripting

Replacing string in multiple files

Hi, I need to replace the string 'abcd' with 'xyz' in a file sample.xml This sample.xml is also present in the subdirectories of the current directory. Eg, If I am in /user/home/ the sample.xml if present in /user/home/ /user/home/folder1/ /user/home/folder2/...

4. Shell Programming and Scripting

Replacing text from multiple files at multiple location

Hi, I have many files scattered in all different folders. I want to replace the text within all the files using a single command ( awk, sed...) Is it possible? example find all the files in which there is text "memory" and replace it with "branded_memories". the files can be at the...

5. UNIX for Dummies Questions & Answers

best method of replacing multiple strings in multiple files - sed or awk? most simple preferred :)

Hi guys, say I have a few files in a directory (58 text files or somthing) each one contains mulitple strings that I wish to replace with other strings so in these 58 files I'm looking for say the following strings: JAM (replace with BUTTER) BREAD (replace with CRACKER) SCOOP (replace...

6. Shell Programming and Scripting

Replacing multiple extensions

HI, I have some csv files with mutiple extensions, I want to remove all the extensions and keep only the .csv extension. anybody can suggest me how to do this. source files 1.txt.csv.txt.csv.csv.txt.csv 2.csv.txt.csv.txt.csv.txt target 1.csv 2.csv --Wang

7. Shell Programming and Scripting

Grep all lines with the string "TNS-" but skip those with "TNS-12514"

Platform: Oracle Linux 6.3 From a log file, I want to grep all lines with the pattern "TNS-" but I want to skip those with the pattern "TNS-12514" . How can I do this ?

8. Shell Programming and Scripting

Replacing matched patterns in multiple files with awk

Hello all, I have since given up trying to figure this out and used sed instead, but I am trying to understand awk and was wondering how someone might do this in awk. I am trying to match on the first field of a specific file with the first field on multiple files, and append the second field...

9. Shell Programming and Scripting

sed parser behaving strange on replacing multiple words in multiple files

I have 4000 files like $cat clus_grp_seq10_g.phy 18 1002 anig_OJJ65951_1 ATGGTTTCGCAGCGTGATAGAGAATTGTTTAGGGATGATATTCGCTCGCGAGGAACGAAGCTCAATGCTGCCGAGCGCGAGAGTCTGCTAAGGCCATATCTGCCAGATCCGTCTGACCTTCCACGCAGGCCACTTCAGCGGCGCAAGAAGGTTCCTCG aver_OOF92921_1 ...

10. UNIX for Beginners Questions & Answers

Issue with search and replacing multiple items in multiple files

Im having an issue when trying to replace the first column with a new set of values in multiple files. The results from the following code only replaces the files with the last set of values in val.txt. I want to replace all the files with all the values. for date in {1..31} do for val in...

LEARN ABOUT PHP

mb_strstr

MB_STRSTR(3)								 1							      MB_STRSTR(3)

mb_strstr - Finds first occurrence of a string within another

SYNOPSIS

       string mb_strstr (string  $haystack, string  $needle, [bool  $before_needle = false], [string  $encoding = mb_internal_encoding()])

DESCRIPTION

       mb_strstr(3)  finds  the first occurrence of $needle in $haystack and returns the portion of $haystack. If $needle is not found, it returns
       FALSE.

PARAMETERS

	      o $haystack
		- The string from which to get the first occurrence of $needle

	      o $needle
		- The string to find in $haystack

	      o $before_needle
		- Determines which portion of $haystack this function returns. If set to TRUE, it returns all of $haystack from the  beginning	to
		the  first  occurrence	of  $needle  (excluding needle). If set to FALSE, it returns all of $haystack from the first occurrence of
		$needle to the end (including needle).

	      o $encoding
		- Character encoding name to use. If it is omitted, internal character encoding is used.

RETURN VALUES

	Returns the portion of $haystack, or FALSE if $needle is not found.

SEE ALSO

       stristr(3), strstr(3), mb_stristr(3).

PHP Documentation Group 													      MB_STRSTR(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replacing multiple lines

Discussion started by: ajnabi

2. Shell Programming and Scripting

renaming multiple files while replacing string

Discussion started by: kevin9

3. Shell Programming and Scripting

Replacing string in multiple files

Discussion started by: arulanandsp

4. Shell Programming and Scripting

Replacing text from multiple files at multiple location

Discussion started by: rudoraj