Browsed by
Category: DBaaS

OCI cli – tooling made easy

OCI cli – tooling made easy

The OCI tool is easy to use. I had a very interesting conversation with Simon Haslam ( here on Twitter @simon_haslam ) about this. In this blogpost we will highlight the cause (and the solution) of this particular case and in a second part, there is a general workflow which did not let me down for my last deployments. 404 NotAuthorizedOrNotFound Simon and his colleagues are working with ansible and Terraform for automatic provisioning of their full environment which at…

Read More Read More

Connectstrings in the OCI

Connectstrings in the OCI

Under the category; asked and answered. When you have created a Data Guard config, the most obvious is that you eventually would like to connect to the Database. This is done using a connect string, often specified in tnsnames.ora or via jdbc-thin. When you read this blog post, then you end up with a Primary and Standby database. One of the questions I got last week “How can we add 2 service names in the same connect string”? I was…

Read More Read More

My first REST adventures

My first REST adventures

REST and ORDS are available already a long time in the Oracle database.  Now I have the opportunity to dig deeper into it. In my current project, which involves a on-premises 12.1 multitenant database to 18c in the cloud. Including the Apex upgrade from 4.2 to the default apex 5 which comes with the 18c installation. When the POC period is over, I might blog more over this project, but this is the POC phase in which we’ll see what…

Read More Read More

The cloud is more than a portal: accessing the trial/promotional account

The cloud is more than a portal: accessing the trial/promotional account

TL;DR I will save you 5 minutes when you want to access the Oracle database as a service via REST on your promotion account when it’s (automatically) coupled to your Identity cloud service (IDCS). Like many people I have a personal promotion account on the Oracle cloud to play with the Oracle Database as a service. Some of you know that I like to do things in commandline more than clicking around in a portal. The REST api is pretty…

Read More Read More

The cloud is more than a portal: oracle-dbcs-cli

The cloud is more than a portal: oracle-dbcs-cli

A common misconception is that “The Cloud” is only accessible through the portal which is provided to you. In this post I will show that Oracle has some utilities ready for you to manage the cloud using the command line (cli). One way to do it, and which is very useful when you only use one-time commands, is Curl. The REST API is well documented with curl examples as well. This time we will focus on oracle-dbcs-cli utility and the…

Read More Read More

%d bloggers like this: