Now this is interesting. I actually messed up following Andrew's
directions; I set DataSource to my ORACLE_SID, which is the name I usually
use for my datasource. In this case, however, Oracle named it INST1_HTTP
(??). Things are working, either because it knows it's the SID or because
the SID and hostname are the same, I'm not sure which.
The odd part is that although ps still shows that we're using the Bequeath
adapter, I'm not seeing any defunct threads. That might change tomorrow
when the site is busier but I'd expect to be seeing some already. I don't
quite understand the change I made, but what the heck... if it works, I'll
be happy! :)
janine
On 4/25/02 3:23 PM, "Janine Sisk" <[EMAIL PROTECTED]> wrote:
> Now we're getting somewhere! I made that change, now let's see if the
> defunct processes come back.
>
> Thanks, Andrew!
>
> janine
>
> On 4/25/02 3:08 PM, "Andrew Piskorski" <[EMAIL PROTECTED]> wrote:
>
>> On Thu, Apr 25, 2002 at 02:55:55PM -0400, Janine Sisk wrote:
>>
>>> Clearly, it appears that I might be using the BEQUEATH adapter after all. I
>>> did some research in the docs but couldn't find anything which explained how
>>> to choose one over the other (I'm sure it's there, I just couldn't find it).
>>> Should I simply add "bequeath_detach = yes" to sqlnet.ora, as Rob has
>>> suggested in the past, or is there more to it?
>>
>> Mark Dalrymple explained the secret to me some months ago. In your
>> nsd.tcl, if you do:
>>
>> ns_param DataSource {}
>>
>> your AOLserver will use Bequeath to connect to the Oracle on the local
>> box. To connect via e.g. TCP/IP, you instead want:
>>
>> ns_param DataSource {ora8}
>>
>> with your 'ora8' datasource configured to use TCP/IP (rather than
>> IPC).
>>
>> FYI, I'm using Bequeath right now with AOLserver 3.3+ad13 and Oracle
>> 8.1.7 on Solaris (SunOS 5.8), and it seems to work fine.
>>
>> --
>> Andrew Piskorski <[EMAIL PROTECTED]>
>> http://www.piskorski.com
>>
>
> --
> Janine Sisk
> President/CEO
> furfly.net, LLC
> Mont Vernon, NH
> Phone: 603-672-1122
>
--
Janine Sisk
President/CEO
furfly.net, LLC
Mont Vernon, NH
Phone: 603-672-1122
