This content has been marked as final. Show 2 replies
Which version of pl/sql developer? Have you tried the sql developer http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Why? If a program has difficulties with an install location either uninstall and don't use it, or move it.
I'm adverse to doing this
ORA-12514 is a client problem. It's saying it has no idea how to connect with what you're asking for.
A known workaround is to uninstall the program/tool (.e.g Toad) and re-install using a path without brackets.
If you don't want that, you could install a current (11.2) Oracle Client package and have the tool use that instead of client libs included in XE server install, as long as it supports the Oracle version in question. A current version of whatever tool you are using should be compatible with current Oracle versions, but you would need to verify with each maker's support site (e.g. requirements, compatibility matrix or similar).
For ease of install etc., take a look at Instant Client.
Edited by: orafad on Apr 14, 2012 6:50 PM