22 posts tagged with "oracle"

A few weeks ago, I was fortunate to accompany a group of twenty-four exchange students from a local university. Some of them came from countries as far as Singapore. While up in the North, the Aurora Borealis might be a common sight, for tourists, it is still pretty much a calculated risk that it might be a fruitless journey. The night skies were overcast on the first night that they arrived, and it was bitterly cold for folks used to tropical weather, but they persisted. On their second night, there was a minor emergency that delayed a few of them from heading out to the remote site for viewing the Northern Lights, but again, they were determined. Within minutes of their arrival at the viewing site, there was a sudden break in the cloudy skies that coincided with a display of greens and purples that illuminated in the heavens. What a treat!

As we near the end of 2022, I'd like to reflect on the year's challenges and milestones.

Is this a lasting treasure, or just a moment's pleasure?

~ Will You Love Me Tomorrow. The Shirelles.

As a technologist, we are constantly bombarded with buzzwords and terms like blockchain, IoT, AI, machine learning, quantum computing, and so much more! I love buzzwords, and wholeheartedly enjoy deciphering the future of technology and work. Hence, for the last few years, I have been a proud member of the committee that peruses and selects abstracts for the Kscope Emerging Technology (ET) track. For next year's Kscope22, I am honoured to be leading the team that will help select a series of sessions that are visionary, and hopefully, give us guidance on what to expect in the years ahead.

For a long time now, I have been eagerly awaiting for out-of-the-box RSA encryption support with pure PL/SQL. Not so much for to sharing secrets, but rather, the ability to sign messages and verify signatures. I might have missed the announcements, but it looks like my wait is over support with asymmetric key operations added in 21c, and (perhaps backported) in 19c as-of release 19.9.

It was only days ago that I had finalised my slides for my upcoming Oracle Groundbreakers APAC Virtual Tour talk on using Oracle Cloud Infrastructure (OCI) Object Storage for storing large files in Oracle Application Express (APEX). Today, I found out with a lot of excitement, that one of my slides was now factually wrong!

I won't deny that it has been a challenging and tough journey, but today, I'm glad to be able to declare that the book "Getting Started with Oracle Cloud Free Tier" has been published and available to purchase!

A reader left an interesting comment/question in my previous post on Making the Move to the Autonomous Database:

"Would You explain how can i check my on-premise DB to satisfy ADB size limitation 20G? What is the size 20G of?"

This is an excellent question to ask before embarking on any Autonomous Database (ADB) migration plans and so I dug a bit deeper.

In my previous post, I mentioned that I have created my Oracle Cloud Free Tier account and provisioned an Autonomous Database (ADB). Now, I'm ready to move my existing Oracle Application Express (APEX) to this new environment. Next, I'll describe the steps I took to move (1) workspace, (2) application and (3) data, from the old to new database.

As mentioned in a previous post, the Free Tier for Oracle Cloud (OCI) is every Oracle Developer's dream. For a while now, I have hosted a personal Oracle Application Express (APEX) instance on Linode. It currently runs an older Oracle Database 11gR2 Express Edition (XE), and I would like to upgrade it to version 18c. The key issue I had though, was that the existing virtual machine hosted on Linode, only has one gigabyte of RAM and that does not meet the 18c XE minimum requirement of two. That left me procrastinating for a long time, but perhaps a blessing in disguise. With this new offering, the next steps are pretty obvious.

Too good to be true? No, it's true!!!

After hearing the rumours for a few years now, Mr Larry Ellison finally announced the availablility of a Free Tier for the Oracle Cloud. The gift bundle includes two small compute instances and two Autonomous Databases. These offerings are a tiny fraction of what the Oracle Cloud provides, but are sufficient for Oracle Developers to maintain their own 24x7 development environments and possibly even production applications for small businesses and non-profit organisations.

Like everyone else in the Oracle Application Express (APEX) community, I wasted no time in getting my account provisioned and am currently working towards moving workspaces and applications from my old personal APEX instance, hosted on Linode.

Support for remote development is one of the newer features of Microsoft Visual Studio Code (VS Code) announced in 2019 that I'm most excited about. With the Remote Development Extension Pack, developers are able to work with code on remote servers using SSH, Docker containers and Windows Subsystem for Linux (WSL).

With only three days remaining for my 30-day trial, I will finally close these series by discussing my experiences dealing with various levels of support from Oracle. Having used the Oracle Cloud (OCI) both in my day job and as a technology evangelist, I have had the opportunity to engage Oracle support at various levels: sales, customer and technical.

Oracle Function was announced late last year (2018), with limited availability to select Oracle Cloud customers. The platform is built on Fn and is Oracle's solution for developers wanting to deploy services using a Serverless Framework.

As succinctly explained by Kaslin Fields, a Fn function is a small embodiment of code that listens and speaks to HTTP streams. Ideally, each Fn function serves one, and only one purpose. It can be implemented in wide variety of programming languages and they are listed here (see the list of runtime options available).

In case you missed it (which is almost impossible), the Oracle Autonomous Database (AutonomousDB) is Oracle's hottest offering on the Oracle Cloud and it now comes fitted with what is arguably the best feature of the Oracle Database: Oracle Application Express (APEX). I have a few more days to go with this trial, so why not take one out for a spin?

To everyone following my 30 Days on the Oracle Cloud experience, I apologise that I was not able to keep up with the series previously, due to work commitments. I have enrolled in yet another trial, so I am hoping to continue where I left off and share my thirty day adventure with an Oracle Cloud trial. I'm on Day 14 now, and for this post, I'll examine an important issue that many of us face, even in our personal life - moving houses!

One of my fondest memories of my previous job was working with VMware virtualization products. With VMware Workstation, system administrators had the ability to "move" a virtual machine (VM) from a local workstation to vSphere. It was no surprise then that I was very exited (and itching to play) when VirtualBox 6.0 was released with a new feature: support for exporting a VM to Oracle Cloud Infrastructure (OCI)!