Browsed by
Category: cloud

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

Data Guard made easy

Data Guard made easy

Sometimes I hear stories about struggles to setup Data Guard correctly. It should not be hard. There are lots of ways which lead to a correct setup. Die hards prefer the manual or own scripted way. Other people prefer the point and click method in Enterprise Manager. But one way, which is very easy, and I don’t hear people speaking a lot about it, is using the Database Creation Assistant (dbca).

Keep it running, can you?

Keep it running, can you?

Recently I had a meeting at a customer with a very nice question. It was a kick-off meeting, but the question was … is it possible to have a system that gives us 99,999 or 99,9999 uptime for our Oracle database. My first reaction was, “But can your stack on top handle these requirements as well?” Apparently they already have this, so now it was time to put this on db-level too. I have to say that the MAA-team does…

Read More Read More

OCI-Tenant admin locked, how to reset your own password

OCI-Tenant admin locked, how to reset your own password

There are some of those days that you rely too heavily on password tools. Yes, you always should use different passwords and strong ones. But I won’t preach to you, but due to this, I locked myself out of my tenant admin user in the Oracle Cloud Infrastructure (OCI). For those who have seen my OCI – talk already, you know I’m a big fan of the OCI – utility. Also a comprehensive list of things you can do with it,…

Read More Read More

OCI-C orchestration error with load balancers

OCI-C orchestration error with load balancers

There are some of those days that you just don’t get it anymore. Last few days were like that for me. One of my current projects is to provide a fully redundant infrastructure in the Oracle Cloud for some critical applications. So I created the Database as a service with dataguard to another region, provisioned a vm (IAAS) for the webserver and tomcat and made some firewall rules. Check also my colleague Freek (you can find him here @dhoogfr ) his journey…

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

Exploring 18c exadata functions

Exploring 18c exadata functions

Recently I was granted access to the finest and latest exadata. Unfortunately it’s not mine, but I was asked if I managed to log in remotely as a test. Of course I wanted to test that. As it turned out, it was the very latest build of 18c which is available for exadata. You can find the release schedules for Oracle versions here:  the single-source-of-truth MOS Note: 742060.1 – Release Schedule of Current Database Releases. I realised this was a cool opportunity…

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

DbaaS, but on metal: Rac on Oracle Cloud Infrastructure

DbaaS, but on metal: Rac on Oracle Cloud Infrastructure

Let’s skip some networking stuff first and do some fun tests on this Cloud infrastructure. One of the things which caught my attention is the RAC database as a service. I will split this in two separate blog posts. This one will tell you about how to create a RAC database as a service and the next one will tell you about how it performs. Let’s get started! General First step is of course log into your portal and make…

Read More Read More

%d bloggers like this: