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

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

Jun 07, 2016 pm 05:58 PM
oracle rac v Revise test environment node

第一部分:测试条件 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) 第二部分:测试

第一部分:测试条件

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 of this Website
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1665
14
PHP Tutorial
1270
29
C# Tutorial
1249
24
What to do if the oracle can't be opened What to do if the oracle can't be opened Apr 11, 2025 pm 10:06 PM

Solutions to Oracle cannot be opened include: 1. Start the database service; 2. Start the listener; 3. Check port conflicts; 4. Set environment variables correctly; 5. Make sure the firewall or antivirus software does not block the connection; 6. Check whether the server is closed; 7. Use RMAN to recover corrupt files; 8. Check whether the TNS service name is correct; 9. Check network connection; 10. Reinstall Oracle software.

How to solve the problem of closing oracle cursor How to solve the problem of closing oracle cursor Apr 11, 2025 pm 10:18 PM

The method to solve the Oracle cursor closure problem includes: explicitly closing the cursor using the CLOSE statement. Declare the cursor in the FOR UPDATE clause so that it automatically closes after the scope is ended. Declare the cursor in the USING clause so that it automatically closes when the associated PL/SQL variable is closed. Use exception handling to ensure that the cursor is closed in any exception situation. Use the connection pool to automatically close the cursor. Disable automatic submission and delay cursor closing.

How to create cursors in oracle loop How to create cursors in oracle loop Apr 12, 2025 am 06:18 AM

In Oracle, the FOR LOOP loop can create cursors dynamically. The steps are: 1. Define the cursor type; 2. Create the loop; 3. Create the cursor dynamically; 4. Execute the cursor; 5. Close the cursor. Example: A cursor can be created cycle-by-circuit to display the names and salaries of the top 10 employees.

How to export oracle view How to export oracle view Apr 12, 2025 am 06:15 AM

Oracle views can be exported through the EXP utility: Log in to the Oracle database. Start the EXP utility, specifying the view name and export directory. Enter export parameters, including target mode, file format, and tablespace. Start exporting. Verify the export using the impdp utility.

What to do if the oracle log is full What to do if the oracle log is full Apr 12, 2025 am 06:09 AM

When Oracle log files are full, the following solutions can be adopted: 1) Clean old log files; 2) Increase the log file size; 3) Increase the log file group; 4) Set up automatic log management; 5) Reinitialize the database. Before implementing any solution, it is recommended to back up the database to prevent data loss.

What steps are required to configure CentOS in HDFS What steps are required to configure CentOS in HDFS Apr 14, 2025 pm 06:42 PM

Building a Hadoop Distributed File System (HDFS) on a CentOS system requires multiple steps. This article provides a brief configuration guide. 1. Prepare to install JDK in the early stage: Install JavaDevelopmentKit (JDK) on all nodes, and the version must be compatible with Hadoop. The installation package can be downloaded from the Oracle official website. Environment variable configuration: Edit /etc/profile file, set Java and Hadoop environment variables, so that the system can find the installation path of JDK and Hadoop. 2. Security configuration: SSH password-free login to generate SSH key: Use the ssh-keygen command on each node

Oracle's Role in the Business World Oracle's Role in the Business World Apr 23, 2025 am 12:01 AM

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.

How to stop oracle database How to stop oracle database Apr 12, 2025 am 06:12 AM

To stop an Oracle database, perform the following steps: 1. Connect to the database; 2. Shutdown immediately; 3. Shutdown abort completely.

See all articles