Month: March 2017

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 …

cloud, macOS

Generate an SSH key on macOS for Oracle Cloud Services

Generate an SSH key on macOS (Sierra 10.12.3)   If you plan on using the Oracle Cloud Services, you will need to generate some SSH Keys to enable secure access to Oracle Cloud resources from applications such as SQL Developer and even terminal connections. Below I will outline the process for creating SSH Keys on …

12cR2, Beginner Series

Oracle Database 12cR2 Introduces 128 Byte Identifiers

Oracle Database 12cR2 Introduces 128 byte Identifiers. Let’s take a look at a simple Table and Column name example:     If only this were available sooner … like 6 months ago (On-Prem of course). In 12cR2, the new Identifier length limit is now 128 bytes. ¬†The 30 character limit on object names made it …

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.   …

12cR2, ACE, Beginner Series, Database, DBA

Installing Oracle Database 12cR2 on Linux 7.3

What do you do when Oracle releases the long awaited 12cR2 version of the database? You download it and install it. So let’s get started. Visit the Oracle Download site and download the version 12cR2 of the database. This time it’s just a single zip file. So grab that and unzip it in a directory …