Re: ORA-12514

> 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