Help Me plss.. Migration problem

[harsha_kusam]

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

[plut0564]

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

Jim

[plut0564]

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

Cheers,

Jim

[harsha_kusam]

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