External Procedure Raises Ora-06522 After Pre-11.2 (ie 8i) - 11gr2 Upgrade (Doc ID 1340343.1)

Last updated on JULY 17, 2017

Applies to:

PL/SQL - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms


After upgrading from 8i to 11.2.0.2, calling an external procedure errors with:

ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extproc: fatal: /app/oracle/ext/scripts/report_prod_sh.so: wrong ELF class: ELFCLASS32

Changes

Oracle software upgrade from a pre-11.2.0.X release to 11.2.

In 11.2, when installing "regular" Oracle on a 64-bit o/s, you only get 64-bit executables and libraries.
In prior releases, we installed 32-bit and 64-bit executables and libraries simultaneously. 
The libraries resided in separated directories - $ORACLE_HOME/lib and $ORACLE_HOME/lib32
(9i and above) or $ORACLE_HOME/lib and $ORACLE_HOME/lib64 (8i).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms