Solved

hwo to configure TNSNAMES.ORA file

Posted on 2009-05-11
8
3,423 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
  • 4
  • 4
8 Comments
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 500 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
 
LVL 40

Assisted Solution

by:mrjoltcola
mrjoltcola earned 500 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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 500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

914 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now