Before making new changes, I did some connection testing to the remote database such as sqlplus connection and it seemed to work fine. I don't think we need to change anything in tnsnames.ora on the remote database. Are there any other verifications we can do to clarify the problem? It seems like Oracle database link process got confused.



On local host, PSDEV8:

$ sqlplus sysadm/peanut@pstest

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Aug 28 15:14:40 2001

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8 Enterprise Edition Release 8.0.5.2.2 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.2.1 - Production


SQL_PSTEST>