Amazon books

Friday, December 19, 2014

Using TAF To collect information about your RAC Nodes

This command is used to generate all information about your RAC Nodes using TAF Utility:

/u01/app/11.2.0.4/grid/tfa/bin/tfactl diagcollect  -from "Dec/18/2014 13:00:00" -to   "Dec/18/2014 15:00:00"


If you do not have TAF yet, install it in all your Oracle Environments. It is like a join of diagnostic tools simplified with one command.

Best Regards,
Paulo Portugal

Gathering ExaWatcher information easily

If you had a problem / crash in your DB Machine and need to investigate it you can simply us this command below to gather information from time where the crash happened:

[root@ex01dbadm07 oracle.ExaWatcher]# ./GetExaWatcherResults.sh --from 12/18/2014_13:00:00 --to 12/18/2014_15:00:00


This command will collect all ExaWatcher information generated during the time you specified.

Best Regards,
Paulo Portugal 

Wednesday, December 10, 2014

New way to check your patches applied in Oracle Database 12c

Simple run this query below:

SYS@BWOEM12C_1>select xmltransform(DBMS_QOPATCH.GET_OPATCH_LIST, DBMS_QOPATCH.GET_OPATCH_XSLT) from dual;

XMLTRANSFORM(DBMS_QOPATCH.GET_OPATCH_LIST,DBMS_QOPATCH.GET_OPATCH_XSLT)
--------------------------------------------------------------------------------

Patch Details:

Patch     16619249:   applied on 2014-06-30T17:43:15-03


SYS@BWOEM12C_1>