ERP 6.0 - ECC 6.0 EHP4 running oracle 11.2.0.2 instant client 10.2.0.4.0 V5

[steven_foo]

Hi All,

We are running ERP 6.0 - ECC 6.0 EHP4 running oracle 11.2.0.2 instant client 10.2.0.4.0 V5 on HP_UX 11.31 64 bit for quite sometime now.

We are on kernel 721 64bit UNICODE patch 526.

Our questions:

1) What is the version of instant client we could upgrade until to support oracle database 11.2.0.2 ?

1.1) Any guideline of steps available to follow for the upgrade?

1.2) Do we need to shutdown or restart the database after the upgrade in order for the new instant client to take effective?

2) I saw in the software download area, there is a Oracle Client 11.2.0.4 v3 available. Will this enable the compatibility level to run Oracle 11.2.0.2 with kernel 721 64bit UNICODE ?

3) How about BR*Tools version to be used, if we use this Oracle Client 11.2.0.4 v3, what version will it be compatible with?

We are using version 7.20 (42).

Thanks.

[Former Member]

Hi steven

1.You can upgrade to 11.2.0.4 or 11.2.0.5 .

1.1 Steps:

# mkdir -p /oracle/client/11x_64

# cd /oracle/client/11x_64

# Mount Oracle client DVD 11.1.0.4 and unzip the client software :

siadm>SAPCAR -xvf  OCL<version>.SAR

*Create symbolic links

cd /oracle/client/11x_64

ln -s instantclient_112_64  instantclient

# cd /oracle/client

# mv 10x_64 10x_64_save

*Create symbolic link

sidadm>ln -s /oracle/client/10x _64 /oracle/client/11x_64

1.2.No need to shut down database,but application server should be down.

2.Yes

3.720 is fine or you can upgrade to 721.

Regards,

Manoj.

[JamesZ]

Hi Steven,

You should use 11g client for 11g database server, while the miner version of client can be bigger than server version. So you can use 11.2.0.4 client to work with 11.2.0.2 database.

You can refer to SAP note 819829 for client update. As mentioned in the note, you used to create a link in order to use kernel 720 ( or btools 720).

Best regards,
James

[steven_foo]

James,

Thanks for the hint. I will take a look into the SAP note.