ORA-12545: Connect failed because target host or object does not exist

ORA-12545: Connect failed because target host or object does not exist

SQL> select status,error_message,error_date from dba_propagation;

抓取进程

select  CAPTURE_NAME,QUEUE_NAME,ERROR_MESSAGE,CAPTURED_SCN,APPLIED_SCN,status from dba_capture;

STATUS

----------

ERROR_MESSAGE

----------------------------------------------------------------------

ERROR_DATE

-------------------

DISABLED

ORA- 25315: unsupported configuration for propagation of buffered messa

ges

2013-09-05 07:54:34

一、  

begin
    dbms_streams_adm.add_schema_propagation_rules(
     schema_name => 'qbjmes',
     streams_name => 'qbjmes_to_racdb',
    source_queue_name => 'strmadmin.qbjmes_queue',
     destination_queue_name => 'strmadmin.racdb_queue@racdb',
    include_dml => true,
     include_ddl => true,
     include_tagged_lcr => false,
    source_database => 'qbjmes',

inclusion_rule => true

queue_to_queue => true);   ------新添加的
   end;
   /

不报错了ora 25315

报错 ora 12545

SQL> select PROPAGATION_NAME,SOURCE_QUEUE_NAME,DESTINATION_QUEUE_NAME,DESTINATION_DBLINK,RULE_SET_NAME,STATUS,ERROR_MESSAGE from dba_propagation;

PROPAGAT SOURCE_Q DESTINATION_QUEUE_NAME

-------- -------- ------------------------------

DESTINATION_DBLINK

--------------------------------------------------------------------------------

RULE_SET_NAME STATUS    ERROR_MESSAGE

--------------- ---------- ----------------------------------------------------

QBJMES_T QBJMES_Q MES_QUEUE_QBJ

O_MES  UEUE

MES

RULESET$_54      DISABLED        ORA-12545: Connect failed because target host or object does not exist

建立传播进程

1. Stop the propagation.

2. Ensure that the source queue is empty.

3. Ensure that the destination queue is empty and has no unapplied, spilled messages before you drop the propagation.

4. Re-create the propagation with the queue_to_queue parameter set to TRUE in the creation procedure.

---------------------------------------------------------------------------------------------

Oracle RAC的ORA- 12545 Connect failed because target host or object does not exist问题

aix5.3系统上的oracle 10.2.0.3 RAC，连接数据库的时候经常报如下错误：

ORA-12545: Connect failed because target host or object does not exist

这个问题可以通过设置rac数据库各个节点的local_listener参数来解决，有两种方式：

方式1

在RAC的每个节点上编辑$ORACLE_HOME/network/admin/tnsnames.ora，增加

local_listener_rac= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=<vip>)(PORT=1521)) )

其中 <vip>对应每个节点各自的vip地址；

在rac的任意一个节点上修改数据库参数，设置local_listener为local_listener_rac

$ sqlplus / as sysdba SQL> alter system set local_listener='local_listener_rac' scope=spfile;

重新启动各个节点上的数据库实例

方式2

也可以按照metallink上id为 364855.1的文档使用如下方法修改
在rac的每个节点上执行如下语句设置local_listener参数

sql>alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=<VIP_address>)(PORT=1521))" scope=both sid='instance_name';

其中 <VIP_address>对应每个节点的vip地址；
instance_name对应当前节点的实例名，如rac1、rac2等，即每次只修改当前实例的参数