How to Limit Access to iSCSI Target
In iSCSI, we call clients as initiators. For allowing only specific initiators to access the target, we have to put all allowable initiators in the… Read More »How to Limit Access to iSCSI Target
How to Reset Sequence to Exact Number You Need
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 Reset Sequence to Exact Number You Need
How to Patch Oracle GoldenGate
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 Oracle GoldenGate
How to Patch a RAC Database
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 a RAC Database
How to Patch Grid Infrastructure and Oracle Home
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 Patch Grid Infrastructure and Oracle Home
How to Backup Oracle Software including Oracle Home and Grid Infra
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 Software including Oracle Home and Grid Infra
How to Backup Oracle Inventory
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 Backup Oracle Inventory
How to Resolve IMP-00038: Could not convert to environment character set's handle
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 Resolve IMP-00038: Could not convert to environment character set's handle
How to Detect Conflicts Before Patching
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 Detect Conflicts Before Patching
How to Use My Oracle Support Conflict Checker Tool
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 Use My Oracle Support Conflict Checker Tool