Upgrade from BW 3.5 to BI 7.0 (Kernel 640 to 700)

[Former Member]

Hello experts,

We are carrying out an upgrade of our BW QA Server, our OS is HP-UX 11.23, and we recently upgraded our oracle database from 9.2.0.7 tu 10.2.0.2

As part of the pre-prepare phase of the upgrade, one of the requirements was to use the new oracle instant client for 10.2.0.2. We arrange to get this db client working but afterwards our sap system was unable to load the dbsl libraries and R3trans failed to connect to the DB. Because of this we found necesary to upgrade the SAP Kernel from 640 to 700. We carried out this step and both sap and oracle are starting without problems and R3trans succeds to connect, but when we try to access thru SAP GUI we get this terrible message:

"Error when initializing the work area SYST."

Any of you have encountered this situacion before?

Any tips or pointers that could help us move on from this error?

We believe our environment variables are ok, I mean everything worked with kernel 640.

Thanks for your help, I will award points to helpful solutions.

[Former Member · Accepted solution]

After you install a new client what variables you used for start sap?

You must add the ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data variable to your SIDadm environment,

and ORA_NLS10=$ORACLE_HOME/nls/data to your oraSID.

While you had an old kernel, you could not work with the new client....

I on your place would return a kernel 640 and have put correct variables at users.

Thanks and regards.

Award if helpful.

[Former Member]

HI Salvador,

Please follow the notes 819829 carefully (read step 5)

And done this step: (Install oracle client version 9.2.0.7)

mv /oracle/client/92x_64 /oracle/client/92x_64_ORIG

mkdir /oracle/client/92x_64

cd /oracle/client/92x_64

SAPCAR -xvf /tmp/OCL92064.SAR

Change all the .dbenv*.csh parameter to new oracle home (include ORA_NLS10 for ora<sid>, but not for <sid>adm)

set <SID>adm user:

ORA_NLS33 = /oracle/client/92x_64/ocommon/nls/admin/data

And before prepartion step follow:

Install Oracle client 10x_64 see note 819829

And dont forget to transport ORAREL6XX.SAR after your SAP up, otherwise you will get error when access ST04 or DB02

Regards,

Fendi

[markus_doehr2]

During the upgrade you need two Oracle clients:

the 9.2.0.7 (at least, better 9.2.0.8) for the 6.40 kernel

the 10.2.0.2 for the 7.00 kernel

If you had just links in /oracle/client/92x_* then those links are gone after the upgrade to 10g because they point to invalid directories.

Install the 9.2 client alongside with the 10.2 client.

Markus