当前位置:网站首页>Solve the problem that Oracle needs to set IP every time in the virtual machine
Solve the problem that Oracle needs to set IP every time in the virtual machine
2022-04-23 13:12:00 【ArchieSean】
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 :
- Open the network and Sharing Center
- Change adapter settings
- Click local connection , Right click Properties
- 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 ..
版权声明
本文为[ArchieSean]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231306322375.html
边栏推荐
- Subscribe to Alibaba demo send business messages
- The project file '' has been renamed or is no longer in the solution, and the source control provider associated with the solution could not be found - two engineering problems
- Kernel error: no rule to make target 'Debian / canonical certs pem‘, needed by ‘certs/x509_ certificate_ list‘
- Imx6ull QEMU bare metal tutorial 2: usdhc SD card
- Golang implements MD5, sha256 and bcrypt encryption
- Golang realizes regular matching: the password contains at least one digit, letter and special character, and the length is 8-16
- Design and manufacture of 51 single chip microcomputer solar charging treasure with low voltage alarm (complete code data)
- 你和42W奖金池,就差一次“长沙银行杯”腾讯云启创新大赛!
- [walking notes]
- mysql 基本语句查询
猜你喜欢
初鉴canvas,展示个小小的小案例
[untitled] make a 0-99 counter, P1 7 connected to key, P2 connected to nixie tube section, common anode nixie tube, P3 0,P3. 1. Connect the nixie tube bit code. Each time you press the key, the nixie
2020最新Android大厂高频面试题解析大全(BAT TMD JD 小米)
Request和Response及其ServletContext总结
nodejs + mysql 实现简单注册功能(小demo)
AUTOSAR from introduction to mastery 100 lectures (51) - AUTOSAR network management
Important knowledge of network layer (interview, reexamination, term end)
Mui + hbuilder + h5api simulate pop-up payment style
2021年6月程序员工资统计,平均15052元,你拖后腿了吗?
The project file '' has been renamed or is no longer in the solution, and the source control provider associated with the solution could not be found - two engineering problems
随机推荐
FatFs FAT32 learning notes
安装nngraph
office2021安装包下载与激活教程
web三大组件之Filter、Listener
LeetCode_ DFS_ Medium_ 695. Maximum area of the island
AUTOSAR from introduction to mastery 100 lectures (81) - FIM of AUTOSAR Foundation
内核错误: No rule to make target ‘debian/canonical-certs.pem‘, needed by ‘certs/x509_certificate_list‘
9419页最新一线互联网Android面试题解析大全
ECDSA signature verification principle and C language implementation
Go language slicing operation
FFmpeg常用命令
Utils of various date conversion
AUTOSAR from introduction to mastery 100 lectures (86) - 2F of UDS service foundation
The first lesson is canvas, showing a small case
melt reshape decast 长数据短数据 长短转化 数据清洗 行列转化
Analysis of the latest Android high frequency interview questions in 2020 (BAT TMD JD Xiaomi)
Go language: passing slices between functions
Community version Alibaba MQ ordinary message sending subscription demo
「玩转Lighthouse」轻量应用服务器自建DNS解析服务器
Timing role in the project