ORA-20783：RECYCLEBIN must be turned off

denglj

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

SQL>@ddl_setup.sql;

GoldenGateDDL Replication setup script

Verifyingthat current user has privileges to install DDL Replication...

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

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

NOTE: Theschema must be created prior to running this script.

NOTE:Stop all DDL replication before starting this installation.

EnterGoldenGate schema name:ogg

You willbe prompted for the mode of installation.

Toinstall or reinstall DDL replication, enter INITIALSETUP

Toupgrade DDL replication, enter NORMAL

Entermode of installation:INITIALSETUP

Working,please wait ...

Spoolingto file ddl_setup_spool.txt

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

Checkcomplete.

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

Working,please wait ...

BEGIN

*

ERROR atline 1:

ORA-20783:

GoldenGateDDL Replication setup:

***RECYCLEBIN must be turned off.

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

restartdatabase and installation.

ORA-06512:at line 19

Disconnectedfrom Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bitProduction

With thePartitioning, OLAP, Data Mining and Real Application Testing options

异常原因：

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

解决过程：

SQL>show parameter recyclebin

NAME                                 TYPE        VALUE

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

recyclebin                           string      on

SQL>alter system set recyclebin=off;

Systemaltered.

SQL>show parameter recyclebin

NAME                                 TYPE        VALUE

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

recyclebin                           string      OFF

SQL>@ddl_setup.sql;

GoldenGateDDL Replication setup script

Verifyingthat current user has privileges to install DDL Replication...

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

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

NOTE: Theschema must be created prior to running this script.

NOTE:Stop all DDL replication before starting this installation.

Enter GoldenGateschema name:ogg

You willbe prompted for the mode of installation.

Toinstall or reinstall DDL replication, enter INITIALSETUP

Toupgrade DDL replication, enter NORMAL

Entermode of installation:INITIALSETUP

Working,please wait ...

Spoolingto file ddl_setup_spool.txt

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

Checkcomplete.

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

Working,please wait ...

RECYCLEBINmust be empty.

Thisinstallation will purge RECYCLEBIN for all users.

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

Enter yesor no:yes

DDLreplication setup script complete, running verification script...

Pleaseenter the name of a schema for the GoldenGate database objects:

Settingschema name to OGG

DDLORA_GETTABLESPACESIZESTATUS:

Line/pos                                 Error

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

Noerrors                                No errors

CLEAR_TRACESTATUS:

Line/pos                                 Error

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

Noerrors                                Noerrors

CREATE_TRACESTATUS:

Line/pos                                 Error

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

Noerrors                                Noerrors

TRACE_PUT_LINESTATUS:

Line/pos                                 Error

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

Noerrors                                Noerrors

INITIAL_SETUPSTATUS:

Line/pos                                 Error

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

Noerrors                                Noerrors

DDLVERSIONSPECIFICPACKAGE STATUS:

Line/pos                                 Error

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

Noerrors                                Noerrors

DDLREPLICATIONPACKAGE STATUS:

Line/pos                                 Error

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

Noerrors                                Noerrors

DDLREPLICATIONPACKAGE BODY STATUS:

Line/pos                                 Error

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

Noerrors                                Noerrors

DDLHISTORY TABLE

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

OK

DDLHISTORY TABLE(1)

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

OK

DDL DUMPTABLES

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

OK

DDL DUMPCOLUMNS

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

OK

DDL DUMPLOG GROUPS

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

OK

DDL DUMPPARTITIONS

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

OK

DDL DUMP PRIMARYKEYS

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

OK

DDLSEQUENCE

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

OK

GGS_TEMP_COLS

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

OK

GGS_TEMP_UK

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

OK

DDLTRIGGER CODE STATUS:

Line/pos                                 Error

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

Noerrors                                Noerrors

DDLTRIGGER INSTALL STATUS

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

OK

DDLTRIGGER RUNNING STATUS

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

ENABLED

STAYMETADATAIN TRIGGER

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

OFF

DDLTRIGGER SQL TRACING

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

0

DDLTRIGGER TRACE LEVEL

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

0

LOCATIONOF DDL TRACE FILE

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

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

Analyzinginstallation status...

STATUS OFDDL REPLICATION

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

SUCCESSFULinstallation of DDL Replication software components

Scriptcomplete.

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