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 »

AUDIT_FILE_DEST (ADUMP)

by Ed Chen
January 7, 2022October 22, 2022

Audit File Location The audit file location AUDIT_FILE_DEST, also known as ADUMP, is the parameter that specifies the destination of audit files in a database.… Read More »

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

by Ed Chen
August 4, 2021October 20, 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

by Ed Chen
October 23, 2019September 13, 2022

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, 2019November 18, 2022

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 Resize Redo Logs in Oracle

by Ed Chen
November 2, 2018October 29, 2022
2 Comments

Increase Redo Log Size The default size of redo logs during installation is 50MB which is too small for production databases. Of course, you can… Read More »