I tried to set up Golden Gate as described in the Oracle Installation and Setup Guide (E35957-01).
But when it comes to the register extract command I get the following error:
GGSCI (LOG-DO-CPDUE1) 26> register extract ext1 database
2012-11-13 17:50:57 WARNING OGG-02064 Oracle compatibility version 22.214.171.124.0
has limited datatype support for integrated capture. Version 126.96.36.199 required f
or full support.
2012-11-13 17:51:11 ERROR OGG-01755 Cannot register or unregister EXTRACT EX
T1 because of the following SQL error: OCI Error 439. See Extract user privilege
s in the Oracle GoldenGate for Oracle Installation and Setup Guide.
What is this OCI error 439?
What to do to solve the problem?
What did you install?
WARNING OGG-02064 Oracle compatibility version 188.8.131.52.0
has limited datatype support for integrated capture. Version 184.108.40.206 required
for full support.
Sounds like you have a compatibility issue, as in, you need to be on 220.127.116.11 like the message says.
I installed: Oracle GoldenGate V18.104.22.168.3 for Oracle 11g 64bit on Windows 2003, 2008 (64bit)
(File: V34342-01.zip). There is no Golden Gate Version 22.214.171.124.
I was astonished about the warning, OGG-02064, because the database is: Oracle Database 11g Release 126.96.36.199.0 - 64bit Production
I tend to ignore the warning for now.
All data types we have are supported by this limited support.
Ok, the OCI error 439 mentioned above obviously is ORA-00439
I ran this command of chapter 11.9.3:
SQL> alter system
2 SET LOG_ARCHIVE_DEST_2='SERVICE=DUEARCH ASYNC OPTIONAL NOREGISTER
and got this (re-translated into English by myself):
ERROR in line 1:
ORA-32017: error modifying SPFILE
ORA-00439: Function not activated: Managed Standby