Oracle Database 12c

How to Patch Grid and Oracle Home 12c (PSU 32917447)

by Ed Chen
August 4, 2021September 9, 2021
2 Comments

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 Oracle Purge RecycleBin

by Ed Chen
November 21, 2020August 25, 2021

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 Migrate Data from 9i to 12c via DB Link

by Ed Chen
November 16, 2019March 26, 2020

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 Install Oracle Database 12.2 on Windows Server

by Ed Chen
October 23, 2019October 28, 2020

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 Create an ACFS File System

by Ed Chen
October 26, 2018August 30, 2021

ACFS File System What is ACFS? ASM Cluster File System (ACFS) is an extension of ASM, which can mount as a file system in your… Read More »

How to Resolve ORA-28040: No matching authentication protocol

by Ed Chen
April 27, 2018September 22, 2021
26 Comments

ORA-28040: No matching authentication protocol When I tried to connect to a 12.1 database from an Oracle client 9.2, it failed with ORA-28040: No matching… Read More »

How Oracle Enable EM Express

by Ed Chen
February 18, 2018September 21, 2021

Enterprise Manager Database Express After installing 12c database, you may want to enable dbconsole just like 10g and 11g, but in fact, there's no emctl… Read More »

How to Install Oracle Database 11.2.0.4 on Oracle Linux 7.2

by Ed Chen
November 6, 2016March 8, 2021

Please download Oracle Database 11.2.0.4 (Patchset 13390677) for your platform, which is actually a full installer of Oracle database. First of all, I take a… Read More »

How to Change Subnet of Grid

by Ed Chen
January 16, 2016September 12, 2021

Oracle 12c uses 4 types of IP addresses to configure network of RAC: Public IP Private IP Virtual IP SCAN IP In which, Public IP,… Read More »

How to Clone PDB to Another CDB

by Ed Chen
October 21, 2015September 6, 2021

Clone PDB to Another CDB The step 1, and 2 are same as How to Clone a PDB From Another PDB in Same CDB, so… Read More »