Issues With The GG Scripts Generated From ORMBA While Running ImportData.sh
(Doc ID 2716724.1)
Last updated on OCTOBER 12, 2020
Applies to:Oracle Financial Services Revenue Management and Billing Analytics - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On ORMBA v220.127.116.11.0, Multiple issues with the GG scripts generated from ORMBA while running importData.sh.
1. Need flexibility to specify separate KP standard locations for GG binary files and Trail/Discard/Report files in ormba.properties file (which is being referred for generating GG scripts). Currently from ORMBA, the GG scripts are generated by assuming that Trail file, discard file, etc. will be created in the Source and Target GG_HOME itself.
Per KP standards we keep GG Binaries files only on /acfsdata but all GG Trail files must land on ZFS/NFS path. ZFS is multi-racked between multiple Exadata rack(s) on infiniband/IB and we can take advantage of IB speed. The DBFS based /acfsdata is available only within a Exadata rack but not across two Exadata boxes.
2. GG Scripts generated are non-compatible for clustered environments. In case of RAC, instead of an absolute host/ip, its the service name that should be used as the service will be running on more than one hosts.
3. Currently in the GG scripts generated from ORMBA product, it uses OGG_HOME/dirdat as the Discard files path in source and OGG_HOME/dirrpt in target.
For item#1, We need to have a provision to specify a path for generating trail files which can be different from GG home. This could be an optional property in which case if its not specified, it will behave as is.
#2. A provision to use Service name instead of hostname:port/Servicename should be available.
#3. Needs to use same folder for discard files in both source and target to avoid KP inconsistency.
The issue has the following business impact:
Due to incorrect values in the GG scripts generated from ORMBA, Infra guys had to manually correct them in each of the ORMBA environments like DEV, UAT, PROD, etc. which is time consuming.
Same activity will have to be done by Infra guys on any further maintenance on the GG Processes.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document