SAN:(SYS@pdb01):PRIMARY> @ggs_setup.sql

SAN:(SYS@pdb01):PRIMARY> alter session set container=pdb01;

alter session set container=pdb01

                  *

ERROR at line 1:

ORA-02248: invalid option for ALTER SESSION

SAN:(SYS@pdb01):PRIMARY> grant connect,resource,dba to ggs identified by ggs;

Grant succeeded.

SAN:(SYS@pdb01):PRIMARY> grant connect,resource,dba to gge identified by gge;

Grant succeeded.

SAN:(SYS@pdb01):PRIMARY> grant connect,resource,dba to ggr identified by ggr;

Grant succeeded.

SAN:(SYS@pdb01):PRIMARY> grant CREATE SESSION,ALTER SESSION,ALTER SYSTEM,SELECT ANY DICTIONARY,FLASHBACK ANY TABLE,SELECT ANY TABLE,SELECT ANY TRANSACTION to gge;

Grant succeeded.

SAN:(SYS@pdb01):PRIMARY> grant SELECT on dba_clusters to gge;

Grant succeeded.

SAN:(SYS@pdb01):PRIMARY> grant EXECUTE on DBMS_FLASHBACK to gge;

Grant succeeded.

SAN:(SYS@pdb01):PRIMARY> grant CREATE TABLE,LOCK ANY TABLE to ggr;

Grant succeeded.

SAN:(SYS@pdb01):PRIMARY> alter user gge default tablespace users;

User altered.

SAN:(SYS@pdb01):PRIMARY> alter user gge default tablespace users;

User altered.

SAN:(SYS@pdb01):PRIMARY> alter user ggs default tablespace ggs_data;

User altered.

SAN:(SYS@pdb01):PRIMARY> set echo off

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

GGS

Setting schema name to GGS

UPDATE_SEQUENCE STATUS:

Line/pos

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

Error

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

No errors

No errors

GETSEQFLUSH

Line/pos

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

Error

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

No errors

No errors

SEQTRACE

Line/pos

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

Error

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

No errors

No errors

REPLICATE_SEQUENCE STATUS:

Line/pos

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

Error

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

No errors

No errors

STATUS OF SEQUENCE SUPPORT

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

SUCCESSFUL installation of Oracle Sequence Replication support

Marker setup script

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

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

Marker setup table script complete, running verification script...

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

Setting schema name to GGS

MARKER TABLE

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

OK

MARKER SEQUENCE

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

OK

Script complete.

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

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 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

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

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

/u01/app/oracle/diag/rdbms/pdb01/pdb01/trace/ggs_ddl_trace.log

Analyzing installation status...

STATUS OF DDL REPLICATION

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

SUCCESSFUL installation of DDL Replication software components

Script complete.

GGS Role setup script

This script will drop and recreate the role GGS_GGSUSER_ROLE

To use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)

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

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

NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name:GGS

Wrote file role_setup_set.txt

PL/SQL procedure successfully completed.

Role setup script complete

Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:

GRANT GGS_GGSUSER_ROLE TO <loggedUser>

where <loggedUser> is the user assigned to the GoldenGate processes.

Trigger altered.

SAN:(SYS@pdb01):PRIMARY> GRANT GGS_GGSUSER_ROLE TO ggs;

Grant succeeded.

SAN:(SYS@pdb01):PRIMARY> GRANT GGS_GGSUSER_ROLE TO gge;

Grant succeeded.

SAN:(SYS@pdb01):PRIMARY> alter user gge default role all;

User altered.

SAN:(SYS@pdb01):PRIMARY> alter user gge default role all;

User altered.

SAN:(SYS@pdb01):PRIMARY> alter user ggs default role all;

User altered.

SAN:(SYS@pdb01):PRIMARY> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning and Automatic Storage Management options

oracle@san:pdb01:/u01/app/ggs01

>