database link

Posted by Roshan on Jul 17, 2017; 11:53am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/database-link-tp2964.html

Hi Erman,

source DB: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit
target DB: 12.1.0.2

I have created a database link using:
create public database link cbs connect to cbs_view identified by E2dslksw using 'cbsprod';

Username and password are both ok

DB link points to 12.1.0.2 database.

Test results are shown below:
from tmp_int_auto_debit_log@CBS
                            *
ERROR at line 5:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from CBS


from tmp_int_auto_debit_log@CBS
                            *
ERROR at line 9:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from CBS


from tmp_int_auto_debit_log@CBS
                            *
ERROR at line 5:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from CBS

Is the password file causing the issue?

Regards,
Roshan