@marker_remove.sql fails with "*** Currently logged user does not have SYSDBA privileges!" (Doc ID 1594311.1)

Last updated on JULY 03, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

While performing DDL setup, running marker_remove.sql script fails with ORA-20783: "*** Currently logged user does not have SYSDBA privileges!"

$ sqlplus / as sysdba

SQL> @marker_remove

Marker removal script.
WARNING: this script removes all marker objects and data.

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.

Enter Oracle GoldenGate schema name:OGG
BEGIN
*
ERROR at line 1:
ORA-20783:
Oracle GoldenGate DDL Replication setup:
*** Currently logged user does not have SYSDBA privileges!
*** Please login as SYSDBA.
ORA-06512: at line 10

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms