Home » Server Options » Replication » Goldenagte extract issue for 12C database (OEL -5)
Goldenagte extract issue for 12C database [message #594581] Fri, 30 August 2013 05:22 Go to next message
amk.singh5@gmail.com
Messages: 2
Registered: August 2013
Junior Member
Hi GG Guru,

I am implementing GG 11g r2 for 12C database. But i am getting below error. Could you please help me on this...

My question Why Goldengaet needs specific package ... Since this is homogeneous & heterogenous.


/u01/12c_database_software/goldengate/dirtmp.
2013-08-30 05:28:44 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to Sequence 66, RBA 25067536, SCN 0.0.
2013-08-30 05:28:44 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, ext1.prm: ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_INTERNAL_CLKM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.
2013-08-30 05:28:44 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.



Database details
----------------

SQL> select object_name, object_type from dba_objects where object_name='DBMS_INTERNAL_CLKM' and object_type in ('PACKAGE');

no rows selected

SQL> select object_name, object_type from dba_objects where object_name='DBMS_INTERNAL_CLKM';

no rows selected

Thanks in advance..



--- Amrendra
Re: Goldenagte extract issue for 12C database [message #594593 is a reply to message #594581] Fri, 30 August 2013 10:58 Go to previous messageGo to next message
Michel Cadot
Messages: 58933
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think GG 11.2 expects a column that no more exists in 12c.
In addition, it is not surprising that GG 11.2 does not know some redo log format of rdbms 12c, dont' you think?

Regards
Michel
Re: Goldenagte extract issue for 12C database [message #594706 is a reply to message #594593] Mon, 02 September 2013 01:33 Go to previous message
amk.singh5@gmail.com
Messages: 2
Registered: August 2013
Junior Member
Hi Michel,

Thanks for your good responce..

Now i have removed decrypt option from prm file. But am gettinng below error. Once i will use "TRANLOGOPTIONS _IGNORETSERECORDS " parameter in extarct prm file.. Extract will be running but it will not capture the data...

Kindly suggest me to proceed further...

Now it is abended because i ahve not used "TRANLOGOPTIONS" options..

Ext1.prm file
=============
EXTRACT ext1
userid gg64@pdborcl, password gg64
setenv (ORACLE_HOME="/u01/app/oracle/product/12.1.0/dbhome_1")
setenv (ORACLE_SID="cdborcl")
rmthost 10.238.52.172, mgrport 2101
exttrail ./dirdat/aa
TABLE dba64.emp;
TABLE dba64.address;


2013-09-02 02:19:38 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file ./dirdat/aa is using format RELEASE 11.2.
2013-09-02 02:19:38 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ext1.prm: Rolling over remote file ./dirdat/aa000009.
2013-09-02 02:19:38 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for target file ./dirdat/aa000010, at RBA 1097.
2013-09-02 02:19:38 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for all targets.
2013-09-02 02:19:38 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext1.prm: Position of first record processed Sequence 70, RBA 3184144, SCN 0.2454337, Aug 30, 2013 8:21:01 AM.
2013-09-02 02:19:40 ERROR OGG-01771 Oracle GoldenGate Capture for Oracle, ext1.prm: DBOPTIONS DECRYPTPASSWORD must be used to decrypt data that is encrypted with Transparent Data Encryption. Otherwise, contact Oracle Support to use TRANLOGOPTIONS with _IGNORETSERECORDS to skip the capture of tables in an encrypted tablespace.
2013-09-02 02:19:40 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.



---- Amrendra
Previous Topic: how to using GoldenGate between MS SQL Server and Oracle 10g.
Next Topic: Materialised View identifying modifications 10g
Goto Forum:
  


Current Time: Thu Aug 28 23:00:11 CDT 2014

Total time taken to generate the page: 0.13492 seconds