It’s the little things that matter. A look at Database Migration & Upgrade Gotcha’s

Ready to migrate & upgrade Oracle Database? Have you configured tempfiles.d daemon? Have you updated the db credentials? Is your list of clients accessing the db complete? Let's look at trivial, not-so-trivial & best practices & tools that can help make your migration a success. This talk will present an ever-growing almanac for Oracle database migrations and upgrades, which consists of various tricks and tips to optimize the migration exercise. It will demonstrate the significance of leveraging the latest Oracle database and examine ancillary Oracle tools, scripts, checklists and best practices. For all organizations, change is inevitable. Attend the session to learn how to survive and thrive during your migration & upgrade project. Other topics we would discuss include time server (chrony), best practices for job migrations including db stat collection jobs, migrating database services, preparing for backups, monitoring and tools like orachk, dbstat and AHF and their role in helping us through the migration. These tips are outcome issues I've experienced while going through multitudes of migrations. So we will also look at the various resources that can help the attendee navigate the rough waters.

Defence against the Dark Arts – Spell’s for DBA’s to secure databases

The spell has been cast, and the evil forces are lurking in the shadows, but are you ready for a fight? Hop on to join Dumbledore’s DB Army as we learn to brew our security potions, practice database safety duels & put on our kevlar. In this era of “cyber-espionage”, where network security steals the prime focus on every organization, database security is often overlooked. Like in any battle, let’s spend some time & understanding the battlefield and common database vulnerabilities. During this session, we will look at some elementary instruments, e.g. listeners, security patches, database roles, privileges, users, and audits- that a DBA can use to build a strong shield around the databases. Along with this, we will glance at various tools that can be leveraged to assess & detect threats. Let us also explore best practices that can help us conduct forensics in case of an incident. So, if you want to learn the various “low-hanging fruits” that can give you a quick win or delve into more complex solutions, this session is most certainly for you