Forum OpenACS Q&A: Re: remote Oracle installation
- On the Oracle server, make sure that
$ORACLE_HOME/network/admin/listener.orais configured correctly, that the Listener is running, etc.
- On the machine where AOLserver is running, make sure
$ORACLE_HOME/network/admin/tnsnames.orais 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.
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?
We upgraded our nsoracle driver from 2.6 to 2.7 and it seems to have solved the issue.