Previously, SELECT published Why Your Database is Not Secure: A Prelude to the COLLABORATE 2019 Session. Over the next few weeks, I thought I would dive in a little deeper into the subject of database security based on that session. The presentation had four topic areas based on the time, effort, risk, and costs to perform. This article provides an overview on three areas that I believe are the lowest in time, effort, risks, and costs. I call these “Easy Pickings.”

Cloud migration is a journey. Migration projects need to be carefully planned, tested and executed and application and database performance needs to be continuously monitored to ensure ongoing success. We often hear about companies who have migrated their databases to the cloud only to find out that their monthly subscription bills are far higher than…

Samuel Pesse, an Oracle ACE, wrote in his blog about how to self-test your database. The content below is a republishing of his words.

Dimitri Gielis, the founder of AOP and APEX R&D, wrote about the best and cheapest Oracle APEX hosting - Oracle Cloud Free Tier.

Oracle GoldenGate Product Management is happy to announce free GoldenGate software licenses and support on OCI Marketplace. This promotional offer is valid for a limited period of time for existing Oracle Cloud customers who have already trusted and invested in Oracle Cloud and also to new customers who are planning to migrate data to Oracle Cloud in the next many months.

Juan Loaiza, Oracle's executive vice president of mission-critical database technologies, spoke at Oracle OpenWorld 2019 about four technology shifts that are reshaping the enterprise database.

Databases are critical to organizations and represent a significant part of total IT spend. That is why you want to deploy your database on the best-optimized platform and protect your data with backups. The Cloud is transforming the way enterprises do business for the better, and backup is no different. That’s where Oracle Cloud Backup for Oracle Database comes into play.

Alan Zeichick, Director of Strategic Communications for Oracle, wrote in Forbes about Oracle’s expansion of its global data center footprint and the Cloud regions that Oracle has been opening worldwide.

Juan Loaiza, Oracle Executive Vice President, gives a quick overview of Exadata X8 capabilities for OLTP, analytics, cloud, and Autonomous Database.

Exadata has been on the market for over 10 years, and today it is an extremely successful product. It runs many of the most mission-critical applications in the world, including petabyte warehouses, critical financial and e-commerce platforms, complex business applications, and massive database consolidations.

Oracle’s Multitenant Option was introduced in 12c Release as an efficient response to the Cloud technology challenges by reducing costs, streamlining processes and managing resources effectively. The architectural model consists of a Container Database (CDB) that controls the instance-wide maintenance activities and contains zero or more isolated pluggable databases (PDB) independently managed in terms of resources and security.

Initially, Oracle did not enforce the model but kept the legacy structures (the older Non-CDB instances) intact. Recently the non-CDB Option was deprecated, a decision that drives Oracle users to start adopting and converting their infrastructure to the new Option. In turn, this posed several challenges of its own and one of those is changing Pluggable Database level name, Container Database name, or Database ID (DBID). 

One possible use case is when a backup file of a PDB is received from a third-party software vendor whose name needs to change to meet the organization’s naming standards or to better convey the purposes of the database. Another scenario is to change the DBID of a cloned database to maintain its unique backup information repository in recovery catalog. In these, and similar situations, we can follow the methods explained below to achieve the required modifications. 

So, here I will provide detailed steps for three different changes that can be implemented in your Multitenant Architecture CDB environment:
-Changing PDB name
-Changing CDB name
-Changing Oracle DBID for all PDB’s

Please note that these changes might have consequences such as impacting backup & recovery. They should not be deployed in a production environment without proper planning and thorough testing.