How to Install Oracle Database 19.18 on Linux
In this post, we'd like to directly install Oracle database 19.18 in a new database server. If you were looking for a procedure to patch… Read More »How to Install Oracle Database 19.18 on Linux
Database Release Update (DBRU)
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 ?
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 Patch Oracle Database 19c on Solaris (DBRU 19.17)
Here are steps to apply Database Release Update (DBRU) 19.17 (p34419443) on Oracle database 19.3 on Solaris. Upload Patches Update Opatch utility Backup Oracle Home… Read More »How to Patch Oracle Database 19c on Solaris (DBRU 19.17)
How to Resolve "Warning: PDB altered with errors."
Warning: PDB altered with errors Tried to open a newly cloned or created PDB, but it failed with "Warning: PDB altered with errors". SQL> alter… Read More »How to Resolve "Warning: PDB altered with errors."
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
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
Connect to PDB as SYSDBA by ORACLE_PDB_SID
Connect as SYSDBA We usually connect to the database by / as SYSDBA without providing any password for maintenance works, such as startup, shutdown and… Read More »Connect to PDB as SYSDBA by ORACLE_PDB_SID
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 Oracle Check OUI Version
In order to select and download the correct and latest release of OPatch, you have to know the current Oracle Universal Installer (OUI) version first.… Read More »How Oracle Check OUI Version