Home » Server Options » Streams & AQ » Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS (Oracle 10.2.0.1, Os: Linux)
Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #346580] Mon, 08 September 2008 23:38 Go to next message
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..
Re: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #346591 is a reply to message #346580] Tue, 09 September 2008 01:28 Go to previous messageGo to next message
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');


Smile ...

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 Go to previous messageGo to next message
babuknb
Messages: 1736
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/
Re: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #346692 is a reply to message #346603] Tue, 09 September 2008 06:56 Go to previous messageGo to next message
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 Go to previous messageGo to next message
varunvir
Messages: 389
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
Re: Stopping failed DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS [message #348512 is a reply to message #347169] Wed, 17 September 2008 01:36 Go to previous message
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..
Previous Topic: Log of Rejected LCRs in Stream Replication.
Next Topic: EM showing creation of same Archivelog twice
Goto Forum:
  


Current Time: Thu Mar 28 03:41:30 CDT 2024