Oraclue

Oracle internals, debugging and undocumented features

Oracle GoldenGate version 11.1.1.1 released

After long wait Oracle finaly relesed new Oracle GoldenGate version 11.1.1.1 which supports encrypted tablespaces.

To download it click on the link below:

https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=13730870

Also there is new documentation for this release:

http://download.oracle.com/docs/cd/E22355_01/index.htm

About  Replicating TDE-encrypted data

  Oracle GoldenGate supports the Transparent Data Encryption (TDE) at the column and tablespace level.

● Column-level encryption is supported for all versions of 10.2.0.5, 11.1, and 11.2.

● Tablespace-level encryption is supported for all versions of 10.2.0.5 and 11.1.0.2.

 Required database patches

  To support TDE, one of the following Oracle patches must be applied to the database,

depending on the version.

 ● Patch 10628966 for 10.2.0.5.2PSU

● Patch 10628963 for 11.1.0.7.6PSU

● Patch 10628961 for 11.2.0.2

Advertisements

Script – How to find table inside PL/SQL

SELECT owner,
       object_type,
       object_name,
       object_id,
       status
  FROM sys.DBA_OBJECTS
 WHERE object_id IN
          (    SELECT object_id
                 FROM public_dependency
           CONNECT BY PRIOR object_id = referenced_object_id
           START WITH referenced_object_id =
                         (SELECT object_id
                            FROM sys.
                                  DBA_OBJECTS
                           WHERE     owner = ‘<owner_name>’
                            AND object_name ='<table>’
                            AND object_type = ‘TABLE’))

Oracle Diagnostic Events in 11g

This was presented at HOTSOS 2011

Oracle 11g has a completely new low-level kernel diagnostics and tracing infrastructure built into it. This presentation will explore new diagnostic events. It covers topics like: how to find Oracle internal documentation about events, sample cases, demos, etc.

You can download it from these links:

PDF file:

Oracle_Diagnostic_Events_in_11g

Presentation:

Oracle Diagnostic Events

OEM 11g install and ORA-12650

Two weeks ago I was trying to  install  OEM grid control version 11 .I did it many times already but this time my process  failed in the middle of install.

After digging numerous number of  install logs I have found message like one bellow:

HealthMonitor Jan 26, 2011 5:39:44 PM OMS Heartbeat Recorder:  error: Could not get id: java.sql.SQLException: Oracle Error ORA-12650
Critical error err=3 detected in module OMS Heartbeat Recorder:

Quick search turn out that    ORA-12650 No common encryption or data integrity algorithm  is error related to  Oracle Advanced Security Option.

Then I realized that have ASO enabled on datatabase which will be used as OEM respository.

My sqlnet.ora looks something like this: 

/* ASO Encryption */

SQLNET.CRYPTO_SEED = “-blablablablablabla”
SQLNET.ENCRYPTION_SERVER = REQUIRED
SQLNET.ENCRYPTION_CLIENT = REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER = (RC4_256)
SQLNET.ENCRYPTION_TYPES_CLIENT = (RC4_256)

/* ASO Checksumm */

SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (MD5)
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (MD5)

After  taking this part from sqlnet.ora file  my install finished successfully.

It sounds easy but it took me some time to dig all install logs and find the cause..

Hotsos Symposium Speaker 2011

I will be speaking at Hotsos Symposium 2011 which will be held March 6 — 10, 2011 at the Omni Mandalay Hotel in Irving, TX.

Presentation Title

Oracle Diagnostic Events

Abstract

Oracle 11g has a completely new low-level kernel diagnostics and tracing infrastructure built into it. This presentation will explore new diagnostic events. I will cover topics like: how to find Oracle internal documentation about events, sample cases, demos, etc.

For more information please check link bellow:

http://www.hotsos.com/sym11.html

Hopefully to see you there!