Ask the Expert

ORA-12514 error when connecting to the Oracle database through Toad

When I am trying to connect to the Oracle database through Toad, I am getting the error ORA:12514 TNS: listener does not currently know service requested in connect descriptor. Can you help me?

    Requires Free Membership to View

You need to look at your database listener's properties. On your database server, do "lsnrctl status". It will list the services the listener supports. The ORA-12514 error is saying that you specified a service that the listener knows nothing about.

This was first published in May 2009

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: