RE: How to determine if a relink is necessary?

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: "Ethan Post" <post.ethan@xxxxxxxxx>
  • Date: Wed, 19 Nov 2008 12:19:25 -0500

Yup, sounded like a DUHvelepor problem all along!!  Enjoy.
 

Dick Goulet 
Senior Oracle DBA 
PAREXEL International 
978.313.3426 
 information transmitted in this communication is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information
by persons or entities other than the intended recipient is prohibited.
If you received this in error, please destroy any copies, contact the
sender and delete the material from any computer.


 

________________________________

From: Ethan Post [mailto:post.ethan@xxxxxxxxx] 
Sent: Wednesday, November 19, 2008 12:15 PM
To: Goulet, Richard
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: How to determine if a relink is necessary?


The error is period/random, does not occur every time.

OCI0000178 - Unable to execute - SQL STATEMENT HERE...

OCI0000179 - Error - ORA-03120: two-task conversion routine: integer
overflow

The SQL is using binds. My guess is that the client side is putting
together a variable like 99999 and in the course of passing it off to
Oracle it is coming across as 99999.000000000000000000 or something, or
perhaps it is somehow coming back to the client like that. I saw this
with Powerbuilder when we went to 10G, Oracle could no longer recognize
a CHR(1) coming from Oracle and changed everything to CHR(2000), when
this came back to the client and then was used in another call to Oracle
the call would fail becuase of 999 padded blanks. In our case I believe
we had to update the Powerbuilder client version which was compatible
with 10G dlls.

-- update --

Just got off call with app guy, more issues coming up, looks like some
OS patches might be missing and also that the binaries were copied to
this server rather than actually installed. He is going to chase that
down for a while.

Thanks for your help.



On Wed, Nov 19, 2008 at 8:59 AM, Goulet, Richard
<Richard.Goulet@xxxxxxxxxxx> wrote:


        Ethan,
         
            First off, what crashes, the app or the database.  If it's
the app then that should be relinked if the database then there is where
a relink should be done.  But first off, what are the Oracle errors that
the app is receiving?  You can be having an overflow of a double coming
from the database into an integer in the app.  Has happen to me in the
past, and that's not a DBA problem.


Other related posts: