I am having a rather odd issue attempting to connect to a new local database I have set up on my PC (A copy of our development database).
I now have two ORACLE HOMEs - one for Devsuite10g, one for Oracle Database 11g. Both of these are 32 bit versions, although my PC is runnig 64 bit Windows 7.
I also have two versions of TOAD - version 10.0.0.41 and version 184.108.40.206. Vesrion 10 is installed in “C:\Program Files (x86)\Quest Software\Toad for Oracle 10”, while Version 12 is outside the program files structure, in “C:\Quest Software\Toad for Oracle 12.1”. Both versions of TOAD are also 32 bit versions (as shown by using Help=>support Bundle).
Version 12 cannot access the local database, coming up with the message “ORA-12154: TNS: could not resolve the connect identifier specified”, while Version 10 does succeed in accessing it. Neither version gives any choices in the “Connect Using” dropdown - version 12 is fixed on DevSuiteHome_forms10g, while version 10 is fixed on OraDb11g_Home1. Both versions do show both homes if you bring up the editor (and in the Support Bundle text). But V12 shows the registry keys as HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE… whiel V10 shows them as SOFTWARE\WOW6432NODE\ORACLE…
The way they are acting would suggest that V12 and Oracle Developer are 64 bit while V10 and local database are 32 bit, but in fact all are 32 bit versions.
The TNSNAMES files are the same in both Oracle Homes, and both versions can access our main production and Development databases (which are 64 bit versions, but obviuosly it is the local client sooftware they are using), it is only the local database which cannot be accessed by V12.
Obviously, I would prefer to use V12 for everything, although just at the moment, I’m glad I hadn’t got round to removing the old version yet!
Has anybody got any ideas?