Oracle Database Standard Edition in the Cloud offers additional features including: All versions: Transparent Data Encryption, which is available only for Enterprise Edition on-prem. 18c onwards: Refreshable PDB Switchover, which is available only for EE on Engineered Systems (Exadata and ODA) on-prem. Additionally, in the Cloud you benefit from Automatic Backups, one-click Restore, one-click CPU up/down Scaling, and Simplified Patching. This…
End of February 2020 Private Endpoints in Autonomous Database on Shared Exadata Infrastructure were announced. This blog post shows an example architecture and a high-level step by step instruction for creating the necessary OCI resources to implement Private Endpoints to access the Autonomous Database from private network only. All values used here are an example and you are…
Oracle Cloud Infrastructure offers a wide range of cloud services that enable you to build and run applications and services in a highly available hosted environment in deferent regions around the globe. In case you have a Compute VM running in one region and want to migrate or clone it to another region, e.g. as a disaster recovery solution, here…
Oracle Autonomous Database eliminates the human labor associated with database tuning, security, backups, patching, upgrade, and other routine management tasks traditionally had to be performed manually. Other tasks like restore and recovery, migration, cloning, and moving data are done on demand (manually), but differently and more conveniently than on-premise. Data Pump is a very useful utility to extract…
Oracle Cloud is a world-class technology I can only encourage you to get familiar and proficient with! If you don’t have any training environment for hands-on experience, register for your Oracle Always Free account. In this blog post, I’m sharing my own experience, recommendations, and the learning path I went through. Feel free to create your own…
Oracle provides different technologies and methods to migrate Oracle databases across platforms. This decision tree is intended to provide an overview of options available to migrate Oracle on-premises databases to Oracle Cloud Database Service (DBCS) or Oracle Autonomous Database. Before making the final decision, review the Oracle documentation for all prerequisites, restrictions, and recommendations. Some…
In the Oracle Cloud, you can provision an Autonomous Database in minutes and start developing your APEX application immediatelly. If you don’t have an Oracle Cloud Account, register for the Always Free resources. From APEX, you can use the APEX_MAIL package to send emails using Oracle Cloud Infrastructure Email Delivery service. Check how easy it is to configure!!! Step…
Use Case: You have a website to be accessible from all over the world. If you were running a business like a web shop, response time to the different geographical locations would be very critical. Solution 1: One web server somewhere Your customers in other regions would probably suffer from low latency. Would this web server…
How many Databases are you running in test and development environments? On-premise, you buy the licenses, the hardware, pay for support, and pay the operation cost! 24×7! BUT! In most cases, nobody is using these databases at weekends, at night, and in different stages of the project. In the Cloud, you pay only for what…
One of the frequently asked questions about Autonomous Database is “how can I access the database without having the traffic traversing the internet?” In case you are keeping the Application on-prem, then the answer is using Transit Routing while connecting to Oracle Cloud Infrastructure (OCI) using VPN or FastConnect from the on-premises network. The architecture looks as simple as…
