oracle 10.2.0.4安装ogg执行ddl_setup.sql时，报警“ORA-20783：RECYCLEBIN must be turned off”

问题描述：oracle 10.2.0.4安装ogg执行ddl_setup.sql时，报警“ORA-20783：RECYCLEBIN must be turned off”，如下所示：

SQL> @ddl_setup.sql;

 

GoldenGate DDL Replication setup script

 

Verifying that current user has privileges to install DDL Replication...

 

You will be prompted for the name of a schema for the GoldenGate database objects.

NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.

NOTE: The schema must be created prior to running this script.

NOTE: Stop all DDL replication before starting this installation.

 

Enter GoldenGate schema name:ogg

 

You will be prompted for the mode of installation.

To install or reinstall DDL replication, enter INITIALSETUP

To upgrade DDL replication, enter NORMAL

Enter mode of installation:INITIALSETUP

 

Working, please wait ...

Spooling to file ddl_setup_spool.txt

 

Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...

 

Check complete.

 

Using OGG as a GoldenGate schema name, INITIALSETUP as a mode of installation.

 

Working, please wait ...

BEGIN

*

ERROR at line 1:

ORA-20783:

GoldenGate DDL Replication setup:

*** RECYCLEBIN must be turned off.

*** For 10gr2, set RECYCLEBIN in parameter file to OFF. For 10gr1, set _RECYCLEBIN in parameter file to FALSE. Then

restart database and installation.

ORA-06512: at line 19

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

异常原因：

根据提示可知，10gr2执行DDL Replication设置时，recyclebin需要关闭.

解决过程：

SQL> show parameter recyclebin

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

recyclebin                           string      on

SQL> alter system set recyclebin=off;

 

System altered.

 

SQL> show parameter recyclebin

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

recyclebin                           string      OFF

SQL> @ddl_setup.sql;

 

GoldenGate DDL Replication setup script

 

Verifying that current user has privileges to install DDL Replication...

 

You will be prompted for the name of a schema for the GoldenGate database objects.

NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.

NOTE: The schema must be created prior to running this script.

NOTE: Stop all DDL replication before starting this installation.

 

Enter GoldenGate schema name:ogg

 

You will be prompted for the mode of installation.

To install or reinstall DDL replication, enter INITIALSETUP

To upgrade DDL replication, enter NORMAL

Enter mode of installation:INITIALSETUP

 

Working, please wait ...

Spooling to file ddl_setup_spool.txt

 

Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...

 

Check complete.

Using OGG as a GoldenGate schema name, INITIALSETUP as a mode of installation.

 

Working, please wait ...

 

RECYCLEBIN must be empty.

This installation will purge RECYCLEBIN for all users.

To proceed, enter yes. To stop installation, enter no.

 

Enter yes or no:yes

 

 

DDL replication setup script complete, running verification script...

Please enter the name of a schema for the GoldenGate database objects:

Setting schema name to OGG

 

DDLORA_GETTABLESPACESIZE STATUS:

 

Line/pos                                 Error

---------------------------------------- -----------------------------------------------------------------

No errors                                No errors

 

CLEAR_TRACE STATUS:

 

Line/pos                                 Error

---------------------------------------- -----------------------------------------------------------------

No errors                                No errors

 

CREATE_TRACE STATUS:

 

Line/pos                                 Error

---------------------------------------- -----------------------------------------------------------------

No errors                                No errors

 

TRACE_PUT_LINE STATUS:

 

Line/pos                                 Error

---------------------------------------- -----------------------------------------------------------------

No errors                                No errors

 

INITIAL_SETUP STATUS:

 

Line/pos                                 Error

---------------------------------------- -----------------------------------------------------------------

No errors                                No errors

 

DDLVERSIONSPECIFIC PACKAGE STATUS:

 

Line/pos                                 Error

---------------------------------------- -----------------------------------------------------------------

No errors                                No errors

 

DDLREPLICATION PACKAGE STATUS:

 

Line/pos                                 Error

---------------------------------------- -----------------------------------------------------------------

No errors                                No errors

 

DDLREPLICATION PACKAGE BODY STATUS:

 

Line/pos                                 Error

---------------------------------------- -----------------------------------------------------------------

No errors                                No errors

 

DDL HISTORY TABLE

-----------------------------------

OK

 

DDL HISTORY TABLE(1)

-----------------------------------

OK

 

DDL DUMP TABLES

-----------------------------------

OK

 

DDL DUMP COLUMNS

-----------------------------------

OK

 

DDL DUMP LOG GROUPS

-----------------------------------

OK

 

DDL DUMP PARTITIONS

-----------------------------------

OK

 

DDL DUMP PRIMARY KEYS

-----------------------------------

OK

 

DDL SEQUENCE

-----------------------------------

OK

 

GGS_TEMP_COLS

-----------------------------------

OK

 

GGS_TEMP_UK

-----------------------------------

OK

 

DDL TRIGGER CODE STATUS:

 

Line/pos                                 Error

---------------------------------------- -----------------------------------------------------------------

No errors                                No errors

DDL TRIGGER INSTALL STATUS

-----------------------------------

OK

DDL TRIGGER RUNNING STATUS

------------------------------------------------------------------------------------------------------------------------

ENABLED 

STAYMETADATA IN TRIGGER

------------------------------------------------------------------------------------------------------------------------

OFF

DDL TRIGGER SQL TRACING

------------------------------------------------------------------------------------------------------------------------

0

DDL TRIGGER TRACE LEVEL

------------------------------------------------------------------------------------------------------------------------

0

LOCATION OF DDL TRACE FILE

------------------------------------------------------------------------------------------------------------------------

/u01/app/oracle/admin/orcl/udump/ggs_ddl_trace.log

 

Analyzing installation status...

 

STATUS OF DDL REPLICATION

------------------------------------------------------------------------------------------------------------------------

SUCCESSFUL installation of DDL Replication software components

Script complete.

说明：如上所示，关闭recyclebin之后，ddl_setup.sql成功执行.