Ask the Expert

Configuring the TNSNAMES.ORA file

This is my first time working with Oracle. I have nine XP machines that will not log on to our database running Oracle 8i. I receive the 12154 TNS error, "cannot resolve service name." I was reading your advice on the TNSNAMES.ORA file. How do I configure it? Is this too vague?

    Requires Free Membership to View

The easiest way to configure the TNSNAMES.ORA file, for those not used to managing them, is to run the Net Configuration Assitant GUI tool provided with your Oracle client software. Fire it up and choose the option to configure a new TNS entry. You will need to know your database server's name, the port of that server's Oracle Listener and the database SID. Fill in the blanks with that information and the wizard will do the rest for you.

This was first published in September 2005

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: