Skip to main content

Posts

Showing posts from 2016

FRA Commands

-- Utilisation (MB) du FRA set lines 100 col name format a60 select    name,   floor(space_limit / 1024 / 1024) "Size MB",   ceil(space_used / 1024 / 1024) "Used MB" from v$recovery_file_dest; -- FRA Occupants SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE; -- Location and size of the FRA show parameter db_recovery_file_dest -- Size, used, Reclaimable SELECT   ROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB,   ROUND((A.SPACE_USED / 1024 / 1024 / 1024), 2) AS FLASH_USED_IN_GB,   ROUND((A.SPACE_RECLAIMABLE / 1024 / 1024 / 1024), 2) AS FLASH_RECLAIMABLE_GB,   SUM(B.PERCENT_SPACE_USED)  AS PERCENT_OF_SPACE_USED FROM   V$RECOVERY_FILE_DEST A,   V$FLASH_RECOVERY_AREA_USAGE B GROUP BY   SPACE_LIMIT,   SPACE_USED ,   SPACE_RECLAIMABLE ; -- After that you can resize the FRA with: -- ALTER SYSTEM SET db_recovery_file_dest_size=xxG; -- Or change the FRA to a new location (new archives w...

Emptying the buffers cache in linux

If you ever want to empty it you can use this chain of commands. # free && sync && echo 3 > /proc/sys/vm/drop_caches && free              total        used        free      shared     buffers      cached Mem:        1018916      980832       38084           0       46924      355764 -/+ buffers/cache:      578144      440772 Swap:       2064376         128     2064248              total        used ...

DNS Configuration for SCAN IP

   DNS Configuration for SCAN IP Set the Domainname:             # domainname rac1.com             # domainname >/etc/defaultdomain Write the zone information in /etc/named.conf             # vi /etc/named.conf options {         directory "/var/named";         };         zone "rac1.com"{         type master;         file "rac1domain.for";                         };         zone "1.168.192.in-addr.arpa"{         type maste...

Usefull Find Commands

find . -name '*.trc' -mtime +1 -exec rm -f {} \; find . -name 'aukornbr_evmlog.20*' -mtime +10 -exec rm -f   {} \; find . -name '*.trm' -mtime +1 -exec rm -f {} \; find . -name '*.aud' -mtime +1 -exec rm -f {} \; & ls -l |grep "Oct 27"|awk '{print "rm "$9}'|sh ls -l |grep "Oct 27"|awk '{print "rm "$9}'|sh =============================================================================== for i in G M K; do du -kh | grep [0-9]$i | sort -nr -k 1; done | head -n 11 =============================================================================== find . -name "+ASM3_*" -mtime +01 -exec rm -f {} \; find . -name "avosorbr_evmlog*" -mtime +30 -exec rm -f {} \; find . -name "avoadt3r_evmlog*" -mtime +25 -exec ls -ltr {} \; find . -name "recover_OLAPPRO*" -mtime +90 -exec rm -rf {} \; find . -name "avoadp4r_evmlog.2014*" -mtime +30 -exec rm -f {} \; find . -na...

Hard dependency with ip address Oracle RAC Cluster.

Command error out due to hard dependency with ip address [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource RDBMS_DB -n Node2 CRS-2527: Unable to start 'RDBMS_DB' because it has a 'hard' dependency on 'sDB' CRS-2525: All instances of the resource 'sDB' are already running; relocate is not allowed because the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource sDB  -n Node2 CRS-2529: Unable to act on 'DB' because that would require stopping or relocating 'LISTENER_DB', but the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource LISTENER_DB  -n Node2 CRS-2527: Unable to start 'LISTENER_DB' because it has a 'hard' dependency on 'sD...