Oracle Discoverer

Asked to clone a copy of Oracle Discoverer  10.1.2 which was installed a couple of years ago.

Unfortunately this was installed by an outside body and they did not bother to place a copy of the s/w in our repository. The version was desupported December 2011 so had to ask Oracle nicely if they would supply us with the s/w.

Thought I might have got away with copying it from one box to another but always think it is better to try a new install.

Oracle kindly pointed us to this document on Metalink.

Requesting Physical Shipment or Download URL for Software Media (Doc ID 1071023.1)

Worth reading if you ever need to get hold of desupported s/w.

So we have downloaded version 10 from the link Oracle sent us following the s/w request and I have also downloaded Discoverer 11g from Oracle e-delivery so we can start to move on.

Will let everyone know how I get on with this.

Changing Oracle Base

Today I was asked to clone a copy of an application running on 11.2.0.2 so I copied the db and app code onto the server and ran "oraenv" to set the environment.

However, oraenv was returning the ORACLE_BASE of the original server and not the new server. In the past I have manually changed the file oraclehomeproperties.xml 

$ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml

Yes you could change the ORACLE_BASE variable but seemed a bit of a fudge.

However I thought there must be a formal way to do this. If you run orabase by itself it returns the ORACLE_BASE value but if you run it with the -s option it will allow you to change the value.

Usage: orabase [-s <New ORACLE_BASE Location>]
       -s : This option will change the current value of ORACLE_BASE
            in ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml
            to the new ORACLE_BASE location specified.

Probably worth logging out and logging back in to get orabase to pick the correct value up.