RDBMS 10g XE problem with parenthesis in path
CraigBApr 14 2012 — edited Apr 14 2012I 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...