Re: Oracle*Net connection problem

BTW, the problem is easy to reproduce from the command line.

Just to tnsping several times from the command line in rapid succesion.

I've seen it fail every other time with an ORA-12154 when using ONAMES.

Jared


On 3/19/07, William Wagman <wjwagman@xxxxxxxxxxx> wrote:

 Jared,

Thanks for the reference. I've passed it off to the vendor to see if this
is one of the things they were aware of or looked at when they were doing
their diagnosis. I'm curious to see what they say.

Thanks.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208


 ------------------------------
*From:* Jared Still [mailto:jkstill@xxxxxxxxx]
*Sent:* Monday, March 19, 2007 9:47 AM
*To:* William Wagman
*Cc:* oracle-l
*Subject:* Re: Oracle*Net connection problem

See ML note *274518.1.*

I'm glad you asked.  It seems there is a parameter in 9.2.0.6 that may
fix this issue.  That information did not appear when we ran into it.

I believe that the issue was actually the ORA-12154 as stated in the note,
and not
the ORA-3113 that this thread is concerned with.

Jared

On 3/14/07, William Wagman <wjwagman@xxxxxxxxxxx> wrote:
>
>  Greetings,
>
> This is interesting. We have an application that uses .NET and we were
> noticing performance degradation using ONAMES. The vendor indicated that
> .NET performs much better with TNSNAMES as opposed to ONAMES. Do you have
> more information about this particular bug?
>
> Thanks.
>
>
> Bill Wagman
> Univ. of California at Davis
> IET Campus Data Center
> wjwagman@xxxxxxxxxxx
> (530) 754-6208
>
>
>  ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Jared Still
> *Sent:* Wednesday, March 14, 2007 1:56 PM
> *To:* mgogala@xxxxxxxxxxx
> *Cc:* oracle-l
> *Subject:* Re: Oracle*Net connection problem
>
>  Hi Mladen,
>
> Is Oracle Names in the mix?
>
> I don't know about 9.2.0.8, but with 9.2.0.6 it has
> been necessary to use a local tnsnames.ora file
> here when the client is Java and/or .Net.
>
> These tend to make a number of connections to
> the database, and a bug in the 9.2 client causes
> name resolution to periodically fail.
>
> Jared
>
>
> On 3/14/07, Mladen Gogala <mgogala@xxxxxxxxxxx> wrote:
> >
> > I have a strange problem: 10.x clients intermittently break the
> > connection with Oracle 9i (9.2.0.8). The error
> > I get is 3113 but there is no accompanying error on the 9.2 server
> > side.
> > I am unable to find any bug filed
> > about that. Has anybody else seen things like that? Unexplicable 3113
> > errors without a trace on the server
> > side? It happens only when different major versions of the database
> > are
> > involved.
> >
> > --
> > Mladen Gogala
> > Sr. Oracle DBA
> > Video Monitoring Systems
> > 1500 Broadway
> > New York City, NY 10036
> > Phone: (212) 329-5201
> > Email: mgogala@xxxxxxxxxxx
> >
> >
> >
> >
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>



--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist




--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: