Forum OpenACS Q&A: Re: database and aolserver on different machines - how to configure nsd.tcl

Thanks Bruno,

Im using Oracle8i but I'm not convinced that specifying only SID will be enough since only SID is what I enter for a local db. Shouldn't there be also an entry for the remote host name and port where this SID is located?

Like Barry said, your instance should be configured to know what SID goes where ... For more information on tnsnames.ora have a look at the oracle documentation.

Hi Jay,
AOLserver will use Oracle Networking to connect to the database in the exact same way as SQL*Plus. If, from the AOLserver machine, you can do a tnsping SID or sqlplus user/pass@SID, then you can be confident that AOLserver will connect to the database. All you need then do is enter the SID for the datasource parameter.

If you can't do a tnsping or SQL*Plus won't connect, then you've got an Oracle networking problem.

best wishes
Brian