[10g] OALL8이 불일치 상태입니다. 에러

/********************************************************************************************
-- Title : [10g] OALL8이 불일치 상태입니다. 에러
-- Reference : ubermensch.tistory.com
-- Key word : 버그 bug oall8
********************************************************************************************/

Bug 4962360
When an Enterprise Manager repository is hosted on a 10.2.0.2.0 database, OMS connections to the repository are sometimes aborted with the following error message:
SQLException java.sql.SQLException: OALL8 is in an inconsistent state.
See Bug 4961570 for once such instance while managing Collabsuite targets.
Cause:
This is caused by RDBMS Bug 5033488 - ORA-07445: exception encountered: core dump kokmrwo()+86.
Workaround:
Log on to the repository as sysdba and execute the following command:
SQL> alter system set "_optimizer_connect_by_cost_based" = false;
Solution
If the problem persists call Oracle Support.

Bug 5028782
Suspending a job fails with "OALL8 is in an inconsistent state is logged in the emoms.log file." or if Patching Job fails with an initialization error "OALL8 is in an inconsistent state is logged in the emoms.
log file.
"Cause:This is caused by RDBMS Bug 5033488 - ORA-07445: exception encountered: core dump kokmrwo()+86.
Related Bug:4961570
Workaround:Log on to the repository as sysdba and execute the following:
SQL> alter system set "_optimizer_connect_by_cost_based" = false;
Solution:
If the problem persists contact Oracle Support.

Bug 4961570
If Enterprise Manager repository is hosted on a 10.2.0.2 RDBMS and you use Enterprise Manager to manage Collabsuite targets, you could encounter the following bug. Enterprise Manager console reports an internal system error while creating an IM service:
SQLException java.sql.SQLException: OALL8 is in an inconsistent state is logged in the emoms.log file.
Cause:
This is caused by RDBMS Bug 5033488 - ORA-07445: exception encountered: core dump kokmrwo()+86.
Workaround:
Log on to the repository as sysdba and execute the following:
SQL> alter system set "_optimizer_connect_by_cost_based" = false;
Solution:
If the problem persists contact Oracle Support.
Solaris Issues
This section lists all the issues relating to Solaris OS.
Oracle Collaboration Suite Management
This section lists all the issues relating to Oracle Collaboration Suite for Solaris OS.