Shell Programming and Scripting

You can just use:

Code:

awk '/ALTER DATABASE OPEN/,/MAXINSTANCES 1/' inputfile > outputfile

Thanks alot..It solved my problem...

HI ,

I have one more problem ..

i want to replace few different entries in file
example
CREATE CONTROLFILE REUSE DATABASE "SID" RESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 16
MAXLOGMEMBERS 5
MAXDATAFILES 512
MAXINSTANCES 1
MAXLOGHISTORY 7260
LOGFILE
GROUP 1 (
'/mount/sid/patch01data/log01a.dbf',
'/mount/sid/patch01data/log01b.dbf'

here i want to change with SID=NEWSID,sid=newsid,REUSE=set and mount=newmount

Please help me how to replace it.

Thanks
Jack

Use sed to do search-and-replaces on the input data.

HI
Thanks for quick replay
sed "'s/$esid/$sid/g','s/$emount/$mount/g','s/REUSE/SET/g','s/$ESID/$SID/g'" temp>temp1
sed: 's/patch01/1/g','s/dev04/2/g','s/REUSE/SET/g','s/PATCH01/3/g' is not a recognized function.
I m getting the above error

Please help me suggest me..

Thanks
jack

You're almost there... no need for the single quotes, and you can separate commands using ";", e.g.

Code:

sed "s/$esid/$sid/g;s/$emount/$mount/g;s/REUSE/SET/g;s/$ESID/$SID/g" temp>temp1

Thanks alot Annihilannic...
one more thing..

How to pass dynamic values to
sed "s/$esid/$sid/g;s/$emount/$mount/g;s/REUSE/SET/g;s/$ESID/$SID/g
to this $esid,sid ..
echo "enter esid"
read esid
echo "enter emount"
read emount
echo "enter ESID"
read ESID
echo "enter sid"
read sid
echo "enter mount"
read mount
echo "enter SID"
read SID
sed 's/$esid/$sid/g;s/$emount/$mount/g;s/REUSE/SET/g;s/$ESID/$SID/g' temp>temp1

Here the values are not taking ..Please help

Thanks
jack