OracleRAC数据库测试报告.docx

.

DSDBServer4
-4配置相同硬件供给商：H3=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=dsdbserv?jp)(PORT=1521))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=AMDB)(INSTANCE_NAME=AMDB3)
)
)AMDB2=
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dsdbserveip)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=AMDB)(INSTANCE_NAME=AMDB2)
)
)
AMDB1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=dsdbservzjp)(PORT=1521))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=AMDB)(INSTANCE_NAME=AMDB1)
)
)
AMDB=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=dsdbservzjp)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=dsdbserv^(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=dsdbservvjpKPORT=1521))
(LOAD_BALANCE=yes)
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=AMDB)
)
)
AMDB_STANDBY=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=dsdbserver4)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=AMDB)
)
)〔对AMDB2和AMDB3同样配置〕，sqlplus命令下逐一登录NAMDB1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=AMDB)(INSTANCE_NAME=AMDB1)
)
)
测试项
测试结果
备注
AMDB1单节点连接
正常
AMDB2单节点连接
正常
AMDB3单节点连接
正常
，sqlplus命令下登录NAMDB=
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(FAILOVER=ON)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=AMDB)(FAILOVER_MODE=
(TYPE=SELECT)(METHOD=BASIC)(RETRIES=20)
(DELAY=5))
)
)
测试项
测试结果
备注
基于服务的多地址连接
正常
=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))
(FAILOVER=ON)
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=AMDB)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RET