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;
Crawl process
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:3 4
One

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   ); ------The newly added
End
/

No error, Ora 25315.

Error 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

Establishment of the communication process

Stop the propagation.

Ensure that's source queue is empty.

Ensure that the destination \ Empty and has no unapplied, spilled messages before you drop the propagation.

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

---------------------------------------------------------------------------------------------
ORA-12545 Connect failed because target host or object does not exist problem for Oracle RAC

The Oracle 10.2.0.3 RAC on the aix5.3 system often reports the following error when connecting to the database:

Ora-12545:connect failed because target host or object does not exist

This problem can be resolved by setting the Local_listener parameters of each node of the RAC database in two ways:

Mode 1 edit $oracle_home/network/admin/tnsnames.ora on each node of the RAC, increasing

Local_listener_rac= (address_list= (Address= (PROTOCOL=TCP) (host=<vip>) (port=1521)) )

Wherein <vip> corresponds to each node's VIP address;

Modify the database parameters on any node of the RAC, setting Local_listener to Local_listener_rac

$ sqlplus/as SYSDBA Sql> alter system set local_listener= ' Local_listener_rac ' scope=spfile;

To restart a database instance on each node

Mode 2 You can also use the following method to modify a document with ID 364855.1 on Metallink
Set the Local_listener parameter on each node of the RAC by executing the following statement

Sql>alter system Set Local_listener= "(Address= (PROTOCOL=TCP) (host=<vip_address>) (port=1521))" Scope=both Sid= ' instance_name ';

Where <VIP_address> corresponds to each node VIP address;
Instance_name the instance name of the current node, such as Rac1, RAC2, and so on, that is, to modify only the parameters of the current instance at a time