Cannot Initialize the Data Source Object of OLE DB Provider "OraOLEDB.ORACLE" for Linked Server: ORA-01012 (Doc ID 1385668.1)

Last updated on JULY 05, 2017

Applies to:

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

***Checked for relevance on 03-Apr-2017***


Symptoms

You are using the Oracle Provider for OLE DB to create a SQL Server Linked Server and receive the following error:

Cannot initialize the data source object of OLE DB Provider "OraOLEDB.ORACLE" for linked server "<NameOfLinkedServer>". OLE DB Provider "OraOLEDB.ORACLE" for linked server "<NameOfLinkedServer>" returned message "ORA-01012: not logged on". (Microsoft SQL Server, Error: 7303)

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