Hi all,
Remember my emergency a few weeks ago where we moved an nsd 2.3.3 site onto
Redhat 7.2 and it blew up on me? We did a hasty upgrade to nsd 3.3+ad13 and
it's running much better now, with one glaring exception - over time,
connections to Oracle start dying:
oracle 674 670 1 11:29
> The Oracle driver is version 2.6, according to it's
> version.h.
Janine,
Don't know if this is very helpful, but we do not see this behavior.
Our site doesn't do many LOBs or large files though.
What version of the Oracle client and server are you on?
--
C. R. Oldham, Director of Technology
On 4/23/02 12:19 PM, "C. R. Oldham" <[EMAIL PROTECTED]> wrote:
> What version of the Oracle client and server are you on?
Good point, CR, that would be useful info wouldn't it! The Oracle version
is 8.1.7.3 (the .3 coming from an Oracle patchset).
janine
--
Janine Sisk
President/CEO
furfly.ne
> Good point, CR, that would be useful info wouldn't it! The
> Oracle version is 8.1.7.3 (the .3 coming from an Oracle patchset).
Data point--probably not very helpful. Our production Oracle install is
8.1.6.2, but we have a dev box running 8.1.7.2. Neither show any
defunct processes. All our
From: Janine Sisk [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 11:14 AM
To: [EMAIL PROTECTED]
Subject: [AOLSERVER] Oracle connections going defunct
Hi all,
Remember my emergency a few weeks ago where we moved an nsd 2.3.3 site onto
Redhat 7.2 and it blew up on me? We did a hasty upgra
]]
> Sent: Tuesday, April 23, 2002 11:14 AM
> To: [EMAIL PROTECTED]
> Subject: [AOLSERVER] Oracle connections going defunct
>
>
> Hi all,
>
> Remember my emergency a few weeks ago where we moved an nsd 2.3.3 site onto
> Redhat 7.2 and it blew up on me? We did a hasty upg
> CR, just wondering, why do you use MTS? Any particular reason?
Back when we had named user licenses for Oracle another app we had (IIS
based) had a tendency to suck up all our allowable licenses. So we
configured MTS to allow more "users" on the IIS system to login.
We just left it in place,
On Tue, Apr 23, 2002 at 09:26:14AM -0700, C. R. Oldham wrote:
> Data point--probably not very helpful. Our production Oracle install is
> 8.1.6.2, but we have a dev box running 8.1.7.2. Neither show any
> defunct processes. All our aolservers connect over Net8/tcp and use
> MTS.
CR, just wond
+-- On Apr 23, Barry Books said:
> I have not run on Linux in a while but when I did I remember having to set
> the database handle timeout to a very large number otherwise I had this
> problem. I think there is a bug in the database driver on Linux since I
> don't have this problem on Sol
> CR, just wondering, why do you use MTS? Any particular reason?
I just recalled, too, that I think InterMedia needs it for some
reason...
--
C. R. Oldham, Director of Technology
NCA CASI
Arizona State University
[EMAIL PROTECTED]
V:480-965-8703 F:480-965-9423
On 4/23/02 1:30 PM, "Rob Mayoff" <[EMAIL PROTECTED]> wrote:
> Janine, I assume you've looked in your bdump, cdump, and udump
> directories for evidence.
Yep - nothing whatsoever of interest.
> Is the defunct process a child of nsd?
Yes, it is. There are only a couple of defuncts right now (I'
Well... I concluded that I was not using BEQUEATH because I looked at
listener.ora, sqlnet.ora and tnsnames.ora and saw only "PROTOCOL = TCP" and
"PROTOCOL = IPC". But I just noticed that when I do a ps, I see
oracle8429 8404 2 14:46 ?00:00:07 oracle
(DESCRIPTION=(LOCAL=YES)(ADDRES
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).
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 u
+-- On Apr 25, Janine Sisk said:
> Well... I concluded that I was not using BEQUEATH because I looked at
> listener.ora, sqlnet.ora and tnsnames.ora and saw only "PROTOCOL = TCP" and
> "PROTOCOL = IPC". But I just noticed that when I do a ps, I see
You need to set your datasource properl
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
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 OR
17 matches
Mail list logo