Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
. Advertisement .
..3..
. Advertisement .
..4..
I get an error:
ORA-02019: connection description for remote database not foundwhen I try to run the following code:
SELECT * FROM [email protected]_ADMINHow to fix the ora 02019 connection description for remote database not found. Please give me some good ideas.
The cause: This error will occur when a database link is not made PUBLIC and the user who created the link is different from the person who is attempting to use the link.
For example, if you create the connection as the SYS account and then try to use it as the AM ADMIN user, you’ll get an error.
Solution: To solve this error, either make the link PUBLIC (so that all users may access) or give the AM ADMIN user permission to establish database links.
Your screenshot shows that you created the database link
AM_ADMIN.INT.xxxaccording to your screenshot. It is being called without the domain just like@AM_ADMIN. If you don’t have asqlnet.orathat definesnames.default_domainwith the exact domain value (and SQL Developer is configured to recognize that), then you will need to quality the link name before you use it.