Since I've been involved in some Oracle License Reviews I've created a few small scripts to audit the usage of some commonly used licensed features. If you need to audit other features you can look in … [Read more...] about Basic License Audit script
In the absence of time to write new interesting articles, I update the Script in with a small simple and very useful script. what it does is: getting the totlat DB size, including datafiles, temp … [Read more...] about Total Database Size
RMAN-03009: failure of delete command ... ORA-19606: Cannot copy or restore to snapshot control file I've hade some issues deleting obsolete backups. This error happen when a snapshot … [Read more...] about ORA-19606: Cannot copy or restore to snapshot control file
This short article will show you how you can clone the database binaries from one host to another using the "well hidden" clone.pl script that has been bundled since 9i The steps are very … [Read more...] about Clone Oracle database binaries, the fastest way!
This short article will show you how you can drop an oracle database from SQL*PLUS using the command DROP DATABASE The steps are easy Start the database on mount exclusive restrict mode Drop … [Read more...] about Drop Database from SQL*PLUS
This Article will guide you, Step by step guide on how to create a physical standby database using RMAN without using duplicate command. The theory behind the task is (as always) simple, below are … [Read more...] about Create a physical standby database using RMAN.
The Error This error occurs when you're attempting to drop a global temporary table. See full error as: ORA-14452, "attempt to create, alter or drop an index on temporary table already in … [Read more...] about ORA-14452: attempt to create, alter or drop an index on temporary table already in use
In this short article I will explain how to move controlfile. The theory is quite simple and the working order is the same as making an offline redolog move from another of my … [Read more...] about Rename and move Oracle Controlfiles
This is an Issue that might occur when running Windows. This is a confusing error since commands like sqlplus runs just fine when i run them from with in the ORACLE_HOME/bin folder. So the issue is … [Read more...] about ORA-12557: TNS:protocol adapter not loadable
If you are running a Data warehouse or a fairly big OLTP Database, or maybe you only have a very big table :) Then you probably know that moving tables between schemas can be a very annoying and long … [Read more...] about Move tables between Schemas