Update! - Unexpected Behaviour With V$DIAG_ALERT_EXT

Oops! Errormessages from a Test database in my Production-DB?!? Story behind: I wanted to know which "ORA-" Errors have occured in my Production-DB and issued a select   to_char(originating_timestamp,'DD.MM.YYYYHH24:MI:SS')   ,message_text from v$diag_alert_ext where message_text like '%ORA-%' and originating_timestamp > sysdate-31 order by originating_timestamp; to...

Read More

REASON FOUND: DBID Problem @ ODA

Hi There! in my blogpost "http://robertcrames.blogspot.com/2018/10/oda-bug-and-poor-support-from-oracle.html" I described a problem with the impossibility of creating databases as a result of an incredebly long DBID and the 'poor' oracle support in that specific case. Well - I contacted Oracle support and had a call with the Support Manager and then ... it worked smoothly 😏. Provided a few more...

Read More

DBID Problem @ ODA ... Bug (?)

long story told short:  Oracle Database Appliance X6-2M and X7-2M,  oak 12.1.2.11 up to 12.2.1.4 We were not able to create databases anymore on one of our 15 ODAs. Detailled analysis has shown that the dbid - result from an 'odacli describe-database -i <DB identifier>' - grows and grows and, when it reaches a size of more than 255 characters, any subsequent try to create a database...

Read More