Windchill 9.1 cannot revise any item ORA-04063

[ptc-113113]

Hi,
If we attempt to revise any object in our test instance, we get the following errors

[rjessen]

Sounds like some of the Oracle packages need to be recompiled. You can identify which ones need to be compiled by connecting to SQLPLUS as the Windchill user and running :-


select object_name, object_type from user_objects where status='INVALID';
This will list invalid packages, for each package you need to run :-

alter package <packagename> compile body
e.g.
alter package EPMWORKSPACEPK compile body

[RajeshBalasunda]

DBA needs to recompile the invalid packages. That's the cause of this
issue. If you need more help on this, let me know.



Best Regards

Rajesh Balasundaram

[scaron1]

Andrew, you need to recompile the package in Oracle, see TAN 128926 attach. This is most likely a re-host test server.



Regards, - Merci,


Serge Caron
Senior Application Engineer, Software PLM Services - Ingénieur d'application sénior, Services informatique PLM
BRT Solutions - Montreal
8268 Boulevard Pie IX, Montréal, Québec, CANADA, H1Z 3T6
TEL. 514.727.7113 / 1.877.399.7113 (EXT.230)
CEL. 514.913.3383
FAX. 514.727.2600
SCaron@brt-solutions.com <">mailto:SCaron@brt-solutions.com>
www.brt-solutions.com

[ptc-113113]

All the responses are saying the same thing
A DBA needs to recompile packages in the database, since this instance was rehosted (i.e.cloned) from an original instance.

Thanks all!!

Andrew

[achukwuka]

Andrew,

Yes, the packages need tobe recompiled. Something after a rehost, some packages becomes invalid and needs to be recompiled.

Thanks



Alexius C. Chukwuka
IT Analyst, PDP Systems
John Deere Power Systems
Product Engineering Center
*Voice: 319-292-8575
*Mobile: 319-429-5336
*FaxFax:319-292-6282
*E-Mail: -

CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail.