Tag: Oracle

Feed: Planet MySQL; Author: Andrew Grimo; Getting started with authentication_oci There is a new means of connecting seamlessly to a MySQL Database Service instance in the Oracle Cloud Infrastructure. It is a method that does not require passwords, and can utilize the public key found in a OCI user’s account profile, without anyone needing to access that profile directly . It derives its access based on its account profile, and any OCI Groups that it might be associated. Usage of proxy users is also a by design option too, but not required. A method that enables an OCI user’s access ... Read More

Feed: Recent Announcements. Amazon Relational Database Service (Amazon RDS) for Oracle now supports M6i and R6i instances. M6i instances are the 6th generation of Amazon EC2 x86-based General Purpose compute instances, designed to provide a balance of compute, memory, storage, and network resources. R6i instances are the 6th generation of Amazon EC2 memory optimized instances, designed for memory-intensive workloads. Both M6i and R6i instances are built on the AWS Nitro System, a combination of dedicated hardware and lightweight hypervisor, which delivers practically all of the compute and memory resources of the host hardware to your instances.   M6i and R6i ... Read More

Feed: Recent Announcements. Oracle PSUs contain bug fixes and other critical security updates. Beginning with Oracle Database version 12.2.0.1, Amazon RDS for Oracle supports Release Updates (RU) in place of the PSU. To learn more about the Oracle PSUs supported on Amazon RDS for each engine versions, see the Amazon RDS for Oracle Release notes. If the Auto minor version upgrade (AmVU) option is enabled, the DB instance is upgraded to the latest quarterly PSU or RU six to eight weeks after it is made available by Amazon RDS for Oracle in your AWS region. These upgrades will happen during ... Read More

Feed: Recent Announcements. To create a new Oracle Database 21c RDS instance with just a few clicks in the AWS Management Console, use the "Launch DB Instance" wizard and select the DB engine version starting with "Oracle 21.0.0.0.*". Amazon RDS for Oracle supports major version upgrade from 19c CDB to 21c. Amazon RDS for Oracle currently does not support major version upgrade from non-CDB (12.1, 12.2, 19c) to 21c. To upgrade your existing RDS for Oracle instances to 21c with just a few clicks from the "Modify DB Instance Wizard" in the AWS Management Console select the DB Engine version ... Read More

Feed: Recent Announcements. Oracle PSUs contain bug fixes and other critical security updates. Beginning with Oracle Database version 12.2.0.1, Amazon RDS for Oracle supports Release Updates (RU) in place of the PSU. To learn more about the Oracle PSUs supported on Amazon RDS, see the Amazon RDS patch update documentation. If the Auto minor version upgrade (AmVU) option is enabled, the DB instance is upgraded to the latest quarterly PSU or RU six to eight weeks after it is made available by Amazon RDS for Oracle in your AWS region. These upgrades will happen during the maintenance window. To learn ... Read More

Feed: Recent Announcements. Amazon Relational Database Service (Amazon RDS) for Oracle now supports two new customer modifiable sqlnet.ora parameters for the Oracle Native Network Encryption (NNE) option. This feature allows customers to block older ciphers and algorithms from being used by the SQL*Net encryption and checksum parameters. You can configure the SQLNET.ALLOW_WEAK_CRYPTO_CLIENTS parameter to allow or deny an outgoing client connection using a non-secure cipher, SQLNET.ALLOW_WEAK_CRYPTO parameter to allow or deny incoming connections when the client uses non-secure ciphers like DES, 3DES, RC4, and non-secure checksumming algorithms like MD5. Both parameters are set to TRUE by default, but it is recommended ... Read More

Feed: Recent Announcements. Amazon Relational Database Service (Amazon RDS) for Oracle and Amazon Aurora now support Database Activity Streams in the Asia Pacific (Jakarta) region. Database Activity Streams provides a near real-time stream of database activities to meet your relational database for compliance and regulatory requirements . When integrated with third party database activity monitoring tools, Database Activity Streams can monitor and audit database activity to provide safeguards for your database. Solutions built on top of Database Activity Streams can help protect your database from internal and external threats. The collection, transmission, storage, and processing of database activity is managed ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; If like me you like to share some data between all your devices (presentations, keypassX file, pictures, …), you probably use a cloud platform to store all that. I do like to keep control of such solution, I used ownCloud and now I’m using Nextcloud. In this article I will show you how to easily deploy Nextcloud on Oracle Cloud (OCI) using MySQL Database Service (MDS) and Object Storage. The easiest way to deploy solutions on OCI is to use Terraform and Resource Manager’s Stack. If you already have an account on Oracle Cloud, ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; On the previous article we saw how to easily deploy Apache Zeppelin on OCI with MySQL using Terraform. In this article we will see how we can accelerate queries enabling MySQL HeatWave. Enabling HeatWave If you used a MySQL Database Service Shape compatible with HeatWave (MySQL.HeatWave.VM.Standard.E3), using the same Resource Manager Stack, you have the possibility to enable HeatWave and deploy a HeatWave Cluster for your MySQL. The first think to do, is to edit the previous applied stack: As we used a HeatWave compatible shape, we have the choice to deploy a HeatWave ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; Apache Zeppelin is a web-based notebook notebook that enables data-driven, interactive data analytics, machine learning, and collaborative documents with SQL, Scala, Python, R. In this article we will see an easy method to deploy Apache Zeppelin on Oracle Cloud with MySQL Database Service ... Read More