Why can’t I connect to Oracle DB from virtual xp running under windows 7 host
Oracle, Oracle Database, PL/SQL Developer, SQL Developer, Virtual PC, Windows XP, Windows XP Virtual Machines
I am running plsqldeveloper on a windows xp virtual machine. (Created on a windows 7 box). When I start plsql developer on the virtual xp machine I type in a vallid Username/Password there are no Databases in the drop down list so I type in a valid database name then I get the following error: Sql*Net not properly installed OracleHomeKey: OracleHomeDir:. It appears to me that plsql developer cannot find the tnsnames.ora. It is this folder: C:oracleproduct10.2.0Client_2NETWORKADMIN folder along with sqlnet.ora. I don't know what is wrong. Should tnsnames.ora and sqlnet.ora be placed in another folder? Please help with this urgent issue.
Software/Hardware used:
Software/Hardware used:
ASKED:
December 6, 2010 5:54 PM
UPDATED:
December 7, 2010 5:03 AM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Have you installed more than one version of Oracle client sofware on the machine ?
Can you connect from SQL*Plus ?
The issue was I had installed more than one version of Oracle client sofware on the VM. However, the database drop down is not populated I still need to type in the
name of the database.
I don’t use pl sql developer, but I believe there is an option (preferences->options) where you can set the appropriate oracle home (and the OCI library) of the client software version you want to use. It might help in this case.
From my side, as Carlosdl said, hope he is correct. The actual location u will have to take care is
Tools > Preferences > options set manually Oracle Home to the folder of ORACLE_HOME and “OCI Library” to the oci.dll file located in ORACLE_HOME/bin/oci.dll
Thanks–