Introduction Oracle GoldenGate is a software product that allows you to replicate, filter, and transform data from one database to another in real-time. It can be used to migrate databases with (near) zero downtime. As logical replication, source and target databases could be of different versions, platforms, and character sets. Even many non-Oracle databases are supported.…
You’ll get this message if Your source database uses a single-byte character set (e.g. WE8ISO8859P1), and Your column width is defined using BYTE length semantic, and You have some column values that do not fit when using a multi-byte character set (e.g. UTF8) as Autonomous Database does If you are not familiar with these terms,…
Oracle Data Pump enables you to move data and metadata from one database to another, providing an extensive range of benefits. The followings are tips and best practices to consider: 1. Run Autonomous Database Schema Advisor First of all, check the database schemas you want to export from the source database using the Autonomous Database Schema…
Scripts, batch jobs, and application code need to provide a database username and password to connect to the database. Using wallets risk is reduced because such passwords are no longer exposed in plain text, and password management policies are more easily enforced without changing application code whenever user names or passwords change. Connect using the connect…
Security is a primary concern for enterprise customers and one of the most discussed topics when it comes to move to the cloud. The same questions are being raised again and again: Is the cloud secure? Is my data safe their? Does it meet my compliance requirements? Before starting with the technical security features that…
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 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…
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…
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…
