G
Guest
The database team just patched the Oracle database with the latest and
greatest security patch. Since they patched it, my application has not been
stable. My application uses ODP 10.1.0.4 and C#. The majority of the database
calls are in stored procedures. The error that is thrown by Oracle is
"ORA-6550: line 0, column 0
LS:00907: cannot load library unit PKG_PRODUCT
(referenced by )" along with "ORA-04068: existing state of packages has been
discarded" though the packages have not been changed in serveral months. We
have tried recompiling them just in case. The application has worked till the
patch was applied. The database team rolled back the patch, but the
application is still having problems. Bouncing the instances of the database
does bring us back up, but only temporarily. The periods of us being up have
ranged from 5 minutes to 6 hours. The average is about 2.5 to 3 hours, but we
are getting worse. I'm in the process of upgrading to ODP 10.2.0.2.21, but am
not convinced that this will correct the problem and am afraid that it may
make things worse. We have a tar open with Oracle, but they have not yet
responded. None of the other applications that do not user the ODP are having
problems (they are java), but my application is a lot more database reliant.
I created a test application that uses a stored procedure and inline SQL and
the SQL queries do work even when the stored procedures do not. We are
getting very frustrated as are our users. Any ideas?
greatest security patch. Since they patched it, my application has not been
stable. My application uses ODP 10.1.0.4 and C#. The majority of the database
calls are in stored procedures. The error that is thrown by Oracle is
"ORA-6550: line 0, column 0
LS:00907: cannot load library unit PKG_PRODUCT(referenced by )" along with "ORA-04068: existing state of packages has been
discarded" though the packages have not been changed in serveral months. We
have tried recompiling them just in case. The application has worked till the
patch was applied. The database team rolled back the patch, but the
application is still having problems. Bouncing the instances of the database
does bring us back up, but only temporarily. The periods of us being up have
ranged from 5 minutes to 6 hours. The average is about 2.5 to 3 hours, but we
are getting worse. I'm in the process of upgrading to ODP 10.2.0.2.21, but am
not convinced that this will correct the problem and am afraid that it may
make things worse. We have a tar open with Oracle, but they have not yet
responded. None of the other applications that do not user the ODP are having
problems (they are java), but my application is a lot more database reliant.
I created a test application that uses a stored procedure and inline SQL and
the SQL queries do work even when the stored procedures do not. We are
getting very frustrated as are our users. Any ideas?