Use dblink to show ORA-01017

The local Oracle database version is 10 Gb, and the remote database version is 11 GB. An error occurred while executing the test query statement after the local database connection was created. The user name and password are correct.

SQL> create database link DBLINK_TEST
Connect to test identified by test
Using '10. 10.15.25 _ 11 ';
The database link has been created.

SQL> select count (*) from remote_big_tab @ DBLINK_TEST;

Select count (*) from remote_big_tab @ DBLINK_TEST
*
Row 3 has an error:
ORA-01017: invalid username/password; logon denied

ORA-02063: followed by line (from DBLINK_TEST)

You can use PL/SQL developer to view the database connection definition. The original user name/password is changed to uppercase, so you can change the method to create it.

SQL> drop database link DBLINK_TEST;
The database link has been deleted.
SQL> create database link DBLINK_TEST
Connect to "test" identified by "test"
Using '10. 10.15.25 _ 11 ';
The database link has been created.
SQL> select count (*) from remote_big_tab @ DBLINK_TEST;
COUNT (*)
----------
1155648

For more details, please continue to read the highlights on the next page:

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store