Oracle RAC修改集群scan ip

Oracle rac 修改vip & scan ip 背景介绍:现在有个需求,主机的物理机迁移,为了让业务改动最小,要修改新主库的VIP & SCAN IP,同网段的修改vip & scan比较简单ps: 过段时间要修改物理机的网段,届时再更新! 阅读详情

由于业务需求,需要进行业务地址变更,使用之前的业务地址。生产环境是rac,所以需要修改集群的scan ip。在正式生产环境操作前,提前在测试环境进行测试,整个修改测试过程如下:

本次测试是要将scan-ip:192.168.80.24 修改为:192.168.80.25

修改步骤如下: 
查看scan_listener状态 
[oracle@nxyddb1 ~]$ srvctl status scan_listener 
SCAN Listener LISTENER_SCAN1 is enabled 
SCAN listener LISTENER_SCAN1 is running on node nxyddb2 
SCAN Listener LISTENER_SCAN2 is enabled 
SCAN listener LISTENER_SCAN2 is running on node nxyddb2 
SCAN Listener LISTENER_SCAN3 is enabled 
SCAN listener LISTENER_SCAN3 is running on node nxyddb2

查看scan_listener配置 
[oracle@nxyddb1 ~]$ srvctl config scan_listener 
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521 
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521 
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521

查看scan状态 
[oracle@nxyddb1 ~]$ srvctl status scan 
SCAN VIP scan1 is enabled 
SCAN VIP scan1 is running on node nxyddb2 
SCAN VIP scan2 is enabled 
SCAN VIP scan2 is running on node nxyddb2 
SCAN VIP scan3 is enabled 
SCAN VIP scan3 is running on node nxyddb2

查看scan配置 
[oracle@nxyddb1 ~]$ srvctl config scan 
SCAN name: nxyddb-scan.us.oracle.com, Network: 1/192.168.80.0/255.255.255.0/eth0 
SCAN VIP name: scan1, IP: /nxyddb-scan.us.oracle.com/192.168.80.24 
SCAN VIP name: scan2, IP: /nxyddb-scan.us.oracle.com/192.168.80.22 
SCAN VIP name: scan3, IP: /nxyddb-scan.us.oracle.com/192.168.80.23

停止scan_listener 
[oracle@nxyddb1 ~]$ srvctl stop scan_listener

停止scan 
[oracle@nxyddb1 ~]$ srvctl stop scan

确认停止后的状态 
[oracle@nxyddb1 ~]$ srvctl status scan_listener 
SCAN Listener LISTENER_SCAN1 is enabled 
SCAN listener LISTENER_SCAN1 is not running 
SCAN Listener LISTENER_SCAN2 is enabled 
SCAN listener LISTENER_SCAN2 is not running 
SCAN Listener LISTENER_SCAN3 is enabled 
SCAN listener LISTENER_SCAN3 is not running

确认停止后的状态 
[oracle@nxyddb1 ~]$ srvctl status scan 
SCAN VIP scan1 is enabled 
SCAN VIP scan1 is not running 
SCAN VIP scan2 is enabled 
SCAN VIP scan2 is not running 
SCAN VIP scan3 is enabled 
SCAN VIP scan3 is not running

修改和scan IP相关的文件 
[root@nxyddb1 ~]# vi /var/named/192.168.80.local 
[root@nxyddb1 ~]# vi /var/named/us.oracle.com.zone

重启服务 
[root@nxyddb1 ~]# service named restart 
Stopping named: . [ OK ] 
Starting named: [ OK ]

修改scan IP 
[root@nxyddb1 ~]# /u01/app/11.2.0/grid/bin/srvctl modify scan -n nxyddb-scan.us.oracle.com

查看是否修改成功 
[root@nxyddb1 ~]# /u01/app/11.2.0/grid/bin/srvctl config scan 
SCAN name: nxyddb-scan.us.oracle.com, Network: 1/192.168.80.0/255.255.255.0/eth0 
SCAN VIP name: scan1, IP: /nxyddb-scan.us.oracle.com/192.168.80.22 
SCAN VIP name: scan2, IP: /nxyddb-scan.us.oracle.com/192.168.80.23 
SCAN VIP name: scan3, IP: /nxyddb-scan.us.oracle.com/192.168.80.25

确认修改成功后启动scan_listener 
[oracle@nxyddb1 ~]$ srvctl start scan_listener

