当前位置:网站首页>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
边栏推荐
- 将opencv 图片转换为字节的方式
- 超40W奖金池等你来战!第二届“长沙银行杯”腾讯云启创新大赛火热来袭!
- AUTOSAR from introduction to mastery 100 lectures (52) - diagnosis and communication management function unit
- decast id.var measure. Var data splitting and merging
- MySQL -- 16. Data structure of index
- Request和Response及其ServletContext总结
- nodeJs + websocket 循环小案例
- web三大组件之Servlet
- Go language mapping operation
- Hbuilderx + uniapp packaging IPA submission app store stepping on the pit
猜你喜欢
CSDN高校俱乐部“名师高校行”——湖南师范大学站
Kernel error: no rule to make target 'Debian / canonical certs pem‘, needed by ‘certs/x509_ certificate_ list‘
The first lesson is canvas, showing a small case
Design of STM32 multi-channel temperature measurement wireless transmission alarm system (industrial timing temperature measurement / engine room temperature timing detection, etc.)
十万大学生都已成为猿粉,你还在等什么?
在 pytorch 中加载和使用图像分类数据集 Fashion-MNIST
MySQL 8.0.11下载、安装和使用可视化工具连接教程
你和42W奖金池,就差一次“长沙银行杯”腾讯云启创新大赛!
melt reshape decast 长数据短数据 长短转化 数据清洗 行列转化
MySQL5.5安装教程
随机推荐
5 tricky activity life cycle interview questions. After learning, go and hang the interviewer!
基于uniapp异步封装接口请求简介
Pyqt5 store opencv pictures into the built-in sqllite database and query
These vscode extensions are my favorite
MySQL -- 16. Data structure of index
STM32 tracking based on open MV
Go iris framework implements multi service Demo: start (listen to port 8084) service 2 through the interface in service 1 (listen to port 8083)
Kernel error: no rule to make target 'Debian / canonical certs pem‘, needed by ‘certs/x509_ certificate_ list‘
这几种 VSCode 扩展是我最喜欢的
[untitled] PID control TT encoder motor
Recovering data with MySQL binlog
【行走的笔记】
Learning notes of AMBA protocol
缘结西安 | CSDN与西安思源学院签约,全面开启IT人才培养新篇章
100 GIS practical application cases (51) - a method for calculating the hourly spatial average of NC files according to the specified range in ArcGIS
EMMC / SD learning notes
@优秀的你!CSDN高校俱乐部主席招募!
解决Oracle中文乱码的问题
mui picker和下拉刷新冲突问题
AUTOSAR from introduction to mastery 100 lectures (52) - diagnosis and communication management function unit