Re: PUBLIC:PLITBLM problem
- From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Tue, 10 Apr 2007 10:05:01 +0300
Hi Nseke,
Sounds to my as bad symptoms I am afraid.
You might try to TAR the issue.
There are some hits in Metalnk already like
bug 5219598, status = Closed, Could Not Reproduce
bug 5280769, status = Suspended, Req'd Info not Avail
I remember one case from my experience then during 9.2 to 10.2 upgrade
process we have run catpatch.sql twice by mistake. This caused the
same type behavior as you describing. Some objects invalidated
spontaneously. The only way to solve this time was to restore 9.2
database and repeat the upgrade.
I would recommend to check upgrade logs for errors and in case of
problems found restore and repeat test environment upgrade.
Please let us know on the progress.
Thank you in advance,
Jurijs
On 4/10/07, aurélien nseke <aurelien.nseke@xxxxxxxxx> wrote:
Hi,
I'm in 11.5.10 CU2
After a database upgrade from 9.2.0.6 to 10.2.3.0 , i have this problem
every morning :
ORA-20001: Oracle error -6508: ORA-04065: not executed, altered or dropped
stored procedure "PUBLIC.PLITBLM" ORA-06508: PL/SQL: could not find program
unit being called: "PUBLIC.PLITBLM" has been detected in
FND_GLOBAL.INITIALIZE. ORA-20001: Oracle error -6508: ORA-04065: not
executed, altered or dropped stored procedure " PUBLIC.PLITBLM" ORA-06508:
PL/SQL: could not find program unit being called: "PUBLIC.PLITBLM" has been
detected in FND_GLOBAL.INITIALIZE.
When i check, i have more than 300 FNDLIBR lines.
after clean this lines and run utlrp.sql, the connection is ok but until the
next day.
How can i resolve this permanently ?Regards.
--
Yury
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Other related posts:
