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…
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…
— 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…