Objects missing or don't display correctly in the Applications Manager v9 client using Oracle12c DB

Document ID : KB000089570
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Objects missing or don't display correctly in the Applications Manager v9 client using Oracle12c DB
Resolution:

Symptoms

We have found an issue with Applications Manager v9 where objects in the UI (jobs, logins, etc) do not display or are missing data when using a 12c database. This issue seems to occur more frequently on Windows operating systems, however has also been encountered on UNIX. It occurs after a period of time (creating more and more objects) and appears to be a data inconsistency between the tables and the indexes.  We have opened a ticket with Oracle support and they are currently investigating the cause of this issue. However, in the meantime, Oracle has provided a temporary workaround of setting optimizer_features_enable to 11.2.0.3 (see below). We will provide an update when we receive more information from Oracle as to the exact cause and solution.


Workaround

You can set optimizer_features_enable either at the system level (will affect the entire database) or at the individual AM user session level. Instructions for both options are included below. Consult your DBA to see which option is best for you.

Option 1 - AM User Session Level:
1.  Log in as the AM Oracle user
2.  Run the following sql to insert a record into the aw_master_stmts table.

SQL> insert into aw_master_stmts values('alter session set optimizer_features_enable=''11.2.0.3''',4);
SQL> commit;
3.  Stop/start the processes for your Master Server (stopso all/startso all).

The optimizer entry will be read from the table and AM will establish connections to oracle with the new session setting. This option will only change the optimization for the AM user (no other database accounts).

Option 2 - System Level:    
1. Run the following sql as the SYS or SYSTEM user:                         
SQL> alter system set optimizer_features_enable='11.2.0.3';
Note: A system change will affect all users/applications in this database.


Resolution

We received confirmation that this is an Oracle bug, resolved in 12.1.0.2.  This was resolved in unpublished bug 18618049.  If you run into this issue, we recommend you contact Oracle and / or upgrade to the latest patch set (12.1.0.2 or above).