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 article will show you how you can Use RMAN to create a new database using the DUPLICATE.....FROM ACTIVE DATABASE command. The steps are as follow: Create the initialization Parameter file … [Read more...] about Duplicate Active database using RMAN
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
It is easy to think you Enterprise Edition of the Oracle database gives you access to all the nice features available. This however can not be more from the truth! This article will show you some … [Read more...] about Are your Oracle licenses all OK?
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 the third and last article in the "Install Oracle 12c RAC and DB on Virtualbox". Part 1 can be found here Part 2 can be found here If you have already finished the RAC installation … [Read more...] about Install Oracle 12c Database on RAC – Part 3/3