Database Connection Not Open (Doc ID 403108.1)

Last updated on MARCH 08, 2017

Applies to:

COREid Identity - Version: 10.1.4 and later   [Release: 10g and later ]
Information in this document applies to any platform.
Checked for relevance on 11-Apr-2010

Symptoms

ODBC Database Connection was successfull.   But Database instance in OAM failed. 

The following error are shown  in the oblogs when Identity Server is trying to make connection.

2006/12/01@14:46:01.067000 3360 2332 SQL_ADAPTER WARNING 0x0000004C
odbcconnection.cpp:162
Could not connect to the database server
Requested connection string^DSN=doam;UID=audit_user;PWD=audit123
2006/12/01@14:46:01.067000 3360 2332 SQL_ADAPTER ERROR 0x0000004C odbcerrormap.
cpp:296
Could not connect to the database server
Error from^ODBCConnection::ODBCConnection()
SQLSTATE^IM004
Native ErrorCode^0
Server Message^[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on
SQL_HANDLE_ENV failed
2006/12/01@14:46:01.067000 3360 2332 SQL_ADAPTER WARNING 0x0000004D
odbcerrormap.cpp:340
SQL disconnect failed
Error from^ODBCConnection::~ODBCConnection()
SQLSTATE^08003
Native ErrorCode^0
Server Message^[Microsoft][ODBC Driver Manager] Connection not open

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