Oracle RDBMS 19c is now certified on Oracle Linux 8. Unfortunately the Oracle Universal Installer in Silent Mode fails when checking the OS version. My OS release: [oracle@olten dbhome_1]$ cat /etc/oracle-release Oracle Linux Server release 8.2 Oracle Universal Installer in Silent Mode The OUI installer in silent mode stops and shows this error message: [WARNING] [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’. There is no parameter available like -ignoreOS or whatever, but two workarounds. [oracle@olten dbhome_1]$ ./runInstaller -ignorePrereq -waitforcompletion -silent \ -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp \ oracle.install.option=INSTALL_DB_SWONLY \ > -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp \ > oracle.install.option=INSTALL_DB_SWONLY \ > ORACLE_HOSTNAME=mohnweg.kestenholz.net \ > UNIX_GROUP_NAME=oinstall \ > INVENTORY_LOCATION=/u01/app/oraInventory \ > SELECTED_LANGUAGES=en,en_GB \ > ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 \ > ORACLE_BASE=/u01/app/oracle \ > oracle.install.db.InstallEdition=EE \ > oracle.install.db.OSDBA_GROUP=dba \…
Read MoreCategory: Oracle Linux
Oracle Cloud Infrastructure and SSH Keys – Jump!
Jump! In our Trivadis Oracle Cloud Infrastructure training environments, we never use direct access to an application or database server by a public IP address. For this case, we use an Oracle Linux based bastion host which acts as a jump host. For security reasons, I never put any SSH keys on a bastion host to connect from there to the target instances. If your bastion host is compromitted, your SSH keys are lost! In one of the last trainings, some participants had problems with. So I decided to blog about. This blog post shows you the different methods to connect to an Oracle Cloud Infrastructure private/public network by using a bastion host. SSH Keys Oracle Cloud Infrastructure Linux based…
Read MoreOCI Database Backup Service Configuration – Avoid 401 Unauthorized Error
While I a preparing new exercises for an Oracle Cloud Infrastructure training, I ran into an issue while configuring the Oracle Database Backup Service for the Object Storage. The OCI backup module installer returns an error 401. My Environment Oracle Linux 7 Virtual Box Machine Oracle 19c RDBMS Backup Service Module Installation Error The installation was done according the documenation https://docs.oracle.com/en/cloud/paas/db-backup-cloud/csdbb/oracle-database-cloud-backup-module-oci.html oracle@ocivm01:~/ [ONPREM] java -jar oci_install.jar -host https://objectstorage.eu-frankfurt-1.oraclecloud.com -pvtKeyFile /home/oracle/.ssh/oci_api_backup_key.pem -pubFingerPrint 1c:79:c5:d5:e4:3a:6e:f5:07:xx:xx:xx -uOCID ocid1.user.oc1..aaaaaaaanqt5qrcbwwseeud7cjfxqcip123456789abcdefghi -tOCID ocid1.tenancy.oc1..aaaaaaaac3gjl7xgpxu3wmmqh2ha123456789abcdefghi -walletDir $ORACLE_BASE/opc_wallet -libDir $ORACLE_HOME/lib -configFile /u01/app/oracle/admin/ONPREM/opc_config/ONPREM.ora -bucket db_backup_doag00 Error Message – java.io.IOException: testConnection: 401 Unauthorized Oracle Database Cloud Backup Module Install Tool, build 12.2.0.1.0DBBKPCSBP_2018-11-09 Error: Could not authenticate to Oracle Database Cloud Backup Module Exception in thread “main” java.lang.RuntimeException: java.io.IOException: testConnection: 401 Unauthorized. at…
Read MoreMonitor your Oracle Cloud Free Tier with Grafana on Oracle Linux 8
In a previous blog post I wrote about monitoring Oracle Cloud Infrastructure components by Grafana. In the meantime, we got the Oracle Cloud Free Tier. Here is an updated version. This blog post shows you how to install and configure the Grafana plugin based on the Oracle blog entry https://blogs.oracle.com/cloudnative/data-source-grafana on an Oracle Enterprise Linux 8 server. Steps to monitor the Oracle Cloud Free Tier by the OCI Grafana Plugin Install and configure the Oracle Cloud Infrastructure CLI – by download or by YUM install Configure Group, User and Policy in Oracle Cloud Infrastructure Console Install Grafana and the OCI Plugin Configure the Grafana DataSource Create a new Dashboard with OCI Metrics Machine Requirements The server needs access to the internet.…
Read MoreOCI Compute Instances – Stop SSH Brute Force Attacks with fail2ban & UseDNS
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 More