查看启动后scan_listener的状态 
[oracle@nxyddb1 ~]$ srvctl status scan_listener 
SCAN Listener LISTENER_SCAN1 is enabled 
SCAN listener LISTENER_SCAN1 is running on node nxyddb1 
SCAN Listener LISTENER_SCAN2 is enabled 
SCAN listener LISTENER_SCAN2 is running on node nxyddb2 
SCAN Listener LISTENER_SCAN3 is enabled 
SCAN listener LISTENER_SCAN3 is running on node nxyddb1

查看启动后scan的状态 
[oracle@nxyddb1 ~]$ srvctl status scan 
SCAN VIP scan1 is enabled 
SCAN VIP scan1 is running on node nxyddb1 
SCAN VIP scan2 is enabled 
SCAN VIP scan2 is running on node nxyddb2 
SCAN VIP scan3 is enabled 
SCAN VIP scan3 is running on node nxyddb1

查看scan修改后的配置 
[oracle@nxyddb1 ~]$ srvctl config scan 
SCAN name: nxyddb-scan.us.oracle.com, Network: 1/192.168.80.0/255.255.255.0/eth0 
SCAN VIP name: scan1, IP: /nxyddb-scan.us.oracle.com/192.168.80.22 
SCAN VIP name: scan2, IP: /nxyddb-scan.us.oracle.com/192.168.80.23 
SCAN VIP name: scan3, IP: /nxyddb-scan.us.oracle.com/192.168.80.25

RAC环境scan ip详解 本地监听器,RAC的每个节点上都会有独立的本地监听器,它会监听该节点的PUBLIC IP和VIP,而每个节点的实例在启动的时候也向本地监听器进行注册,当然它也会向SCAN监听器注册,当VIP或者PUBLIC IP(这种情况比较少见)有连接请求的时候,本地监听器就接受处理并和本地实例建立连接。除了DNS和GNS解析方法外,SCAN也可以使用hosts文件来解析,但用过的人都知道,此方法不仅在安装RAC的时候产生问题,后期使用也是存在问题的,比如SCAN域名只能定义一个SCAN IP。 阅读详情

相关推荐

技术分享 | Oracle-RAC修改IP信息

本文为墨天轮数据库管理服务团队第61期技术分享

Era666的博客 1403

oracle rac 修改scanip

oracle rac调整scan ip

winderss的博客 1343

Oracle 11g Rac 修改 “SCAN-IP”

Oracle 11g Rac 修改 “SCAN-IP” - 总体思路 1、停止scan_listener、停止scan 2、修改host对应的scan_ip 3、修改ocr注册信息 4、启动scan_listener、scan 5、分节点重启has服务 6、测试连接信息 停止scan_listener、停止scan --停止scan资源 srvctl stop scan_listener ...

glogin 3423

oracle rac 修改scan ip

以前在客户现场迁移完单节点到rac集群,客户要求迁移完成后,需要使用原来IP地址。Svrctl modify scan -n xxx(对应hosts配置名字)3 修改新RAC集群hosts配置文件的scan-ip为原生产库IP。目前自己处于学习阶段,如果文章有问题,请指正!1 迁移数据到新RAC集群后,停止原生产库。4 停止SCAN IP资源并检查集群。6、启动SCAN IP资源并检查资源。5 修改OCR中VIP资源的信息。2 修改原生产库主机IP地址。登高必自卑,行远必自迩。

qq_17121835的博客 838

【RAC】oracle 11g RAC修改scan-ip

oracle 11g RAC修改scan-ip查看scan ip的状态信息[grid@rac1 ~]$ srvctl config scan SCAN name: rac-cluster-scan, Network: 1/192.168.70.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP: /rac-cluster-scan/192.168.70.13...

debimeng 1617

别再让C盘爆红了!手把手教你将Anaconda虚拟环境迁移到其他盘(附权限问题解决)

本文详细指导如何将Anaconda虚拟环境从C盘迁移到其他驱动器,解决C盘空间不足问题。通过conda config命令和直接修改.condarc配置文件两种方法,确保环境迁移顺利进行,同时提供权限问题解决方案和长期维护技巧,帮助用户高效管理虚拟环境。

weixin_42525289的博客 420

Oracle RAC集群IP地址修改

