Troubleshooting Oracle Streams

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