Oracle Database 12c

How to Resolve Error in invoking target 'install' of makefile ins_ctx.mk

by Ed Chen
April 23, 2022April 21, 2022

ins_ctx.mk Met this error about makefile ins_ctx.mk during the installation of Oracle 11.2 on Enterprise Linux 7: The pieces of error message are: Error in… Read More »

Where is AUDIT_FILE_DEST (ADUMP)

by Ed Chen
January 7, 2022May 18, 2022

Audit File Location The audit file location AUDIT_FILE_DEST, also known as ADUMP may be different from version to version. For 10g and later releases Conventionally,… Read More »

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

by Ed Chen
August 4, 2021April 12, 2022
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, 2020July 3, 2022

In this post, we'll talk about the following topics. Feature of Recyclebin Prerequisite of Using Recyclebin Ways to Purge Recyclebin A. Feature of Recyclebin Since… Read More »

How to Migrate 9i to 12c via DB Link

by Ed Chen
November 16, 2019March 28, 2022

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 Restore RAC Database from RMAN Backup Set

by Ed Chen
July 4, 2019July 3, 2022

For 10g RAC database restoration, you may check: How to Restore 10g RAC Database from a Backup Set. Suppose we have restored 12c clusterware back.… Read More »

How to Restore OCR and Voting Disk

by Ed Chen
June 30, 2019October 1, 2021

There're 2 procedures of restoring OCR and voting disk in this post. They are: Restore OCR and Voting Disk For 12c Clusterware Restore OCR and… Read More »

Intermediary Database 11g - Workaround to ORA-03134

How to Resolve ORA-03134: Connections to this server version are no longer supported

by Ed Chen
February 17, 2019October 31, 2021

ORA-03134 As I mentioned in How to Resolve ORA-28040: No matching authentication protocol. ORA-28040 is not difficult to be solved if you were trying to… Read More »

How to Create ACFS File System

by Ed Chen
October 26, 2018October 10, 2021
2 Comments

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 »