Page 1 of 1
Upgrade ORacle to 9i - What change I do on Datastage server
Posted: Tue Sep 06, 2005 9:47 am
by ketfos
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
Posted: Tue Sep 06, 2005 2:18 pm
by lstsaur
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.
Posted: Tue Sep 06, 2005 2:31 pm
by lebos
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
Posted: Tue Sep 06, 2005 3:13 pm
by ketfos
Hi,
Where is the dsenv file located. We are running DS 7.5 on HP Unix.
Thanks
Ketfos
Posted: Tue Sep 06, 2005 3:17 pm
by mdan
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
Posted: Wed Sep 07, 2005 6:51 am
by lebos
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