Re: Please help: where is "tnsnames.ora"

From: Nancy Teh <Nancy.Teh_at_cc.monash.edu.au>
Date: Wed, 13 May 1998 10:56:31 +1100
Message-ID: <3558EFBF.1812E7A9@cc.monash.edu.au>

Hello Huaping,

Try /etc directory or $ORACLE_HOME/network/admin directory.

If still no success, try typing from the unix command line:

   > find / -name tnsnames.ora -print

If you still can't find the tnsnames.ora file(remember tnsnames.ora is only required on the client machines), and what you are after is the host, port and sid. You can find that in the sqlnet.ora file. Again to a find as above or look under $ORACLE_HOME/network/admin or /etc.

Good Luck.

Nancy Teh

Huaping Luo wrote:
>
> I am using UNIX (solaris2) with SQL*NET2. Which directory is the file
> "tnsnames.ora" is in becuase I want to find my "HOST.PORT.SID" to connect
> my ORACLE database using JDBC thin driver.
>
> Any help is extremely appreciated.
>
> Huaping Luo

--

---

Nancy Teh
Email:Nancy.Teh_at_cc.monash.edu.au

---

Received on Tue May 12 1998 - 18:56:31 CDT