When a virtual machine can connect to a native, but discovers that the remote is still not able to connect, this time to add a rule at the firewall, add the way:
A: in Root Login
B: enter on the terminal Setup , configure the firewall. as follows:
C : check whether the Oracle-related ports are configured. (Up and down keys to view, left and right keys to forward or close)
D redefined if no related rules are defined.
Then select Forward:
E the same for MySQL the rules are configured (configure as above)
F Finally, click OK until finished. Remember to Connect to the remote connection again via Plsql.
Configuration Linux under Oracle of the *.ora
/home/oracle_11/app/oracle/product/11.2.0/db_1/network/admin/listener.ora, The contents are as follows:
G Configuration Windows under the client Tnsnames.ora file, file directory is:
F:\app\to-to\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
Plsql the effect after the connection
2. Use a client under Windows to connect a solution on a virtual machine when Oracle is not connected