Oracle internals, debugging and undocumented features
After long wait Oracle finaly relesed new Oracle GoldenGate version 220.127.116.11 which supports encrypted tablespaces.
To download it click on the link below:
Also there is new documentation for this release:
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 18.104.22.168.
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 22.214.171.124.6PSU
● Patch 10628961 for 126.96.36.199
WHERE object_id IN
( SELECT object_id
CONNECT BY PRIOR object_id = referenced_object_id
START WITH referenced_object_id =
WHERE owner = ‘<owner_name>’
AND object_name ='<table>’
AND object_type = ‘TABLE’))
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:
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..
I will be speaking at Hotsos Symposium 2011 which will be held March 6 — 10, 2011 at the Omni Mandalay Hotel in Irving, TX.
Oracle Diagnostic Events
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:
Hopefully to see you there!