Oracle Database 12c: Fix the EM DB Express issue for Linux-64 Multitenant Setup

Symptom:

1. Resources and SQL Monitor can not load in Enterprise Manager

2. Following errors flooding the database alert log:

2013-12-02 11:27:11.511000 +08:00
found dead shared server 'S000', pid = (20, 6)
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5] [PC:0xB71F161, qervwRowProcedure()+113] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/cdborcl/cdborcl/trace/cdborcl_s000_3664.trc  (incident=9765):
ORA-07445: exception encountered: core dump [qervwRowProcedure()+113] [SIGSEGV] [ADDR:0x5] [PC:0xB71F161] [Address not mapped to object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

 

Solution:

1. Apply patch PSU Oct2013 for 12.1.0.1 (17027522) Refer to: http://www.dbaglobe.com/2013/12/oracle-database-12cinstalling-psu-in.html

2. Apply bug fix 16527374. Refer to http://www.dbaglobe.com/2013/12/oracle-database-12capply-online-patch.html