OraFAQ Forum: Streams & AQ » Stopping failed DBMS_STREAMS_ADM.MAINTAIN

Home » Server Options » Streams & AQ » Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS (Oracle 10.2.0.1, Os: Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #346580]

Mon, 08 September 2008 23:38

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

Hi Friends,

I am trying to configure Stream replication on my databases.
I completed all prerequisites for it like stream admin creation , archive log mode, db link creation etc.
After that when i executed procedure DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS, I got an error.
I solved the thing which was causing the problem , and then again gave the command to execute procedure DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS.
But this time i am getting error like :

ERROR at line 1:
ORA-23622: Operation SYS.DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS is in progress.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2334
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7451
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2624
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2685
ORA-06512: at line 2

Please tell me how to stop this..

Regards,
Dipali..

Report message to a moderator

Re: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #346591 is a reply to message #346580]

Tue, 09 September 2008 01:28

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

Hello Friends,

I Got the Solution..
Putting here so that other can have instant help..

we have to query

select * from DBA_RECOVERABLE_SCRIPT ;

From here we will get script_id..

Then, we can recover from the error using following procedure..

exec DBMS_STREAMS_ADM.RECOVER_OPERATION('<script_id>','ROLLBACK');

...

Then executed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS with corrected situation and parameter and everything is just fine like God Smile

Regards,
Dipali..

[Updated on: Tue, 09 September 2008 07:24] by Moderator

Report message to a moderator

Re: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #346603 is a reply to message #346591]

Tue, 09 September 2008 02:04

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

Senior Member

Thanks for your update.

After 251 post still your not understanding how to post code. Please read & follow Posting Guideline as stated in URL

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #346692 is a reply to message #346603]

Tue, 09 September 2008 06:56

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

Welcome, GentalBabu,

While i was stucked with the problem , and busy with my office work, i took time to post the solution so that other persons facing same problem can have solution.. While doing this in hurry, i forget to format the post.. Otherwise you can see my other posts.. Anywasy.. if my "sorry" can satisfy you, then "SORRY"...

Regards,
Dipali..

[Updated on: Tue, 09 September 2008 07:56]

Report message to a moderator

Re: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #347169 is a reply to message #346591]

Wed, 10 September 2008 23:05

varunvir
Messages: 363
Registered: November 2007

Senior Member

Hi dipali,

DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS 
Can you update me about Maintain_schema.Why are you using it 
for.

Regards,
Varun Punj

Report message to a moderator

Re: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #348512 is a reply to message #347169]

Wed, 17 September 2008 01:36

Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India

Senior Member

Varun,

MAINTAIN_SCHEMAS procedure is used to configure either bi-directional or uni-directional schema level stream replication..

You can find more information about it from http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_strm_a.htm#CDEDAJEB

Regards,
Dipali..

Report message to a moderator

Previous Topic:	Log of Rejected LCRs in Stream Replication.
Next Topic:	EM showing creation of same Archivelog twice

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 26 02:52:50 CST 2021