ORACLE-10gR2-RAC环境增加及删除节点.docx资源-CSDN文库

版权申诉

oracle

5 浏览量 2023-10-25 21:53:16 上传评论收藏 3.66MB DOCX 举报

资源推荐

资源详情

资源评论

ORACLE 10gR2 RAC 环境增加及删除节点

一、初始化第 3 台节点 ............................................................................................................2

配置 hosts 文件...........................................................................................................2

配置 SSH 密钥认证....................................................................................................3

配置 ASM 共享盘.......................................................................................................4

二、添加 clusterware 到新节点................................................................................................5

检查安装环境 .............................................................................................................5

安装 clusterware 到新节点.........................................................................................7

三、复制 oracle 软件到新节点...............................................................................................14

四、配置监听服务到新节点...................................................................................................18

五、添加实例到新节点 ..........................................................................................................25

六、移除节点 ..........................................................................................................................31

删除DATABASE 实例.............................................................................................31

删除 ASM 实例.........................................................................................................36

删除节点 ...................................................................................................................36

[oracle@jssdbn1 ~]$ scp ~/.ssh/authorized_keys jssdbn2:~/.ssh/authorized_keys

authorized_keys

100% 3000 2.9KB/s 00:00

[oracle@jssdbn1 ~]$ scp ~/.ssh/authorized_keys jssdbn3:~/.ssh/authorized_keys

oracle@jssdbn3's password:

authorized_keys

配置 SSH 密钥认证

RAC 环境中各节点间不仅时刻保持通讯，而且还有可能互访文件，因此必须要保证各

节点间访问不需输入DBA 手动密码即可自动完成，这里我们通过配置SSH 来实现这一点。

首先是在新增加的节点时操作，即jssdbn3 节点(注意执行命令的用户)：

然后转至jssdbn1 节点执行，也是以 oracle 身份进行操作(执行过程中，当访问远端节点

时可能需要输入目标节点的密码)：

最后传输jssdbn1 节点中配置好的认证密钥信息到节点 2 和节点 3，执行命令如下：

[oracle@jssdbn1 ~]$ ssh jssdbn3 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys

The authenticity of host 'jssdbn3 (192.168.10.13)' can't be established.

RSA key fingerprint is 95:23:18:7a:5b:a9:5f:48:d7:1e:1a:f9:01:ec:f0:b1.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added 'jssdbn3,192.168.10.13' (RSA) to the list of known hosts.

oracle@jssdbn3's password:

[oracle@jssdbn1 ~]$ ssh jssdbn3 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys

oracle@jssdbn3's password:

[root@jssdbn3 ~]# su - oracle

[oracle@jssdbn3 ~]$ mkdir ~/.ssh

[oracle@jssdbn3 ~]$ chmod 700 ~/.ssh

[oracle@jssdbn3 ~]$ ssh-keygen -t rsa

Generating public/private rsa key pair.

Enter file in which to save the key (/home/oracle/.ssh/id_rsa):

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in /home/oracle/.ssh/id_rsa.

Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.

The key fingerprint is:

37:89:ec:6a:49:2d:18:5d:9d:c2:7c:66:84:b0:2e:94 oracle@jssdbn3

[oracle@jssdbn3 ~]$ ssh-keygen -t dsa

Generating public/private dsa key pair.

Enter file in which to save the key (/home/oracle/.ssh/id_dsa):

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in /home/oracle/.ssh/id_dsa.

Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.

The key fingerprint is:

43:f1:b1:9f:e6:ec:b5:b0:74:72:24:22:22:5c:24:ca oracle@jssdbn3

剩余42页未读，继续阅读

评论收藏

内容反馈

版权申诉

小小哭包

粉丝: 1899
资源: 3854

ORACLE-10gR2-RAC环境增加及删除节点.docx

deploying-oracle-11gr2-rac-on-rhel6_1

Linux-Oracle-11gR2-RAC安装配置.docx

Oracle-11g-R2-RAC-with-ASM存储迁移-手记.docx

deploying-oracle-11gr2-rac-on-rhel6.pdf

Linux-Oracle-11gR2-RAC安装配置.doc

ORACLE-11G-R2-在RED-HAT6.3环境中搭建RAC集群及简单维护.docx

【Oracle-RAC】Linux--Oracle-11g-R2-RAC-安装配置详细过程V3.0(图文并茂)

Linux--Oracle-11g-R2-RAC-安装配置详细过程V3.0(图文并茂).zip

VMware搭建Oracle-11g-RAC测试环境-For-Linux.docx

ORACLE_10gR2_RAC升级ORACLE_10gR2_RAC升级

Oracle 11gR2 RAC + ASM on AIX-6.1安装指导手册

ORACLE-11G--RAC安装文档.docx

Linux-Oracle-12c-RAC安装配置v1.0.docx

Oracle11GR2RAC及负载均衡搭建手册.docx

OracleRAC数据库测试报告.docx.docx

oci.dll 12版本全部

数据库系统概念（原书第七版）课后作业题

fineReport课后10题答案.zip

win64-11gR2-client.zip

Oracle19c-Windows客户端

oracle 12c windows 安装包下载

Kingbase KCA题库

Oracle11安装依赖包，11.2.0.4.0版本

Oracle19c(19.3)数据库驱动ojdbc.jar

OracleClient-19C Oracle客户端，包括windows和Linux

2024年日历excel和Oracle新增sql（标记上班日，周末，节假日）

DBeaver Oracle驱动

欧拉系统安装oracle 11g

最新资源