Installation of Oracle in Virtual Machine use PLSQL Developer Connection tutorial in host machine, oracleplsql

Installation of Oracle in Virtual Machine use PLSQL Developer Connection tutorial in host machine, oracleplsql

To meet the development requirements, install the XP system and Oracle on the VM, and install the Oracle Client and PLSQL Developer on the host to simulate remote Oracle database operations.

First, install the Oracle database in the Virtual Machine. For details, refer to: Click to open the link.

First, configure the network settings of the Virtual Machine and change the network connection method to Bridging.

After installing the database in the VM, you must configure the listener in the C: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN folder. ora and tnsnames. ora file, open it in notepad

Change localhost to the ip address of your VM.

Remember to change the ip addresses of both files.

After setting, ping the VM on the local machine. If the general rules are ping, the setting is successful.

Method: cmd ---> enter the ip address 1521 of the telnet Vm, for example, telnet 192.168.1.1 1521.

If the connection is successful, the following information is displayed:

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

For the installation process, see: Click to open the link.

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

TNS_ADMIN
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 to the end.

Next, choose [PLSQL Developer 8] → [Tools] → [preference]

[Oracle_HOME]: D: \ Oracl11_32 \ instantclient_11_2

[OCI]: D: \ Oracl11_32 \ instantclient_11_2 \ oci. dll

Finally, copy tnsnames. ora from the VM to D: \ Oracl11_64 \ product \ 11.2.0 \ client_1 \ network \ admin.

Restart PLSQL Developer to connect.