Skip to Main Content

Golden Gate OGG-05263 No GGSCHEMA clause was specified in the GLOBALS file.

FreiburgBillNov 21 2017 — edited Nov 21 2017

In OTN I am using these instructions to "try" and configure GoldenGate with a MSSQL Source DB to an Oracle12c Target DB

http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-goldengate-460262.html

Replicating Transactions Between Microsoft SQL Server and Oracle Database Using Oracle GoldenGate

Everything goes okay up till the command:

GGSCI (MSSQL) 2> ADD TRANDATA HRSCHEMA.EMP

Where I get the error:

ERROR   OGG-05263  No GGSCHEMA clause was specified in the GLOBALS file. Please specify a GGSCHEMA shema name.

I searched and saw that currently there was no "GLOBALS" file.   So I created one:

F:\GG\dirprm\globals.prm

And added one line:

GGSCHEMA hrschema

That did not help. 

Still getting the same error.

Any suggestions?

Are there GoldenGate Environment variables that I need to have??

Thank-you in advace for your help.

Bill

Comments
Post Details
Added on Nov 21 2017
2 comments
2,194 views