December 2020 archive

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

Playing with new Oracle Database 21c in your VirtualBox

Last week Oracle released the newest Oracle Database 21c. This is an Innovation release (not long term like 19c) that introduces many cool new features, including also the 20c new features which DB release didn't happen: Oracle is mindful of the unprecedented economic and business disruption our customers faced in 2020. We decided to not …

Continue reading