Category: Oracle

Docker, Oracle

Microservices PoC: A Docker Calculator

This example will explore building a simple container that has one specific ¬†function. I’ll then extend this concept to a bit to add additional containers in an effort to build a basic calculator that can add, subtract, divide, and multiply. The current rendition will execute from the command line. Given enough time, we can REST …

Docker, Oracle

MongoDB Docker Oracle Linux Slim

Working for a consulting firm, I have the opportunity to occasionally explore technologies that don’t quite align with my focus area(s). I started looking at MongoDB, and over the last couple of weeks, I’ve found it to be quite fun. This post will focus on my intro to MongoDB and hopefully will result in a …

Database, Docker, Node.js, Oracle, oracledb

Deploy node-oracledb with Official Instant Client Image

A few days ago, I started building a PoC with the Oracle DB 12.1 and Oracle Instant Client. My goal was to deploy each component to separate and see if I could access the DB from the OIC container. Now to take it a step further. Adding the node-oracledb driver to enable Node.js interaction with …

cloud, Database, Docker, Oracle

Using the Oracle Instant Client with Docker and Oracle DB12c

This weekend, in my desire to learn more about Docker, I decided to implement a multi-container solution. In this PoC, I plan to deploy a container with the Oracle Database 12.1 and a second container with the Oracle Instant Client 12.2. The goal will be to connect to the Database container from the Instant Client …

cloud, Oracle

SSH Into the Oracle Database Cloud Service

One of the things that make us feel comfortable when working with a database is the ability to ssh into the server, connect to the database, and use sqlplus or sqlcl to interact with the database. You might not know it, but even though the Oracle Database Cloud Service is a PaaS solution, you still …

GaTechDays, Oracle

GaOUG Tech Days Session: REST Request and JSON with APEX Packages

It’s that time of year where we have to start delivering on those promises made months ago when we professed to be experts at some Oracle tech. Experts enough to commit to standing up in front an audience eagerly awaiting us to drop that tidbit of knowledge that will change their lives. Give then that …

Oracle

Establish SSH Connection to Oracle Database Cloud Service with SQL Developer

Establish SSH Connection to Oracle Database Cloud Service with SQL Developer A couple of days ago, I showed how to Configuring the Oracle Database Cloud Service, and finished up with promising to help you connect to this database with SQL Developer. As part of the example, you are required to create an SSH key. We …

Beginner Series, Oracle

My Cloud Services DBaaS: Configuring the Oracle Cloud Database Service

My Cloud Services DBaaS I went ahead and jumped on the bandwagon¬†and signed up for my very own Oracle Cloud Services Account. They make it too easy, so let’s jump right in and create a new Database Service. Obviously you will need to sign-up and get an account, which can be done right here: Cloud …

12cR2, Oracle

Use SQL Developer to Create a PDB – Database 12cR2

Continuing along with the release of 12cR2, let’s quickly look at creating a PDB in the database. Now that we have a database installed fire up one of my favorite tools, SQL Developer and let’s get to work. Note: These steps have not change from 12cR1, but maybe you haven’t seen that process either.   …

Beginner Series, Logger, Oracle

PL/SQL Instrumentation: Installing Logger

If you are writing PL/SQL, the open source tool Logger, started by Tyler Muth and now owned and maintained by Martin D’Souza is instrumental in error identification and debugging. While I am sure that there are other resources that can provide the same information, this post will show you how to get Logger installed and …