How to remotely connect oracle11G and ploracle11g from a virtual machine through PL/SQL

How to remotely connect oracle11G and ploracle11g from a virtual machine through PL/SQL

Environment requirements:

1. win8.1 Operating System

2. Download instantclient_10_2 must be 32-bit: http://www.oracle.com/technetwork/cn/topics/winsoft-085727.html

You can also download the http://download.csdn.net/detail/u011218159/8346121 at the address below:

It must be 32-bit because it is currently only supported by 32OS.

3. PL/SQL Developer tool: http://download.csdn.net/detail/u011218159/8346143

The following are some configurations:

1. Install PL/SQL Software

2. decompress the instantclient_10_2 package

3. View or copy the tnsnames. ora file to the instantclient directory and edit the file:

[Oracle @ localhost ~] $ Cat/u01/app/product/11.2.0/db_1/network/admin/tnsnames. ora # tnsnames. ora Network Configuration File:/u01/app/product/11.2.0/db_1/network/admin/tnsnames. ora # Generated by Oracle configuration tools. JIAGULUN = // configure the (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost. localdomain) (PORT = 1521) // target host and PORT number (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jiagulun) // $ ORACLE_SID ) [Oracle @ localhost ~]

4. Disable the Linux firewall or add an open port number.

[Root @ localhost ~] #/Etc/init. d/iptables stop // manually close the firewall Flushing firewall rules: [OK] Setting chains to policy ACCEPT: filter [OK] Unloading iptables modules: [OK] [root @ localhost ~] # Vi/etc/syscsysconfig/sysctl. conf [root @ localhost ~] # Vi/etc/sysconfig/ipip6tables ipmi iptables-configip6tables-config iptables [root @ localhost ~] # Vi/etc/sysconfig/iptables

Add the following code: oracle-A RH-Firewall-1-INPUT-m state -- state NEW-m tcp-p tcp -- dport 1521-j ACC

Restart the system

5. Configure PL/SQL to go to the preference directory:

6. configure system environment variables:

TNS_ADMIN = tnsnames. ora path to the system environment variable: CTR + C -- system information -- System variable

7. Start PL/SQL tools

If you have any questions, leave a message!