Forum OpenACS Q&A: Re: ns_ora, memory leak, server dies

Collapse
Posted by Samer Abukhait on
Server is not able to write to the Database

is oracle on the same server as aol ?

is the web user able to connect to oracle and write ??

test everything separated from aol

as the web user
sqlplus dbuser
create and write something.

if everything is fine, then you might accuse memory or CPU, your judge will be no body but 'top'

Collapse
Posted by Nis Jørgensen on
  • Oracle is on a different server.
  • Problem happens when _reading_ a blob from the db (the stream_write_lob writes a lob from the db to the connection, if I am not mistaken (which I might very well be)
  • And problem is not reproducible (but frequent)
  • Collapse
    Posted by Jeff Davis on
    which version of the driver and which version of oracle are
    you using?
    Collapse
    Posted by Nis Jørgensen on
    AOLserver/3.3.1+ad13
    Oracle 8.1.7
    ArsDigita Oracle Driver version 2.5
    Collapse
    Posted by Andrew Piskorski on
    Nis, that version of the Oracle driver is ancient. You should be using nsoracle 2.7 from SourceForge.
    Collapse
    Posted by Nis Jørgensen on
    I will look at upgrading my oracle driver. I have a few other things that I will try first (one thing at a tiem when debugging).
    Collapse
    Posted by Nis Jørgensen on
    OK. Driver upgraded, problem persists. Any other ideas?
    Collapse
    Posted by Guan Yang on
    I'm also experiencing this. Server is Oracle 9i (9.2.something), nsoracle-2.7, aolserver-4.0.2.

    Guan