I have searched on this, but could not find the specific problem previously listed, so here goes...
We recently had IBM complete a new installation of DataStage version 8 on a Linux OS. Following the installation, the consultant ran serveral test jobs, one of which was to use the Oracle Enterprise stage to connect to an Oracle DB. This job failed with the following:
Code: Select all
Item #: 8
Event ID: 7
Timestamp:: 2008-05-08 11:44:53
Type: Fatal
User Name: dsadm
Message:: main_program: PATH search failure:
Item #: 9
Event ID: 8
Timestamp:: 2008-05-08 11:44:53
Type: Fatal
User Name: dsadm
Message:: main_program: Error loading "orchoracle": Could not load "orchoracle": libclntsh.so.10.1: wrong ELF class: ELFCLASS64.
Item #: 10
Event ID: 9
Timestamp:: 2008-05-08 11:44:53
Type: Fatal
User Name: dsadm
Message:: main_program: Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
Item #: 11
Event ID: 10
Timestamp:: 2008-05-08 11:44:53
Type: Fatal
User Name: dsadm
Message:: main_program: Creation of a step finished with status = FAILED.
Given this, I was surprised that the issue hadn't been posted up here before as it must be very widespread.
For info, in the lib directory, the libcIntsh.so file is seen as:
Code: Select all
lrwxrwxrwx 1 oracle oinstall 53 2006-10-02 14:10 libclntsh.so -> /opt/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
-rw-r--r-- 1 oracle oinstall 20527539 2006-10-02 14:10 libclntsh.so.10.1
Code: Select all
-rw-r--r-- 1 oracle oinstall 0 2005-10-22 21:55 libclntsh.so
Thanks in advance,
S