Patch Oracle before DBCA, Can We ?
Yes, the answer is positive. Usually, we patch Oracle home with one or more existing databases for routine software updates. However, for a new database… Read More »Patch Oracle before DBCA, Can We ?
DBA_REGISTRY_SQLPATCH
How to Patch Oracle Database 19c on Linux (DBRU 19.18)
Here are steps to apply Database Release Update (DBRU) 19.18 (REL-JAN230131, 34765931) to Oracle database 19c (19.3) on Linux. Upload Patches Update Opatch utility Backup… Read More »How to Patch Oracle Database 19c on Linux (DBRU 19.18)
How to Resolve ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted
ORA-65144 Tried to remove restricted mode from a newly cloned PDB, but it failed with ORA-65144. SQL> show pdbs CON_ID CON_NAME … Read More »How to Resolve ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted
How to Patch Oracle Database 19c on Windows (DBRU 19.14)
After installing Oracle Database 19c on Windows, we may need to upgrade the database regularly. Assuming that you have done the following items: OPatch utility… Read More »How to Patch Oracle Database 19c on Windows (DBRU 19.14)
Prefix DBA, ALL, USER Mix & Match
Scopes of Data Dictionary Views There're 3 different scopes of data dictionary views, DBA, ALL and USER. You may think all dictionary views always have… Read More »Prefix DBA, ALL, USER Mix & Match
How to Check Oracle Version
Database Version Sometimes, you would like to determine what release of Oracle database you are operating on in order to take some other action you… Read More »How to Check Oracle Version
How to Patch Grid and Oracle Home 12c (PSU 32917447)
In this post, I want to patch PSU 32917447 on grid and oracle home 12.1.0.2. Since I have talked about patching Grid and RAC database… Read More »How to Patch Grid and Oracle Home 12c (PSU 32917447)
DBA_TEMP_FREE_SPACE Might be Incorrect in Multitenant Environment
I consistently get the wrong figures about free space of temporary tablespace in database tools, so I made a research. First of all, it's a… Read More »DBA_TEMP_FREE_SPACE Might be Incorrect in Multitenant Environment
How to Patch Oracle Database 19c on Linux (DBRU 19.9)
Here are steps to apply Database Release Update (DBRU) 19.9 (p31771877) on Oracle database 19.3. Upload Patches Update Opatch utility Backup Oracle Home Apply Release… Read More »How to Patch Oracle Database 19c on Linux (DBRU 19.9)
How to Patch Grid and Oracle Home 12c
To patch a Grid infrastructure including Oracle home, we need to download the correct patch from My Oracle Support (MOS) for your current version of… Read More »How to Patch Grid and Oracle Home 12c