Oracle RAC 12c: A Recipe to Recover From Losing OCR, Voting Disk, or ASM Password

Starting with Oracle 11gR2, it is difficult to lose your OCR file or voting disk as they are stored in an ASM disk group with normal or high redundancy. The scenario below will corrupt the header of oracleasm disks that belong to disk group that has an OCR file, a voting disk, and ASM Password… read more

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

From The DBA Perspective: Highlights from Oracle OpenWorld 2017

Again this year Oracle OpenWorld was packed with too many keynotes, sessions and activities to choose from. In my very first blog post, I would like to talk about my personal favorites. Oracle OpenWorld 5k Run: Every year on Sunday morning, the SQL Developer team championed by Jeff Smith invites the community to run/walk/jog across… read more