Where is Audit File Location
AUDIT_FILE_DEST (ADUMP) The audit file location AUDIT_FILE_DEST, also known as ADUMP may be different from version to version. For 10g and later releases Conventionally, we… Read More »Where is Audit File Location
Oracle Database 12c
How to Patch Grid and Oracle Home 12c (PSU 32917447)
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 to Patch Grid and Oracle Home 12c (PSU 32917447)
How Oracle Purge RecycleBin
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 Oracle Purge RecycleBin
How to Migrate 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 9i to 12c via DB Link
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 Restore RAC Database from RMAN Backup Set
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 RAC Database from RMAN Backup Set
How to Restore OCR and Voting Disk
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 »How to Restore OCR and Voting Disk
How to Resolve ORA-03134: Connections to this server version are no longer supported
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 Resolve ORA-03134: Connections to this server version are no longer supported
How to Create ACFS File System
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 Create ACFS File System
How to Resolve ASM Disks Not Visible
Requirements for Disk Discovery There're several requirements for disks to be discovered: 1. Right Device Type For 11g or later, only block devices leading by… Read More »How to Resolve ASM Disks Not Visible