Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

RDBMS 10g XE problem with parenthesis in path

CraigBApr 14 2012 — edited Apr 14 2012
I have installed Oracle Database 10g XE on Windows 7 Ultimate (64-bit) computer and I am getting the error: "ORA-12154: TNS:Could not resolve the connect identifier specified" when I try to connect to the database using any non-Oracle product (PL/SQL Developer, TOAD, etc). After a little research I learned that this is a bug with Oracle where the connecting program has a parenthesis in this path and downloaded a patch from My Oracle Support for this, however, after downloading I discovered that the patch did not apply to the Express Edition.

When installed, PL/SQL Developer installed to C:\Program Files (x86)\. I've seen some references to where people simply copied the installed program from \Program Files (x86) to \Program Files and this fixed the error. I'm adverse to doing this.

Besides installing the 11g Express Edition or installing Windows XP Mode, does anyone know a possible resolution?

Here are the details of my installation:
HP dual-core CPU, 4gb RAM, Windows 7 Ultimate 64-bit

Regards,
Craig...

Comments

clcarter
Which version of pl/sql developer? Have you tried the sql developer http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
I'm adverse to doing this
Why? If a program has difficulties with an install location either uninstall and don't use it, or move it.

ORA-12514 is a client problem. It's saying it has no idea how to connect with what you're asking for.
orafad
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.
http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html

Edited by: orafad on Apr 14, 2012 6:50 PM
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 12 2012
Added on Apr 14 2012
2 comments
1,296 views