11g RAC Administration and Maintenance Tasks and Utilities: Task List: Checking CRS Status Viewing Name Of the Cluster Viewing Nodes…
Category Database
ORACLE TRANSPARENT DATABASE ENCRYPTION 11gR2 : eNCRYPTING eNTIRE tABLESPACE Create oracle encryption wallet: create a directory on the oracle server.…
In a heterogeneous environment it sometimes becomes necessary to access information across different database. In this exercise I will demonstrate…
Oracle 11g Dataguard introduced powerful new features viz. Active Data Guard and Snapshot Standby Database. Snapshot standby database specially is…
A brief comparison between Oracle and SQL Server. In my view, Oracle comes out ahead in this comparison. Platform dependancy…
From time to time a DBA might need move an Oracle database datafile from one location to another. Reasons for…
Apple use’s Oracle Active Dataguard 11g for its AppStore. In Oracle 11g data guard you can have upto 30 active…
Oracle 11gR2 is a major release upgrade from 10gR2 and 11gR1 both. Many previous parameters like user_dump_dest etc have been…
ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at:…
Sometimes it becomes necessary to stop the log shipping procedure without doing a shutdown of the standby database or server.…
For this excersie we will install Oracle Audit Vault Server 10.2.3.0 on a Solaris 10 SPARC-64 Box. The Agent will…
Restoring a controlfile without rman _____________________________________ suppose you lost a controlfile say control01.ctl. The controlfile got deleted but you have…
Transparent Application Failover (TAF) is a client-side feature that allows for clients to reconnect to surviving nodes in the event…
To use real-time apply where before log shipping the LGWR process writes to a standbylog file simultaneously along with the…
I had installed Oracle Database 11g on Solaris 10 few days back. I thought of documenting the steps for easy…
select x.inst_id,x.indx+1,ksppinm,ksppity,ksppstvl,ksppstdf, decode(bitand(ksppiflg/256,1),1,’TRUE’,’FALSE’), decode(bitand(ksppiflg/65536,3),1,’IMMEDIATE’,2,’DEFERRED’,3,’IMMEDIATE’,’FALSE’), decode(bitand(ksppstvf,7),1,’MODIFIED’,4,’SYSTEM_MOD’,’FALSE’), decode(bitand(ksppstvf,2),2,’TRUE’,’FALSE’), ksppdesc from x$ksppi x, x$ksppcv y where (x.indx = y.indx) /*and (translate(ksppinm,’_’,’#’) not like…
A physical standby database is created from an existing other database. This other database will then be the primary database.…
Automatic Storage Management (ASM) in Oracle Database 10g Automatic Storage Management (ASM) is a new feature was introduced in Oracle…
ORA-19905: log_archive_format must contain %s, %t and %r During a go-live when a 10.2.0.4 database was being readied for a…
Here are some scripts related to Tables/Indexes . Tabs w/ Questionable Inds TABLES WITH QUESTIONABLE INDEX(ES) NOTES: Owner – Owner…
PL/SQL Procedure to Automatically Backup ControlFile to trace whenever you are shutting down or starting up the database. ‘ALTER DATABASE…
As read originally on Coskan’s Blog When i got errors from database and complaining about “what happened again” my colleagues…
Many times it becomes necessary to append date stamp on your export dumps. In Unix systems, shell scripting is very…
A. Delete DB Control Objects: Option 1. Delete DB Control Configuration Files using EMCA scripts Option 2. Delete DB Control…