RE: How to determine if a relink is necessary?

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.  

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: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ethan Post Sent: Wednesday, November 19, 2008 9:38 AM To: oracle-l_at_freelists.org
Subject: How to determine if a relink is necessary?

DBA (not my database) says no relink required, it was done on 10G install and patch automatically. 3'rd party bar code App is getting ORAerrors  regarding datatype on insert or update (converts integer to double or something I think and crashes), 10g client has been installed. All sources (vendor, metalink) say relink. App guy wants to relink but DBA says no way. What to do, is there a way to determine if a relink is required? As far as I know a relink won't hurt and may fix a **CRITICAL** app problem, I don't understand why the DBA refuses to do this, anybody sympathize with him? Me thinks the customer thinks we have our heads where it don't shine. Not my account so not much I can do other than advise the app guy.

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