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

Source: Internet
Author: User

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.



Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.