在RAC上启动splex的队列出错，熟悉splex高手进来看看！

显示全部楼层 · 2010-3-1 11:07:22

是从两个节点的RAC复制到单机服务器上，数据库版本是10.2.0.4
节点1的tnsnames.ora
ORA10G1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb301-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10g)
(INSTANCE_NAME = ora10g1)
)
)

ORA10G2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb303-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10g)
(INSTANCE_NAME = ora10g2)
)
)
ORA10G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb301-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = oradb303-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10g)
)
)

RAC源库和目标库的/etc/hosts文件如下：
127.0.0.1 localhost.localdomain localhost
192.168.0.110 oradb301
192.168.0.109 oradb303
192.168.0.103 standby

节点的/etc/oratab文件配置如下：
+ASM1:/data/oracle/product/10.2.0/db_1:Y
ora10g:/data/oracle/product/10.2.0/db_1:Y

下面队列的文件
sp_ctrl (oradb301:2200)> edit config aaa
datasource:o.ora10g
#source tablestarget tables routing map
[email protected]

sp_ctrl (oradb301:2200)> activate config aaa
cnc_supplemental_log() Error connecting to Oracle
sp_ctrl (oradb301:2200)> show log
Press ENTER for next page, q to return to sp_ctrl command line.
Notice 2010-09-25 21:44:19.620970 13998 4139259584 User command: oracle copy config ORA_config to aaa (from oradb301)
Notice 2010-09-25 21:44:59.057401 13998 4139259584 User command: oracle edit/create config aaa (from oradb301)
Notice 2010-09-25 21:45:03.150881 13998 4139259584 Command server: Can't find home for Oracle SID ora10g(connecting from oradb301) [module pdb]
请问是不是哪里配置有问题，请高手帮忙看看，不甚感激！！

千问 · 2010-3-1 11:07:22

在RAC上安装splex，还需要哪些配置吗？

千问 · 2010-3-1 11:07:22

顶一下

千问 · 2010-3-1 11:07:22

顶一下