Author Archives: Markus Flechtner

Oracle Database 18c, Standard Edition 2 & ORA-38153

When creating a new Oracle 18c database (Standard Edition 2) with dbca (custom database), I noticed lots of messages in the alert.log file: Errors in file /u00/app/oracle/diag/rdbms/sn18/SN18/trace/SN18_j002_20332.trc: ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SQ_SQL_SW_36″ ORA-38153: Software edition is incompatible … Continue reading

Posted in Oracle 18c | Comments Off on Oracle Database 18c, Standard Edition 2 & ORA-38153

Oracle Critical Patch Updates – some statistics

In January I started some posts on the Oracle Critical Patch Updates (CPU) on my German blog (www.markusdba.de). Here’s the translated version of my July post: In January 2018 I started publishing some statistics and graphics about Oracle’s Critical Patch … Continue reading

Posted in Common | Tagged , , | Comments Off on Oracle Critical Patch Updates – some statistics

Oracle Multitenant – SYS*-privileges on PDB level

In an Oracle Container Database, SYSDBA, SYSDG, SYSBACKUP etc. privileges can be granted on PDB level. This enables PDB administrators with their local users e.g. to open and to close a PDB. How does this work and where is this … Continue reading

Posted in Multitenant, Oracle 12c | Comments Off on Oracle Multitenant – SYS*-privileges on PDB level

Back home from nlOUG Tech Experience 2018 at the Rijtuigenloods/Amersfoort

Almost one week ago, I attended the conference of the Dutch Oracle User Group (nlOUG), “nloug Tech Experience 2018”. It was another great experience, once again, thanks to nlOUG for the chance of being part of it. I had two … Continue reading

Posted in Common | Tagged , | Comments Off on Back home from nlOUG Tech Experience 2018 at the Rijtuigenloods/Amersfoort

#c18lv: Presentation “Taming the PDB”

Today I had a second presentation at COLLABORATE18 on another feature of the Multitenant Databases: Resource management and lockdown profiles. Thanks to everyone who attended the session. Here you can find: the presentation: 2018_1226_flechtner_taming_the_pdb a demo on lockdown profiles: lockdowndemo a demo … Continue reading

Posted in Common, Multitenant | Comments Off on #c18lv: Presentation “Taming the PDB”