GoldenGate upgrade to 12.1.2 fails at ulg.sql
edited Jun 26, 2018 9:28AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
Source database : 11.2.0.2
Target database : 11.2.0.3
Old GG : 11.2.0.1
I am upgrading GG to 12.1.2 following instruction on http://docs.oracle.com/goldengate/1212/gg-winux/GWUUP/upgrade_ora.htm.
I have two questions.
Target database : 11.2.0.3
Old GG : 11.2.0.1
I am upgrading GG to 12.1.2 following instruction on http://docs.oracle.com/goldengate/1212/gg-winux/GWUUP/upgrade_ora.htm.
I have two questions.
1. Running ulg.sql on source database is failing.
Oracle GoldenGate supplemental log groups upgrade script.
Please do not execute any DDL while this script is running. Press ENTER to continue.
for schema in (select schema_name, allkey_suplog from LOGMNR$SCHEMA_ALLKEY_SUPLOG) loop
*
ERROR at line 126:
ORA-06550: line 126, column 55:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 126, column 16:
PL/SQL: SQL Statement ignored
ORA-06550: line 128, column 8:
PLS-00364: loop index variable 'SCHEMA' use is invalid
0