[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Linked Server Error ORA-01017

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Linked Server Error ORA-01017.


Applies to: SQL Server 2008 R2.
 

Problem Description.
 

While trying to query an Oracle linked server via the OPENQUERY function, we received the following error:

OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServerName" returned message "ORA-01017: invalid username/password; logon denied".

Error: 7303, Severity: 16, State: 1.

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServerName".

 

Cause.


On the Oracle database server, the password of the remote login account used on the Linked Server to connect to Oracle was changed.


Solution.


Make a right click on the linked server and select "Properties", then on the "Select a page" panel click on Security and provide the new password for the "Remote login".



 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.