While running below script...getting it's stuck up....so I export the below parameters for the environment.
This below script should run under golden gate directory
SQL>conn / as sysdba
SQL>@/ora/oracle/ggs12/marker_setup.sql
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:gguser
....
....
....
....
....
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:ggate Marker setup table script complete, running verification script... SP2-0310: unable to open file "marker_status.sql" Script complete.
bash-4.1$ echo $ORACLE_HOME
/ora/oracle/app/oracle/product/12.1.0/dbhome_1
bash-4.1$ export ORACLE_HOME=/ora/oracle/app/oracle/product/12.1.0/dbhome_1
bash-4.1$ export PATH=$ORACLE_HOME/bin:$PATH
bash-4.1$ export ORACLE_SID=orasap
bash-4.1$ export PATH=/ora/oracle/ggs12:$PATH
bash-4.1$ export LD_LIBRARY_PATH=/ora/oracle/ggs12:$ORACLE_HOME/lib
bash-4.1$ pwd
/ora/oracle/ggs12
bash-4.1$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sat May 2 02:52:47 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> !pwd
/ora/oracle/ggs12
SQL> @marker_setup.sql
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:gguser
Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGUSER
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
Script complete.
No comments:
Post a Comment