RE: Urgent - tnsnames problem..Solved.

Hi

It was because of a missing / at the end of Oracle Home entry in the listener.ora file.

Thanks for your replies..

Manivannan.M

On Thu, 26 Apr 2001, Martin Kendall wrote:

> Have you got a Listener running ?
>
> Martin
>
> -----Original Message-----
> Sent: 26 April 2001 19:16
> To: Multiple recipients of list ORACLE-L
>
>
> Hi
> I have a problem. I've installed Oracle 8.0.5 on HPUX.
> I've created the database. But I can't connect thro tns. Its giving me
> Oracle not available error. I've
> checked the entries.
> Here is the tnsnames.ora file
>
>
> #
> # Installation Generated Net8 Configuration
> # Version Date: Oct-27-97
> # Filename: Tnsnames.ora
> #
> extproc_connection_data =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
> (CONNECT_DATA = (SID = extproc))
> )
>
> VUNTEST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 163.122.1.35)(Port= 1521))
> (CONNECT_DATA = (SID = VUNTEST))
> )
>
>
> Thanks in advance..
> Manivannan.M
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Manivannan Muthukrishnan
> INET: manivannan.m_at_tatainfotech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Martin Kendall
> INET: Martin.Kendall_at_Rubus.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Manivannan.M
  INET: manivannan.m_at_tatainfotech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).