Search This Blog

Sunday, January 27, 2008

knllgobjinfo: MISSING Streams multi-version data dictionary!!!


Part-I ---- how to setup stream replication between two databases
http://dbataj.blogspot.com/2008/01/oracle-streams-setup-between-two.html
Part-II --- how to add new site in existing stream replication
http://dbataj.blogspot.com/2008/01/oracle-streams-adding-new-site-in.html

New TARGET Database alert.log found below error message
knllgobjinfo: MISSING Streams multi-version data dictionary!!!

Source Database: DB1
Existing TrgtDB: DB2
New Trgt DB: DB3

WORKAROUND:
Existing Target Database: DB2
1. Stop apply process at all existing target sites
SQL> conn strmadmin/strmadmin@db2
Connected.
SQL> exec dbms_apply_adm.stop_apply('apply_stream');

PL/SQL procedure successfully completed.

Source Database: DB1
2. Prepare instantiation SCN
SQL> conn strmadmin/strmadmin@db1
Connected.
SQL> begin
2 dbms_capture_adm.prepare_table_instantiation(table_name => 'scott.taj');
3 end;
4 /

PL/SQL procedure successfully completed.

Existing Target Database: DB2
3. Start apply process at all existing target database
SQL> conn strmadmin/strmadmin@db2
Connected.
SQL> exec dbms_apply_adm.start_apply('apply_stream');

PL/SQL procedure successfully completed.

5 comments:

Anonymous said...

Hi, constantly i used to check blog posts here early in the break
of day, since i enjoy to gain knowledge of more and more.


my site; yellow

Anonymous said...

Spot on with this write-up, I seriously feel this
web site needs much more attention. I'll probably be returning to read through more, thanks for the information!

Also visit my web site; laythes

Anonymous said...

I tend not to create a leave a response, but I read a few of the responses on this page "knllgobjinfo: MISSING Streams multi-version data dictionary!!!".
I do have 2 questions for you if it's okay. Is it simply me or do a few of the comments look like they are written by brain dead visitors? :-P And, if you are writing at other online sites, I would like to keep up with you. Would you post a list of every one of your shared pages like your twitter feed, Facebook page or linkedin profile?

Here is my page :: samhoun

Anonymous said...

Every weekend i used to pay a visit this website,
as i wish for enjoyment, as this this site conations truly pleasant funny
stuff too.

Have a look at my website :: customized twitter backgrounds

Anonymous said...

I have been exploring for a little for any high quality articles or weblog posts on this kind
of space . Exploring in Yahoo I at last stumbled upon this web site.
Studying this info So i'm happy to exhibit that I've a very
good uncanny feeling I came upon exactly what I needed.
I so much for sure will make sure to do not overlook this
website and give it a look on a continuing basis.

Here is my weblog: methods to buy followers on social media service twitter