database link

[Roshan]

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

[ErmanArslansOracleBlog]

password file is irrelevant.
Did you create your db link with the correct user and its password?
Send me your db link  creation script.

[ErmanArslansOracleBlog]

Bythe way; check this -> 207303.1

[ErmanArslansOracleBlog]

Anyways, it is not supported.

For database links between different Oracle versions connections must be supported in BOTH directions

Well. You should try putting an intermediate db in the middle.

Read my blog post below...  I explained it there.

http://ermanarslan.blogspot.com.tr/2015/01/rdbms-oracle-client-server-dblink.html

[Roshan]

Thanks for update.

I checked the link.

I have setup intermediate database as 10g. I have created the database link which points source(9i) to 10g database.

select * from dual@abcd
                   *
ERROR at line 1:
ORA-12537: TNS:connection closed

I am able to tnsping the intermediate DB.

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.29.228)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PMTCC01)))
OK (0 msec)

[ErmanArslansOracleBlog]

 Check whether the TCP.VALIDNODE_CHECKING is active on that database server.

If it is active then check whether IP address of the failing client is added in the TCP.INVITED_NODES list (located in the sqlnet.ora file). If not add the same. (or just disable the TCP validnode checking)

[Roshan]

Thanks Erman. It is working now. I have used another instance with 10g database as intermediate between the 9i and 12c.

[ErmanArslansOracleBlog]

Good Roshan.