RE: [cx-oracle-users] Symbol reference error: OCIHandleFree - REPOST
Brought to you by:
atuining
Menu
▾
▴
RE: [cx-oracle-users] Symbol reference error: OCIHandleFree - REPOST
|
From: Ogbuji, C. <OG...@cc...> - 2005-11-10 13:53:49
|
Thanks, I went back and removed the reference to 7.3.2 from my LD_LIBRARY_PATH That looks to have been the culprit, but I'm now unable to build cx_Oracle against the 10.1.0.3 Solaris 32-bit Instance Client (http://download.oracle.com/otn/solaris/instantclient/instantclient-basi c-solaris32-10.1.0.3.zip) My LD_LIBRARY_PATH: LD_LIBRARY_PATH=3D/programs/lsf/6.0/sparc-sol7-64/lib:/usr/dt/lib:/usr/loc al/lib:/usr/lib:/usr/ccs/lib:/usr/local/pgsql/lib:/usr/local/mysql/lib:/ usr/local/lib:/usr/lib:/usr/ccs/lib:/usr/local/pgsql/lib:/usr/local/Orac leClient:/usr/local/OracleClient/lib The contents of /usr/local/OracleClient (I simply unpacked them from the above zip - as directed by the installation instructions): bash-2.03$ ls /usr/local/OracleClient/ classes12.jar libclntsh.so.9.1.new libocci.so.10.1 libocijdbc10.so sdk libclntsh.so.10.1 libnnz10.so libociei.so ojdbc14.jar libclntsh.so.10.1 is there The build error: bash-2.03$ python setup.py install running install running build running build_ext building 'cx_Oracle' extension creating build creating build/temp.solaris-2.8-sun4u-2.4 gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC -I/usr/local/OracleClient/rdbms/demo -I/usr/local/OracleClient/rdbms/public -I/usr/local/OracleClient/network/public -I/usr/local/OracleClient/sdk/include -I/usr/local/include/python2.4 -c cx_Oracle.c -o build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o -DBUILD_TIME=3D"November 10, 2005 08:50:52" In file included from /usr/local/OracleClient/sdk/include/oci.h:2327, from cx_Oracle.c:9: /usr/local/OracleClient/sdk/include/oci1.h:148: warning: function declaration isn't a prototype In file included from /usr/local/OracleClient/sdk/include/ociap.h:206, from /usr/local/OracleClient/sdk/include/oci.h:2351, from cx_Oracle.c:9: /usr/local/OracleClient/sdk/include/nzt.h:674: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2665: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2674: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2684: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2693: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2702: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2711: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2719: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2729: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2736: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/nzt.h:2744: warning: function declaration isn't a prototype In file included from /usr/local/OracleClient/sdk/include/oci.h:2351, from cx_Oracle.c:9: /usr/local/OracleClient/sdk/include/ociap.h:9952: warning: function declaration isn't a prototype /usr/local/OracleClient/sdk/include/ociap.h:9958: warning: function declaration isn't a prototype In file included from Variable.c:93, from Cursor.c:211, from Connection.c:303, from SessionPool.c:132, from cx_Oracle.c:73: DateTimeVar.c: In function `DateTimeVar_SetValue': DateTimeVar.c:81: warning: unused variable `status' creating build/lib.solaris-2.8-sun4u-2.4 gcc -shared build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o -L/usr/local/OracleClient/lib -L/usr/local/OracleClient -lclntsh -o build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so -s ld: fatal: library -lclntsh: not found ld: fatal: File processing errors. No output written to build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so collect2: ld returned 1 exit status error: command 'gcc' failed with exit status 1 Searching google and google groups suggests people having issues with 64 bit versions of the clntsh library and such, but I doubt that's the issue here as I'm pretty certain I have the right download for my system: bash-2.03$ uname -a SunOS joplin 5.8 Generic_117350-28 sun4u sparc SUNW,Sun-Fire-280R Any help would be appreciated as I'd love to be able to move on to pythonic interaction with the Oracle DB instead of using Jython w/ ZJDBC Chimezie Thomas-Ogbuji Lead Systems Analyst Thoracic and Cardiovascular Surgery Cleveland Clinic Foundation 9500 Euclid Avenue/ JJ40 Cleveland, Ohio 44195 Office: 216-444-8593 -----Original Message----- =46rom: cx-...@li... [mailto:cx-...@li...] On Behalf Of Chris Dunscombe Sent: Friday, October 28, 2005 3:56 AM To: cx-...@li... Subject: Re: [cx-oracle-users] Symbol reference error: OCIHandleFree - REPOST Chimezie, Just a quick point your LD_LIBRARY_PATH includes Oracle 7.3.2. Is this correct=3F I'd guess you'd need to have at least 8.1.7 as cx_Oracle isn't supported against Oracle 7 anymore. HTH Chris --- Chimezie Ogbuji <chi...@gm...> wrote: > I appologize for the repost, but I realized my original subject line > was incorrectly specified (OCI-22054 error using cx_Oracle) and > probably would have the email show up under a defunct thread and not > at the top level: >=20 > I've been struggling for some time to find an easy (non-convoluted) > way to connect to Oracle 8,9, and 10g databases consistently from a > Solaris 8 MP box. For some time I had been using DataDirects Oracle > Wire Protocol drivers with UNIX ODBC and egenix's mxODBC. However, > DataDirect's drivers (which do not require an Oracle Client install - > which is the most attractive thing about them) have since exceeded my > evaluation period, so I'm giving cx_Oracle a shot. >=20 > Following directions from this thread > (http://sourceforge.net/mailarchive/forum.php=3Fthread_id=3D8719369&forum_id =3D34464), > I've installed the the Oracle Instant Client, installed the SDK > package, modified the setup.py of cx_Oracle and was able to run python > setup.py install w/out any errors: >=20 > bash-2.03$ python setup.py install > running install > running build > running build_ext > building 'cx_Oracle' extension > creating build > creating build/temp.solaris-2.8-sun4u-2.4 > gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes > -fPIC -I/usr/local/OracleClient/rdbms/demo > -I/usr/local/OracleClient/rdbms/public > -I/usr/local/OracleClient/network/public > -I/usr/local/OracleClient/sdk/include -I/usr/local/include/python2.4 > -c cx_Oracle.c -o build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o > -DBUILD_TIME=3D"October 27, 2005 10:01:17" > In file included from /usr/local/OracleClient/sdk/include/oci.h:2327, > from cx_Oracle.c:9: > /usr/local/OracleClient/sdk/include/oci1.h:148: warning: function > declaration isn't a prototype > In file included from /usr/local/OracleClient/sdk/include/ociap.h:206, > from /usr/local/OracleClient/sdk/include/oci.h:2351, > from cx_Oracle.c:9: > /usr/local/OracleClient/sdk/include/nzt.h:674: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2665: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2674: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2684: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2693: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2702: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2711: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2719: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2729: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2736: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/nzt.h:2744: warning: function > declaration isn't a prototype > In file included from /usr/local/OracleClient/sdk/include/oci.h:2351, > from cx_Oracle.c:9: > /usr/local/OracleClient/sdk/include/ociap.h:9952: warning: function > declaration isn't a prototype > /usr/local/OracleClient/sdk/include/ociap.h:9958: warning: function > declaration isn't a prototype > In file included from Variable.c:93, > from Cursor.c:211, > from Connection.c:303, > from SessionPool.c:132, > from cx_Oracle.c:73: > DateTimeVar.c: In function `DateTimeVar_SetValue': > DateTimeVar.c:81: warning: unused variable `status' > creating build/lib.solaris-2.8-sun4u-2.4 > gcc -shared build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o > -L/usr/local/OracleClient/lib -L/usr/local/OracleClient -lclntsh -o > build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so -s > running install_lib > copying build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so -> > /usr/local/lib/python2.4/site-packages >=20 > However, when I try to run any of the tests (or just try to import the > newly installed cx_Oracle) I get the following symbol reference error: >=20 > bash-2.03$ python test/test.py > Traceback (most recent call last): > File "test/test.py", line 3, in =3F > import cx_Oracle > ImportError: ld.so.1: python: fatal: relocation error: file > /usr/local/lib/python2.4/site-packages/cx_Oracle.so: symbol > OCIHandleFree: referenced symbol not found >=20 > I wouldn't expect the build process to complete if there were symbol > reference issues, but I have the Instant Client binaries installed in > /usr/local/OracleClient > , the sdk package installed in /usr/local/OracleClient/sdk, my > ORACLE_HOME variable points to /usr/local/OracleClient, and > LD_LIBRARY_PATH includes /usr/local/OracleClient: >=20 > bash-2.03$ env | grep LD_LIBRARY_PATH > LD_LIBRARY_PATH=3D/programs/lsf/6.0/sparc-sol7-64/lib:/usr/dt/lib:/vol/ora cle/product/7.3.2/lib:/usr/local/lib:/usr/lib:/usr/ccs/lib:/usr/local/pg sql/lib:/usr/local/mysql/lib:/usr/local/lib:/usr/lib:/usr/ccs/lib:/usr/l ocal/pgsql/lib:/usr/local/OracleClient > bash-2.03$ env | grep ORACLE_HOME > ORACLE_HOME=3D/usr/local/OracleClient >=20 > I'm not sure why it's unable to resolve the symbol. Any help would be > greatly appreciated >=20 > Chimezie >=20 >=20 > ------------------------------------------------------- > This SF.Net email is sponsored by the JBoss Inc. > Get Certified Today * Register for a JBoss Training Course > Free Certification Exam for All Training Attendees Through End of 2005 > Visit http://www.jboss.com/services/certification for more information > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >=20 =09 =09 __________________________________=20 Yahoo! Mail - PC Magazine Editors' Choice 2005=20 http://mail.yahoo.com ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course =46ree Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information _______________________________________________ cx-oracle-users mailing list cx-...@li... https://lists.sourceforge.net/lists/listinfo/cx-oracle-users ---------------------------------------------------------------------------= --- Confidentiality Note: This message is intended for use only by the = individual or entity to which it is addressed and may contain information = that is privileged, confidential, and exempt from disclosure under = applicable law. If the reader of this message is not the intended recipien= t= or the employee or agent responsible for delivering the message to the = intended recipient, you are hereby notified that any dissemination, = distribution or copying of this communication is strictly prohibited. If = you have received this communication in error, please contact the sender = immediately and destroy the material in its entirety, whether electronic or= = hard copy. Thank you. ------------ Visit us online at our award-winning http://www.clevelandclinic.org for a = complete listing of Cleveland Clinic services, staff and locations from one= = of the country's leading hospitals. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D |
