The name of Oracle I'm going to San Diego to day, to try to figure out the mystics about Oracle RAC. I'm really looking forward to spend one whole week only dedicated to Databases and RAC, nothing … [Read more...] about Going to San Diego
Archives for November 2014
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
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?
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