Hi Jirka, Thanks for the response.
I have installed cx_Oracle in Solaris again and followed this steps but still the error is same: Exception Type:DatabaseErrorException Value: Error while trying to retrieve text for error ORA-01804 Download cx_oracle module: http://sourceforge.net/projects/cx-oracle/files/5.0.3/cx_Oracle-5.0.3.tar.gz/download Install: [me] ~/install_cx_oracle/cx_Oracle-5.0.3> gunzip cx_Oracle-5.0.3.tar.gz [me] ~/install_cx_oracle/cx_Oracle-5.0.3> tar xvf cx_Oracle-5.0.3.tar [me] ~/install_cx_oracle/cx_Oracle-5.0.3> cd cx_Oracle-5.0.3 [me] ~/install_cx_oracle/cx_Oracle-5.0.3> /usr/local/bin/python setup.py build running build running build_ext building 'cx_Oracle' extension creating build creating build/temp.solaris-2.10-sun4u-2.6-11g gcc -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -fPIC -I/opt/app/oracle/products/11.2.0/rdbms/demo -I/opt/app/oracle/products/11.2.0/rdbms/public -I/usr/local/stow/python/include/python2.6 -c cx_Oracle.c -o build/temp.solaris-2.10-sun4u-2.6-11g/cx_Oracle.o -DBUILD_VERSION=5.0.3 In file included from /opt/app/oracle/products/11.2.0/rdbms/public/oci.h:3024, from cx_Oracle.c:10: /opt/app/oracle/products/11.2.0/rdbms/public/ociap.h:10788: warning: function declaration isn't a prototype /opt/app/oracle/products/11.2.0/rdbms/public/ociap.h:10794: warning: function declaration isn't a prototype creating build/lib.solaris-2.10-sun4u-2.6-11g gcc -shared build/temp.solaris-2.10-sun4u-2.6-11g/cx_Oracle.o -L/opt/app/oracle/products/11.2.0/lib -L/opt/app/oracle/products/11.2.0 -L. -lclntsh -lpython2.6 -o build/lib.solaris-2.10-sun4u-2.6-11g/cx_Oracle.so [me] ~/install_cx_oracle/cx_Oracle-5.0.3> echo $ORACLE_HOME/ /opt/app/oracle/products/11.2.0/ [me] ~/install_cx_oracle/cx_Oracle-5.0.3> sudo python setup.py install Password: running install running build running build_ext running install_lib copying build/lib.solaris-2.10-sun4u-2.4-11g/cx_Oracle.so -> /usr/lib/python2.4/site-packages [me] ~/install_cx_oracle/cx_Oracle-5.0.3> python Python 2.4.4 (#1, Jan 10 2007, 01:25:01) [C] on sunos5 Type "help", "copyright", "credits" or "license" for more information. >>> import cx_Oracle >>> cx_Oracle.version '5.0.3' Did i missed something? Thanks, Kamal On Fri, Apr 22, 2011 at 3:20 PM, Jirka Vejrazka <jirka.vejra...@gmail.com>wrote: > Hi Kamal, > > checking my install history, this is what I had to do to use > cx_Oracle on Ubuntu Server: > > $ /usr/local/oracle/instantclient_11_2$ ln -s libclntsh.so.11.1 > libclntsh.so > $ WITH_UNICODE=1 ORACLE_HOME=/usr/local/oracle/instantclient_11_2 > python setup.py build > $ sudo bash > # WITH_UNICODE=1 ORACLE_HOME=/usr/local/oracle/instantclient_11_2 > python setup.py install > > and tested: > $ export > LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/oracle/instantclient_11_2 > $ python > Python 2.5.2 (r252:60911, Jan 20 2010, 21:48:48) > [GCC 4.2.4 (Ubuntu 4.2.4-1ubuntu3)] on linux2 > Type "help", "copyright", "credits" or "license" for more information. > >>> import cx_Oracle > >>> cx_Oracle.version > '5.0.3' > > Then I added the LD_LIBRARY_PATH to /etc/profile so it'd be used by > all users, including the Apache process. > > The error you're getting is most likely caused by ORACLE_HOME not > being set during cx_Oracle installation. To be extra sure, consider > adding it to /etc/profile too. > > > HTH > > Jirka > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-users@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
