ra2 studio - Fotolia


Top Oracle tips and tricks of 2017 you won't want to forget

We've rounded up five of the most notable tip articles we published in 2017, with advice that can help make Oracle projects easier for IT teams to navigate and manage.

A lot of changes occurred in the Oracle world over the past year. As 2017 comes to an end, it's time to highlight some of the top Oracle tips and tricks we've published along the way. From how to perform a database upgrade to advice for saving money on Oracle licensing costs, our experts have shared valuable knowledge on deploying and managing Oracle environments.

Here are SearchOracle's top five tips of the year based on reader feedback.

Combat rising Oracle licensing fees

Oracle kicked off 2017 with a financial bang for users of non-Oracle cloud platforms. The company amended how its required license count is calculated, doubling the number of processor licenses needed to run its software in the Microsoft Azure and Amazon Web Services clouds.

Users shouldn't have been shocked by the new cloud policy given the strong hold Oracle has on the database market, as well as the fact that it pulled a similar tactic with rival server hardware years ago when it acquired Sun Microsystems.

Fear not, said Craig Guarente of licensing consultancy Palisade Compliance. In his article, Guarente shares a few of the Oracle tips and tricks he has up his sleeve and explains how it's possible to avoid falling victim to pesky higher Oracle licensing costs.

Choose between Oracle and Workday HCM

Trying to determine whether to go with Oracle or competitor Workday for cloud-based human capital management (HCM) software can be a daunting task if you don't know what to look for. Workday HCM has its roots in the cloud and has been considered one of the leaders when it comes to mobile HCM features.

Oracle HCM, on the other hand, is largely based on Oracle's Fusion applications and Taleo talent management software. Technical consultant Robert Sheldon breaks down the pros and cons of both HCM applications.

Manage a stress-free database upgrade

There are several reasons you should consider an Oracle Database 12c upgrade if you haven't already done one. First and foremost, it's one of only two versions Oracle completely supports ahead of an upcoming 18c release it detailed in September.

That being said, performing a database upgrade can be an overwhelming task; such projects require careful thought and planning. Mess up the upgrade and you may be faced with a disastrous situation. Expert Brian Peasland offers Oracle tips and tricks to avoid database upgrade headaches.

Select the best MySQL database

If you're new to the MySQL database world, you may have difficulty deciding which of Oracle's various offerings of the open source software is right for you. IT pros need to determine which features matter most to their organization, such as price, support, partitioning, backup and security.

In this tip, technical consultant Robert Sheldon takes a close look at various MySQL databases, including MySQL Standard Edition, MySQL Enterprise Edition, MySQL Cluster CGE and MySQL Community Edition.

Differentiate Oracle BICS and DVCS

Oracle Data Visualization Cloud Service (DVCS) and Business Intelligence Cloud Service (BICS) are both notable for visual analytics. Since these services share similar capabilities, they're often confused.

Oracle DVCS and BICS aren't interchangeable, however, and one may lend itself better than the other depending on the situation at hand. Technical consultant Robert Sheldon explains what makes Oracle BICS and DVCS different from one another.

Dig Deeper on Cloud computing infrastructure