Visit Counter

Friday, May 1, 2020

SP2-0310: unable to open file "marker_status.sql"




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