Oracle Active DataGuard on AWS RDS

Reading the latest updates and news I found that AWS has introduced a read-only replica for their AWS RDS for Oracle with the Active DataGuard technology behind that. It allowed clients offload reporting and some read-only activity to the standby freeing the primary Oracle database for transactions. It was possible to use the Data Guard… read more

Oracle Cloud Infrastructure multi-factor authentication

For some time we didn’t have a multi-factor authentication in the Oracle cloud and those short-lived numeric codes were one of the best way to reinforce your protection and prevent a bad actor to break your credentials. It is not 100% protection but it is well better than a username and a password. Just recently… read more

Oracle 19c on LiveSQL

I used to write about the Oracle free service for developers livesql.oracle.com in the past. For those who work with Oracle databases and haven’t tested it I recommend go and try. It runs with a “SQL Developer like” interface with the ability to test syntax for your SQL queries, packages or procedures and provide a… read more

Considerations for ODA X7-2 HA Rack & Stack as well as Bare Metal Deployment

Installation of the ODA X7 has some new considerations. Oracle has made some key modifications and being prepared for the installation will save you time and effort. Following the steps listed in this blog post will help ensure a smooth installation. After racking the ODA, You will need to connect to the serial management (SER… read more

Upgrading the time zone file and timestamp with time zone data in a 12.2 Oracle database

It is sometimes necessary to upgrade the time zone file and timestamp with time zone (TSTZ) data in an Oracle database, for instance when you upgrade to a new version of the database or when the rules for Daylight Saving Time (DST) change. Since version 11.2, the update process was straightforward: one would simply download… read more