Attempting to Connect Using the Oracle Provider for OLE DB from an Application or UDL File Fails With: ORA-1804: Failure to Initialize Timezone Information

(Doc ID 1357422.1)

Last updated on JULY 22, 2017

Applies to:

Oracle Provider for OLE DB - Version 11.2.0.1 and later
Information in this document applies to any platform.

***Checked for relevance on 22-Jul-2017***

Symptoms

Attempting to connect to the database using the Oracle Provider for OLEDB from an application or UDL file fails with:

ORA-1804: Failure to Initialize Timezone Information

Attempting to connect to the database using the Oracle ODBC driver from an application or the test connection button of the ODBC administrator tool also fails with:

Unable to connect
SQLState=IM0004
[Microsoft][ODBC driver Manager] Driver's SQLAllocHandle failed on SQL_HANDLE_ENV failed

Starting SQL PLUS fails with:

P2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Changes

None Known.

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