Oracle Team

RMAN channels in RAC

By Franck Pachot . When you want to minimize the backup or restore duration, you can parallelize RMAN operations by allocating multiple channels. If you are in cluster, you can open channels from several nodes. Let's see why, how, and(…)

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

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 -(…)

IBM Bluemix Database Cloud Service – My first trial

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(…)

New features into the Cloud

The last Week end Oracle has proceeded to a new upgrade into the Oracle Cloud. For the Data Region EMEA Oracle Database Public Cloud Services had maintenance on : Oracle Java Cloud Service Oracle Database Cloud Service Unfortunately it is(…)

DBA, turkeys and NoSQL hype

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(…)

SQL> alter database switchover to …

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(…)

Oracle Cloud Service – my first outage

By Franck Pachot . We experienced the first planned outage this week-end, so let's see how it is notified and what happens.

You are in Standard Edition, when to worry?

By Franck Pachot . A previous blog post explaining what happens for those in 'Standard Edition One' had a "don't worry" in the title because you can upgrade to SE2 with minimal additional cost - except(…)

11.2.0.4 support? Don’t worry until 2017

By Franck Pachot . Customers reluctant to go to 12c before 12.2, in addition to Standard Edition contract changes when going to 12c, has lead to lot of upgrades to 11.2.0.4 but what about support? Don't worry. It's supported for(…)

dbsnmp expiring password, manually triggering metrics collections

When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a(…)