Hope this title didn't shock you.
Today is a nightmare day! While on the to office, someone SMS me that tens of jobs are failed.
Below is the funny message.
ORA-28575
/usr/lib/dld.sl: Bad magic number for shared library:
/home/app/oracle/product/9.0.1/lib/libclntsh.sl.9.0
/usr/lib/dld.sl: Exec format error
When spoke out this to sysadmin, 3 sysadmin jumped up and 3 others laughed.
While I was investigating, quite a few Managers checked with me other areas and question me WHY WHY WHY.
Not in the mood. Are their things important than production problem? Appreciate they can "PLAN" better in future in a whole picture.
Back to the subject, this is caused after change the ORACLE_HOME in the profile, subsequently caused the LIB_LIBRARY_PATH can't find 32bit lib file.
i.e the SHLIB_PATH includes $ORACLE_HOME/lib (64bit) and does not include lib32 (32bit).
