Ask the Expert

Can't resolve service name in 9i

I have a problem installing and running an Oracle9i database. I installed Oracle9i successfully on Win2000 and made a database and installed tnsnames and listener files, but I can't connect to it. I receive this message: Could not resolve service name.

    Requires Free Membership to View

The problem appears to be that you do not have an appropriate entry in tnsnames for the instance you're trying to connect to. Make sure that the entry you have in tnsnames matches exactly the name you're using when you try to connect. For instance, if you're trying to connect to an instance "test", then the entry in tnsnames must be called "test".

This was first published in March 2004

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: