So, I've been running this script and ran into a bit of a snag. No worries though, I managed to sort it out by setting some environment parameters. This script is supposed to work under the Golden Gate directory.
I fired up an SQL session as the system DBA:
SQL> conn / as sysdbaSQL>@/ora/oracle/ggs12/marker_setup.sql
This triggers a script for setting up markers. It asks for the name of a schema for the Oracle GoldenGate database objects. Just make sure you've created the schema before running this script, and don't forget to stop all DDL replication before getting started.
Here's a snippet of how the interaction goes:
Enter Oracle GoldenGate schema name: gguser.........Enter Oracle GoldenGate schema name: ggate
After all that, it finishes up with the message:Marker setup table script complete, running verification script...SP2-0310: unable to open file "marker_status.sql"Script complete.
Now, for the command-line part, I did a few exports to set up the environment correctly. Check it out:
$ echo $ORACLE_HOME/ora/oracle/app/oracle/product/12.1.0/dbhome_1$ export ORACLE_HOME=/ora/oracle/app/oracle/product/12.1.0/dbhome_1$ export PATH=$ORACLE_HOME/bin:$PATH$ export ORACLE_SID=orasap$ export PATH=/ora/oracle/ggs12:$PATH$ export LD_LIBRARY_PATH=/ora/oracle/ggs12:$ORACLE_HOME/lib$ pwd/ora/oracle/ggs12
Then I hopped into SQLPlus:
SQL*Plus: Release 22.214.171.124.0 Production on Sat May 2 02:52:47 2020Connected to:Oracle Database 12c Enterprise Edition Release 126.96.36.199.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics, and Real Application Testing optionsSQL> !pwd/ora/oracle/ggs12SQL> @marker_setup.sql
Again, it prompts for the GoldenGate schema name, so just provide that. Once you've got that set, it completes the process with a success message:
Marker setup table script complete, running verification script...Please enter the name of a schema for the GoldenGate database objects:Setting schema name to GGUSERMARKER TABLE-------------------------------OKMARKER SEQUENCE-------------------------------OKScript complete.
Hope that helps you out! Let me know if you need more assistance.