1 / 12

Troubleshooting Oracle Streams

This guide offers a clear introduction to Oracle Streams, the framework for information sharing between databases. Designed for beginners, it covers the components of Oracle Streams, the challenges you might face, and practical solutions to common issues. With a focus on configuration and maintenance, it addresses frequently asked questions about troubleshooting Streams. A live demo will be included to illustrate the concepts, making it easier to understand and apply in real-world scenarios. Learn how to be creative with your data routing effectively!

quincy-joseph
Télécharger la présentation

Troubleshooting Oracle Streams

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Troubleshooting Oracle Streams

  2. About Chen Shapira • Oracle Production DBA for HP SaaS • 10 years in IT: DBA, Developer, Manager, Linux sysadmin, Storage admin • OCP • ITIL Certified • Blogger • OTNer

  3. The Plot • Short explanation for the complete newbie • Introducing the problem • Overview of components • Live Demo!

  4. What are streams? • “Framework for information sharing” • Routing messages between databases. • Mostly used for replication and ETL • But it is so flexible – you can be very creative!

  5. Are streams scary? • No! Streams are easy to configure and maintain. • Yes! Streams have lots of moving parts, so there are lots of new things to learn and lots of things that can break.

  6. Easy to Configure • Lots of online guides for configuring streams: • Oracle documentation • Lewis Cunningham • and even me.

  7. Most frequent question in Oracle streams forums

  8. Streams Doesn’t Work? • Where do we start looking? We need to check each component. • For this we need to know our components and how to look at them.

  9. Mandatory Map

  10. Now I Configure Streams • With bugs, of course.

  11. What went wrong?

  12. These are just few of my favorite scripts

More Related