PLSQ Connecting remote (virtual machine) Oracle Database Help documentation

Working Group accidentally touches the virtual machine, is curious to install one to play. Later I heard that the database can be installed on the virtual machine, go home on the busy, and did not have a long time to succeed, and then my friend Xiao Li gave me a remote help, or no success. It's so bad that I lost it. But his help is that I understand The principle of PLSQ access to remote databases. After a few days of their own in there, through the online search information, alas good! Oops that happy Ah, finally decided to write a Help document sharing! Good to go.

first step oracel database Span style= "FONT-FAMILY:CALIBRI;" >, plsq software; download instant Client, Click to download download first Yes, , download and unzip , win7 c :d: \oracle\instantclient_11_2

Step Two : test whether the database installation was successful. Please refer to the online information;

Step three : Configuration IP to ensure that the virtual machine's IP The virtual machine can be installed in the PC ) with cmd Command Ping the pass.

1. IP of the virtual machine

650) this.width=650; "title=" 1.png "src=" Http://s3.51cto.com/wyfs02/M01/4C/8E/wKiom1Q_9TWBBkFRAAG2USHta-I975.jpg " alt= "Wkiom1q_9twbbkfraag2ushta-i975.jpg"/>

This machine IP (I use the wireless network)

650) this.width=650; "style=" Float:none; "title=" 2.png "src=" http://s3.51cto.com/wyfs02/M01/4C/8E/wKiom1Q_ 9kwipxujaafvldyjjqy093.jpg "alt=" Wkiom1q_9kwipxujaafvldyjjqy093.jpg "/>

also use cmd Command Ping 192.168.139.128 ( virtual machine IP)

650) this.width=650; "style=" Float:none; "title=" 3.png "src=" http://s3.51cto.com/wyfs02/M02/4C/8E/wKiom1Q_ 9kbbzimraahl51if39k458.jpg "alt=" Wkiom1q_9kbbzimraahl51if39k458.jpg "/>

Note: in Ping IP before you must turn on the virtual machine's firewall, or you will always Ping Pass the

The above San du success, then the following is simple.

Fourth Step: Configure environment variables

First create a new folder in this machine, such as I am in the C directory for C:\oracle , to a folder configuration environment variables

native My Computer (computer)--à property à advanced system Settings - à Environment Variables , add several environment variables. Can be in

650) this.width=650; "style=" Float:none; "title=" 7.png "src=" http://s3.51cto.com/wyfs02/M02/4C/8F/wKioL1Q_ 9dqh2ylxaaatjqewbrm346.jpg "alt=" wkiol1q_9dqh2ylxaaatjqewbrm346.jpg "/> or 650" this.width=650; "style=" Float:none; "title=" 8.png "src=" http://s3.51cto.com/wyfs02/M01/4C/8E/wKiom1Q_9aOTvQXOAAAJhtk8Fvk499.jpg "alt=" Wkiom1q_9aotvqxoaaajhtk8fvk499.jpg "/> added.

variables: Tns_admin = C:\oracle\instantclient_11_2\NETWORK\ADMIN Note: This is the most important. The wrong report can't be resolved

variables: Nls_lang = simplified Chinese_china. ZHS16GBK Note: This is to solve the problem of database garbled

variables: Ld_library_path = C:\oracle

variables: SQLPath = C:\oracle

finally in the system environment Path the last addition of the variable ; C:\oracle

For example C:\Java\jdk1.7.0_51\bin; C:\Java\jre7\bin; C:\windows\system32; C:\oracle;

Fifth Step

find your own installation on the virtual machine ORACLE Directory of the Database (mine is ( 4-1 ) has been installed Oracle you know the database!

in this installation directory ( C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN )

found under Tnsnames.ora and the Listener.ora files,

650) this.width=650; "style=" width:697px;float:none;height:275px; "title=" 4.png "src=" http://s3.51cto.com/wyfs02/ M00/4c/8f/wkiol1q_9n3thsahaaja_far_bm743.jpg "width=" 713 "height=" 271 "alt=" wkiol1q_9n3thsahaaja_far_bm743.jpg "/ >

The changes are as follows

Tnsnames.ora File Modification

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = virtual machine IP) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = orcl.168.139.129) can be the name of your own database installation
)
)

Note service_name with the Sid_name Same Value

Listener.ora File Modification

Sid_list_listener =

(Sid_list =

(Sid_desc =

(sid_name = orcl.168.139.129) can be the name of your own database installation

(Oracle_home = C:\app\Administrator\product\11.2.0\dbhome_1)

(program = Extproc)

(Envs = "Extproc_dlls=only:c:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")

)

)

LISTENER =

(Description_list =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = virtual machine IP) (PORT = 1521))

)

)

This machine was just created. Oracle folder under ( C:\oracle ) to create a new folder instantclient_11_2 ,

650) this.width=650; "style=" Float:none; "title=" 5.png "src=" http://s3.51cto.com/wyfs02/M01/4C/8F/wKioL1Q_ 9nvw8mjvaagcsvsc31w897.jpg "alt=" Wkiol1q_9nvw8mjvaagcsvsc31w897.jpg "/>

sub-folders under construction NETWORK , sub-folders are under construction ADMIN and Will Tnsnames.ora copied to this machine just created ADMIN Clamp down

Sixth Step plsq Set

open pl/sql tools preference

inside set oracle Home c:\oracle\odac_client oci Library c:\ \oracle\ instantclient_11_2 \oci.dll

650) this.width=650; "style=" Float:none; "title=" 6.png "src=" http://s3.51cto.com/wyfs02/M02/4C/8F/wKioL1Q_ 9nyxn1yzaajgvsjwfvs550.jpg "alt=" Wkiol1q_9nyxn1yzaajgvsjwfvs550.jpg "/>

This article is from the "PLSQ Connected virtual machine" blog, so be sure to keep this source http://6651617.blog.51cto.com/6641617/1564983

PLSQ Connecting remote (virtual machine) Oracle Database Help documentation