Re: HELP !!!! [Oracle]ORA-12154: TNS:could not resolve service name

A few suggestions:

1. Drop down one level from ODBC to TNS.

Use a SQL+, Sql WorkSheet, EZSQL or Golden32 to test connections.

2. TCP/IP Stuff.

1. Make sure you do not have a DNS failure dereferencing a host name breaking your TNS. Test by hard coding the server's IP address in the correct TNSNAMES.ORA file.
2. Try using the Oracle Utility TNSPING.EXE
3. Try Using either NET8 Easy Config or SQL*Net Easy Config utilities

Rock Cogar.
Radian International LLC.
Oak Ridge, TN. USA.
rock_cogar_at_my-deja.com

In article <s65c3sbkf9480_at_corp.supernews.com>,   Bandoba <bandoba_at_yahoo.com> wrote:
> Hi,
>
> Check if OracleTNSListener service is running. That service is
supposed
> to resolve the name. Also check your TNSNAMES.ORA file.
>
> For Oracle 8.0.5 on NT, the name of the service is
OracleTNSListener80.
>
> HTH
> Bandoba
>
> Rene Rijbroek wrote:
> >
> >
> > PLEASE Help Me,
> >
> > I have an oracle database running on a window NT 4.0 enterprise
server.
> > Everything was ok and working fine. Until suddenly i can not access
the
> > oracle database using ODBC. When i do try, i get the following
error:
> >
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not
> resolve
> > service name
> >
> > I have tried everything, newest ODBC drivers, windows NT sp6 etc.
etc.
> etc.
> > Can anyone help me, i saw the exact question posted on a message
board a
> > while back with no answers at all. Please, is there somebody who
knows
> how
> > to solve this problem. The only thing i can think of is to
reinstall the
> > whole computer, there has to be an other way.
> >
> > Thx in advance, Rene Rijbroek
> >
> >
>
> --
> Posted via CNET Help.com
> http://www.help.com/
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 28 1999 - 17:12:49 CST