1 / 12

Troubleshooting Oracle Streams

This article provides an overview of Oracle Streams, a framework for information sharing, and offers tips and scripts for troubleshooting and configuring Streams. Learn how to identify common issues and effectively maintain Streams in your Oracle environment.

brownangela
Download Presentation

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