If you want the Virtual Machine to connect to the Internet then set its Network Adapter to either NAT or Bridged in the Virtual Machine's Settings!
I well know that I can connect to internet with Bridged and NAT. But (it is a long story) I will have MUCH more benefits if I do it with a Host-Only. And according to VMware manual, it is a fact that it is possible. Why not use the best way (for my particular case) if it is available there, just waiting to be configured?
the only problem is that I am an Oracle DBA, not a networking specialist, and I have no idea how to achieve this goal. I have made several tests, but only in a try and error manner, without no success.
I think this should be a piece of cake for a networking specialist, and I think there must be someone around here who already did it, and want to share the solution.
If one enables Host Only to connect beyond the Host then it is no longer a Host Only Network and why you should use either NAT or Bridged as there's typically no need to configure anything other then to select the Adapter Type in the VM's Settings and it allows for connectivity beyond the Host providing the Host has connectivity. Also as a general rule it is typically advised that one does not modify the default VMnets unless there is no other way as it usually leads to breaking the VMware Virtual Network Infrastructure. (Especially when done by a DBA! (JK))
Seriously though why can't you just use NAT or add a second Network Adapter set to NAT to the VM?
As to telling you how to make a Host Only Network connect beyond the Host, well all we know is you are reading the VMware Workstation 10 manual and you're a DBA. So not nearly enough information to give you an answer based on actual facts of the scenario. Like what VMware Product and version (can't assume anything) what Host OS and version, etc., etc.!
BTW did you read the last part of that paragraph you quoted as it states, "...to connect the virtual machine to a Token Ring or other non-Ethernet network."
And it does give an example: "On a Windows XP or Windows Server 2003 host computer, you can use host-only networking in combination with the Internet connection sharing feature in Windows to allow a virtual machine to use the dial-up networking adapter or other connection to the Internet on the host system."
My reason to want to configure this option, is a VERY long story which I think is not relevant to get the answer I am looking for. But, believe me, it has a deep value for me.
I never has accepted the easy way if it is not the BEST way (for any particular case). Sooner or later I will find someone who already did it, or find The answer by myself.
I Am not sure about this translation to English, but I will try: "The prudent man adapts to the world. The imprudent man try to make the world to adapt to him. So that, the progress of the human race is made by the imprudent man".
Thank you anyway WoodyZ
Look, I know how to do it and have done it however there is a good reason for saying what I already have. Anyway since we do not even know what VMware product or version you're using, because you haven yet stated so, nor provided any information about the Host OS, the latter of which is the most important as that will determine what suggestions will be made. As an example on a Windows Host ICS can be use on VMnet1 or there are Proxy Application that can be downloaded and installed. Some free some paid however you do not need to be a Network Administrator to figure this out! Even a DBA using Google should be able to handle this task!
My Host is Win7 x64 with VMware Workstation 10. My Guests are Red Hat Linux 5 and 6, Oracle Linux 5 and 6, and Oracle Solaris 11. My host has 2 physical network adapters.
Are you now able to recommend me the next steps? Is it needed a proxy software (which ones can I use)? Is it possible to achieve this task using only ip forwarding and route add command on the host or guest?
In other goals, can I use same technic to get communicated the VMware Workstation 10 virtual adapters (in the Host) with Oracle VirtualBox 4 virtual adapters (also in the host) and viceversa. I am currently using the Bridged Network of my VMware to communicate to VBox machines, but it provides mostly only one network. I want to be able to communicate more networks between them.
Have you tried adding another network card to the host as bridged? That may solve your issue.