Oracle Base Database Service Developer Edition – A Cost-Effective Way to Build in the Cloud

Since September 2025, Oracle Base Database Service offers a new edition: Developer – or better: Enterprise Edition Developer. For those who need OS-level access to the database system for file transfers, SYSDBA or other administrative permissions, local database exports, or more than one tablespace (unlike Autonomous Database Shared) – the Base Database Service covers it all. No PDB count limitation of 3, Enterprise Features included. And the best part: License included! You only pay for the underlying resources like storage. Technical documentation: https://docs.oracle.com/en/cloud/paas/base-database/about/index.html#GUID-1DF6ECD3-A865-47B4-9C18-0D307113A507 Important note: This edition is not recommended for production. It fit’s best for development and testing. But why? There are some technical Limitations Supported Oracle Versions Provisioning The path to provisioning a Base Database Service is straightforward:…

Read More

Oracle Cloud Infrastructure – Configuring Network Access with Access Control Rules (ACLs)

When running Autonomous Databases (ADB) in Oracle Cloud Infrastructure (OCI), it’s crucial to prioritize security, even for development and test environments. Allowing unrestricted public access (0.0.0.0/0) is not a secure solution and should be avoided. To ensure that only trusted sources can access your databases, you can restrict access to specific IP addresses and Virtual Cloud Networks (VCNs). To enhance security, I configured my ADB to allow access only from specified IP addresses and VCNs. This approach ensures that only authorized users can connect to the database. My next step was to add the public IP address of my workstation to the ADB’s access control rules, so I can securely manage the database from my current location. While the OCI…

Read More

Oracle Cloud Infastructure – Enable Multipath for Ultra High Performance UHP Storage

The Oracle Cloud Infrastructure Block Volume service leverages NVMe-based storage for consistent performance and offers flexible and elastic performance options. You only need to provision the required capacity, and the performance scales according to the selected performance level, up to the service limits. There are four performance levels available who have a direct impact at performance. Four Levels of Performance Ultra High Performance: Ideal for workloads with the highest I/O demands, offering the best possible performance. This level allows you to purchase between 30 and 120 VPUs per GB/month. Higher Performance: Suitable for workloads with high I/O requirements that do not need the peak performance of the Ultra High Performance level. This level provides 20 VPUs per GB/month. Balanced: The…

Read More

Oracle Cloud Infrastructure CLI – How to fix sign.py:10: CryptographyDeprecationWarning

WSL2 is a game-changer for developers like me. I prefer Oracle Linux 8 for coding in Ansible, Terraform, and OCI-CLI. Setting up Oracle Linux 8.8 on WSL2 from the Microsoft Store was easy. With OCI CLI configured within the Linux environment, managing Oracle Cloud Infrastructure resources became effortless. WSL2 eliminates the need for additional virtualization software, providing a seamless Linux environment on Windows. This integration has significantly improved my development workflow, making tasks like deploying infrastructure and managing cloud resources more accessible. In conclusion, WSL2’s integration with Windows and support for various Linux distributions, including Oracle Linux, has transformed the way I work. If you’re a developer, I highly recommend giving WSL2 a try – it might just revolutionize your…

Read More

Oracle Cloud Infrastructure – iSCSI Block Volume Attachment – the magic Way

Have you always attached an OCI Block Volume to a Compute Instance? If yes, I assume by console or OCI CLI and then executed manually the iSCSI commands to attach the device on OS level. But wait, here is a magic way to attach the Block Volume – by the Oracle Cloud Agent. Prerequisites Attached Service Gateway in VCN Oracle Cloud Agent software installed on the instance Enable the Block Volume Management plugin Verify Compute Instance disk status Create a Block Volume and attach Block Volume to Compute Instance OCI Tool oci-iscsi-config The OCI CLI method – the expressway If you want to  auto-attach a high-performance block volume (multipath enabled) or a block volume where auto-tune is enabled, these two…

Read More