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 …
December 2020 archive
Dec 15
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 …
Dec 14
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 …
Dec 14
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 …
Dec 13
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 …