Every day and night, the SSH login by key into my public accessible Oracle Cloud Infrastructure Linux Compute Instance was permitted for hours. And sometimes, when I had luck, it worked. For me it was not clear when it works and when not. But something has blocked me. The password authentification in the OCI Linux instance is basically disabled, the key is the only way to log in. After some investigation on the OCI instance, I found a huge amount of login trials in the /var/log/secure file. These brute force attacks were locking me out! Nov 4 03:57:24 instance-as-1 sshd[1975]: Received disconnect from 132.232.17.146 port 53924:11: Normal Shutdown, Thank you for playing [preauth] Nov 4 03:57:24 instance-as-1 sshd[1975]: Disconnected from 132.232.17.146…
Read MoreYear: 2018
Easy Database Migration to Oracle Cloud Infrastructure OCI by Creating a Backup in the Cloud
Oracle has provided an updated OCI command line toolset with a new and easy method to migrate an on-premises database into the Oracle Cloud Infrastructure as DBaaS. According the document here, I have tried it out – and it works: https://docs.cloud.oracle.com/iaas/Content/Database/Tasks/mig-onprembackup.htm My Test Setup Oracle 18c Enterprise Edition with SID=ORA18 Single Tenant Architecture Oracle Linux 7.4 non TDE – Attention: non TDE on-premises data stays unencrypted in the cloud !!! Database and Server Prerequisites Archivelog Mode is enabled Parameter db_create_file_dest is set Server needs Internet Connection Oracle OCI CLI installed and configured – https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliinstall.htm#bash OPC Backup Module available – https://www.oracle.com/technetwork/database/availability/oracle-cloud-backup-2162729.html Java installed – https://www.java.com/de/download/help/linux_x64rpm_install.xml The OCI CLI Directory OCI CLI and opc_install.jar plus the .pem file have to be in the same directory. oracle@ol7ora18:~/migrate/…
Read MoreOracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 3
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 Import Prerequisites Credentials To get acccess to the dump file on the Oracle Object Storage, a credential has to be created in the Oracle Autonomous Transaction Processing database with the DBMS_CLOUD procedure. For more information about the package, see the blog post from Christian Antognini – DBMS_CLOUD Package – A…
Read MoreOracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 2
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 MoreOracle 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 More