Re: ORA-12514

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: 2000/04/05
Message-ID: <8cfkgg$vvo$2@newsg3.svr.pol.co.uk>#1/1

Try OraCodes: a free help file that contains all the Oracle error messages and codes. You can download it from http://www.oraxcel.com

Thanks,

--
Gerrit-Jan Linker

web:     http://www.oraxcel.com
email:  gjlinker_at_oraxcel.com

Oraxcel: Linking Oracle to Excel
OraCodes: Explaining ORA- error codes
OraSQL: Explaining Oracle SQL syntax
OraDebug: PL/SQL debugger
OraWeb: Oracle access from IE
programmer <programmer_at_nospam.com> wrote in message
news:selanemmeop17_at_corp.supernews.com...


> > SQL> host oerr ora 12514

>

> Doesn't work for me:

>

> SQL> host oerr ora 12514

> The name specified is not recognized as an

> internal or external command, operable program or batch file.

>

>

>

> > 12514, 00000, "TNS:listener could not resolve SERVICE_NAME given in

> > connect descriptor"

> > // *Cause:  The SERVICE_NAME in the CONNECT_DATA was not found in the

> > listener's tables.

> > // *Action: Check to make sure that the SERVICE_NAME specified is

 correct.


> > // *Comment: This error will be returned if the database instance has

 not


> > // registered with the listener; the instance may need to be started.

>

> This doesn't really make sense to me. I can successfully connect with

> the username,password, servicename from plus80.exe, but trying to run

> over the Microsoft ODBC driver for Oracle, it fails with that ORA-12514 -

> but succeeds if I switch back to system account...

> (and so far everything is consistently repeatable)

>

> Same username,password,servicename works running in plus80...

>

> I don't know how to turn tracing on, but no doubt I can figure it out, and

> see what I see. Thanks for the feedback...

>

> - Perry

>

>

>

>

Received on Wed Apr 05 2000 - 00:00:00 CDT