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 accessing a remote database. 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.

The first step install software, virtual machines, Database software, download Download and download the first one . Download the decompression to put it in the main packing directory For example the second step Test whether the database installation was successful. Please refer to the online information;

: IP IP PC cmd Ping

of the virtual machine This machine (I use the wireless network)

650) this.width=650; "title=" \ "\ \" 2.png\\ "\" "src="%5c "alt=" \ "/> also use the command virtual machine

in the Ping IP Pass the

Fourth Step: Configure environment variables

first create a new folder on this machine, C Directory is , configure environment variables for a folder

Native My Computer (computer) à à - Environment Variables variable:= Note: This is the most important. Wrong will report variable: Note: This is to solve the database garbled problem

Ld_library_path = c:\\\\oracle

SQLPath = c:\\\\oracle

Path ; C:\\\\oracle

C:\\\\java\\\\jdk1.7.0_51\\\\bin; C:\\\\java\\\\jre7\\\\bin; C:\\\\windows\\\\system32; C:\\\\oracle;

Locate the directory where you installed your database on the virtual machine (my is 4-1Oraclec:\\\\app\\\\administrator\\\\product\\\\ 11.2.0\\\\dbhome_1\\\\network\\\\admin found and the file,

650) this.width=650; "title=" \ "\ \" 4.png\\ "\" "src="%5c "alt=" wkiol1q_9n3thsahaaja_far_bm743.jpg\\ "\" "/>

File modification

Virtual Machines IP orcl.168.139.129) )
)

service_name Sid_name File Modification

(Sid_list =

(Sid_name = can be the name of your own database installation

(program = Extproc)

)

(Description_list =

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

(DESCRIPTION =

Virtual Machines IP) (PORT = 1521))

)

Oracle c:\\\\oracle instantclient_11_2

NETWORK ADMIN Copy to the new folder you just created.

Sixth Step Setup

PL/SQL Tools Preference set in the inside Oracle Home ,OCI Library \\\\oci.dll

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

PLSQ Connecting remote (virtual machine) Oracle Database Help documentation