修改集群IP地址:(跨网段修改) 修改前规划: 当前IP地址配置: IP地址 映射名 网卡名 备注 192.168.199.203 rac1 eth0 一节点公网IP 192.168.199.204 rac2 eth0 二节点 公网IP 192.168.199.201 rac1-vip / 一节点 VIP 192.168.199.202 rac2-vip / 二节点 VIP 172.16.1.10 rac1-priv eth1 一节点 私网IP 172.16.1.20

dbhang的博客 3434

抖音X-Medusa风控逆向:unidbg环境重建与魔改AES还原

X-Medusa并非传统加密算法,而是深度耦合运行时环境的动态混淆系统,其核心是硬件指纹感知、线程上下文绑定与非标AES变异。理解其原理需跳出‘找密钥’思维,转向对CPU型号、系统属性、微秒级时间及内存布局的综合建模。技术价值在于将不可控的客户端风控,转化为可复现、可配置、可运维的服务化能力;典型应用场景包括合规数据采集、API协议适配与移动安全研究。本文聚焦Android native层逆向实践,基于unidbg实现高保真环境模拟,并完整还原S-Box动态生成、MixColumns矩阵变异与轮密钥XOR扰

weixin_33783283的博客 685

RAC系统主机修改ip、vip、scan_ip

1.停库、停集群 登录pgprsdb1,使用grid执行 srvctl stop database -db pgprsdb 分别登陆pgprsdb1、pgprsdb2用root用户执行 crsctl stop crs 2.主机修改ip(虽然主机ip已经变了,但是主机名称没有变,不需要重新做互信) 10.32.228.89 pgprsdb1---------->10.32.2...

661

【AI赋能】Sora + CapCut 打造爆款短视频:从脚本到发布的自动化工作流

本文详细介绍了如何利用Sora、Grok和CapCut等AI工具构建自动化短视频生产工作流。通过结构化Prompt生成专业脚本,借助Sora将文字转化为高质量视频素材,并利用CapCut进行高效剪辑与合成,实现从创意到发布的十倍效率提升,助力个人及团队打造爆款内容。

g8f9d0s1a2的博客 496

vue2 - 最新详细实现高德地图绘制动态热力图详细教程,在某区域或城市地图上做“热力图层“展示人流量、旅游人口密度、热量图、全国地区地理热力图,利用颜色的深浅表示密度或强度等场景(详细示例代码教程)

vue2,nuxt2,高德地图,热力图,绘制热力图层,报错,卡顿,出不来怎么办,无法关闭,怎么解决这个问题,出错,城市名称,城市某个街道,城区,省份,市区,县城,乡镇,村,各省份的热力图,交通流量,人口流量,密度,旅游出行,人口数量,颜色介绍,深浅代表,人流量,vue2使用高德地图实现某个区域热力图,vue高德地图api加载热力图及关闭,接收热力图数据并渲染热力图,关掉热力图,Vue使用高德API制作热力图,热力图加载不出来,电子围栏围住热力图,vue2中使用高德地图渲染热力图组件,高德地图使用热力图详细教

✅ 精选推荐文章 4201

Oracle Rac 修改vip scan ip

方案:选择同一网段,不同ip地址 需求:需要网络工程师规划两组ip(一组用于备库rac,另一组用于修改ip时,将报表库的ip替换出来,本次迁移建议不做私有ip的修改) -------------------------------------------------------------------以一节点修改public ip实验测试------------------------------...

云计算、数据库、大数据、容器、微服务、深度学习、NLP、Python 1030

ANFIS实现数据非线性回归附Matlab代码

在本文中,我们将介绍如何使用Matlab实现基于MSE的ANFIS非线性回归,并提供相应的源代码。ANFIS是一种融合了模糊逻辑和神经网络的方法,它可以通过学习数据集中的模式来构建一个模糊推理系统。ANFIS的训练过程基于最小化MSE,以提高模型的拟合能力。通过上述代码示例,我们可以使用基于MSE的ANFIS模型对数据进行非线性回归,并获得相应的预测结果。在示例中,我们定义了一个包含两个样本的新输入数据集 X_new,然后使用训练好的ANFIS模型进行预测,并将结果存储在变量 Y_pred 中。

2301_79326588的博客 473

关于RAC修改scan ip

