cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Windchill 9.1 cannot revise any item ORA-04063

ptc-113113
1-Visitor

Windchill 9.1 cannot revise any item ORA-04063

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

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

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
4-Participant
(To:ptc-113113)

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

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

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.


Announcements


Top Tags