- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: tnsnames.ora file - What's the relevance??
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 02:59 PM
тАО11-12-2002 02:59 PM
I need to put the entry of the services / servers that I need to connect, in this file (tnsnames.ora).
Would you be able to explain the working of this file and how does it connect to the respective database using the parameters entered.
Sanjay
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 03:18 PM
тАО11-12-2002 03:18 PM
SolutionThe tnsnames.ora file is like a roadmap to all the DBs you may wish to connect to.
It contains all the info a client would need to find & connect to a DB - such as:
1) SID name - the common name the DB is known as. It's the value NOT in parens.
2) PROTOCOL - the type of transport (TCP, etc) to use to communicate with the DB
3) HOST - Could be a name OR IP
4) PORT = The port number to use to communicate
This file is referrenced when you do something like an sql connect call such as
sqlplus username/password@DBNUM01
It looks up the DBNUM01 value in that file & uses the host/port info to setup the connection.
HTH,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 03:24 PM
тАО11-12-2002 03:24 PM
Re: tnsnames.ora file - What's the relevance??
The best place to start is in ${ORACLE_HOME}/network/admin/samples. That directory will contain a tnsnames.ora sample as well as a listeners.ora sample. If you are only setting up a client then you can probably copy a tnsnames.ora file from another client. You must still be able to resolve hostnames using /etc/hosts, NIS, and/or DNS.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 03:37 PM
тАО11-12-2002 03:37 PM
Re: tnsnames.ora file - What's the relevance??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 04:10 PM
тАО11-12-2002 04:10 PM
Re: tnsnames.ora file - What's the relevance??
Thanks Guys.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 06:03 AM
тАО11-13-2002 06:03 AM
Re: tnsnames.ora file - What's the relevance??
I think you do need Oracle client
installed: Toad is looking for
client libraries: oci.dll,
which is an API to connect to oracle. After that, Setup
ORACLE_HOME , a place where
Toad will start searching for cupported binaries to connect to Oracle. When you specify which DB you need to connect, that's where you need entry in local tnsnames.ora where you'll point
to Oracle_SID and all its characteristics: which host it's
on , etc ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-13-2002 12:43 PM
тАО11-13-2002 12:43 PM
Re: tnsnames.ora file - What's the relevance??
Install Oracle client for whatever version of database you are trying to connect to.
Run the Net Manager or SQL*NET Easy Configurator application that will be installed after the client.
Follow the wizard which should be intuitive. You should add an alias, database SID and host IP address that the database resides in. Your configuration will be saved on completion which builds a tnsnames.ora in ORACLE_HOME.
You can then use the alias that you created to connect to the database with any tool including TOAD.
Hope this helps.
Kim