This content has been marked as final. Show 7 replies
WHere is your database; is it installed in Windows 7 or on a server? Have you configured your tnsnames.ora?
Edited by: CraigB on Aug 29, 2012 9:50 AM
The database is in a server . I am able to connect it from windows 7 but not from Oracle client in windows xp mode-virtual PC.
yes I have configured the tns. the tns ping returns the following error.
TNS-12545 connect failed becuase target host or object doesnt exist.
this is a SQLnet issue. Please check the following document for troubleshooting purposes.
Troubleshooting ORA-12545 / TNS-12545 Connect failed because target host or object does not exist (Doc ID 553328.1)
this is a SQLnet issue. Please check the following document for troubleshooting purposes.I think this goes deeper than a SQLnet issue. Are you able to see anything on your network from your Windows XP Virtual Machine(VM) or are you able to connect to the Internet?
When you setup the VM, did you instruct the VM Wizard to allow the VM access to your network? A quick way to confirm this would be to simply ping the server your database resides on from your VM. If you are able to ping the DB Server, then I would agree with Roberto that you probably just need to configure the TNS Names on your VM. If you can't ping the server, then you need to modify your VM to allow it access resource of the host computer. For this, you will need to look at Microsoft's website for direction.
Hope this helps,
If someone's response is helpful or correct, please mark it accordingly.
I started working on a similar setup though in my case,
- the db is in the host Win7,
- oracle forms is in win xp mode (virtual machine),
- host Win7 and XP can ping each other,
- XP can access the internet
tnsping connection times out with tns-12535. sqlplus/forms errors with tns-12203.
Culprit turned out to be the firewall.
I have the same problem as mentioned in the issue. Even after turning off firewall, I am experiencing the 'target not found' issue. When I ping from virtual machine I am getting 'Request Timed out'. The database is in a server.