OCM

Welcome aboard at Oracle, Alex Zaballa

Our PM team is slowly growing – and I am so happy about our newest team member. Welcome aboard at Oracle, Alex Zaballa!

Now I think I need to start learning a bit more Portuguese. Rodrigo is located in Brazil, and Alex relocated a while ago to the US but is Brazilian as well. I am really excited to have another super-smart guy in our team helping us with upgrades, (cloud) migrations, patching, Cloud Migration Advisor and CPAT, and other cool things. Personally, I enjoy working with people who have such a deep knowledge …

Continue reading...

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

OOW 2018: Upgrade to 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 …

Continue reading...

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 3
ORA-904: "XDB"."DBMS_CSX_INT"."GUIDTO32": invalid identifier
XDB 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 …

Continue reading...

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", 
Continue reading...