Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

hwo to configure TNSNAMES.ORA file

Posted on 2009-05-11
8
Medium Priority
?
3,520 Views
Last Modified: 2012-05-06
Hi experts,

                  Can someone please guide me with the easiest way to configure TNSNAMES.ORA file for oracle client.
0
Comment
Question by:aman0711
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 2000 total points
ID: 24355267
1) Using netca command from client box
2) Copy the one below and change CAT to your SID and the IP address to your host
CAT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = my_ip_address)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = CAT)
    )
  )

Open in new window

0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24355275
Clarification, you can do 1 or the other above, no need to do both, however it is a good idea to learn how to run netca, as it will help you configure other naming services and the listener as well, when needed.
0
 
LVL 10

Author Comment

by:aman0711
ID: 24355306
Hi mrjoltcola,
                         I am very new to this, as you already know :-)

                        As you suggested me in my other questiong (Oracle ODBC connection), I downloaded the oracle client on my machine.

                          Using netca command? where exactly I need to give that command?

                      In the second method, you meant, copy the contents and edit the TNSNAMES.ora present in Oracle_home/network/admin?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 40

Assisted Solution

by:mrjoltcola
mrjoltcola earned 2000 total points
ID: 24355493
netca is an Oracle program. Install the Oracle client, it will add Oracle programs to your PATH, then you can just type netca at the command prompt on Windows

Easiest route is not to run netca, just copy the TNSNAMES.ORA file I gave.

Your TNSNAMES.ORA file should be copied to the {ORACLE_HOME}/network/admin directory, this is created when you install Oracle client and you should note it down.

Did you run the oracle client install?
0
 
LVL 10

Author Comment

by:aman0711
ID: 24355552
Hi mrjoltcola,

                        I ran the netca and I guess I am able to edit the tnsnames.ora.

                        I even tested the connection with netca GUI.

                        Now how do I test it from SQL*PLUS?
 
                        I mean as soon as I openj SQL*PLUS. its asking for username, password and hoststring? and as far as I remember, I didnt submit any username and pass while installing. what is this host string?

                        Please have a look at the file, is it correct? I configured two database instances

bon007.ABC.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = pl100.mno.abc.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bon007)
    )
  )
 
offd01.ABC.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ml48.xyz.abc.com)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = offd01)
    )
  )

Open in new window

0
 
LVL 40

Assisted Solution

by:mrjoltcola
mrjoltcola earned 2000 total points
ID: 24355593
Now that you configured TNSNAMES, sqlplus only needs the TNS aliases (bon007 and offd01)
Put one of those aliases in for host string.

Or use a command prompt mode:

sqlplus user/password@bon007
0
 
LVL 10

Author Comment

by:aman0711
ID: 24355618
Wow.. so cool :-) Worked perfectly :-)
 Let me close this question here, Can we move to configuring ODBC connection now?
0
 
LVL 10

Author Closing Comment

by:aman0711
ID: 31580168
Thank You so much :-)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question