PL/SQL Procedure to Automatically Backup ControlFile to trace whenever you are shutting down or starting up the database. ‘ALTER DATABASE…
As read originally on Coskan’s Blog When i got errors from database and complaining about “what happened again” my colleagues…
Many times it becomes necessary to append date stamp on your export dumps. In Unix systems, shell scripting is very…
A. Delete DB Control Objects: Option 1. Delete DB Control Configuration Files using EMCA scripts Option 2. Delete DB Control…
Dedicated to Gwen Shapira It’s a tale of woe and malice, a tale of a DBA That the users learned…
The following INIT.ORA/SPFILE parameter can be used if your current redologs are corrupted or blown away. It may also be…
UPGRADE ORACLE 10.2.0.1 TO 10.2.0.4 WINDOWS SERVER 2003 32-BIT ————————————————————— 1. CHECK FOR TIMZEZONE INFORMATION USING FOLLOWING SQL QUERY SELECT…
*** I would like to update this post since this is one of the most frequently accessed pages on my blog.…
Directions :: First do gunzip then cpio of the file you downloaded from oracle.com 1. Run “gunzip <filename>” on all…