The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 03-18-2008
sewood sewood is offline
Registered User
  
 

Join Date: Feb 2006
Posts: 6
Edit value in File

I have a file oratab with entry like this
SCADAG:/esitst1/oracle/product/9.2.0.8:Y

I am trying to discover a way to change the 9.2.0.8 part of this to something like 10.2.0.4 as part of an upgrade script.

I have tried
cat /etc/oratab >>/tmp/oratab
ORACLE_HOME=/esitst1/oracle/product/9.2.0.8
export ORACLE_HOME
NEW_HOME=/esitst1/oracle/product/10.2.0.4
export New_HOME

sed -e "s/${ORACLE_SID}:${ORACLE_HOME}/${ORACLE_SID}:${NEW_HOME}/g" /tmp/oratab >/etc/oratab

If I read it correctly, it appears not to like the forward slashes.

Any suggestions as how to do this would be greatly appreciated. I may be even going down the wrong road here.

Thanks