Forum OpenACS Q&A: Re: postgres connection (to maxopen or not)

Collapse
3: Re: postgres connection (to maxopen or not) (response to 1)
Posted by Sudeep Sakhi on 04/04/03 07:42 AM
Hello Chris,

I want to install Aolserver on redHat machine and Oracle 9i on Windows machine. Can u guide me what all should I write in the bash profile of nsadmin user(user installing aolserver) about the ORACLE ENV variables like ORACLE_HOME etc.

Also what are the other changes that need to be done to run Aolserver with a remote databse?

Thanks.
Sudeep.

Collapse
4: AOLserver connect to remote Oracle (response to 3)
Posted by Andrew Piskorski on 04/05/03 11:30 PM
Sudeep, running Oracle on Windows like that is a rather bizarre Oracle setup. However, the fact that the remote Oracle happens to be on a Windows machine should make no difference on the AOLserver side, the configuration is the same as running Oracle on a remote Linux or Solaris box, which is a common configuration for larger OpenACS sites.

I've never done it, but my understanding is you will need to install the Oracle client libraries on the Linux box running AOLserver. Use TCP/IP connection in AOLserver rather than Beqeath - just make sure that ns_param DataSource has the Oracle instance name you defined in the Oracle Listener (e.g., ora8@ora8). Empty string for ns_param DataSource means use Bequeath, and you don't want that. Something like that. (Some of my Oracle terminology probably isn't quite right.)