修改scan ip无需停止数据库实例,asm或crs 例如:scan ip需要从192.168.10.24改为192.168.10.25 在节点1,进入grid安装的bin目录,查看当前scan ip状态信息 (需以root用户执行) [root@rac1 bin]# ./srvctl config scan SCAN name: jzh-cluster-scan, Network:1/192.168.1.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP:/

qq_39111199的博客 988

lammps教程:ovito免费输出高清图片方法

基本原理是调用ovito软件包中的TachyonRenderer模块,该模块可实现Tachyon渲染,达到和ovito 2.9 Tachyon完全相同的效果。这种方法在后来的ovito版本中已经不能使用,但是ovito 2.9版本在后处理方面功能较少,使用起来也不是特别方便。在之前的推文中,曾介绍过使用ovito 2.9版本更换Tachyon渲染器实现高清图片的输出。这个方法只需要配置ovito模块即可,完全免费,不需要购买ovito pro版。具体的配置参数可到ovito官网查询。大家好,我是小马老师。

lammps_jiayou的博客 2766

8、对比 LightGBM、XGBoost 和深度学习

本文对比了LightGBM、XGBoost和深度学习模型(特别是TabTransformer)在处理表格数据时的性能差异。从模型复杂度、数据准备、训练时间、准确性和适用场景等方面进行分析,重点探讨了三者在人口普查收入预测任务中的表现。文章详细介绍了XGBoost与LightGBM的核心特性与区别,深入讲解了TabTransformer的架构与实现,并涵盖了分类特征编码、缺失值处理和类别不平衡等关键数据预处理技术,为选择合适的表格数据建模方法提供了实践指导。

julia4scientist的博客 120

Oracle 11gr2修改RAC集群的scan ip,并处理ORA-12514问题

1.查看scan ip的状态信息 grid@cwgsdb1:~$srvctlconfigscan SCANname:rac-scanip,Network:1/100.100.100.0/25...

cizhanliang7973的博客 826

刷机维修进阶教程-----adb禁用错了系统app导致无法开机 如何保数据无损恢复机型

在刷机维修过程中 。我们会遇到一些由于客户使用adb指令来禁用手机app而导致手机无法开机进入系统的故障机型。通常此类问题机型有好几种解决方法。但如果客户需要保数据来恢复机型。其实操作也是很简单的.还有类似误删除应用导致不开机等等如何保数据。  通过博文了解💝💝💝    1💝💝💝----adb禁用或者删除系统app导致无法开机的几种解决方法 2💝💝💝----如何保数据来无损恢复机型 3💝💝💝----其他保数据解决系统类故障无法开机的步骤解析

小马哥的专栏 1352

ORACLE修改RAC集群IP

1、停止两节点监听自动启动 srvctl disable listener 2、停止两节点监听 srvctl stop listener 3、禁止两节点自动启动数据库、停止数据库 srvctl disable database -d racdb 4、停止两节点数据库 srvctl stop database -d racdb -o immediate 5、禁止两节点自动启动vip srvc...

搬服务器专家 541

Data-Structures-and-Algorithm-Analysis-in-Java.pdf

作者: Weiss, Mark A. 出版社: Addison Wesley Data Structures and Algorithm Analysis in Java is an “advanced algorithms” book that fits between traditional CS2 and Algorithms Analysis courses. In the old ACM Curriculum Guidelines, this course was known as CS7. This text is for readers who want to learn good programming and algorithm analysis skills simultaneously so that they can develop such programs with the maximum amo...

深度学习工具包 DeepLearningToolbox

