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
Category Uncategorized
The Unified Auditing in Oracle 12c can Grow the SYSAUX table to a large size. In our case it grew…
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…
Sometimes to have a funky time on the BASH shell you can run the below shell script [code language=”bash”] #!/bin/bash…
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…
— 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…
I read a quote a few years ago that really resonated with me. The quote is attributed to Jeffrey Hammerbacher,…
— Enable Password-less SSH between Linux Servers Before using PSSH — In the Server (192.168.100.55) from where you want to…
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…
A production database of showed 4 cores of CPU burning constantly by 2 process E000 and E001. On further investigation…
Take a backup of the databases before removing mysql [code language=”bash”] rm /usr/local/mysql rm -rf /usr/local/mysql* rm -rf /Library/StartupItems/MySQLCOM rm…
Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object,…
When user upload a xml file into schema, it was hang during upload operation and then it shows Ora-12801 error.…
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…
COLUMN object_name FORMAT A40 COLUMN number_of_blocks FORMAT 999,999,999,999 SELECT o.object_name, COUNT(*) number_of_blocks FROM DBA_OBJECTS o, V$BH bh WHERE o.data_object_id =…