Re: shell script for dynamically building init.ora file

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 24 Aug 2005 18:19:30 +0200
Message-ID: <430c9f47$0$24157$9b4e6d93@newsread4.arcor-online.net>

Maxim Demenko schrieb:

> nirav schrieb:
> 

>> Experts ,
>>
>> I am working on a need to clone databases..and in that I need to write
>> a shell script which will 'dynamically generate' the init.ora file for
>> target database using that of source database and a temp file which
>> will hold changed value of parameters.
>> For example in temp file there is a param like:
>> db_name =targetdb
>>
>> and in source init.ora file db_name=db1 then the shell script should
>> read the temp file and be able to create a new init.ora file with
>> changed value
>> ie db_name=targetdb (so all other parameters that are not specified in
>> temp file will remain same, but all specified parameters will be
>> changed.)
>>
>> Can you suggest some similar scripts for such work? Any help, I am very
>> thankful..
>>
>> Regs
>> Nirav
>>

> 
> There are many ways to code it ( most flexible would be that with awk or 
> perl ), but to achieve simple merging of two files based on a key column 
> you can use join command.
> 
> # Put all key/values from initSRC.ora which are
> # not specified in temp file
> # into target configuration
> join initSRC.ora initTMP.ora -t "=" -v1 > initTGT.ora
> # Put all key/values from temp file based on matched key pairs
> # into target configuration
> join initSRC.ora initTMP.ora -t "=" -o "0 2.2" >> init.TGT.ora
> 
> Additionally you possibly would like to sort the contents of your files...
> Best regards
> 
> Maxim

That will provide wrong results if in the temp file are values containing "=" ( key/value separator in init.ora ). To get the correct results simply put the contents of temp file instead of second join: join initSRC.ora initTMP.ora -t "=" -v1 > initTGT.ora cat initTMP.ora >> init.TGT.ora

It can even be combined into oneliner:
join initSRC.ora initTMP.ora -t "=" -v1|cat initTMP.ora -> initTGT.ora

Best regards

Maxim Received on Wed Aug 24 2005 - 11:19:30 CDT