OOW 2018: Upgrade to Oracle 18c – Live and Uncensored

Less than two weeks until the potentially busiest Oracle Open World conference I’ve ever attended. The schedule is filled up already and closed down. And I’m pretty sure I will need time off afterwards to relax and recover. But I’m looking forward to our annual big event in San Francisco. To make it as exciting as possible for you we are very happy to have high profile speakers with us in all our talks. And we promise: No marketing. Just tech facts. If you’d like to sneak into OOW 2018: Upgrade to 18c – Live and uncensored, then mark your…

Ouch … again OCM

Another customer, another upgrade – and again from Oracle Database 11.1.0.7 to Oracle Database 11.2.0.3. And again an OCM error during upgrade which is not very obvious to relate to OCM once you see the errors during upgrade. While monitoring the database during upgrade with tail -f on the alert.log we’ve spotted this one here: ORA-604: error occurred at recursive SQL level 3ORA-904: “XDB”.”DBMS_CSX_INT”.”GUIDTO32″: invalid identifierXDB SGA reset to NULL. Looks like some issue with XDB. But actually it is related to OCM and it seems that something gets created in the wrong order. Currently DEV is working on that…

Upgrade to 11.2.0.3 – OCM: ORA-12012 and ORA-29280

OCM is the Oracle Configuration Manager, a tool to proactively monitor your Oracle environment to provide this information to Oracle Software Support. As OCM is installed by default in many databases but is some sort of independent from the database’s version you won’t expect any issues during or after a database upgrade 😉 But after the upgrade from Oracle 11.1.0.7 to Oracle 11.2.0.3 on Exadata X2-2 one of my customers found the following error in the alert.log every 24 hours: Errors in file /opt/oracle/diag/rdbms/db/trace/db_j001_26027.trc: ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1″ ORA-29280: invalid directory path ORA-06512: at “ORACLE_OCM.MGMT_DB_LL_METRICS”, line…