Oracle Enterprise Manager Database Control & Time Zone

Background: Egypt time zone is GMT+2. Starting from year 1988, Egypt started to use the summer time zone (GMT +3) starting from the last Thursday of Apr till the last Thursday of September (5 months), then it reset back to GMT +2 for the remaining of the year. Summer time zone was cancelled at 20-Apr-2011, … Continue reading Oracle Enterprise Manager Database Control & Time Zone

Oracle Data Pump Import Log File Analysis

In most (or all) cases , when you fully import the database using oracle data pump or the old “imp” import utility , you will get some errors. Some of them are expected and could be ignored and some need close attention to investigate and fix. For big databases, the import log file may be … Continue reading Oracle Data Pump Import Log File Analysis