Browsed by
Category: memoToSelf

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

Exadata Security: the joy of PXE and UEFI: Secure boot violation

Exadata Security: the joy of PXE and UEFI: Secure boot violation

Today I had the honour to join my colleague Freek D’Hooge (find him here: @dhoogfr )in the datacenter. Task for today, reimage an 1/8th X7 Exadata using PXE. Andy (Colvin) warned me already that when trying to reimage them, they are now using UEFI – boot. Knowing this in advance, this would be an exatastic day. As usual, Andy was right. Trying to boot one of the cells on the pxe “the old method” resulted in: “Secure boot violation: Invalid signature…

Read More Read More

Tunnelblick ovpn client for Mac os High Sierra

Tunnelblick ovpn client for Mac os High Sierra

This weekend I was playing around with Openvpn to a new site. I use Tunnelblick for this, but this time was the first time after I had upgraded my Mac to High Sierra (10.13.5). Suddenly my vpn connections didn’t want to load anymore. Tunnelblick threw these errors to me:

I was running a beta, so first thing was to install the stable release, but the message remained. This link: https://tunnelblick.net/cKextLoadError.html helped me. In high sierra to use or add modules…

Read More Read More

A heads up for my bad memory

A heads up for my bad memory

Gotcha! This post is not about memory settings at all, but a quick heads up. If you are dealing with several generations of exadata’s and you like ironhugging them as much as I do, sometimes things can get confusing. The X7 exadata has changed a bit so when you use them, it’s nice to do things right. Only way to do it right is check it, double check it and verify. One of the things which is always in my…

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

Back to basics: controlfile autobackup and recovery

Back to basics: controlfile autobackup and recovery

Sometimes it’s not bad to look back to the basics. Due to circumstances I’m focusing more on backups nowadays. This time I wanted to have a closer look to controlfile autobackups. Oh by the way, for the one who follow me on twitter, yes, it’s this post which is related to this picture 🙂 Most of the tests I do, I do them at night (not this one, because I needed it for my customer) and yes, I write most…

Read More Read More

Can’t locate Term/ReadKey.pm in @INC during catcdb.sql in 12.1.0.2

Can’t locate Term/ReadKey.pm in @INC during catcdb.sql in 12.1.0.2

During some playing around with database creation on 12.1.0.2 using several methods, Geert De Paep (find him at @geertdepaep) and I discovered something funny. Creating the database using dbca, works as expected. But then it was time to create a container database using the create database statement. The best thing to do is follow the official oracle documentation. Find it here: http://docs.oracle.com/database/121/ADMIN/cdb_create.htm#ADMIN13529 all steps are normal until running the catcdb.sql-script. When running it from a oel6.5 with a default (non-patched)…

Read More Read More

A more secure connection to a pdb with the Oracle Wallet

A more secure connection to a pdb with the Oracle Wallet

Wallets are cool! Since 9i oracle is pushing us towards services for connecting to a database. Since pdb’s have arrived, you get less and less choice to connect without a service. Recently I discovered passwords stored in environment variables in order to connect to the pdb. A short talk to the author of the script learned me that he just wants to connect to a pdb, so I offered the solution to store the password in the oracle wallet. Here is how…

Read More Read More

Memo to Self: Recap cellsrvstat

Memo to Self: Recap cellsrvstat

Sometimes I ask myself “how did that work again”, so I decided to document this every time I have this feeling. With some links to the documentation, easy commands,… you got the picture. First one today, new customer, new environment, to get some feeling with the cells, I used cellsrvstat. Documentation reference (here ). Cellsrvstat is also part of the exawatcher on the cells. A basic overview of the command. If you log on to the cells as root, it…

Read More Read More

%d bloggers like this: