Installing Oracle in a virtual machine using the Plsql Developer Connection Tutorial in a host

Due to development needs, install the XP system in the virtual machine and install Oracle, install Oracle client and PLSQL developer in the host to simulate remote operation of Oracle database.

The first thing to do is to install the Oracle database in the virtual machine, the process reference: Click the Open link

First, configure the network settings for the virtual machine and change the network connection method to bridging.

After installing the database in the virtual machine, you need to configure the Listener.ora and Tnsnames.ora files under the C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN folder, open with Notepad, and

localhost to the IP of its own virtual machine.

Remember to change the IP of all two files.

After Setup, ping the virtual machine with this machine if the ping general instructions are set up successfully.

Method: cmd---> Input telnet virtual machine IP 1521 For example: Telnet 192.168.1.1 1521

The successful connection shows:

Next the host configuration, to download the Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) and Instant Client for Microsoft Windows (32-bit).

Installation process Please refer to: Click to open the link

After the installation is complete, configure the environment variables and add the following two variables, respectively:

< Span style= "margin:0px; padding:0px; Color:rgb (51,51,51); Font-family: ' Segoe UI regular ', ' Segoe UI ', Arial,tahoma,sans-serif; font-size:13px; Line-height:16px ">tns_admin &NBSP;
value:   d:\oracl11_64\product\11.2.0\client_1\network\admin

Nls_lang

Value: American_america. Zhs16gbk

Edit path: add:D:\Oracl11_32\instantclient_11_2

< Span style= "line-height:16px" > next into " Plsql Developer 8 "→" Tools "→" preference "

< Span style= "line-height:16px" >" Oracle_home " :&NBSP; d:\oracl11_32\instantclient_11_2

" OCI ": &NBSP; D:\ORACL11_32\INSTANTCLIENT_11_2\OCI.DLL&NBSP;

< Span style= "line-height:16px" and finally  TNSNAMES.ORA&NBSP; copy to   D:\ORACL11_64\PRODUCT\11.2.0\CLIENT_1\NETWORK\ADMIN&NBSP; under

Restart plsql developer to connect.

Installing Oracle in a virtual machine using the Plsql Developer Connection Tutorial in a host