OGG-00664 ORA-12154

Problem: EXTRACT (Capture and Propagation) ABENDED and next in gsserr.log:

ERROR OGG-00664 OCI Error beginning session (status = 12154-ORA-12154: TNS:could not resolve the connect identifier specified).

Identification:

I had this problem on windows 2008 sp2 machine after installation of new oracle's software on the server.

Solution:

Need adds to EXTRACT (Capture and Propagation) parameters' files the next line:

setenv (ORACLE_HOME="c:\oracle\product\11.2.0\db_1")