Oracle 10202 Upgrade - Installing Oracle Instant Client

[Former Member]

Dear all,

I've started with preparations for Oracle upgrade of our test system which is complete homogenous system copy from production.

It's SAP R/3 4.6C with 4.6D_EXT supp. pack 2271, HP-UX 11.11 and Oracle 9.2.0.5

Following the Oracle Upgrade Guide_211:

I've update Oracle client into 9207 like in the <i>Note 964783 - Updating Oracle client on host with multiple SAP systems</i>, because on the same host I have another test instance from another production system.

I also followed the Note 819829 Oracle Database 10g Instant Client 10.x on Unix and changed in the .sapenv_<host>.csh for the SHLIB_PATH

<b>setenv SHLIB_PATH /usr/sap/SID/SYS/exe/run:/oracle/client/10x_64/instantclient:/oracle/client/9207/lib</b>

regarding the <b>point 7.</b> In general, you have to make sure that LD_LIBRARY_PATH does not contain a directory of another ORACLE_HOME (server or client) or of another instant client of another release in a position before /oracle/client/10x_64/instantclient. This could lead to unforseeable behaviour.

Now I have in the /oracle/client folders for 92x_64, 9207 and 10x_64.

When I check with user ora<sid> and <sid>adm, ldd points to 9207:

ldd dboraslib.sl

libclntsh.sl.9.0 => /oracle/client/<b>9207</b>/lib/libclntsh.sl.9.0

libwtc9.sl => /oracle/client/9207/lib/libwtc9.sl

libc.2 => /lib/pa20_64/libc.2

libwtc9.sl => /oracle/client/9207/lib/libwtc9.sl

librt.2 => /usr/lib/pa20_64/librt.2

libpthread.1 => /usr/lib/pa20_64/libpthread.1

libnss_dns.1 => /usr/lib/pa20_64/libnss_dns.1

libdl.1 => /usr/lib/pa20_64/libdl.1

libm.2 => /usr/lib/pa20_64/libm.2

libc.2 => /usr/lib/pa20_64/libc.2

libcl.2 => /usr/lib/pa20_64/libcl.2

Is it ok that I've changed SHLIB_PATH to include both the 10x_64 first then the 9207 client librarries???

setenv SHLIB_PATH /usr/sap/SID/SYS/exe/run:/oracle/client/10x_64/instantclient:/oracle/client/9207/lib

Thanks,

Many regards,

Ruzica

[former_member618758]

Hi,

For environment variable for ora<dbsid> (database server):

Since the Oracle Instant Client is not used in the ora<dbsid>

environment, you do not have to adjust this variable to the environment.

<LIBPATHVAR> is usually set to <ORACLE_HOME>/lib on the database server.

<LIBPATHVAR> must not include the directory in which an Instant Client

is installed.

Environment variable for the <sapsid>adm user :

<LIBPATHVAR>: must contain the directory of the Instant Client.

Example:

LD_LIBRARY_PATH=

/usr/sap/C11/SYS/exe/run:/oracle/client/10x_64/instantclient

Please note 830578 for more detail information.

Thanks,

George