RE: Connection Problem

Hi Sanjeev ,

        Check you have made the entry in correct tnsnames.ora file. If it is Windows NT, first find out all tnsnames.ora using find facility, then make entry in all of them. Also check you are using correct version of tnsping (tnsping/tnsping80).

        In case of Solaris check that you have made entry in $ORACLE_HOME/network/admin/tnsnames.ora but this will work only when there is no tnsnames.ora in /etc . Some times /etc also has tnsnames.ora in case of autostart listeners/databases.

        I hope ping is working in your systems. That is obviously the first step(of course next is tnsping...;-)

HTH,
Rajesh

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Sanjeev Singh
Sent: Thursday, September 28, 2000 2:57 AM To: Multiple recipients of list ORACLE-L Subject: RE: Connection Problem

In your entry try putting IP address instead of HostName.

-----Original Message-----
Sent: Wednesday, September 27, 2000 1:06 PM To: Multiple recipients of list ORACLE-L

Thanks for the reply. I already have an entry in TNSNames.ora. I tried Ping
and TNSPing also.

But I still get the same error.

Sanjay Kumar

• Original Message ----- To: "'Sanjay Kumar'" <ora_user_at_hotmail.com> Sent: Wednesday, September 27, 2000 11:59 AM

> You need an entry in tnsnames.ora in the machine where you are tring
to
> connect ( Client ).
> If you are tring to connect from NT Oracle to Solaris Oracle, you need
an
> entry in tnsnames.ora on NT server.
>
> Satyam Josyula
>
> > -----Original Message-----
> > From: Sanjay Kumar [SMTP:ora_user_at_hotmail.com]
> > Sent: Wednesday, September 27, 2000 2:42 PM
> > To: Oracle List (Telelist); Oracle Discussion List
> > Subject: Connection Problem
> >
> > Hi,
> >
> > I have a database running on Solaris 8 and another running on
Windows
NT.
> >
> > Is it possible to connect to Oracle on Solaris from Oracle on
Windows.
> >
> > I added an entry in the listener file and tried to connect. But I
got
the
> > following error
> >
> > TNS:12154: TNS Could not resolve the Service name in Connect
Descriptor
> >
> > ANY help appreciated?
> >
> > Rgds,
> > Sanjay Kumar
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sanjay Kumar
  INET: ora_user_at_hotmail.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: Sanjeev Singh
  INET: ssingh_at_symyx.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