Avoid using quotes and case sensitivities if you can.
1. Replace double quote with single quote.
Change reference is GETENV statement to use single quotes rather than double quotes, as example is :
2. Specify NOUSEANSISQLQUOTES in GLOBALS parameter.
The default is now USEANSISQLQUOTES.
When capturing and mapping object names, such as table names, Oracle GoldenGate always recognizes double-quoted strings as case-sensitive object names,
regardless of whether USEANSISQLQUOTES or NOUSEANSISQLQUOTES is specified.
With USEANSISQLQUOTES enabled, Oracle GoldenGate treats a string within double quotes as a case-sensitive column name, and it treats a string within single quotes as a literal.
Oracle GoldenGate Command Interpreter for Oracle Version 184.108.40.206.1 OGGCORE_220.127.116.11.0_PLATFORMS_151211.1401_FBO Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38 Operating system character set identified as UTF-8. Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (arrow.localdomain) 1> INFO CREDENTIALSTORE
Reading from ./dircrd/: Default domain: OracleGoldenGate Alias: ggs_user Userid: ggs_admin Other domains: admin To view other domains, use INFO CREDENTIALSTORE DOMAIN
GGSCI (arrow.localdomain) 2> DBLOGIN USERIDALIAS GGS_USER
ERROR: Alias 'GGS_USER' not found in credential store..
GGSCI (arrow.localdomain) 3> DBLOGIN USERIDALIAS ggs_user
Successfully logged into database.