Oracle 11gR2 RAC 环境测试修改节点VIP的测试操作记录-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Oracle 11gR2 RAC 环境测试修改节点VIP的测试操作记录

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 05:58 PM

oracleracvRevisetestenvironmentnode

第一部分：测试条件

A、IP地址

192.168.1.52    node1

192.168.1.53    node2

192.168.1.55    node1-vip

192.168.1.56    node2-vip

10.10.10.52     node1-priv

10.10.10.53     node2-priv

192.168.1.60    racdb-cluster-scan

B、版本：Oracle 11gR2 （11.2.0.2）

第二部分：测试过程

测试目标：将192.168.1.52服务器的VIP 192.168.1.55修改成为192.168.1.62

测试步骤：

1、确定本机cluster的网络接口

$ oifcfg iflist -p -n

2、确定本机的public 和private借口配置信息

$ oifcfg getif

3、确定本机的虚拟IP，VIP地址，VIP子网掩码

$ srvctl config vip -n node1

$ srvctl config nodeapps -a

4、停止node1上的orcl1的实例（Oracle用户操作）

$ srvctl stop instance -d orcl -i orcl1

（经测试也可以不down instance，如果不停掉节点的instance，则必须down掉配置的service）

5、停止node1上的监听服务

$ srvctl stop listener -n node1

由于listener是使用的VIP，这也使用了VIP服务，这两部分是有关联关系的。

6、停止VIP地址

$ srvctl stop vip -n node1

7、验证VIP地址不再运行

$ ifconfig -a

8、修改/etc/hosts

# vi /etc/hosts

9、修改节点应用以及提供新的vip地址(grid用户操作)

$ srvctl modify nodeapps -n node1 -A 192.168.1.55/255.255.255.0/bond0

10、启动节点VIP (grid用户操作)

$ srvctl start vip -n node1

11、验证VIP地址运行状态(grid用户操作)

$ srvctl config vip -n node1

VIP exists: /node1-vip/192.168.1.62/192.168.1.0/255.255.255.0/bond0, hosting node node1

12、启动node1上的监听服务（grid用户操作）

$ srvctl start listener -n node1

13、启动node1上的orcl1的实例（Oracle用户操作）

$ srvctl start instance -d orcl -i orcl1

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AM

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AM

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

See all articles