Home » Server Options » Streams & AQ » setting up streams on 9i (9.2.0.7.0)
setting up streams on 9i [message #548354] Wed, 21 March 2012 09:32 Go to next message
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?
Re: setting up streams on 9i [message #548357 is a reply to message #548354] Wed, 21 March 2012 09:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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
Re: setting up streams on 9i [message #548364 is a reply to message #548357] Wed, 21 March 2012 10:12 Go to previous messageGo to next message
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.
Re: setting up streams on 9i [message #548376 is a reply to message #548364] Wed, 21 March 2012 12:20 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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

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


Current Time: Wed Dec 11 14:02:07 CST 2024