Forum OpenACS Q&A: remote Oracle installation

Collapse
Posted by Zachary Shaw on
I'm currently trying to set up a remote oracle installation and in a bit of a time crunch.

there's reference to https://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?

Collapse
Posted by Andrew Piskorski on
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:
  1. On the Oracle server, make sure that $ORACLE_HOME/network/admin/listener.ora is configured correctly, that the Listener is running, etc.
  2. 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.
  3. In your AOLserver config file, set your "ns_param datasource OID.NAME" line to match the name of the Oracle instance in tnsnames.ora.
Collapse
Posted by Zachary Shaw on
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 https://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?

Collapse
Posted by Andrew Piskorski on
What precisely do you mean by, "bringing down our server"?
Collapse
Posted by Zachary Shaw on
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" https://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.