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

（编辑：晋中站长网）

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