This content has been marked as final. Show 6 replies
Hi Igor i have almost the same configuration (windows 7 home premium) and had the same problem. Exit sql developer and try adding your DB's IP address in the windows's host file (C:\windows\system32\drivers\etc\).
That you can ping it indicates the VM O/S is visible. Can you TNSPING the listener?
Post the LISTENER.ORA and TNSNAMES.ORA file for the database and the TNSNAMES.ORA file for the client.
... and what about your firewall? Is the port for the database listener open? Ping often works per default while TCP ports are usually "closed" and have to be opened to the outside world... I'm not sure about the default configuration in OEL right now, but it might be worth a look. You can easily configure it via +/usr/bin/setup+ (console based)
Thank you for the idea. I have added symbolic names in hosts file and don't use raw IP addresses anymore.
However, main problem is still unsolved. Not being a very Linux man, I work on this Linux VM through PuTTY (copy/paste command line) and WinSCP (file transfer for CodeWright edition, cause I don't like vi and the VM does not have GUI). So, the VM is perfectly atteignable , save for DB.
Thank you very much, Udo!
Indeed, the port 1521 was closed by the VM's firewall.
I have opened it with /usr/bin/setup and the DB became available.
Oups... I have forgotten to mark the question as answered.