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.