Hi Experts,
Getting below error's while accessing remote table using db link.
-------- -----------------------------------------------------------------
0/0 ORA-04052: error occurred when looking up remote object
ORA-00604: error occurred at recursive SQL level 1
ORA-03150: end-of-file on communication channel for database link
ORA-02063: preceding line from
For your information we have tested tns ping from the remote database it's working fine, but when we test db link ping its given below error
SQL> select * from dual@elitewifi_duaaa2
2 ;
select * from dual@elitewifi_duaaa2
ERROR at line 1:
ORA-03150: end-of-file on communication channel for database link
ORA-02063: preceding line from ELITEWIFI_DUAAA2
But same thing we can achieve by below steps;
=====================================
SQL> set transaction read only;
Transaction set.
SQL> select * from dual@elitewifi_duaaa2;
D
-
X
SQL>
Could you please help in this matter why db link not working without SET TRANSACTION READ ONLY statments,
Environment info::
Oracle 11gr2 two nodes RAC :
Local DB version (2 Node RAC)
==============
11.2.0.4.0
Remote DB version (2 node RAC)
================
11.2.0.3.0