Ed Chen Logic - To Make My Logic More Logical

How to Revert OMF Spfile and Password File in RAC

by Ed Chen
December 2, 2020December 2, 2020

Even though I chose NOT to use Oracle Managed Files (OMF) during Oracle 19c RAC database creation, I still got OMF spfile and password file… Read More »

How to Query TEXT in ALL_VIEWS

by Ed Chen
November 28, 2020November 28, 2020

ALL_VIEWS Dictionary view ALL_SOURCE contains only several object types like PROCEDURE, PACKAGE BODY, FUNCTION, TYPE except VIEW. If you want to search the content of… Read More »

How to Resolve ORA-03206: maximum file size of (4194304) blocks in AUTOEXTEND clause is out of range

by Ed Chen
November 25, 2020November 26, 2020

ORA-03206 Theoretically, we can add a data file with maximum size of 32 GB to a tablespace with 8 KB block size. Actually, we can't.… Read More »

How to Purge Recycle Bin in Oracle

by Ed Chen
November 21, 2020November 24, 2020

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 to Resolve DBD: login failed, probably a symptom of a deeper problem in Oracle

by Ed Chen
November 18, 2020November 4, 2020

DBD: login failed, probably a symptom of a deeper problem in Oracle When I tried to upgrade Oracle Customer Care and Billing (CC&B) system by… Read More »

How to Prevent Automatic Restart of a Database by SRVCTL

by Ed Chen
November 14, 2020October 30, 2020

Oracle Automatic Restart contains a lot of components to be restarted. Here we focus on the database. The default policy of a RAC database is… Read More »

Oracle Enterprise Manager Database Express 19c - A Dialog from XDB ask for Credential

How to Remove EM Express XDB Credential Dialog

by Ed Chen
November 11, 2020November 12, 2020

You may surprisingly see a credential dialog from XDB like the feature image when you tried to login Oracle Enterprise Manager Database Express (EM Express).… Read More »

Oracle Enterprise Manager Database Express 19c - This Page Can't be Displayed

How to Resolve Enterprise Manager Express Secure Connection Fail

by Ed Chen
November 7, 2020November 12, 2020

Saw an error in Internet Explorer 11 when I tried to connect to Oracle Enterprise Manager Database Express (EM Express) of a RAC server. This… Read More »

How to Resolve ORA-15173: entry 'pdbseed' does not exist in directory

by Ed Chen
November 4, 2020November 6, 2020

Saw errors when creating a 19c RAC database by DBCA like the following. [oracle@primary01 ~]$ vi $ORACLE_BASE/cfgtoollogs/dbca/ORCLCDB/trace.log_2020-10-13_19-42-05PM ... ORA-19504: failed to create file "+DATA01/ORCLCDB/pdbseed/sysaux01.dbf" ORA-17502:… Read More »

Complete Initialization Parameters List in DBCA 19c

by Ed Chen
October 31, 2020October 19, 2020

The complete list is shown during creating a 19c RAC database by DBCA.