Oracle 11gR2 RAC搭建（假造机搭建）

EM打点（oracle用户，个中一个节点执行即可，会见解点https://节点IP:1158/em 用户名暗码用上文配置的system之类的）

$ emctl status dbconsole
$ emctl start dbconsole
$ emctl stop dbconsole

当地sqlplus毗连
安装oracle客户端版修改tsnames.ora
D:developapporclproduct11.2.0client_1networkadmintsnames.ora
添加
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.248.110)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)12345678910

这里的HOST写的是scan-ip

sqlplus sys/[email?protected]_ORCL as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 礼拜四 4月 14 14:37:30 2016

Copyright (c) 1982,2010,Oracle. All rights reserved.

毗连到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning,Real Application Clusters,Automatic Storage Management,OLAP,
Data Mining and Real Application Testing options
SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

orcl1 OPEN

当开启第二个呼吁行窗口毗连时，发明实例名为orcl2，可以看出，scan-ip的插手可以具有负载平衡的浸染。

假如毗连的时辰有报错：ORA-12545
办理方案：
a.可以在本机hosts文件添加双机的vip
b.可能修改数据库的监听设置
SQL> show parameter local

NAME TYPE VALUE

local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=scan-vip)(PORT=1521))
parallel_force_local boolean FALSE

修改local_listener主机名为VIP-IP地点
SQL> alter system set local_listener=‘(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.149.202)(PORT=1521))‘ sid=‘orcl2‘;

System altered.

SQL> alter system set local_listener=‘(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.149.201)(PORT=1521))‘ sid=‘orcl1‘;

System altered.

容灾演练（模仿单机运行）
参考文档
https://blog.csdn.net/yujiajia111/article/details/82998601
本文参考文档：
https://blog.csdn.net/u014595668/article/details/51160783
https://www.cnblogs.com/lijiaman/p/7673795.html

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!