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