Cause : create_pipes failed due to ORA-06550: line 1, column 19: PLS-00302: component 'CREATE_PIPES' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored. Solution : 1. Shutdown the CM and Application cleanly. 2. Shutdown the database. 3. Start the database and listener if it’s down. 4. Run Autoconfig in database tier and check it’s completing normal or not. 5. Run CMCLEAN.sql 6. Run Autoconfig in apps tier. 7. Through adadmin, please do the below. a. Generate Product JAR files b. Generate message files c. Relink Application programs. (You may face the warning ld: warning: symbol `ui10144' has differing sizes, which we can ignore.) 8. Start the Application and check, still you get the same error.
Yet another blog for dba's. Shared my work experience here. Hope it will be useful for you guys all.