EXPERT RESPONSE
You do not need to restart the database to fix your
problem. But you must correctly configure your
TNSNAMES.ORA file. One thing that people don't
understand about database links is that it will only
look in $ORACLE_HOME/network/admin for a TNSNAMES.ORA
file. And this file must reside on the server that the
database is running! So correctly configure this file
in this location for your database links. I always
test database links by issuing the following query:
SELECT sysdate FROM dual@remotedb;
If I get the results back, then the link is working
fine. Otherwise, fix the corresponding error.
For More Information
|
