ORA-20783 *** Please move GGS_ADMIN to its own tablespace

ORA-20783  *** Please move GGS_ADMIN to its own tablespace

I’d been working on a newly refresh database and i need to enable ddl replication on our GG.

but i’m getting *** Please move GGS_ADMIN to its own tablespace

SQL> @ddl_setup.sql

Oracle 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 Oracle 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 Oracle GoldenGate schema name:ggs_admin

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.

declare
*
ERROR at line 1:
ORA-20783:
ORA-20783:
Oracle GoldenGate DDL Replication setup:
*** Please move GGS_ADMIN to its own tablespace
ORA-06512: at line 34

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

SQL>
I check the default table of ggs_admin

SQL> select username, default_tablespace from dba_users where username=’GGS_ADMIN’;
USERNAME                       DEFAULT_TABLESPACE          
—————————— ——————————
GGS_ADMIN                      GGS_DATA      

Then i have to check if other user is using GGS_DATA.

SQL> select USERNAME from dba_users where default_tablespace=’GGS_DATA’;

USERNAME                    
——————————
GGS_ADMIN
AQ_USER

SQL>

So i change the AQ_USER default tablespace to other DATA_GBL.

SQL> alter user aq_user default tablespace DATA_GBL;

User altered.

SQL>
so now no other user is using GGS_DATA

SQL> select USERNAME from dba_users where default_tablespace=’GGS_DATA’;

USERNAME
——————————
GGS_ADMIN

SQL>

now, executed again the @ddl_setup.sql and it worked.

SQL> @ddl_setup.sql

Oracle 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 Oracle 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 Oracle GoldenGate schema name:ggs_admin

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 GGS_ADMIN as a Oracle GoldenGate schema name.

Working, please wait …

DDL replication setup script complete, running verification script…
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGS_ADMIN

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 IGNORE TABLE
———————————–
OK

DDL IGNORE LOG TABLE
———————————–
OK

DDLAUX  PACKAGE STATUS:

Line/pos                                 Error
—————————————- —————————————————————–
No errors                                No errors

DDLAUX PACKAGE BODY STATUS:

Line/pos                                 Error
—————————————- —————————————————————–
No errors                                No errors

SYS.DDLCTXINFO  PACKAGE STATUS:

Line/pos                                 Error
—————————————- —————————————————————–
No errors                                No errors

SYS.DDLCTXINFO  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
————————————————————————————————————————
/optware/oracle/diag/rdbms/cxxxnm2s/CXXXNM2S/trace/ggs_ddl_trace.log

Analyzing installation status…

STATUS OF DDL REPLICATION
————————————————————————————————————————
SUCCESSFUL installation of DDL Replication software components

Script complete.
SQL>

  • September 11, 2017 | 13 views
  • Comments