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?
|
|
|
|
|
|