Select Page

Migrating Oracle Databases from Operating System Specs

Author: Ozwen Coelho | 4 min read | May 30, 2024


 

Migrating an Oracle database is an exciting task, and a DBA puts all their energy in the process of designing various methods to migrate the database from one server to another.

 

Typically, the DBA selects the best approach for migrating databases by considering the business requirement, and then migrates the database.

STOP !!!

Let’s consider databases as humans. When we plan to migrate to another city, we focus on the climate conditions, apartments, transportation, health care facilities, and the list goes on.

We calculate all the things revolving around the human and make sure that we can migrate and sustain easily.

The same goes for databases. We must also focus on the operating system that the database is migrating to.

What to Consider from an Operating System Point of View

  • Certification: Database version must be certified with the operating system.
  • CPU: Number of cpu/processors/sockets, its model and MHz.
  • Cores: Number of cores decides the average number of active sessions per second that the database can handle.
  • Memory: Sufficient memory to support the database.
  • Swap Space: Sufficient swap space as per Oracle guidelines, depending on the memory allocated.
  • Huge Pages: Huge page setting should be carried forward from source to target.
  • Packages: Mandatory packages/rpm’s as per Oracle documentation.
  • Storage: IOPS comparison.
  • Network: NIC card/Module/Interface/Speed and ports.
  • Time zone: Source and target time zone should be the same.

Conclusion

Migrating Oracle databases involves meticulous planning and consideration, especially when it comes to the underlying operating system. Each factor, from certification to network capabilities, plays a crucial role in ensuring a smooth transition. By prioritizing these operating system specifications, you can avoid common pitfalls and ensure that your database not only migrates successfully but also thrives in its new environment. Remember, the goal is not just to move your database but to enhance its performance and reliability post-migration.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

PostgreSQL vs. Oracle: Let’s Compare

Discover some key differences between PostgreSQL vs Oracle that can help you make an informed decision when deciding on a database management system.

Vijay Muthu | March 30, 2021

Oracle RMAN Backup and Recovery with Restore Points

Oracle restore points are useful for benchmark testing. Find out how you can use Oracle’s Recovery Manager (RMAN) tool to create and use restore points.

Cindy Putnam | May 3, 2019

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS