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 …
dez 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 …
dez 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 …
dez 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 …
out 28
Oracle October 2020 Critical Patch Advisory - PL/SQL detailed changes
Oracle October 2020 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 201020 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 11.2.0.4 SYS.DBMS_PDB - PACKAGE BODY 11g (BP) 12.1.0.2 DVSYS.DBMS_MACADM - PACKAGE BODY 12cR1 (PSU) …