Infrastructure at your Service

Category

Oracle

Franck Pachot

Dbvisit replicate allows DDL replication even when source and destination have different structure

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . I’ve tested a little thing for a customer, and as usual I spool the result into a blog post in case it helps others. Not all replication software – at least in their current version – can manage both different target structure (which is often the main reason for logical replication) and keep up with new DDL on the source (which you can’t avoid – applications evolves). Let’s see how smart…

Read More
Franck Pachot

IBM Bluemix Database Cloud Service – My first trial

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Remember my first try of Oracle cloud when Larry Ellison announced the Cloud in june? This week at OOW15 Larry Ellison announced that IBM is not a competitor anymore for them, then I checked IBM Cloud: IBM Bluemix offers IaaS, PaaS and SaaS. As I did in my first trial for Oracle, I’m testing the simplest DB2 ‘SQL Database service’.

Read More
Franck Pachot

OOW15 – Day 3 – thoughts from DemoGrounds about SIZE AUTO

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . If you are at Oracle Open world, don’t miss the DemoGrounds where you can talk to product managers and developers. It’s a good way to know how and why something is implemented. They also listen to your user experience on their product, for possible evolution. But remember they are not there to receive complaints or answer your SR… Of course, I had a lot of very interesting discussions about current and…

Read More
Franck Pachot

OOW15 – Day 1- No fog on Golden Gate brige but Cloud everywhere at Moscone center

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Here are the two sides of the Oracle Open World: marketing and community. Of course Oracle organizes that big event for marketing: show the future products and explain how they are better than all competitors ones. But it’s not only that. There is a community around Oracle, of users, partners, technologists, speakers, authors, etc. And Oracle Open World is also the place to meet.

Read More
Franck Pachot

DBA, turkeys and NoSQL hype

By | Business Intelligence, Database management, Oracle | No Comments

By Franck Pachot . We (DBAs) look at this NoSQL hype with a large smile. We know how powerful are SQL databases and we can’t imagine processing data seriously without it. And the technologies that come with NoSQL brings back the problem that we have solved with SQL databases. But can’t we ignore what is currently going on. Behind the Big Data buzzwords there are real requirements. And if we refuse to listen to them,…

Read More
Franck Pachot

SQL> alter database switchover to …

By | Database Administration & Monitoring, Oracle | One Comment

By Franck Pachot . In 12c the manual switchover to physical standby requires only one command (ALTER DATABASE SWITCHOVER) instead of two (ALTER DATABASE COMMIT TO SWITCHOVER on each database). We usually recommend to use the broker and I wanted to see if the broker uses that new command or not. Let’s compare the alert.log for both manual and broker switchover. One simple command I have the broker configured, but try a manual switchover with…

Read More