Oracle GoldenGate and Encrypted Tablespaces (TDE) in 11.2

To make GG work with encrypted tablespaces  you have to apply database patch: Patch  10395645 for Oracle 11.2.0.2. mkstore -wrl ./ -createEntry ORACLE.SECURITY.CL.ENCRYPTION.ORACLEGG Supply shared secret for GG ( not wallet password).Last step is to supply wallet password.Copy ewallet.p12 file to other nodes ( if running RAC but not sharing wallet location ). Do not … Read more

Filed under HA

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 … Read more

Filed under HA

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 … Read more

Filed under Tools

Blue

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: … Read more

Filed under Internals

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 … Read more

Filed under Troubleshooting