RE: Oracle*Net connection problem

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_at_ucdavis.edu
(530) 754-6208  

From: Jared Still [mailto:jkstill_at_gmail.com] 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_at_ucdavis.edu> 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_at_ucdavis.edu
	(530) 754-6208 

	 



________________________________


	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
	Sent: Wednesday, March 14, 2007 1:56 PM
	To: mgogala_at_vmsinfo.com
	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_at_vmsinfo.com> 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_at_vmsinfo.com 
		
		
		
		




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

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


--
http://www.freelists.org/webpage/oracle-l