Hi All,

We have beenn migrated from 9i to 10g

and one of our python script is still pointing out to 9i libraries

import cx_Oracle

when it's trying to import this library my script is failing

ImportError: ld.so.1: python: fatal: libclntsh.so.9.0: open failed: No such file or directory


Could some one pls help me out how to resolve this

Our neww library path is set to correct one

echo $LD_LIBRARY_PATH
/data/lgcmsp1/apps/dbus_3_0_8_14/vitria.3.1/SPARC_5.8/6.0/lib:/data/lgcmsp1/apps/dbus_3_0_8_14/SPARC_5.8/6.0/lib::/data/lgcmsp1/apps/dbus_3_0_8_14/SPARC_5.8/6.0/lib:/data/lgcmsp1/apps/dbus_3_0_8_14/vitria.3.1/SPARC_5.8/6.0/lib:/data/oracle/product/10.2.0.3/lib

Use a soft link to the old library and put is in you LD_library_path.
Cheers,

Jim

Just remembered something, go into the $ORACLE_HOME/bin in there is an executable gencltsh, run this as the oracle user.

Cheers,

Jim

Hi All,

We have been migrated our oracle database from 9i to 10g

and one of our python script is still pointing out to 9i libraries

import cx_Oracle

when it's trying to import this library my script is failing

ImportError: ld.so.1: python: fatal: libclntsh.so.9.0: open failed: No such file or directory


Could some one pls help me out how to resolve this

Our neww library path is set to correct one

echo $LD_LIBRARY_PATH
/data/lgcmsp1/apps/dbus_3_0_8_14/vitria.3.1/SPARC_5.8/6.0/lib:/data/lgcmsp1/apps/dbus_3_0_8_14/SPARC_5.8/6.0/lib::/data


And same i sent to DBA's They came back and asking as below....
------------------------------------------------------
Harsha

Your python script is clearly looking for the old 9i software.

How do you tell Python which Oracle Home to use?

--------------------------------------------------------

Could someone pls help me plss....

Cheer's
Harsha

This article has been dead for over six months. Start a new discussion instead.