Forum OpenACS Q&A: remote Oracle installation

Posted by Zachary Shaw on 03/26/06 05:51 AM

I'm currently trying to set up a remote oracle installation and in a bit of a time crunch.

there's reference to http://openacs.org/new-file-storage/one-file?file_id=273
all over the place but the doc doesn't exist.

Can someone send it to me or repost it?

2: Re: remote Oracle installation (response to 1)

Posted by Andrew Piskorski on 03/28/06 01:35 AM

Why do you want this mysterious missing file in the first place? Using a remote Oracle instance from AOLserver is no problem, all you should need to do is:

On the Oracle server, make sure that $ORACLE_HOME/network/admin/listener.ora is configured correctly, that the Listener is running, etc.
On the machine where AOLserver is running, make sure $ORACLE_HOME/network/admin/tnsnames.ora is configured correctly. Use tnsping and sqlplus to verify this.
In your AOLserver config file, set your "ns_param datasource OID.NAME" line to match the name of the Oracle instance in tnsnames.ora.

3: Re: Re: remote Oracle installation (response to 2)

Posted by Zachary Shaw on 03/28/06 06:07 PM

I was looking for it because documentation on setting it up seemed fairly light and the "mysterious missing file" is the doc is referenced at http://openacs.org/doc/current/oracle.html . "For more details on a remote Oracle installation, see Daryl Biberdorf's document."

I've gotten it set up and working in our dev env, but I'm now having an issue in our prod env.

When we're using the remote oracle instance, it keeps bringing down our server... intermitantly. I move it back to a local install and everything seems fine. I'm looking for differences in our config files, but nothings jumping out at me.

Have you ever had this experiance?

4: Re: remote Oracle installation (response to 3)

Posted by Andrew Piskorski on 03/29/06 01:15 PM

What precisely do you mean by, "bringing down our server"?

5: Re: Re: remote Oracle installation (response to 4)

Posted by Zachary Shaw on 03/29/06 06:25 PM

We turned out to be experiancing exactly the same behavior (and very similar set up) to the user who posted on "Selecting an empty (null) oracle-clob crashes AOLserver on Linux" http://openacs.org/forums/message-view?message%5fid=141431

We upgraded our nsoracle driver from 2.6 to 2.7 and it seems to have solved the issue.