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 18c
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 Resolve ORA-17628 Error Message
ORA-17628: Oracle error 1031 returned by remote Oracle server In some situations, you might see errors like the following when cloning a remote pluggable database… Read More »How to Resolve ORA-17628 Error Message
How to Resolve OpenSSH 8 Problems for Oracle 19c
OpenSSH 8 I found there're some problems related to secure file copy (scp) happened in Oracle 19c when OpenSSH is 8 or higher in Linux… Read More »How to Resolve OpenSSH 8 Problems for Oracle 19c
How to Start EM Express for PDB
EM Express for PDB I assumed that you have enabled Enterprise Manager Express (EM Express) before reading this post. During database creation, DBCA enables Enterprise… 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 to. Therefore, the database refused the user… Read More »How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied
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 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 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