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>


Wednesday, November 5, 2014

GoldenGate Error ERROR OGG-01028

If you get this error:

Oracle GoldenGate Capture for Oracle, ext_cont.prm:  Formatting error on: table name SALES_SOUB_ADMIN.CW_OPT_INS, rowid AAAR5fAAGAAJ/3PAB8, X
ID 20.12.64, position (Seqno 64, RBA 3474748). Error converting timestamp with timezone from Oracle to ASCII format for column DT_LAST_UPDATE.


Include this parameter in your .prm file:

TRANLOGOPTIONS INCLUDEREGIONID


Check MOS Note: 1929158.1

Best Regards,
Paulo Portugal

Tuesday, October 28, 2014

Change your DG Protection Mode with one single parameter

Instead of setting 3 parameters to increase your detection and protection mode when using a DG environment, in 11g we can set just one parameter:

db_ultra_safe  = data_only, or data_and_index or off (Protect just table data, protect also index or none) .

This parameter changes these other 3 :  db_block_checking, db_lost_write_protect and db_block_checksum


Best Regards,
Paulo Portugal

Tuesday, October 14, 2014

Check if your database is using ASYNC_IO or not

TO check if your database is using async_io, just execute this query below;

SYS@ABR1 AS SYSDBA> select count(*) filetype_name,asynch_io from v$iostat_file group by filetype_name,asynch_io;

FILETYPE_NAME ASYNCH_IO
------------- ---------
   1 ASYNC_OFF
   1 ASYNC_OFF
   1 ASYNC_OFF
  15 ASYNC_ON
   1 ASYNC_OFF
   1 ASYNC_OFF
   1 ASYNC_OFF
   1 ASYNC_OFF
   1 ASYNC_OFF
   1 ASYNC_OFF
 185 ASYNC_ON
   1 ASYNC_OFF

12 rows selected.

SYS@ABR1 AS SYSDBA>


As you can see, I have 185 datafiles using ASYNC IO, if you cannot find anyone using ASYNC_ON, than you are not using ASYNC_IO, check your disk_asynch_io initialisation parameter and make sure it is set to TRUE.  Also check with your OS admin if your OS is ok to use ASYNC IO.

Best Regards,
Paulo Portugal


Thursday, October 2, 2014

GGSCI (host) 3> dblogin useridalias ggadm ERROR: Unable to open credential store. Error code 28761..

Add credentias to new version of GG:




GGSCI (host) 4> ADD CREDENTIALSTORE

Credential store created in ./dircrd/.

GGSCI (host) 5> ALTER CREDENTIALSTORE ADD USER ggadm, password xxxxx alias ggadm

Credential store in ./dircrd/ altered.

GGSCI (host) 6> dblogin useralias ggadm



This wors fine for me.

Best Regards,
Paulo Portugal