By Uwe Hesse Link to original post: http://uhesse.wordpress.com/oracle-database-ha-architecture/ A very popular topic in many of my courses is Oracle Database…
Author Shadab Mohammad
Transportable Tablespace across Different Platforms ___________________________________________________ In our example we will transport a tablespace called TEST. The tablespace should be…
1. Start session trace To start a SQL trace for the current session, execute: ALTER SESSION SET sql_trace = true;…
Index Re-building is a debatable concept amongst DBA’s. Experts like Ask Tom think rebuilding indexes doesn’t create any considerable performance…
1. Copy the backup of the dumpfile to the target server. 2. Create a tablespace in our eg: called TEST.…
Well, most of the oracle DBAs are very much interested in learning Oracle Applications 11i or R12. For that, we…
A database link creates a connection between a local database and a remote database. You might want to create a…
The database does not startup, and gives errors like: ORA-38737: Expected sequence number 2483 doesn’t match 2304 ORA-38701: Flashback database…
The Complex Oracle Data Guard in less than 15 easy steps. Create a physical standby database in less than an…
Sometimes when your running an Oracle database, it becomes necessary to automate some tasks like cleaning your archivelogs. Since in…
How to change the Size of the Redo Log files to improve the log switch frequency in Oracle database. select…
Purpose of this parameter found in sqlnet.ora file: Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If…
How to configure just newly added disks in Solaris 10? It’s really simple. 1. first show all attached targets bash-3.00#…
—– Procedure to import table from production system to test system —— 1. Copy the backup(dump) of schema onto /backup_restor_only…
####PSU patching, interim patches ##### Sometimes before moving to a new 10.2.0.* version there are CPU patches released on a…
How to backup the Oracle Control File? There are two approaches: you either generate a binary image of the Control…
Whenever you are trying to backup Archivelogs from RMAN you might get the following error. Starting backup at 25-FEB-10 current…
I’m now a certified expert in Oracle. Just cleared the 1z0-048 exam for Oracle RAC 10g Cluster. The exam tests…
The size of the database is the total size of the datafiles that make up the tablespaces of the database.…
SQL> select * from v$flashback_database_log; SQL> show parameter db_file SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=2g; System altered. SQL> alter system set…
1. Turn on block checking REASON: The aim is to detect, very early the presence of corrupt blocks in the…
Copy Table to a new table with some condition ______________________________________________ SQL> CREATE TABLE newTable AS (SELECT * FROM emp WHERE…
Oracle Apps 11i is divided into : Database Tier ( Database & DB Listener ) and Application Tier ( WebServer,…
Oracle Database philosophy is Data Recover-ability. This is the reason if you have a huge table with more than 100…