Oracle 12c TDE on RAC Database with Physical Standby RAC. The Oracle Database Home has Multiple Instances, due to which…
Tag oracle
Being a DBA requires us many a times to step outside our role and solve a problem in a smart…
Downloadable free tool from MOS for doing a Security assessment for Oracle Database (compatible with 10.2,11.2,12) https://support.oracle.com/epmos/faces/DocumentDisplay?id=2138254.1
The Unified Auditing in Oracle 12c can Grow the SYSAUX table to a large size. In our case it grew…
[sourcecode language=”sql”] run { allocate channel sbt1 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; allocate channel sbt2 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; CONFIGURE DEFAULT…
The Below Script will generate output if percentage of tablespace space left free is less tan 20%. You can easily…
First Install UTL_MAIL ### To install UTL_MAIL: [code language=”sql”] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ###…
The script below can be used to check the Disk Group Space Free and also Check Directory sizes for each…
Setup for the Environment ——————- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home…
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…
— Create ACFS filesystem on 12c Linux Exadata — 1. Create a volume in ASM ASMCMD [+] > volcreate -G…
Writeback cache is a feature of cache where the blocks are written to flash first before flushing to the disk.…
Unmounting ACFS File Systems ACFS file systems can be used by Oracle RAC for hosting software files for the database.…
Recently we patched our Exadata machines to the April 2016 QFSP. On running DBCA we got X11 forwarding error and…
Let’s say you have already created logfiles from Group 1 to Group 8 on a 2 node RAC cluster on…
Before we begin this is a note from the Oracle Website The name of these bundle patches was changed to…
Often when you have a Linux up and running you run out of space. I use VMware Fusion on my…
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…
Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object,…
One of the best sites for scripts related to checking library cache locks… http://allappsdba.blogspot.qa/2012/04/to-check-library-cache-lock-contention.html
The “Library Cache Pin” wait event is generally a wait event associated with library cache concurrency. Generally the wait event…
ORA-00245: control file backup failed; target is likely on a local file system RMAN-08132: WARNING: cannot update recovery area reclaimable…