Oracle Database 18c

Installation Guide on AIX for All Releases of Oracle Database

by Ed Chen
March 23, 2023April 20, 2023

In this post, we collect installation guides on AIX for all database releases. You may bookmark this page by pressing Ctrl + d. There're 2… Read More »

Installation Guide on Solaris for All Releases of Oracle Database

by Ed Chen
March 22, 2023April 20, 2023

In this post, we collect installation guides on Solaris for all database releases. You may bookmark this page by pressing Ctrl + d. There're 2… Read More »

Installation Guide on Windows for All Releases of Oracle Database

by Ed Chen
March 21, 2023August 31, 2023
2 Comments

In this post, we collect installation guides on Windows for all database releases. You may bookmark this page by pressing Ctrl + d. There're 2… Read More »

Installation Guide on Linux for All Releases of Oracle Database

by Ed Chen
March 20, 2023April 20, 2023

In this post, we collect installation guides on Linux for all database releases. You may bookmark this page by pressing Ctrl + d. There're 2… 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 Oracle Purge RecycleBin

by Ed Chen
November 21, 2020March 15, 2023

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

How to Resolve ORA-17628: Oracle error 1031 returned by remote Oracle server

by Ed Chen
November 16, 2020April 14, 2023
2 Comments

ORA-17628 In some situations, you might see errors like the following when cloning a remote pluggable database (PDB): SQL> create pluggable database finance_pdb from finanpdb@link_to_test1… Read More »

How to Resolve OpenSSH 8 Problems for Oracle 19c

by Ed Chen
October 13, 2020September 4, 2021
10 Comments

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 Start EM Express for PDB

by Ed Chen
July 22, 2020February 23, 2023

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 Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied

by Ed Chen
January 11, 2020December 24, 2022
8 Comments

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 »

JavaScript is not enabled. Please enable it and reload the page.