OraFAQ Forum: Streams & AQ » Oracle streams with 10g source & 11g target

Home » Server Options » Streams & AQ » Oracle streams with 10g source & 11g target (Oracle 10.2.0.4 running on AIX5.3/ Oracle 11.2.0.1 running on RHEL5.4)

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

Oracle streams with 10g source & 11g target [message #460784]

Mon, 14 June 2010 15:42

divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA

Senior Member

Hi All,

I'm about to configure Oracle Streams with the Source database 10.2.0.4 & target 11.2.0.1. has anyone done this before?
If yes, can I get any useful documentation on this configuration, please, especially with performance on the source database (which in my case will be a Production database).

Thanks in advance...

- divroro12 -

Report message to a moderator

Re: Oracle streams with 10g source & 11g target [message #460785 is a reply to message #460784]

Mon, 14 June 2010 15:47

varunvir
Messages: 389
Registered: November 2007

Senior Member

But why dont you upgrade 10.2.0.4 to 11.2.0.1 before stream configuration.

Report message to a moderator

Re: Oracle streams with 10g source & 11g target [message #460787 is a reply to message #460785]

Mon, 14 June 2010 16:02

divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA

Senior Member

Don't wanna disturb a steady running Prod env't right now. This can open up room for more errors.

- divroro12 -

Report message to a moderator

Re: Oracle streams with 10g source & 11g target [message #460795 is a reply to message #460787]

Mon, 14 June 2010 18:55

varunvir
Messages: 389
Registered: November 2007

Senior Member

I dont think You can do that because 11g streaming has lot of new features in it.But please go through the stream document to make sure of this.
Regards,
Varun Punj,

Report message to a moderator

Re: Oracle streams with 10g source & 11g target [message #460949 is a reply to message #460795]

Tue, 15 June 2010 12:53

divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA

Senior Member

I submitted a tar on this with Oracle Support & was told it's feasible; I'll definitely try it, but am wondering if there's anyone out there who've done it before, so I can gain from his experience.

- divroro12 -

Report message to a moderator

Re: Oracle streams with 10g source & 11g target [message #472126 is a reply to message #460784]

Thu, 19 August 2010 00:00

dba_247
Messages: 1
Registered: November 2007

Junior Member

Good that you got confirmation from Oracle about Streams set up between 10g and 11g.

How did your POC go?

Any gotchas that you would like to share?

Sincerely,
Ram.
OCP DBA
OCP RAC Certified DBA

[Updated on: Thu, 19 August 2010 00:09]

Report message to a moderator

Re: Oracle streams with 10g source & 11g target [message #472747 is a reply to message #472126]

Mon, 23 August 2010 10:36

divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA

Senior Member

Yes, i did open a tar with Oracle support & they confirmed it is feasible; so I went ahead & implemented it, & are currently streaming...

- divroro12 -

Report message to a moderator

Previous Topic:	Drop rule set
Next Topic:	Same Queue with Multiple Payloads

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 21:54:09 CST 2025