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

PRUEBA001=(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp) (HOST=alberto.dominio.local) (PORT=1522)) (CONNECT_DATA= (SID=PRUEBA002TEST)) (HS=OK))
 

Cause.

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

Solution.

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.