Fatal Error ORA-20000 INITIAL_INSTALL PROCEDURE INVALID

Document ID : KB000090138
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Fatal Error ORA-20000 INITIAL_INSTALL PROCEDURE INVALID
Resolution:
Detailed Description and Symptoms

Awinstall fails with the following error:


Starting at 10/08/11 08:30:02 script aw_post_checks
Finished at 10/08/11 08:30:05 Elapsed Time 00:00:03 script aw_post_checks
prompt 4 Fatal error(s) trying to execute script aw_post_checks
 
Fatal Error ORA-20000 INITIAL_INSTALL PROCEDURE INVALID
Fatal Error ORA-20000: Invalid objects
Fatal Error ORA-06512: at "APPWORX.CHECK_OBJECTS", line 16
Fatal Error ORA-06512: at line 1
4 Fatal error(s) trying to execute script aw_post_checks
Fatal Error occurred - check the log D:\AWPROD7\install\aw_install.log
set_path=D:\AWP


Investigation

Log into the Application Manager database as the AM user and run the following:

SQL>select OBJECT_NAME, OBJECT_TYPE, STATUS from user_objects where STATUS  <> 'VALID';

If the SQL statement returns rows, this indicates there are invalid objects in the AM repository.

Solution

?To recompile all AM DB objects: 

1) execute sosite to set the environment

 

2) execute awinstall to run the setup routines
3) check the system settings and set the database setup to reach main menu
4) in main menu call function 04 (Setups)
5) in setup menu call function 05 (Recompile invalid Objects)
6) then go back to main menu (7)
After this we check if the objects are recompiled:
7) in main menu call function 03 (Data Checks)
8.) finally call 02 for check for invalid objects

* As the intial run of awinstall failed it will need to be re-ran to complete