Document Type | Troubleshooting
Category | Interface/Integration
Document Number | TIITS012
Issue
When configuring a DB Link from Tibero to Oracle (hereafter T to O), an ORA-01017: invalid username/password; logon denied error may occur.
SQL> create database link ora_link2 connect to system identified by "facc4036" using 'gw_orcl'; Database Link 'ORA_LINK2' created. SQL> select * from dual@ora_link2; TBR-12044: Unable to connect to remote database. TBR-15103:(ORA-01017) invalid username/password; logon denied
Cause
When creating the DB Link, if the Oracle user's password is enclosed in double quotes ("), Oracle treats the password as case-sensitive, causing the authentication information not to match the actual password, resulting in the ORA-01017 error.
Solutions
When specifying the password, if you enclose it in single quotes ('), Oracle recognizes the password as plain text, allowing the connection through the DB Link to proceed normally.
SQL> create database link ora_link connect to system identified by 'facc4036' using 'gw_orcl'; Database Link 'ORA_LINK' created. SQL> select * from dual@ora_link; DUMMY ----- X 1 row selected.
Caution
When creating the DB LINK object, be careful to use the correct password of the target Oracle user for the connection.