Local Undo of PDB for Each RAC Instance
Usually, we have separate undo tablespace for each instance in a RAC database. For example, UNDOTBS1 is for the first instance and UNDOTBS2 is for… Read More »Local Undo of PDB for Each RAC Instance
Database Configuration Assistant (DBCA)
How to Remove MGMT Database
Some DBA may consider to remove MGMT database because of resource consuming. I myself found that MGMT database is error-prone when we apply patches on… Read More »How to Remove MGMT Database
How to Resolve ORA-15173 Error Message
ORA-15173: entry 'pdbseed' does not exist in directory There're two operations that you might see ORA-15173. Creating a Multitenant Database Creating a Pluggable Database ORA-15173… Read More »How to Resolve ORA-15173 Error Message
Complete Oracle 19c Initialization Parameters List in DBCA
The complete list is shown during creating a 19c RAC database by DBCA.
How to Build 19c RAC - 4 of 4 - Creating a RAC Database
After Oracle database 19c software has been installed, we can now create a RAC database by Database Configuration Assistant (DBCA). [oracle@primary01 ~]$ dbca We would… Read More »How to Build 19c RAC - 4 of 4 - Creating a RAC Database
How to Empty an Oracle Database
Empty a Database In my case, a phased out database server is going to transfer to another project team, my job is to remove all… Read More »How to Empty an Oracle Database
How to Install Oracle Database 12.2 on Windows Server
The goal in this post is to install an Oracle database 12.2 on windows server 2012. Here we separate our job into 2 major steps:… Read More »How to Install Oracle Database 12.2 on Windows Server
How to Create a 19c Database by DBCA with Silent Mode
After installing Oracle 19c software only with silent mode, you may like to create a database by Database Configuration Assistant (DBCA) with silent mode, too.… Read More »How to Create a 19c Database by DBCA with Silent Mode
How Oracle 11g Silent Install Software Only
With a Response File First of all, we have prepared a response file for installing Oracle software only as following. Let's see the effective content… Read More »How Oracle 11g Silent Install Software Only
How to Create Database on ACFS
Assuming that you have created a ACFS file system for the database creation. Then you can go on reading this post. Create a Database on… Read More »How to Create Database on ACFS