1、硬件情况:
IBM P550一台,Power 5+处理器四颗,4G内存,73G硬盘两块
IBM P550一台,Power 5处理器两颗,2G内存,73G硬盘两块
建联 一台,146G×4
其中,P550作为主机,P550作为辅机,服务器上的两块硬盘都做成RAID 0,磁盘阵列上的4块硬盘做成RAID 5。
2、软件情况:
*作系统采用IBM AIX 5.3.0 64-bit
双机软件:使用IBM HACMP CASCADE 4.4.0.0双机软件
数据库:Oracle 9.2.0.1.0 for IBM AIX EE 64-bit
3、目前安装情况
192.168.0.61 oracle # P550_1上
192.168.0.62 oracle # P550_2上
我把软件和数据库都安装在阵列上(有人说两边都要安装数据库,有人说都可以。我觉得这样安装也可以,目前是这么安装的)
由于都装在阵列上面,编辑listener.ora和tnsnames.ora
# LISTENER.ORA Network Configuration File:
# /ora/oracle/product/9.2.0.1.0/network/admin/listener.ora
# Generated by Oracle Configuration tools:
LISTENER_MAIN =
( DESCRIPTION_LIST =
(DESCRIPTION =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP ) (HOST = 192.168.0.62 ) (PORT = 1521 )))
) )
SID_LIST_LISTENER_MAIN =
( SID_LIST =
( SID_DESC =
( SID_NAME = jmsb) (ORCLE_HOME = /ora/oracle/product/9.2.0.1.0 )
) )LISTENER_MAIN =
( DESCRIPTION_LIST =
(DESCRIPTION =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP ) (HOST = 192.168.0.61 ) (PORT = 1521 )))
) )
SID_LIST_LISTENER_MAIN =
( SID_LIST =
( SID_DESC =
( SID_NAME = jmsb) (ORCLE_HOME = /ora/oracle/product/9.2.0.1.0 )
) )# TNSNAMES.ORA Network Configuration File:
# /ora/oracle/product/9.2.0.1.0/network/admin/tnsnames.ora
# Generated by Oracle Configuration tools:
jmsb=
(DESCRIPTION =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP ) (HOST = 192.168.0.62 ) (PORT = 1521 )))
( CONNECT_DATA = ( SERVICE_NAME = jmsb)
) jmsb=
(DESCRIPTION =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP ) (HOST = 192.168.0.61 ) (PORT = 1521 )))
( CONNECT_DATA = ( SERVICE_NAME = jmsb)
)
4、目前的运行状况
192.168.0.61 oracle # P550_1上
192.168.0.62 oracle # P550_2上
运行HACMP的双机命令clstart之后,能看到的是:虚拟地址192.168.0.1和P550_2地址
192.168.0.62。数据库只能在192.168.0.62 startup,客户端netconfiguration用192.168.0.62才能成功。
如果不运行HACMP的双机命令,数据库在192.168.0.61或是192.168.0.62 startup,客户端netconfiguration用192.168.0.61或是192.168.0.62都能成功。
5、问题
a、我这样安装是不是可行?
b、双机怎么进行数据库的切换、接管?
c、我写的listener.ora和tnsnames.ora对不对,是不是要用虚拟地址?
d、在实现双机后,客户端的NETCONFIGURATION配置是不是应该用虚拟地址?
IBM P550一台,Power 5+处理器四颗,4G内存,73G硬盘两块
IBM P550一台,Power 5处理器两颗,2G内存,73G硬盘两块
建联 一台,146G×4
其中,P550作为主机,P550作为辅机,服务器上的两块硬盘都做成RAID 0,磁盘阵列上的4块硬盘做成RAID 5。
2、软件情况:
*作系统采用IBM AIX 5.3.0 64-bit
双机软件:使用IBM HACMP CASCADE 4.4.0.0双机软件
数据库:Oracle 9.2.0.1.0 for IBM AIX EE 64-bit
3、目前安装情况
192.168.0.61 oracle # P550_1上
192.168.0.62 oracle # P550_2上
我把软件和数据库都安装在阵列上(有人说两边都要安装数据库,有人说都可以。我觉得这样安装也可以,目前是这么安装的)
由于都装在阵列上面,编辑listener.ora和tnsnames.ora
# LISTENER.ORA Network Configuration File:
# /ora/oracle/product/9.2.0.1.0/network/admin/listener.ora
# Generated by Oracle Configuration tools:
LISTENER_MAIN =
( DESCRIPTION_LIST =
(DESCRIPTION =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP ) (HOST = 192.168.0.62 ) (PORT = 1521 )))
) )
SID_LIST_LISTENER_MAIN =
( SID_LIST =
( SID_DESC =
( SID_NAME = jmsb) (ORCLE_HOME = /ora/oracle/product/9.2.0.1.0 )
) )LISTENER_MAIN =
( DESCRIPTION_LIST =
(DESCRIPTION =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP ) (HOST = 192.168.0.61 ) (PORT = 1521 )))
) )
SID_LIST_LISTENER_MAIN =
( SID_LIST =
( SID_DESC =
( SID_NAME = jmsb) (ORCLE_HOME = /ora/oracle/product/9.2.0.1.0 )
) )# TNSNAMES.ORA Network Configuration File:
# /ora/oracle/product/9.2.0.1.0/network/admin/tnsnames.ora
# Generated by Oracle Configuration tools:
jmsb=
(DESCRIPTION =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP ) (HOST = 192.168.0.62 ) (PORT = 1521 )))
( CONNECT_DATA = ( SERVICE_NAME = jmsb)
) jmsb=
(DESCRIPTION =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP ) (HOST = 192.168.0.61 ) (PORT = 1521 )))
( CONNECT_DATA = ( SERVICE_NAME = jmsb)
)
4、目前的运行状况
192.168.0.61 oracle # P550_1上
192.168.0.62 oracle # P550_2上
运行HACMP的双机命令clstart之后,能看到的是:虚拟地址192.168.0.1和P550_2地址
192.168.0.62。数据库只能在192.168.0.62 startup,客户端netconfiguration用192.168.0.62才能成功。
如果不运行HACMP的双机命令,数据库在192.168.0.61或是192.168.0.62 startup,客户端netconfiguration用192.168.0.61或是192.168.0.62都能成功。
5、问题
a、我这样安装是不是可行?
b、双机怎么进行数据库的切换、接管?
c、我写的listener.ora和tnsnames.ora对不对,是不是要用虚拟地址?
d、在实现双机后,客户端的NETCONFIGURATION配置是不是应该用虚拟地址?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货