Task #515
KFHIB Oracle DB Production
Status: | Work Completed-End life cycle | Start date: | October 09, 2010 | |
---|---|---|---|---|
Priority: | High | Due date: | October 10, 2010 | |
Assignee: | Ahmad Hazri | % Done: | 100% | |
Category: | - | Estimated time: | 3.00 hours | |
Target version: | - | Spent time: | 3.00 hours |
Description
Oracle DB Production
Target date: 09/10/2010 (During DR live since Prod on freeze)
History
#1 Updated by Ahmad Hazri almost 14 years ago
- File kfhib07_oraDB_vers_upgrade.gif added
- Status changed from New - Begin Life Cycle to Work Completed-End life cycle
- % Done changed from 10 to 100
Oracle DB upgrade successfully
issue:
Unable to drop user (for import/restore Db process) and some minor issue
SQL> drop user esbprd cascade; drop user esbprd cascade * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS ORA-04064: not executed, invalidated ORA-04064: not executed, invalidated package body "LBACSYS.LBAC_EVENTS" ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS" ORA-06512: at line 2 ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS" ORA-06512: at line 2
Solution/Workaround
shutdown immediate; startup migrate; alter view lbacsys.lbac$all_table_policies compile; alter package lbacsys.lbac_events compile body; shutdown immediate; startup;