Why can’t I connect to Oracle DB from virtual xp running under windows 7 host

30 pts.
Tags:
Microsoft Windows XP
Oracle
Oracle Database
PL/SQL
SQL development
Virtual PC
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Have you installed more than one version of Oracle client sofware on the machine ? Can you connect from SQL*Plus ?
    69,510 pointsBadges:
    report
  • PLSqlWannaB
    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.
    30 pointsBadges:
    report
  • carlosdl
    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.
    69,510 pointsBadges:
    report
  • Subhendu Sen
    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--
    28,600 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following