Thanks a lot. Now that issue is resolved after i execute below command. sudo ln -s /opt/app/oracle/products/11.2.0/lib/libclntsh.so.11.1
But now i am getting databse error. Any pointer please? Exception Value: Error while trying to retrieve text for error ORA-01804 Here is my code to fetch the data from database. def cases(request, dbname, prnum=None, message=''): connection = cx_Oracle.Connection("%s/%s@%s" % ('foo', 'bar', 'xyz')) cursor = cx_Oracle.Cursor(connection) sql = "SELECT fielname FROM tablename where rownum < 10" cursor.execute(sql) names = [row[0] for row in cursor.fetchall()] cursor.close() connection.close() Thanks, Kamal On Thu, Apr 21, 2011 at 9:31 PM, kamal sharma <kamalp.sha...@gmail.com>wrote: > After creating soft link, still it is giving the same error. Do i need to > create soft link for any other files? My response are inline with KS: > > On Thu, Apr 21, 2011 at 9:21 PM, Ian <ian.g.ke...@gmail.com> wrote: > >> On Apr 21, 9:39 am, kamal sharma <kamalp.sha...@gmail.com> wrote: >> > Here is the error I am getting now: >> > >> > cd /usr/local/lib >> > >> > /usr/local/lib> sudo ln >> > /opt/app/oracle/products/11.2.0/lib/libclntsh.so.10.1 >> > ln: ./libclntsh.so.10.1 is on a different file system >> > >> > /usr/local/lib> cd /usr/lib/ >> > /usr/lib> sudo ln /opt/app/oracle/products/11.2.0/lib/libclntsh.so.10.1 >> > ln: ./libclntsh.so.10.1 is on a different file system >> >> Right, it's not possible to create hard links across file systems. >> Create a soft link instead using "ln -s" (soft links are usually >> preferable anyway). >> > > KS: Ok i have created soft link and it is fine. > sudo ln -s /opt/app/oracle/products/11.2.0/lib/libclntsh.so.10.1 > >> >> > Also set this in .cshrc file >> > >> > setenv LD_LIBRARY_PATH "$ORACLE_HOME/lib32:$ORACLE_HOME/lib" >> > setenv LD_LIBRARY_PATH /usr/X11R6/lib:/usr/local/lib >> > >> > echo $LD_LIBRARY_PATH >> > /usr/X11R6/lib:/usr/local/lib >> > echo $ORACLE_HOME/ >> > /opt/app/oracle/products/11.2.0/ >> >> Is this in your .cshrc file or the WSGI user's .cshrc? And are you >> sure it's using csh and not bash? >> > > KS: Yes it .cshrc file. > >> >> -- >> >> 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.