Oracle Database Blog‎ > ‎Golden Gate‎ > ‎OGG Errors‎ > ‎

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