[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

Error ORA-01017 on Oracle Database Gateway dblink



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019

Error ORA-01017 on Oracle Database Gateway dblink.

Applies to: Oracle Database Gateway, Oracle Database Link, Microsoft SQL Server Standard.

Date created: October 9, 2019.

Problem Description.

Trying to create an Oracle dblink (Database Link) using Oracle Database Gateway to connect an Oracle database server to a database located on a Microsoft SQL Server instance, we decided to test using below statement:

SQL> select sysdate from dual@DOMINIOCOOP;

select sysdate from dual@DOMINIOCOOP


But the test was not successful, and we received the following error:

ERROR at line 1:

ORA-01017: invalid username/password; logon denied

[Oracle][ODBC SQL Server Driver][SQL Server]Login failed for user 'ORACLE'.

{28000,NativeErr = 18456}[Oracle][ODBC SQL Server Driver]Invalid connection

string attribute {01S00}

ORA-02063: preceding 2 lines from DOMINIOCOOP




The name of the login on the SQL Server instance is not correct or the password associated with the login is not correct.


We changed the password of the Oracle login on the SQL Server instance and that did the trick.

Create the login if it does not exist on the SQL Server instance.




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