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
In this article I will discuss the concept of voting disks and why they are a critical component in RAC, what they are, why they are needed and how you can manage them Voting disks (also known … [Read more...] about RAC – Voting Disks, what the fuzz is all about.
This Article will go though and describe the most common tools for managing your OCR files. I will also talk about what the purpose of them and how they are managed internally. OCR … [Read more...] about Manage your Oracle Cluster Registry (OCR)
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 how to manage Oracle RAC startup and shutdown scenarios. Both for Individual instances and for all instances, also including the ASM instances. We will cover: Shutdown RAC … [Read more...] about Manage RAC – Starting and stopping – Multiple options
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 article will show you how you can clone the database files from one host to another with out using RMAN, instead only coping the required files to the new host. This is a very easy way of moving … [Read more...] about Clone the Oracle Database to new host, without 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