Setup for the Environment ——————- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home…
Category Database
1 ) Set the environment variable also via srvctl @ oracle user. export ORACLE_UNQNAME=’$ORACLE_HOME/bin/srvctl config database |grep -w ${ORACLE_SID%?}’ srvctl…
Configure 12c dataguard broker using the below command onPrimary database server primeprd – > tnsnames for primary database primedr-> tnsnames…
Query to check sessions writing to flashcache on Exadata select se.sid, sn.name, s.value, se.program from v$sesstat s natural join v$statname…
Oracle Version Affected : 12.1.0.2 OS : OEL 6 Update 7, x64 This error is related to Parallel Query and…
Unmounting ACFS File Systems ACFS file systems can be used by Oracle RAC for hosting software files for the database.…
Let’s say you have already created logfiles from Group 1 to Group 8 on a 2 node RAC cluster on…
export MMSG=/tmp/$$.mail export ADDR=”shadab@easyoradba.com” export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 export ORACLE_SID=orcl file=/tmp/${$}_`date +%Y%m%d` sqlplus -s “/as sysdba” << .eof > $file set pages…
Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
The long awaited Oracle 12c version (12.1.0.2) with the In-Memory option is now available for public download. The standout feature…
http://www.oracle.com/technetwork/database/options/dbim-vs-sap-hana-2215625.pdf
Oracle has released Enterprise manager 12c RC4 version. It is available to download, link below http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html
Very well explained article why Storage Snapshots are not the best way for backing up an Oracle database. http://www.oracle.com/technetwork/database/features/availability/rman-fra-snapshot-322251.html?utm_content=buffer67053&utm_medium=social&utm_source=facebook.com&utm_campaign=buffer
http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
Install VSFTP RPM from the DVD media *Mount the Media and go to Directory cd /media rpm -ivh vsftpd-2.2.2-11.el6.x86_64.rpm Configure…
One of the best books I have read on any Oracle technology. Must read if you need to know practical…
Mogens Norgaard ( He is Danish, and my Danish is rubbish. So i hope i got his name right :D)…
<div style=”margin-bottom:5px”> <strong> <a href=”https://www.slideshare.net/OracleMKTPR20/database-consolidation-on-oracle-exadata-13603279″ title=”Database consolidation on oracle exadata” target=”_blank”>Database consolidation on oracle exadata</a> </strong> from <strong><a href=”http://www.slideshare.net/OracleMKTPR20″ target=”_blank”>Oracle…
— Count number of sessions oracle for 7 days, Provided you keep data that long — [sourcecode language=”sql”] select to_char(BEGIN_INTERVAL_TIME,’HH24′), ROUND(SUM(CURRENT_UTILIZATION)/COUNT(*))…
Oracle has released the much anticipated patchset release to Oracle 11gR2 database. The patch is available on My Oracle Support search…
In case you want to search a string or any other number in all tables inside a schema. Then there…
This error occurs when an expression is divided by zero. It is considered a logical error in Oracle. In mathematics,…
Just finished installing Oracle 12c on Cent OS 6.3. From the looks of it 12c looks like a winner. Oracle…