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 <span style= "" font-family: ">instant Client, click Download Download the first one is done download unzip to Place the main packing directory as an example the second step is to test the success of the database installation. 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=" wkiom1q_9kwipxujaafvldyjjqy093.jpg\ ""/> also use commands Virtual Machines

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/1564984

PLSQ Connecting remote (virtual machine) Oracle Database Help documentation