Upgrade ORacle to 9i - What change I do on Datastage server

ketfos · Post by **ketfos** » Tue Sep 06, 2005 9:47 am

Hi,
We have upgraded ORacle 8i to 9i.
What changes we need to make on the datastage server side (7.5) so that it picks ORacle 9i database.

Thanks
Ketfos

lstsaur · Post by **lstsaur** » Tue Sep 06, 2005 2:18 pm

Hi Ketfos,
Make sure that Oracle9i client is installed and has its own home. Also, OCI8TO9.B utility should be used to convert any Oracle OCI8 stage used in your jobs. Good luck.

lebos · Post by **lebos** » Tue Sep 06, 2005 2:31 pm

You will also have to change the dsenv file to specify the new Oracle Home and LibPath.

Details can be found in the Oracle OCI Plug In Manual.

We just did this and have experienced no problems at all.

Larry

ketfos · Post by **ketfos** » Tue Sep 06, 2005 3:13 pm

Hi,
Where is the dsenv file located. We are running DS 7.5 on HP Unix.

Thanks
Ketfos

mdan · Post by **mdan** » Tue Sep 06, 2005 3:17 pm

try
find <DS Installation Path> -name dsenv -print
usually in <dsadm home>/Ascential/DataStage/DSEngine/dsenv

ketfos wrote:Hi,
Where is the dsenv file located. We are running DS 7.5 on HP Unix.

Thanks
Ketfos

lebos · Post by **lebos** » Wed Sep 07, 2005 6:51 am

Do the following:

sign on as dsadm, then
cd `cat /.dshome`

This will take you to the dshome directory. dsenv is there.

I would recommend making a copy before changing it. Remember that you must bounce the DSEngine in order for changes to dsenv to take effect. From the dshome directory:

bin/uv -admin -stop
bin/uv -admin -start

Wait at least ten seconds between these two commands.

Good luck.

Larry