2. solutions when oracle cannot be connected to a virtual machine using a windows Client
When the virtual machine can connect to the local machine, but the remote connection is still unavailable, add rules in the firewall at this time:
A: Log On As root.
B: Enter setup on the terminal to configure the firewall. As follows:
C: Check whether the oracle port is configured. (Check the up and down keys, and forward or close the left and right keys)
D. If no related rule is defined, redefine it.
Then select forwarding:
E. Configure the same mysql rules (as shown above)
F. Click OK until it is finished. Remember that you can connect to the remote connection through PLSQL.
Configure *. ora of oracle in Linux
/Home/oracle_11/app/oracle/product/11.2.0/db_1/network/admin/listener. ora, the content is as follows:
G. Configure the tnsnames. ora file in the windows client. The file directory is:
F: \ app \ to-to \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ tnsnames. ora
Effect of PLSQL connection