You post has been moved from the Database Installation forum space,
to the Oracle Linux forum space.
You definitely do not have a database installation question.
You have frustrations with your Linus OS that happems to OL 5.x
However, I actually think you need to ask your question in a VMware forum, as that is likely where your computer system is temporarily messed up - in your host configuration.
I'm not using VMware anymore and switched to free Oracle VirtualBox, but the concepts are the same. The default virtual machine NAT adapter is only good for connecting to the Internet using DHCP on behalf of the host OS and cannot be used to address the guest OS from outside.
You need to configure the bridged network adapter, or a combination of NAT for outgoing and host-only for incoming network traffic. There is plenty of info on the web and the VMware knowledgeable or Google about using the virtual network editor.