Catoctin Data Blog

Welcome back.  In my earlier blog post we created an account on Oracle Cloud Free Tier, and we created an Oracle 21c database as part of the Always Free option.  Each database comes with one superuser named ADMIN, and we created a developer account named SADIE. Database users on Oracle Cloud can be configured with REST or not.  REST-enabled users can connect to the database through the Oracle Cloud web-based interfaces like SQL Developer Web.  Users without REST enabled can only connect to these databases using traditional client software such as SQL*Plus installed on your laptop. Connecting from your own application or from a client-server utility like SQL*Plus on your laptop requires special attention and is low-to-medium difficulty.  I'll walk you through the process in this blog post. You will need Oracle Client software, and since everything on Oracle Cloud is secured you'll need a copy of your database wallet in order to connect to the database.  Don'...

In a previous blog post I described the Oracle Cloud Free Tier, which includes both Always Free and Free Trial.  In that blog I detailed what you get and how to enroll.  This blog takes it to the next level by showing you how to create an Oracle 21c database and connect existing applications or develop new applications. Recall Oracle Always Free allows you to create up to 2 VMs and up to 2 databases.   Also recall there is no relationship between the Oracle VMs and the Oracle databases - they run on different servers and cannot talk to each other until you perform a bunch of configuration steps.   The exception is when you want to create a MySQL or other database, then you do so manually on the VM. Creating Your First Oracle 21c Database for Free Let's start by creating an Oracle 21c database in the Oracle Cloud Free Tier.   The process is very logical and easy.   It requires zero prior knowledge with of Oracle Database.   First, log into your ...

Oracle 21c is not yet available for on-prem deployments, but it is available as a preview release on the Oracle Cloud.  This post describes how to get started with free access to Oracle 21c in the Oracle Cloud. About Oracle Cloud Free Tier The Oracle Cloud Free Tier allows you to run Oracle databases and Oracle VMs, and developer tools, at no cost ( ref ).   The core services are free for an unlimited amount of time and includes two VMs and two databases.   Oracle offers a lot of extra services on this same platform that are not free, so be careful.   Many  extra features can be tried for free using credits as noted later, but after the end of your free trial period you have to pay to play.   The Always Free features are just that, always free, and never expire or incur a cost. The Oracle Cloud Free Tier has two parts: Always Free, and Free Trial.   The Always Free is free for an unlimited time.   The Free Trial gives you $300 in credits which...