Upgrading to Oracle 9

[fid509]

We upgraded a test system from Oracle 8 to Oracle 9
I changed the binaries to the oraoci9 equivalents and tried to start the SC again. The SC sercerwon't start and when I try to run scenter -help I get the following error:
ld.so.1: scenter: fatal: /xxx/xxx/app/oracle/product/9.2.0.3/lib/libclntsh.so.9.0: wrong ELF class: ELFCLASS64
Killed

Searching Google learned me that this is caused by the fact that the library file is compiled for 64-bit while the scenter is not (I suppose it is only 32-bit?). Anybody has encountered a similar problem and maybe found a solution?

thx,
Geert

[tommy]

Have You checked that SC is compatible with that release of Oracle?

[fid509]

It should be according the compability matrix:

SC 5.0.1.7

Platform
Sun SPARC

OS
Solaris 2.6, 2.7, 8

RDBM
Peregrine P4
Oracle 7.3.4, 8.0.6, 8.1.6, 8.1.7, 9.0.1, 9.2.0.1
IBM DB2 6.1, 7.1, 7.2
Sybase 12.0, 12.5 Informix 7.31, 9.2.1, 9.3

[fid509]

Just an update, as I suspected the sc binaries are compiled in 32bit, so you have to use the 32bit Oracle 9 client instead of the default 64bit. This client is located in /xxx/xxx/app/oracle/product/9.2.0.3/lib32/

[swynsma]

You can run the 64 bit oracle.
But you need to place the path to the 32 bit libraries in the front of your lib path so it uses those.
In our installation on HP-UX it was:
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:...
export SHLIB_PATH=$ORACLE_HOME/lib32:...

[brunodg]

we can confirm previuous post. First declare lib32:

LIBPATH on AIX
If the 32bit library path (lib32) is not set as first lib path in LIBPATH in .profile of the user peregrine; PSC doesn’t start up.
Nothing appears in sc.log but in server.log, you’ll get this message:

[peregrine@server] /srvcnt/peregrine/logs > cat server.log
exec(): 0509-036 Cannot load program scenter because of the following errors:
0509-150 Dependent module /oracle00/home/9.2.0.5/lib/libclntsh.a(shr.o) could not be loaded.
0509-103 The module has an invalid magic number.
[peregrine@server] /srvcnt/peregrine/logs >

To avoid this, change LIB_PATH in .profile to:
LIBPATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$SCHOME/RUN:.

regards

Bruno DG