I can now report that we still see no defunct processes, so this seems to
have fixed the problem. Many thanks to all!
janine
On 4/25/02 5:33 PM, "Janine Sisk" <[EMAIL PROTECTED]> wrote:
> 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
>
--
Janine Sisk
President/CEO
furfly.net, LLC
Mont Vernon, NH
Phone: 603-672-1122
