| Goldenagte extract issue for 12C database [message #594581] |
Fri, 30 August 2013 05:22  |
 |
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 #594706 is a reply to message #594593] |
Mon, 02 September 2013 01:33  |
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
