Home » Server Options » Streams & AQ » ORA-604 During dropping a Propagation
ORA-604 During dropping a Propagation [message #169841] Sat, 29 April 2006 05:11 Go to next message
Eisele
Messages: 2
Registered: April 2006
Junior Member


I have strange problem with Streams:
Source: ORACLE 9.2.07. plus Patch 4285404
Target: ORACLE: 10.2.0.1

I, successfully create rules, a ruleset, capture and a propagation process, but no capturing took place, so I wanted to drop the rules, the ruleset, the capture and the propagation process, everthing was successfull, except dropping the propagation, I get the errormessage, which shown below.
I also include the definition of the db-link.

Any idea which would help me out there, would be greatly welcomed.

Regards,

Rüdiger
SQL> begin
2 DBMS_PROPAGATION_ADM.DROP_PROPAGATION(
3 propagation_name => 'PPV_STREAMS_PROPAGATION');
4 end ;
5 /
begin
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 556
ORA-06512: at "SYS.DBMS_PROPAGATION_ADM", line 82
ORA-06512: at line 2


SQL> select * from dba_db_links where db_link like '%PPV%' ;

OWNER
------------------------------
DB_LINK
--------------------------------------------------------------------------------
USERNAME
------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
--------
STRMADMIN
PPVDB.GLOBAL
STRMADMIN

OWNER
------------------------------
DB_LINK
--------------------------------------------------------------------------------
USERNAME
------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
--------
ppvdb
29.04.06


SQL> show parameter db_domain

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string global
SQL> show parameter global_name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean TRUE
SQL> select * from global_name
2 ;

GLOBAL_NAME
--------------------------------------------------------------------------------
WIZPROD1.GLOBAL

SQL>

Re: ORA-604 During dropping a Propagation [message #169993 is a reply to message #169841] Mon, 01 May 2006 10:06 Go to previous message
Eisele
Messages: 2
Registered: April 2006
Junior Member
The problem is fixed. Please see Metalink Note257803.1

Rüdiger
Previous Topic: Streams Paused for Flow Control
Next Topic: Streams -- How to check the delay
Goto Forum:
  


Current Time: Tue Sep 30 23:08:53 CDT 2014

Total time taken to generate the page: 0.10973 seconds