No more 12.2 Oracle RURs patches after 2021?

As some of you know, every quarter, once Oracle releases it’s Critical Patch Update Advisory, some of us (like myself, Mike Dietrish, Frits Hoogland and some other DBAs around) download some or all the available patches to scan the differences Oracle performed in the database. In my case, I download all the PSUs, BPs, RUs, …

Continue reading

21c Gradual Database Password Rollover brings new backdoor opportunities

Oracle Database 21c introduced the new feature called “Gradual Database Password Rollover”. This allows the database password of the application user to be altered while allowing the older password to remain valid for the time specified by the PASSWORD_ROLLOVER_TIME limit (PROFILE parameter). With this new feature, a password of an application can be changed without having …

Continue reading

Understanding internally how 21c Gradual Database Password Rollover works

Oracle Database 21c introduced the new feature called “Gradual Database Password Rollover“. This allows the database password of the application user to be altered while allowing the older password to remain valid for the time specified by the PASSWORD_ROLLOVER_TIME limit (PROFILE parameter). With this new feature, a password of an application can be changed without having …

Continue reading

How to create your 21c Oracle Database

In the previous article, I showed how you can build a Gold Image of your Oracle Database 21c in DBaaS to play and study the new features in your own VMs (Playing with new Oracle Database 21c in your VirtualBox). Now that you have successfully deployed the binaries, the next step is to create a …

Continue reading

ORA-28427: cannot create, import or restore unencrypted tablespace: USERS in Oracle Cloud

Those days I was trying to create a database using the “CREATE DATABASE” syntax in a IaaS Compute in Oracle Cloud to build a lab for one of my sessions. SQL> CREATE DATABASE db21c USER SYS IDENTIFIED BY Oracle11__ USER SYSTEM IDENTIFIED BY Oracle11__ EXTENT MANAGEMENT LOCAL UNDO TABLESPACE undotbs1 DEFAULT TEMPORARY TABLESPACE tempts1 DEFAULT …

Continue reading