Issue while oracle database connect to sybase
[oracle@dbnode admin]$ sqlplus "/as sysdba"
SQL*Plus: Release 12.2.0.1.0 Production on
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production
SQL> alter session set container=DB1;
Session altered.
SQL> select * from dual@sybase_test1;
select * from dual@sybase_test1
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
[Oracle][ODBC Sybase Wire Protocol driver][Sybase ASE]Login Failed. Check for
valid user ID, server name and password. {28000,NativeErr = 4002}
ORA-02063: preceding 2 lines from sybase_test1
root cause:
sybase username password was invalidate which is used to connect to sybase database.
Solution:
1. connect sybase database and see if the user name password is working?
2. if it's not working then reset password.
3. update the password in db link
4. Retest issue