深度学习工具包Deprecation notice.-----This toolbox is outdated and no longer maintained.There are much better tools available for deep learning than this toolbox, e.g. [Theano](http://deeplearning.net/software/theano/), [torch](http://torch.ch/) or [tensorflow](http://www.tensorflow.org/)I would suggest you use one of the tools mentioned above rather than use this toolbox.Best, Rasmus.DeepLearnToolbox================A Matlab toolbox for Deep Learning.Deep Learning is a new subfield of machine learning that focuses on learning deep hierarchical models of data.It is inspired by the human brain's apparent deep (layered, hierarchical) architecture.A good overview of the theory of Deep Learning theory is[Learning Deep Architectures for AI](http://www.iro.umontreal.ca/~bengioy/papers/ftml_book.pdf)For a more informal introduction, see the following videos by Geoffrey Hinton and Andrew Ng.* [The Next Generation of Neural Networks](http://www.youtube.com/watch?v=AyzOUbkUf3M) (Hinton, 2007)* [Recent Developments in Deep Learning](http://www.youtube.com/watch?v=VdIURAu1-aU) (Hinton, 2010)* [Unsupervised Feature Learning and Deep Learning](http://www.youtube.com/watch?v=ZmNOAtZIgIk) (Ng, 2011)If you use this toolbox in your research please cite [Prediction as a candidate for learning deep hierarchical models of data](http://www2.imm.dtu.dk/pubdb/views/publication_details.php?id=6284)```@MASTERSTHESIS\{IMM2012-06284, author = "R. B. Palm", title = "Prediction as a candidate for learning deep hierarchical models of data", year = "2012",}```Contact: rasmusbergpalm at gmail dot comDirectories included in the toolbox-----------------------------------`NN/` - A library for Feedforward Backpropagation Neural Networks`CNN/` - A library for Convolutional Neural Networks`DBN/` - A library for Deep Belief Networks`SAE/` - A library for Stacked Auto-Encoders`CAE/` - A library for Convolutional Auto-Encoders`util/` - Utility functions used by the libraries`data/` - Data used by the examples`tests/` - unit tests to verify toolbox is workingFor references on each library check REFS.mdSetup-----1. Download.2. addpath(genpath('DeepLearnToolbox'));Example: Deep Belief Network---------------------```matlabfunction test_example_DBNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit RBM and visualize its weightsrand('state',0)dbn.sizes = [100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);figure; visualize(dbn.rbm{1}.W'); % Visualize the RBM weights%% ex2 train a 100-100 hidden unit DBN and use its weights to initialize a NNrand('state',0)%train dbndbn.sizes = [100 100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);%unfold dbn to nnnn = dbnunfoldtonn(dbn, 10);nn.activation_function = 'sigm';%train nnopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.10, 'Too big error');```Example: Stacked Auto-Encoders---------------------```matlabfunction test_example_SAEload mnist_uint8;train_x = double(train_x)/255;test_x = double(test_x)/255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit SDAE and use it to initialize a FFNN% Setup and train a stacked denoising autoencoder (SDAE)rand('state',0)sae = saesetup([784 100]);sae.ae{1}.activation_function = 'sigm';sae.ae{1}.learningRate = 1;sae.ae{1}.inputZeroMaskedFraction = 0.5;opts.numepochs = 1;opts.batchsize = 100;sae = saetrain(sae, train_x, opts);visualize(sae.ae{1}.W{1}(:,2:end)')% Use the SDAE to initialize a FFNNnn = nnsetup([784 100 10]);nn.activation_function = 'sigm';nn.learningRate = 1;nn.W{1} = sae.ae{1}.W{1};% Train the FFNNopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.16, 'Too big error');```Example: Convolutional Neural Nets---------------------```matlabfunction test_example_CNNload mnist_uint8;train_x = double(reshape(train_x',28,28,60000))/255;test_x = double(reshape(test_x',28,28,10000))/255;train_y = double(train_y');test_y = double(test_y');%% ex1 Train a 6c-2s-12c-2s Convolutional neural network %will run 1 epoch in about 200 second and get around 11% error. %With 100 epochs you'll get around 1.2% errorrand('state',0)cnn.layers = { struct('type', 'i') %input layer struct('type', 'c', 'outputmaps', 6, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %sub sampling layer struct('type', 'c', 'outputmaps', 12, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %subsampling layer};cnn = cnnsetup(cnn, train_x, train_y);opts.alpha = 1;opts.batchsize = 50;opts.numepochs = 1;cnn = cnntrain(cnn, train_x, train_y, opts);[er, bad] = cnntest(cnn, test_x, test_y);%plot mean squared errorfigure; plot(cnn.rL);assert(er<0.12, 'Too big error');```Example: Neural Networks---------------------```matlabfunction test_example_NNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);% normalize[train_x, mu, sigma] = zscore(train_x);test_x = normalize(test_x, mu, sigma);%% ex1 vanilla neural netrand('state',0)nn = nnsetup([784 100 10]);opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samples[nn, L] = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.08, 'Too big error');%% ex2 neural net with L2 weight decayrand('state',0)nn = nnsetup([784 100 10]);nn.weightPenaltyL2 = 1e-4; % L2 weight decayopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex3 neural net with dropoutrand('state',0)nn = nnsetup([784 100 10]);nn.dropoutFraction = 0.5; % Dropout fraction opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex4 neural net with sigmoid activation functionrand('state',0)nn = nnsetup([784 100 10]);nn.activation_function = 'sigm'; % Sigmoid activation functionnn.learningRate = 1; % Sigm require a lower learning rateopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex5 plotting functionalityrand('state',0)nn = nnsetup([784 20 10]);opts.numepochs = 5; % Number of full sweeps through datann.output = 'softmax'; % use softmax outputopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex6 neural net with sigmoid activation and plotting of validation and training error% split training data into training and validation datavx = train_x(1:10000,:);tx = train_x(10001:end,:);vy = train_y(1:10000,:);ty = train_y(10001:end,:);rand('state',0)nn = nnsetup([784 20 10]); nn.output = 'softmax'; % use softmax outputopts.numepochs = 5; % Number of full sweeps through dataopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, tx, ty, opts, vx, vy); % nntrain takes validation set as last two arguments (optionally)[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');```[![Bitdeli Badge](https://d2weczhvl823v0.cloudfront.net/rasmusbergpalm/deeplearntoolbox/trend.png)](https://bitdeli.com/free "Bitdeli Badge")

oracle-rac 修改集群IP

修改ORACLE rac集群IP: 1.备份OCR,手工备份: ocrconfig -export /tmp/ocr.bak 2.关闭数据 srvctl stop database -d qhdb 3.关闭集群资源 crsctl stop res -all 4.关闭crs(两个节点) crsctl stop crs -f 5.修改网卡配置文件和/etc/hosts表 6.启动两个节点的CRS crsctl start crs 7....

anshen_oracle的博客 449

锂电池充电器电路设计 里面有电路

锂电池充电器电路设计 里面有电路 3.7V升压到5V电路设计。

数据库学习案例20240206-oracle 19C RAC跨网段修改IP_rac更换ip

前几天客户有套19C的需求调整,需要将原先的地址跨网段修改IP地址,包括public_ip,vip,scan_ip等。之前在11g版本也多次实施过网络调整,所以一开始也就完全按照11g的过程来调整IP地址,经过实战后发现还是和11g的版本在个别命令上有所区别。那么今天我就在虚拟机环境上,把19C的网络地址修改实验过程做一个完整的记录,供大家学习参考💖💖。

oradbm的博客 732

Devexpress16.2.6破解工具

Devexpress16.2.6破解工具Devexpress16.2.6破解工具Devexpress16.2.6破解工具Devexpress16.2.6破解工具

oracle 11g RAC 修改public ip ,vip , scan ip

有的时候因为网络环境更变,数据库需要更改public ip ,vip 和 scan ip 环境:redhat 5.7 + oracle 11.2.0.3  RAC   + raw 实例名:ASM   、+ASM1  、   +ASM2 数据库名:racdb 数据库实例名:racdb1  、 racdb2 原来IP信息: # add by RAC in

okhymok的博客 968

修改RAC scan_ip配置双scan_ip

修改RAC scan_ip配置双scan_ip

zongzizz的博客 2538

rac多scan-ip配置

rb和cc若在一套rac cluster上,需要配置两个scan-ip来规避可能的后续操作,当前环境已有一个scanip,增加scanip的步骤 检查当前scan和scan_listener的状态 grid@rac1[/home/grid]$srvctl config scan SCAN name: rac-cluster-scan, Network: 1 Subnet IPv4: 10.45.53.0/255.255.255.0/ens192, static Subnet IPv6: SCAN

Du.的博客 2063

oracle rac 添加 多个scan ip,你不可不知道的坑!

在修改scan ip时需注意如果新增了scan ip的个数,则需执行srvctl modify scan_listener -u进行更新,若不执行该命令,将只有一个listener_scan1监听,执行后将根据scan ip数自动增加listener_scan2,listener_scan3。关注我,学习更多的数据库知识!详情请查看oracle rac 添加 多个scan ip,你不可不知道的坑!

老苏畅谈运维 855
上一篇: PostgreSQL升级:使用pg_upgrade进行大版本(16.3)升级(17.0)
下一篇: 由于目录权限问题导致Oracle RAC 重启遭遇ORA-01078、ORA-01565、ORA-17503、ORA-12547报错处理过程
听雪楼主.
博客等级 码龄10年 513粉丝 214原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值