RE: How to determine if a relink is necessary?

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Wed, 19 Nov 2008 12:19:25 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F200AA684@US-BOS-MX011.na.pxl.int>

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_at_gmail.com] Sent: Wednesday, November 19, 2008 12:15 PM To: Goulet, Richard
Cc: oracle-l_at_freelists.org
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_at_parexel.com> 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.

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

Received on Wed Nov 19 2008 - 11:19:25 CST