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

Collapse
3: Re: database and aolserver on different machines - how to configure nsd.tcl (response to 1)
Posted by Jay Dubanik on 07/14/04 08:22 PM
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?

Collapse
5: Re: database and aolserver on different machines - how to configure nsd.tcl (response to 3)
Posted by Bruno Mattarollo on 07/15/04 10:08 AM

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.

Collapse
6: Re: database and aolserver on different machines - how to configure nsd.tcl (response to 5)
Posted by Brian Fenton on 07/15/04 03:55 PM
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