memoToSelf Archives - A view on a dba's daily life

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

July 31, 2018 Pieter Van Puymbroeck Comments 0 Comment

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

July 10, 2018 Pieter Van Puymbroeck Comments 0 Comment

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:

Could not start OpenVPN (openvpnstart returned with status #247)
Contents of the openvpnstart log:
*Tunnelblick: openvpnstart log:
Loading tap-signed.kext
stderr from kextload: /Applications/Tunnelblick.app/Contents/Resources/tap-signed.kext failed to load - (libkern/kext) kext (kmod) start/stop routine failed; check the system/kernel logs for errors or try kextutil(8).
stderr from kextload: /Applications/Tunnelblick.app/Contents/Resources/tap-signed.kext failed to load - (libkern/kext) kext (kmod) start/stop routine failed; check the system/kernel logs for errors or try kextutil(8).
stderr from kextload: /Applications/Tunnelblick.app/Contents/Resources/tap-signed.kext failed to load - (libkern/kext) kext (kmod) start/stop routine failed; check the system/kernel logs for errors or try kextutil(8).
stderr from kextload: /Applications/Tunnelblick.app/Contents/Resources/tap-signed.kext failed to load - (libkern/kext) kext (kmod) start/stop routine failed; check the system/kernel logs for errors or try kextutil(8).
stderr from kextload: /Applications/Tunnelblick.app/Contents/Resources/tap-signed.kext failed to load - (libkern/kext) kext (kmod) start/stop routine failed; check the system/kernel logs for errors or try kextutil(8).
Unable to load net.tunnelblick.tun and/or net.tunnelblick.tap kexts in 5 tries. Status = 71

Could not start OpenVPN (openvpnstart returned with status #247)

Contents of the openvpnstart log:

*Tunnelblick: openvpnstart log:

Loading tap-signed.kext

stderr from kextload: /Applications/Tunnelblick.app/Contents/Resources/tap-signed.kext failed to load - (libkern/kext) kext (kmod) start/stop routine failed; check the system/kernel logs for errors or try kextutil(8).

Unable to load net.tunnelblick.tun and/or net.tunnelblick.tap kexts in 5 tries. Status = 71

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

June 23, 2018 Pieter Van Puymbroeck Comments 0 Comment

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

May 7, 2018 Pieter Van Puymbroeck Comments 0 Comment

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

July 22, 2017 Pieter Van Puymbroeck Comments 0 Comment

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

April 24, 2017 Pieter Van Puymbroeck Comments 0 Comment

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

April 6, 2017 Pieter Van Puymbroeck Comments 0 Comment

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

February 21, 2017 Pieter Van Puymbroeck Comments 0 Comment

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

A view on a dba's daily life

Facts encountered during dba work

Browsed by
Category: memoToSelf

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

July 31, 2018 Pieter Van Puymbroeck Comments 0 Comment

Like this:

A heads up for my bad memory

June 23, 2018 Pieter Van Puymbroeck Comments 0 Comment

Like this:

My first REST adventures

May 7, 2018 Pieter Van Puymbroeck Comments 0 Comment

Like this:

Back to basics: controlfile autobackup and recovery

July 22, 2017 Pieter Van Puymbroeck Comments 0 Comment

Like this:

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

April 24, 2017 Pieter Van Puymbroeck Comments 0 Comment

Like this:

A more secure connection to a pdb with the Oracle Wallet

April 6, 2017 Pieter Van Puymbroeck Comments 0 Comment

Like this:

Memo to Self: Recap cellsrvstat

February 21, 2017 Pieter Van Puymbroeck Comments 0 Comment

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this: