Oracle 8.1.7.4 Patch fails on 11i-64

[Michael Simone]

I'm trying to upgrade an Oracle 8.1.7.0 installation (64-bit) on an 11.11 server to 8.1.7.4. When it's in the linking phase of the installer, it dies with an error in the make.log indicating that it can't find libclntsh, which is clearly there in both lib and lib64. I've made sure both those paths ($ORACLE_HOME/lib, $ORACLE_HOME/lib64) are in my SHLIB_PATH and LD_LIBRARY_PATH.

Other posts on here indicate no OS patches were required for the Oracle patch. Anybody else see this? As a result of this mess, I'm reinstalling 8.1.7.0 to get my DB back up and running. Unfortunately, no 64-bit test bed to try this out on.

Thanks.

[Steven E. Protter]

For HP-UX SHLIB_PATH is critical.

There are detailed instructions for the upgrade. Its not an install and forget it release.

You have to follow steps to 8.1.7.4 including converting your java, data and an transitional release in the 8.1.7.2 range.

http://metalink.oracle.com
http://otn.oracle.com

Don't follow the instructions to a tee, you have no hope of success.

SEP

[Michael Simone]

So is my SHLIB_PATH correct? Do I need more than that?

I am following the patch instructions properly. I ran this upgrade on a 32-bit system, going straight from 8.1.7.0 to 8.1.7.4, with no problems. The instructions don't indicate any intermediary steps, and I have no Java objects, just data tables and indices and views.

[Sandeep Kapare]

There are two separate patchsets for both 32bit & 64bit 8.1.7.4 Make sure you are not installing patchset intended for 32bit on 64bit kernel.

[Brian Crabtree]

Michael,

Try unsetting the SHLIB_PATH and LD_LIBRARY_PATH variables, and running "relink all" from the command line after setting up your enviroment variables to point to the ORACLE_HOME (don't forget the PATH variable). This should allow it to relink, and will give you the error again if it does. It might be that it is finding the 32bit libclntsh.sl file in the path.

Otherwise, check that the libclntsh.sl symlink is pointing to a valid file. It should be pointing at libclntsh.sl.8.0 (I think) which should exist as well.

Thanks,

Brian

[David Nixon]

I've seen that link error when installing
Application Server 10g: a preceeding script to build a libclntsh had failed..
Might be worth checking install logs for errors from
$ORACLE_HOME/bin/genclntsh

I