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

How to Use My Oracle Support Conflict Checker Tool

by Ed Chen
August 26, 2020September 4, 2020

The checker provided by My Oracle Support (MOS) is for detecting any conflicts between your database configuration and the incoming patch. The URL is at:… Read More »

How to Check GoldenGate Release Version

by Ed Chen
August 22, 2020August 27, 2020

Before downloading the right patches for Oracle GoldenGate, we have to know the current release no. First of all, point ORACLE_HOME to GoldenGate's Home. [oracle@ora12c… Read More »

How to Resolve OPATCHAUTO-72080: Invalid patch location

by Ed Chen
August 19, 2020August 20, 2020

Invalid patch location When I tried to apply patch in a RAC environment, I got error "Invalid patch location". [root@primary01 ~]# export PATH=$PATH:/u01/app/12.1.0/grid/OPatch [root@primary01 ~]#… Read More »

How to Display Some Info in AIX Prompt

by Ed Chen
August 8, 2020August 4, 2020

By default, there's little information in prompt for a new user. Usually, I changed the prompt into this: $ vi ~/.profile ... export PS1=$USER@`hostname -s`:'$PWD>'… Read More »

impdp Parameter for All Releases of Oracle Database

by Ed Chen
August 5, 2020August 7, 2020

Here is the list of impdp available parameters for All Releases of Oracle Database. impdp All Parameters for Oracle Database 20c impdp All Parameters for… Read More »

expdp Parameter for All Releases of Oracle Database

by Ed Chen
August 1, 2020August 7, 2020

Here is the list of expdp available parameters for All Releases of Oracle Database. expdp All Parameters for Oracle Database 20c expdp All Parameters for… Read More »

How to Kill All Sessions Instantly

by Ed Chen
July 29, 2020July 22, 2020

Kill All Sessions I have talked about many topics about identifying and killing sessions in my blog, including: How to Kill Session in Logon Trigger… Read More »

How to Revert EM Express 19c Back to Flash-Based

by Ed Chen
July 25, 2020July 22, 2020

Since Oracle database 19c, we have a new UI of Enterprise Manager Express (EM Express) which is based on Java JET technology. As you can… Read More »

How to Start EM Express for PDB

by Ed Chen
July 22, 2020August 12, 2020

EM Express for PDB During database creation, DBCA enables Enterprise Manager Express (EM Express) for being created CDB, not for PDB globally by default. We… Read More »

DROP INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020July 3, 2020

Here is the list of DROP INDEX Syntax for All Releases of Oracle Database. DROP INDEX Syntax for Oracle Database 20c DROP INDEX Syntax for… Read More »