oehrlis

Manually fix / configure a few things which have not been added to the Oracle Database Container

export CON_NAME='cdbua190'

Install missing packages:

docker exec -it -u root $CON_NAME yum install -y hostname rlwrap

oehrlis

VSC RegEx Examples

Some

Replace filename with a link

• Search for the following RegEx

([\w\d\-.]+\.sql)

oehrlis

Create a tempfile before the Table

sed '1,/^- \*\*Kurs Dauer:\*\*.*$/!d' README2.md >README_part1.md
echo "" >>README_part1.md

Create a tempfile after the table. Do also remove the table itself

sed '/^|.*|/d' README2.md|sed '0,/^- \*\*Kurs Dauer:\*\*.*$/d' >README_part3.md

Create the list of bastion hosts

oehrlis

Below you find a couple of oci cli commands and examples. Query syntax http://jmespath.org/examples.html#filters-and-multiselect-lists

list all activ compartments

oci iam compartment list --all --output table --compartment-id-in-subtree true \
--query "data [?\"lifecycle-state\" =='ACTIVE'].{Name:name,OCID:id}"

list all inactive compartments

oci iam compartment list --all --output table --compartment-id-in-subtree true \

oehrlis

First convert the public Key (tutorialinux.com/convert-ssh2-openssh/)

ssh-keygen -i -f ssh2.pub > openssh.pub

Upload the Key to the cloud jump host

scp openssh.pub opc@jumphost.trivadislabs.com:~/.ssh/
ssh opc@jumphost.trivadislabs.com 'cat ~/.ssh/openssh.pub >> ~/.ssh/authorized_keys'

And to the oud server for user oracle

oehrlis

Simple alias to execute base in docker container with some terminal settings

alias deo='function _deo() { if [ -n "${1}" ]; then docker exec -e COLUMNS="`tput cols`" -e LINES="`tput lines`" -it -u oracle ${1} bash --login; else echo "No docker container specified"; fi } ; _deo'
alias der='function _der() { if [ -n "${1}" ]; then docker exec -e COLUMNS="`tput cols`" -e LINES="`tput lines`" -it -u root ${1} bash --login; else echo "No docker container specified"; fi } ; _deo'

oehrlis

Search TEX package for a specific file:

tlmgr search --global --file

oehrlis

A bash for loop to add a hardlink for the software images in vagrant and docker build environments.

export SW_STAGE="/data/docker/volumes/orarepo"
for i in *.download; do 
  ln -f ${SW_STAGE}/${i%%.download} .
done

oehrlis

Build my local docker tools using a loop

docker pull oraclelinux:7-slim
docker pull 06kellyjac/markdownlint-cli
docker pull treeder/bump
docker pull markdownlint/markdownlint
docker pull alpine
docker pull busybox
for i in $HOME/Development/github.com/oehrlis/docker-*/Dockerfile; do 

oehrlis

---

title: "Demo Oracle und Docker" subtitle: "DOAG Webinar Oracle Datenbanken in Docker Container" author: [Stefan Oehrli] date: "08 März 2019" tvddocversion: 1.0 papersize: a4 listings-disable-line-numbers: true titlepage: true toc: true