2 Replies Latest reply: Apr 14, 2012 11:51 AM by orafad RSS

    RDBMS 10g XE problem with parenthesis in path

    CraigB
      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...
        • 1. Re: RDBMS 10g XE problem with parenthesis in path
          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.
          • 2. Re: RDBMS 10g XE problem with parenthesis in path
            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