May be
your ORACLE_SID is in lower case(vuntest) and your SID in the
listener.ora is in upper case <FONT
color=#000000>(SID = <FONT
color=#ff0000>VUNTEST)..
<SPAN
class=525040823-27042001>Check'em..
<FONT face=Tahoma
size=2>-----Original Message-----From: Adams, Matthew (GEA, 088130)
[mailto:MATT.ADAMS_at_APPL.GE.COM]Sent: Thursday, April 26, 2001 11:44
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Urgent - tnsnames problem..
what error are you getting? Is the
listener process running?
- R. Matt Adams - GE
Appliances - matt.adams_at_appl.ge.com Meddle not
in the affairs of troff, for it is subtle and
quick to anger.
> -----Original Message----- >
From: Manivannan Muthukrishnan [<A
href="mailto:manivannan.m_at_tatainfotech.com">mailto:manivannan.m_at_tatainfotech.com]
> Sent: Thursday, April 26, 2001 2:16 PM <FONT
size=2>> To: Multiple recipients of list ORACLE-L <FONT
size=2>> Subject: Urgent - tnsnames problem.. >
> > Hi <FONT
size=2>> 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. <FONT
size=2>> Here is the tnsnames.ora file >
> > # <FONT
size=2>> # Installation Generated Net8 Configuration <FONT
size=2>> # Version Date: Oct-27-97 > # Filename:
Tnsnames.ora > # >
extproc_connection_data = >
(DESCRIPTION = > (ADDRESS =
(PROTOCOL = IPC)(KEY = extproc)) <FONT
size=2>> (CONNECT_DATA = (SID = extproc))
> ) >
> VUNTEST = <FONT
size=2>> (DESCRIPTION = <FONT
size=2>> (ADDRESS = (PROTOCOL= TCP)(Host=
163.122.1.35)(Port= 1521)) <FONT
size=2>> (CONNECT_DATA = (SID = <FONT
color=#ff0000>VUNTEST)) >
) > > <FONT
size=2>> Thanks in advance.. >
Manivannan.M > > --
> Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com" target=_blank>http://www.orafaq.com
> -- > Author: Manivannan
Muthukrishnan > INET:
manivannan.m_at_tatainfotech.com > <FONT
size=2>> 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). >
Received on Fri Apr 27 2001 - 18:38:43 CDT