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 <[email protected]>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 <[email protected]> wrote:
>
>> On Apr 21, 9:39 am, kamal sharma <[email protected]> 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 [email protected].
>> To unsubscribe from this group, send email to
>> [email protected].
>> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
