When the virtual machine can connect to the machine, but found remote or not able to connect, this time to join the rules at the firewall, the way to join is:
A: in Root Login
B: enter on the terminal Setup , configure the firewall. For example, the following:
C : check whether the Oracle-related port is configured. (Up and down keys to view, left and right keys to forward or close)
watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvdg90b3r1envvcxvhbg==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/southeast ">
D assume that there are no related rules defined and defined again.
Then select Forward:
watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvdg90b3r1envvcxvhbg==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/southeast ">
E the same pair of MySQL the rules are configured (configure as above)
watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvdg90b3r1envvcxvhbg==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/southeast ">
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. The Files folder is:
F:\app\to-to\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
Plsql the effect after the connection
watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvdg90b3r1envvcxvhbg==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/southeast ">
2. How to use client in Windows to connect to Oracle on a virtual machine