To answer this question for your company, the criticalness of your application and database must be clear. In a High Availability Environment, a standby-database can be part of the technical solution to ensure minimum downtime for your database. But when moving...
Life of an IT Infrastructure Designer
Jobacle
Webinar “Oracle migration to Postgres in the Cloud”
Recently I attended a webinar “Oracle migration to Postgres in the Cloud”. It felt a bit like cheating, as I'm more an Oracle guy and my company is Oracle Platinum partner…. But very curious how easy it is to migrate (it depends…) and what hurdles to expect. The...
Oracle disaster recovery without licensing the DR site
Recently I got a question of a customer regarding a failover configuration. They wanted to install a second server acting as a failover server, switched off until the primary experiences an outage, and they don't want to pay licenses for it. By bringing the...
No more RAC in SE2 19c
A short post after a tweet of Johannes Ahrends (@carajandb on twitter). He brought to our attention that he was worried: SE2 doesn't include RAC anymore in 19c. Is it a documentation bug? Unfortunately not... his worries appeared to be ligitimate. He made a...
Oracle licenses needed while monitoring your (non-)Oracle environment with OEM
With Oracle Enterprise Manager (OEM) you are able to monitor an Oracle environment as well as a non-Oracle environment, like Microsoft’s SQL Server. You are also able to exchange notifications between Oracle Enterprise Manager and e.g. Microsoft’s SCOM. How to monitor...
expdp, ora-1555, Query Duration = 0
During a migration of a database, a remote export/import procedure (through database-link) fails intermittently. Some tables are skipped during export, with the familiair 'ORA-0155' error. Snapshot too old. Procedure hasn't changed. What's going on, besides the...