OraFAQ Forum: Streams & AQ » setting up streams on 9i

Home » Server Options » Streams & AQ » setting up streams on 9i (9.2.0.7.0)

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

setting up streams on 9i [message #548354]

Wed, 21 March 2012 09:32

piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

I tryed to setup streams between ORA20 (11g on windows2003) and ORA21 (11gon windows2003) and ORA22 (9i on windows2003).

ORA20 (11g) ---> ORA21 (11g) works perfectly.
ORA20 (11g) ---> ORA22 (9i) have basics problems with environment configuration.
after execution....

 DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
    privilege     => DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, 
    grantee       => 'STRMADMIN', 
    grant_option  => TRUE);

..which is one of fist step in streams configuration i receive

ORA-03113: end-of-file on communication channel

does this version on windows 2003 support streams?

alert log is empty after executing this statement. database works. there is need to connect again to db after executing this procedure because I am losing connection and nothing is happening.

did some of you have experience with streams configuration on 9i?

Report message to a moderator

Re: setting up streams on 9i [message #548357 is a reply to message #548354]

Wed, 21 March 2012 09:40

Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Who say you can setup Streams between 9i and 11g?

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regards
Michel

Report message to a moderator

Re: setting up streams on 9i [message #548364 is a reply to message #548357]

Wed, 21 March 2012 10:12

piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

but i can't even execute DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE without disconnecting with database - one of the firsts step during this configuration. fresh created database.
on the same server i have another instance (the same version 9i) and DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE execute properly. but i need to run this procedure on this fresh created db.

thanks Michael.

Report message to a moderator

Re: setting up streams on 9i [message #548376 is a reply to message #548364]

Wed, 21 March 2012 12:20

Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Michel Cadot wrote on Wed, 21 March 2012 15:40

...
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regards
Michel

Report message to a moderator

Previous Topic:	how to create oracle streams
Next Topic:	Streams replication from source and not from target

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 26 16:04:10 CST 2021