How to Purge Recycle Bin in Oracle
Since 10g, we have recycle bin that can store dropped tables and indexes. Whenever we need them, we can flashback the dropped tables or indexes… Read More »How to Purge Recycle Bin in Oracle
Oracle Database 18c
How to Start EM Express for PDB
EM Express for PDB During database creation, DBCA enables Enterprise Manager Express (EM Express) for being created CDB, not for PDB globally by default. We… Read More »How to Start EM Express for PDB
How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied
ORA-01045 ORA-01045 means that the user who tried to connect to the database has no privilege to connect. Therefore, the database refused the user to… Read More »How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied
How to Migrate Data from 9i to 12c via DB Link
Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »How to Migrate Data from 9i to 12c via DB Link
How to Build 18c RAC – 4 of 4 – Creating a RAC Database
How to Build 18c RAC - 3 of 4 - Installing Database Software on All Nodes Create a RAC Database Check All Grid Services Make… Read More »How to Build 18c RAC – 4 of 4 – Creating a RAC Database
How to Build 18c RAC - 3 of 4 - Installing Database Software on All Nodes
How to Build 18c RAC - 2 of 4 - Installing Grid Infrastructure Install Database Software Upload and Unzip Source on Node 1 Please note… Read More »How to Build 18c RAC - 3 of 4 - Installing Database Software on All Nodes
How to Build 18c RAC - 2 of 4 - Installing Grid Infrastructure
How to Build 18c RAC - 1 of 4 - Preparing Two Database Servers Suppose that you have prepared servers including two database servers, storage… Read More »How to Build 18c RAC - 2 of 4 - Installing Grid Infrastructure
How to Build 18c RAC - 1 of 4 - Preparing Two Database Servers
For 19c, you may refer to: How to Build 19c RAC - 1 of 4 - Preparing Two Database Servers. Network Design for RAC Let's… Read More »How to Build 18c RAC - 1 of 4 - Preparing Two Database Servers
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
How to Create a ACFS File System on 18c by ASMCA
Normal Way to Create ACFS File System The steps that create ACFS file system by ASMCA can be simplified as such: 1. Use a disk… Read More »How to Create a ACFS File System on 18c by ASMCA