DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, July 13, 2017

OGG-02550 ORACLE_HOME is not set to Oracle software directory.



2016-03-10 15:14:32  ERROR   OGG-02550  ORACLE_HOME is not set to Oracle software directory.

2016-03-10 15:14:32  ERROR   OGG-01668  PROCESS ABENDING.

GGSCI (dbhost02.domain.com) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     DPUMP1      00:00:00      00:00:04
EXTRACT     STOPPED     EXT1        00:00:00      00:19:06
REPLICAT    RUNNING     REP2        00:00:00      00:00:08

GGSCI (dbhost02.domain.com) 6> view params EXT1

EXTRACT ext1
USERID gguser, PASSWORD ora123
EXTTRAIL /u02/app/oracle/product/12.1.0/oggcore_1/dirdat/aa
TRANLOGOPTIONS EXCLUDEUSER gguser
TABLE app.emp;
DDL INCLUDE MAPPED

Please note that if you have one GoldenGate installation for multiple databases this will not be possible and you will have to set those variables in the extract and replicat processes directly using:

SETENV (ORACLE_HOME = "path to Oracle home location")
SETENV (ORACLE_SID = "SID")


EXTRACT ext1
USERID gguser, PASSWORD ora123
EXTTRAIL /u02/app/oracle/product/12.1.0/oggcore_1/dirdat/aa
TRANLOGOPTIONS EXCLUDEUSER gguser
TABLE app.emp;
SETENV (ORACLE_HOME = "/u02/app/oracle/product/12.1.0/dbhome_1")
SETENV (ORACLE_SID = "ORAGG1")
DDL INCLUDE MAPPED

After adding the variable to restart the extract process.

GGSCI (dbhost02.domain.com) 7> start EXT1

GGSCI (dbhost02.domain.com) 8> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     DPUMP1      00:00:00      00:00:04
EXTRACT     RUNNING     EXT1        00:00:00      00:19:06
REPLICAT    RUNNING     REP2        00:00:00      00:00:08

No comments: