Ed Chen Logic - Page 3 of 81 - To Make My Logic More Logical

How to Reset Sequence to Exact Number You Need

by Ed Chen
September 23, 2020September 24, 2020

Start Sequence to Exact Number Let's say someone abused a sequence object and you found the current sequence number is far away from the current… Read More »

How to Patch Oracle GoldenGate

by Ed Chen
September 19, 2020September 9, 2020

Use the Latest OPatch First of all, we have to download the latest OPatch utility for GoldenGate. In this case, we downloaded OPatch 11.2.0.3.25 for… Read More »

How to Patch a RAC Database

by Ed Chen
September 16, 2020September 23, 2020

If you know how to patch a single-instance database, then you'll learn that patching a RAC database has some additional steps and risk after reading… Read More »

How to Patch Grid Infrastructure and Oracle Home

by Ed Chen
September 12, 2020September 23, 2020

To patch a Grid infrastructure including Oracle home, we need to download the correct patch from My Oracle Support (MOS) for your current version of… Read More »

How to Backup Oracle Software including Oracle Home and Grid Infra

by Ed Chen
September 9, 2020September 4, 2020

I know there're OS backups on database servers already, so we usually don't have to backup Oracle software by ourselves. In case that you don't… Read More »

How to Backup Oracle Inventory

by Ed Chen
September 5, 2020September 8, 2020

Using cp You don't have to tar or zip all of Oracle central inventory, because the inventory is pretty small, normally, it's in several megabytes.… Read More »

How to Resolve IMP-00038: Could not convert to environment character set's handle

by Ed Chen
September 2, 2020November 19, 2020

IMP-00038 I thought it was a character set conversion problem when using the original import (imp) to import a dump file, so I tried to… Read More »

How to Detect Conflicts Before Patching

by Ed Chen
August 29, 2020September 4, 2020

Before you apply the new patch, you probably want to know whether the current configuration of Oracle home that conflict with the patch. Here in… Read More »

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 »