"ORA-01005: null password given; logon denied" - Intermittent From SQL Server When Reconnecting (Doc ID 2293674.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Provider for OLE DB - Version 11.2.0.4 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms

Attempting to use the Oracle Provider for OLE DB to connect from Microsoft SQL Server SSMS and SSIS to an Oracle database connects successfully but intermittently disconnects and fails to reconnect with:

 

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