I have previously shared how to run the Oracle Database 23c Free database on an X86 Mac using PodMan, you can find that blog post here. But what about Oracle 23ai and the newer M1/M2/M3 ARM based Apple silicon Macs I hear you ask, so here you go. Preparation Start by installing the Homebrew package manager, if not already installed. brew update % brew --versionHomebrew 4.3.8 And confirm Oracle SQLcL is available. % sql -vSQLcl: Release 24.1.0.0 Production Build: 24.1.0.087.0929 Now, install Colima container runtime and Docker if not already installed on your Mac. brew install colima d ..read more

Oracle Linux Server Configuration For this blog post I will be using an Oracle Linux 8 server and a Pure Storage FlashArray to demonstrate how block volumes can be presented to an Oracle Linux 8 database server via iSCSI. Let’s start by logging in as root and configuring the Linux database server to support Internet Small Computer System Interface Protocol (iSCSI). Note: for Oracle RAC servers you will need to perform the steps below on each node of the cluster. Install iscsi-initiator-utils yum install iscsi-initiator-utils -y yum install lsscsi Install multipath yum install device-map ..read more

In this blog post I will share how to configure an Oracle Linux 8.9 server and Podman to work with Docker Compose. Docker Compose is a command-line tool used for defining and the running single, or multi-container applications.  Docker Compose simplifies the management of the entire application stack, making it easy to manage services, networks, and volumes all from a single, easy to read YAML (Yet-Another-Markup-Language) formatted file. Install and confirm Podman installed Install the Podman package if not already installed, using the below. sudo dnf module install container-tools:ol8 ..read more

Background As many of you may already know, I have been a long time supporter of running Oracle on NFS, having deployed many Oracle E-Business suite, single instance and RAC databases on NFS over years. However, for many Oracle DBAs NFS (Network File Systems) is still something of an unknown entity, in this post I hope to demystify Oracle on NFS. What is NFS (Network File System) NFS is a distributed file system protocol that provides clients access to shared resources like files and directories in file systems located on a server. Clients can remotely read files and write to files on the ..read more

I recently published a blog on restricting Linux block storage IO sizes using Kernel settings, but what if you don’t have root access, or want a more dynamic approach for your Oracle Database. In this blog post I am going to explore the use of multiblock read count (MBRC) on an Oracle 19c Database. Oracle Multi Block Read The Oracle db_file_multiblock_read_count (MBRC) parameter specifies the maximum number of blocks read in one I/O operation during a sequential scan. From the Oracle 19c Database documentation: The default value of this parameter is a value that corresponds to the maximum I/O ..read more

A colleague recently asked me an interesting question, How can I reduce the size of a physical IO on Linux? So here’s a blog that hopefully answers that question. Linux Operating System For this blog I will be using a Linux server with a Kernel that has a default maximum size of 1280KB (if you are running an older Kernel you may still be using 512KB, another reason to upgrade) connected to Pure Storage FlashArray which supports a maximum transfer size of 4MB. The Linux Kernel has 2 parameters in the /sys/block file system used to manage physical block IO sizes: max_hw_sectors_kb  ..read more

I have previously shared how to run the Oracle Database 23c FREE database on an X86 Mac using PodMan, you can find that blog post here. But what about the newer M1/M2 Macs I here you ask ? Well, I have just got myself and new 2023 MacBook Pro with the Apple M2 Pro ARM based chipset, so it’s time to look into running Oracle Database 23c Free on Apple M2. Preparation Start by installing Homebrew package manager. brew update % brew --version Homebrew 4.1.17 Now, install Colima container runtime and Docker if not already installed on your Mac. brew install colima docker % colima --versio ..read more

In Part 1 of this blog series I shared how to create a Pure Storage FlashBlade S3 compliant Object Storage account, user and bucket. I also demonstrated how to download the MySQLairportdb database, and upload objects into the Object Store S3 bucket. In Part 2, I showed how we can use the MySQL Shell to install the aiportdb database dump into a MySQL 8 database using the S3 Object Storage bucket. In this blog post I will show how we can also use the MySQL Shell to dump a MySQL 8 database to an S3 Compatible Object Storage bucket. Create Bucket Let’s start by creating a new Bucket in our previou ..read more

In this short blog post I am going to share how to upload a large file to Oracle Cloud Infrastructure (OCI) Object Storage using the AWS CLI to perform a concurrent multipart upload. For this post I will use a large 4GB file to demonstrate an upload. Let’s start by creating a file called bigfile using the Linux dd command, for example. dd if=/dev/random of=bigfile bs=1024 count=4096000 AWS Configuration Values The AWS CLI documentation details a number of configuration options which can be set for the aws s3 and aws s3api commands. Update AWS S3 multipart_threshold, multipart_chunksize and m ..read more

In my previous blog post I shared how to setup a Pure Storage FlashBlade S3 compliant Object Storage account, user and bucket. I also demonstrated how to download the MySQLairportdb database, and upload objects into the Object Store S3 bucket. If you want to follow along with this post, you can review the setup steps here. In this blog post I will show how we can use the MySQL Shell to install the aiportdb database dump into a MySQL 8 database using the S3 Object Storage bucket previously created. List S3 Bucket Use the s3cmd ls command or aws s3api list-buckets command to confirm the buc ..read more