The editor in this article will introduce in detail how to build an oracle environment under vmware. The content is detailed, the steps are clear, and the details are handled properly. I hope this article on how to build an oracle environment under vmware can help you solve your doubts. Follow the editor's thinking slowly Slow down, let's learn new knowledge together.
oracle11g(database: Installed in a virtual machine)
oracle client (client: installed on your local machine)
VMware( Install virtual machine)
windows7 system
pl/sal devoloper (pl/sql programming client: installed on this machine You can remotely connect to the oracle database on the virtual machine)
Process: Omit
Test whether the machine can ping the system of the virtual machine
p>
Note: The installation process can be done by default (typical installation), and one of the steps is to set the passwords of the three default database users of sys system soctt, which must be remembered, and can be uniformly set to root
a, after the installation is complete, go to the installation directory of the virtual machine oracle and find
C:\app\DELL-PC\product\11.2.0\dbhome_1\NETWORK\ADMIN
Find the tnsnames.ora file, copy
b, and then find the installation directory of oracle client
product\10.1.0\Client_1 \NETWORK\ADMIN
Just replace the tnsnames.ora file inside
The content is as follows:< /p>
# tnsnames.ora Network Configuration File: C:\app\DELL-PC\product\11.2.0\dbhome_1\network\admin\tnsnames.ora #
Change to:
# tnsnames.ora Network Configuration File: F:\Oracle\product\10.1.0\Client_1\network\ admin\tnsnames.ora #
Note: 192.168.242.134 can be changed to the ip address of your virtual machine system
Open pl/sql, log in as user scott, password is root set by myself
Confirm that you can log in successfully, write it down and you can happily program pl/sql.
Copyright Description:No reproduction without permission。
Knowledge sharing community for developers。
Let more developers benefit from it。
Help developers share knowledge through the Internet。
Follow us
2023-03-20
2023-02-06
2023-02-04