What is this Site!!

All about Real time requirements in Orale Stay Tune!!

Sunday, January 6, 2008

Shell Script To Dynamically Generate Init.ora File


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?


--------------------------------------------/


Try something this:

CODE

set pages 0 term off feed off trims on lin 132 ver off

def fdb='FromDB'

def tdb='ToDB'

spo /tmp/init&&tdb.ora

Select NAME||'='||replace(VALUE,'&&fdb','&&tdb')

From DBA_PARAMETERS;

spo off




2 comments:

12345 said...

Nice blog, Thanks For Sharing this infromative article.
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad

shaik shah said...

Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
Oracle Fusion HCM Online Training
Oracle Fusion Financials Online Training