Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12514

Re: ORA-12514

From: programmer <programmer_at_nospam.com>
Date: 2000/04/03
Message-ID: <selanemmeop17@corp.supernews.com>#1/1

> 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...

Received on Mon Apr 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US