Extract Abends With Error OGG-00551 Database Operation Failed: Couldn't Connect ODBC error: SQLSTATE 37000 native database error 4060. (Doc ID 1633138.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 10-Feb-2016

Symptoms

ERROR OGG-00551 Database operation failed: Couldn't connect to ogg. ODBC error: SQLSTATE 37000 native database error 4060. [Microsoft][SQL Server Native Client 11.0][SQL Server]Can not open database "ogg" requested by the login. Login Failure.


dblogin sourcedb OGGTEST  and Add trandata works fine. Also extract can run from command prompt and when manager is not installed as service

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms