Archive for January, 2010

Oracle database link error: ORA-01017: invalid username/password; logon denied

Monday, January 11th, 2010

Today I create a database link in Oracle as follows CREATE DATABASE LINK DATABASE_LINK1 CONNECT TO SCOTT IDENTIFIED BY TIGER USING 'PDTT'; When I try to use the link I get an error. select * from dual@DATABASE_LINK1; SQL Error: ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from DATABASE_LINK1 01017. 00000 -  "invalid username/password; logon denied" At first I ...