database link

[Roshan]

Oracle Database 11g

Hello Erman,

I am testing a database link. I am getting


SQL> select sysdate from dual@NEMO;
select sysdate from dual@NEMO
                         *
ERROR at line 1:
ORA-02019: connection description for remote database not found



How can I check the database link?

Regards,

Roshan

[ErmanArslansOracleBlog]

Check your database server's tnsnames.ora file.
The defitinion for NEMO must be there. If not, then you need to add the corresponding tns entry to your database server's tnsnames.ora file.