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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Dec 19 2017
Added on Nov 21 2017
2 comments
2,227 views