In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database using Oracle Data Pump. Part 1: Creation of the ATP database and connection verification Part 2: Export of on-premises data with Oracle Data Pump and move into into the Oracle cloud Part 3: Import of data into the ATP database with Oracle Data Pump Oracle Data Pump Export on On-Premises Database Oracle recommends the following settings for the Oracle Data Pump export job. If you use already an 18c database, you have to set the version parameter to 12.2 to avoid this error during ATP import process: ORA-39358: Export dump file version 18.0.0…
Read MoreCategory: Oracle RDBMS
Oracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 1
In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database Oracle Data Pump. Part 1: Creation of the ATP database and connection verification Part 2: Export of on-premises data with Oracle Data Pump and move into into the Oracle cloud Part 3: Import of data into the ATP database with Oracle Data Pump Basics about ATP from the Using Oracle Autonomous Transaction Processing User Guide: Autonomous Transaction Processing is designed to support all standard business applications and deliver scalable query performance. Autonomous Transaction Processing provides all of the performance of the marketleading Oracle Database in an environment that is tuned and optimized for transaction processing workloads. As…
Read MoreOracle Database Backup Service – Encrypt your 12.2 Database Backups to the Cloud
The Oracle RMAN backup encryption is necessary if you want to backup your database into the Oracle cloud. In Oracle 12c, you have three methods available to encrypt an Oracle RMAN backup: with a passphrase with a master encryption key hybrid with a passphrase and an encryption key On docs.oracle.com, the basic setup is described here: https://docs.oracle.com/en/cloud/paas/db-backup-cloud/csdbb/configuring-encryption-backups.html#GUID-4A1F5CF5-7EAF-4D71-9B7F-B46412F552CE In this blog post, I show you how to configure your database environment with a master encryption key and a keystore. I use this solution to to backup and recovery to and into the Oracle cloud. And in the cloud, I don’t like to type in passwords manually for every action or write passwords in backup and restore scripts. There are also some…
Read MoreOracle Database Appliance X6 – resize your /u01
Basically on an ODA X6-L the directory /u01 has the size of 100 GB. With seven different ORACLE_HOME directories for the Oracle databases and the Grid Infrastructure software, there is no disk space left for patching the Oracle Database Appliance. ODA patches require between 13 GB and 15 GB free space on /u01 for the new software. Just FYI – during the patch process a new stage directory called /u01/patching is created where the new software is temporarily located. Patch Apply failed – Not enough free Space If there is not enough free space available, update processes like updating a database home fail. [root@oda-srv2046 ~]# odacli describe-job -i f024f27d-7c9a-43fc-9ae8-4f99ef809280 Job details —————————————————————- ID: f024f27d-7c9a-43fc-9ae8-4f99ef809280 Description: DB Home Patching: Home Id…
Read MoreGet your Oracle 18c Instance in the Oracle Infrastructure Cloud OCI Classic
Do you want to work with Oracle 18c in the Oracle Cloud but the database version is not selectable in the webinterface? You can create an 18c instance in the command-line interface with the PaaS Service Manager (psm). The installation is very well described here, for example you need Python and OpenSSL. My personal installation of the psm executable runs in the Windows 10 integrated Ubuntu system. Link to the PaaS Service Manager: https://docs.oracle.com/en/cloud/paas/java-cloud/pscli/abouit-paas-service-manager-command-line-interface.html After the successful psm setup, you can create an DBaaS instance with this command $ psm dbcs create-service –config-payload db18c-ee.json The file db18c-ee.json contains all the information you need to create an 18c instance. Here is my example – I have created a cloud storage container…
Read More