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).


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


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

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