Solve the problem that Oracle needs to set IP every time in the virtual machine

The blogger's name is taken from 《 Shaun the Sheep 》 Shawn the lamb in the , The name is ： Sean , Transliterated as Sean, Take your own last name ： Archie , In order to conform to our reading habits , Connected to form ArchieSean. Bloggers aim to build blogs into a technology stack for personal online notes , Be convenient for yourself and others . If there are any mistakes in the blog , Please point out , Thank you. .

I installed it on the local virtual machine Oracle, But when using graphical tools to link , Every time I need to set up a virtual machine ip To oracle Go to the file of , To solve this problem , You can use the computer name instead of the original ip

• To configure listener

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = Computer name )(PORT = 1521))
    )
  )

• To configure tnsnames

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Computer name )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Another solution

• First, we can set vm Of ip It's static ip, The modification steps are as follows
  
  Do a few operations in this picture ：
  （1） Choose vm8, Click change settings
  （2） Modify subnet IP And subnet mask
  （3） Click on NAT Set up , Set up the gateway , Here's the picture
  
  here , The static state of the virtual machine ip Setup completed , You can turn on the virtual machine , Set up the ip. What I use here is win7 Virtual machine （ Installed Oracle）, The modification steps are as follows ：

1. Open the network and Sharing Center
2. Change adapter settings
3. Click local connection , Right click Properties
4. Find... In attributes IPV4 Editing , Here's the picture
   
   Click ok , The advantage of this is , In the use of Oracle When , adopt PL/SQL When the connection , You can configure fixed ip To connect , You don't have to view the virtual machine every time ip Address and then establish a connection , It's more convenient .

If there are any questions , Please comment ..