Chapter 9. Appendix and Glossary
Both the authors have put in many hours creating and rewriting this book. But, there are areas of Oracle Streams that fall outside the previous chapter. This chapter is the catch-all chapter dealing with subjects that did not quite fit in the previous chapters. Subjects that we wanted to mention to provoke thought are along the lines of the following:
Read on and be creative. Use what you have learned in this book to come up with solutions to problems. Know what Streams should be used for and when Streams is NOT a good fit.
Spend some time researching Oracle Streams on OTN or Google Oracle Streams and you will eventually come across Oracle Streams Commander (OSC). OSC comes out of Oracle Deutschland GmbH. It is a standalone product that is separate from Grid Control. Personally, I think it is a solution that probably came out of the Oracle Deutschland GmbH...
Spend some time researching Oracle Streams on OTN or Google Oracle Streams and you will eventually come across Oracle Streams Commander (OSC). OSC comes out of Oracle Deutschland GmbH. It is a standalone product that is separate from Grid Control. Personally, I think it is a solution that probably came out of the Oracle Deutschland GmbH Consulting group. OSC is a product that is constantly maturing and seems to be separate from the main development efforts of Oracle Headquarters.
As a tool, OSC is something I do not use because it is an Oracle Consulting solution and NOT an official Oracle product. But, you may like it for its ease of use and simple 'point and click' abilities. As the OSC matures more, I can envision it being an add-on "pack" to Grid Control. For more information on OSC, please visit the website http://www.oracle.com/global/de/community/platform/osc/index.html.
Oracle Real Application Cluster ( RAC) is one of the components used in Oracle Maximum Available Architecture (MAA). As such, we are seeing more Oracle RAC configurations being deployed more often to support High Availability requirements. Oracle Streams does work in an Oracle RAC configuration.
Pre-planning must be done in order to fully utilize both Oracle Streams and Oracle RAC. There must be careful considerations related to the design, and implementation of: Capture, Queues, Propagation, and Apply processes. Oracle RAC must be configured so that all archive logs can be accessed by Capture process. As Capture process will follow the Queue if an instance goes down, the configuration of Capture and Queues should be planned accordingly.
The use of the procedure DBMS_AQADM.ALTER_QUEUE_TABLE
is suggested to set up primary_instance
and secondary_instance
. This will help when determining where the Queue migrates, should an instance fail in a RAC environment. To determine...
Oracle has recently completed the acquisition of GoldenGate software during the writing of this book. The acquisition brings an exciting and interesting time to Oracle's line-up of Data Integration and Replication technology. Oracle Data Integration (ODI) is currently positioned as "a fully unified solution for building, deploying, and managing real-time, data-centric architectures in an SOA, BI, and data warehouse environment." While Oracle GoldenGate (OGG) provides "real-time, log-based change data capture, and delivery between heterogeneous systems."
Take note that both of these products are complementary to Oracle Streams. For instance, ODI provides advance ETL/ELT abilities in real time across heterogeneous environments. ODI essentially moves and transforms data regardless of the database platform.
OGG brings a strong story related to supporting heterogeneous environments. OGG brings XSTREAM to Oracle Streams. XSTREAM exposes APIs allowing for data sharing between ...
* indicates Oracle Parameter. Please refer to Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-03 for further details.