I have a client who upgraded their windows 2003 server to Oracle 11g. They previously had Oracle 9.2.0.4. When they had 9.2.0.4 they created a database link from 9.2.0.4 to a 10g database running on Solaris 9. Except for an occasional SQL exception in TEMS_LOAD: ORA-02049: timeout: distributed transaction waiting for lock error there were no problems. After upgrading from 9.2.0.4 to 11g they created a database link from 11g to 10g the same exact way they did it for the 9.2.0.4 to 10g database. However, they have been unable to establish the database link. Can someone tell me what kind of questions I can ask to help them troubleshoot this issue and any relevant Oracle documentation
go to an OS prompt and try this... (all one line)
tnsping (DESCRIPTION=(ADDRESS=(PRO
if that doesn't return or has a very long time then try...
ping 000.000.00.128
see where the timing lag is coming from.