Ed Chen Logic - Page 2 of 95 - To Make My Logic More Logical

How to Resolve ORA-28417 Oracle Error Message

by Ed Chen
August 30, 2021August 31, 2021

ORA-28417: password-based keystore is not open Tried to close the password-protected keystore that we created for transparent data encryption (TDE), but we got ORA-28417 like… Read More »

How to Resolve ORA-24247 Oracle Error Message

by Ed Chen
August 27, 2021September 12, 2021

ORA-24247: network access denied by access control list (ACL) There're two error patterns of ORA-24247 in this post. Resolve or Connect Privilege Debug Mode in… Read More »

How to Resolve "No ADR base is set"

by Ed Chen
August 25, 2021July 23, 2021

No ADR base is set To manage Automatic Diagnostic Repository (ADR), we used to use ADRCI command line to interact with server. [oracle@primary01 oracle]$ adrci… Read More »

How to Resolve ORA-65011 Oracle Error Message

by Ed Chen
August 23, 2021August 29, 2021

ORA-65011: Pluggable database does not exist Tried to open a pluggable database (PDB), but it failed with ORA-65011. SQL> alter pluggable database ORCLPDB1 open; alter… Read More »

How to Resolve ORA-09925 Oracle Error Message

by Ed Chen
August 20, 2021August 29, 2021

ORA-09925: Unable to create audit trail file There're two error scenarios of ORA-09925 in this post, one is for single-instance databases, the other is for… Read More »

How to Resolve PRVG-2002 Oracle Error Message

by Ed Chen
August 18, 2021August 29, 2021

PRVG-2002 : Encountered error in copying file Saw error PRVG-2002 when verifying the cluster environment before installing grid infrastructure 19c on Linux 8.2. [grid@primary01 ~]$… Read More »

How Oracle Check Archivelog Mode

by Ed Chen
August 17, 2021August 22, 2021

Check Archivelog Mode There're two ways that can check whether archivelog mode is enabled or not. SQL*Plus command To use SQL*Plus specific command, you have… Read More »

How to Resolve ORA-32002 Oracle Error Message

by Ed Chen
August 16, 2021August 30, 2021

ORA-32002: cannot create SPFILE already being used by the instance Tried to restore the server parameter (SPFILE) to the default location from a parameter file… Read More »

How to Resolve ORA-00308: cannot open archived log

by Ed Chen
August 13, 2021August 30, 2021

ORA-00308 Found ORA-00308: cannot open archived log during performing a database point-in-time recovery (DBPITR) by RMAN. ORA-00308: cannot open archived log '/oradata/ORCL/ARCH/ORCL_1_294150.arc' ORA-27037: unable to… Read More »

How to Resolve ORA-65118 Oracle Error Message

by Ed Chen
August 11, 2021August 29, 2021

ORA-65118: operation affecting a pluggable database cannot be performed from another pluggable database When we tried to close a pluggable database (PDB), we got ORA-65118.… Read More »