Dietrich Schroff

Subscribe to Dietrich Schroff feed
Dietrich Schroffhttps://plus.google.com/101232877473830670008noreply@blogger.comBlogger365125
Updated: 8 hours 47 min ago

Docker-CE: Setting up a tomcat in less than a minute and running your JSP...

Wed, 2017-12-13 15:14
Last time i wrote about processes and files of a docker container hosting the docker example myapp.py.
Next step was to run a tomcat with a small application inside.

This can be done with theses commands:
  1. Get tomcat from the docker library:
    # docker pull tomcat
    Using default tag: latest
    latest: Pulling from library/tomcat
    3e17c6eae66c: Pull complete
    fdfb54153de7: Pull complete
    a4ca6e73242a: Pull complete
    5161d2a139e2: Pull complete
    7659b327f9ec: Pull complete
    ce47e69f11ad: Pull complete
    7d946df3a3d8: Pull complete
    a57cba73d797: Pull complete
    7e6f56cdb523: Pull complete
    06e4787b3ca5: Pull complete
    c760cb7e43cb: Pull complete
    ad6d0815df5c: Pull complete
    d7e1da09fc22: Pull complete
    Digest: sha256:a069d49c414bad0d98f5a4d7f9b7fdd318ccc451dc535084480c8aead68272d2
    Status: Downloaded newer image for tomcat:latest
  2. Test the tomcat:
    # docker run -p 4000:8080 tomcat
    20-Nov-2017 20:38:11.754 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.23
    20-Nov-2017 20:38:11.762 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Sep 28 2017 10:30:11 UTC
    20-Nov-2017 20:38:11.762 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.23.0
    ....
    ....
    org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["http-nio-8080"]
    20-Nov-2017 20:41:59.928 INFO [Thread-5] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["ajp-nio-8009"]
     

This was easy.
Now create your JSP and run it:
  1. create a directory
    mkdir tomcatstatus
  2. create a jsp inside this direcotry
    vi tomcatstatus/index.jsp
    and insert the following content:
    <%@ page language="java" import="java.util.*" %>


    Host name : <%=java.net.InetAddress.getLocalHost().getHostName() %>

    Server Version: <%= application.getServerInfo() %>

    Servlet Version: <%= application.getMajorVersion() %>.<%= application.getMinorVersion(
    ) %>
    JSP Version: <%= JspFactory.getDefaultFactory().getEngineInfo().getSpecificationVersio
    n() %>
  3. Run docker
    docker run -v /home/schroff/tomcatstatus:/usr/local/tomcat/webapps/status -p 4000:8080 tomcat
  4. Connect to port 4000:

Wow - i am really stunned how fast the tomcat was setup and the jsp was launched. No installation of java (ok, this is only apt install) and no setup procedure for Apache tomcat (ok, this is just a tar -zxvf). But if i want to run more than one installation - docker is faster than repeating the installation or copying files.  Really cool!


(One thing i forgot: Installation of docker onto your server)

Docker-Swarm: Running a minimal webserver in a swarm

Sun, 2017-12-10 12:32
In my last posting to docker swarm i created a swarm on virtualbox with alpine linux with a hdd footprint of 290MB per node:
There are some tutorials out there with running a nginx or a java webserver in a container but >100MB for each node seems far to much for my tests.

So i decided to create a application which listens on port 8080 with netcat. I created a directory ncweb with ncweb.sh:
ncweb# cat ncweb.sh
#!/bin/bash
sed -i  's/Hostname:.*/Hostname: '$HOSTNAME'/g' index.html
while true; do { echo -e 'HTTP/1.1 200 OK\r\n'; cat index.html;}  | nc  -l -p 8080; done 2&>1 logfileand a index.html:
ncweb# cat index.html
<html>
  <head>
    <title>"Hello, World"</title>
  </head>
  <body bgcolor=white>
    <table border="0" cellpadding="10">
      <tr>
        <td>
          <h1>"Hello, World"</h1>
        </td>
      </tr>
    </table>
  </body>
</html>The Dockerfile looks like this:
# cat Dockerfile
FROM alpine
WORKDIR /tmp
ADD .  /tmp
ENTRYPOINT [ "/tmp/ncweb.sh" ]After that i created the container:
ncweb# docker build -t ncweb:0.2 .
Sending build context to Docker daemon  4.096kB
Step 1/5 : FROM alpine
 ---> 053cde6e8953
Step 2/5 : WORKDIR /tmp
 ---> Using cache
 ---> c3e11ac3773b
Step 3/5 : RUN mkdir ncweb
 ---> Using cache
 ---> d9e634c03cd1
Step 4/5 : ADD .  /tmp
 ---> 95f022aacc1c
Step 5/5 : ENTRYPOINT [ "/tmp/ncweb.sh" ]
 ---> Running in c1a9e8cee248
 ---> 6880521f68e4
Removing intermediate container c1a9e8cee248
Successfully built 6880521f68e4
Successfully tagged ncweb:0.2And let's do a test without docker swarm:
ncweb# docker run -p 8080:8080  ncweb
But running this as a service fails:
# docker service create --replicas=1 --name myweb ncweb:0.2
image ncweb:0.2 could not be accessed on a registry to record
its digest. Each node will access ncweb:0.2 independently,
possibly leading to different nodes running different
versions of the image.
n0himwum38bqzd8ob1vf8zhip
overall progress: 0 out of 1 tasks
1/1: No such image: ncweb:0.2
^COperation continuing in background.
Use `docker service ps n0himwum38bqzd8ob1vf8zhip` to check progress.and:
# docker service ps n0himwum38bqzd8ob1vf8zhip
ID                  NAME                IMAGE               NODE                DESIRED STATE       CURRENT STATE                 ERROR                        PORTS
8tjsuae9jv8o        myweb.1             ncweb:0.2           node01              Ready               Rejected 3 seconds ago        "No such image: ncweb:0.2"  
qp24ssxb5bl5         \_ myweb.1         ncweb:0.2           alpine              Shutdown            Failed 36 seconds ago         "task: non-zero exit (2)"   
zwfgcatk7zyi         \_ myweb.1         ncweb:0.2           node01              Shutdown            Rejected about a minute ago   "No such image: ncweb:0.2"  
v4a7zkb85yd4         \_ myweb.1         ncweb:0.2           node01              Shutdown            Rejected about a minute ago   "No such image: ncweb:0.2"  
ycjftjusv484         \_ myweb.1         ncweb:0.2           node01              Shutdown            Rejected about a minute ago   "No such image: ncweb:0.2"  
 
# docker service rm n0himwum38bqzd8ob1vf8zhip
n0himwum38bqzd8ob1vf8zhip
The error "No such image..." is happening, because the container ncweb is only in the repository of my master.
The easiest way for my test environment is to distribute the local image to all nodes:
# docker save ncweb:0.3 | ssh 192.168.178.47 docker load
The authenticity of host '192.168.178.47 (192.168.178.47)' can't be established.
ECDSA key fingerprint is SHA256:2/8O/SE1fGJ4f5bAQls5txrKMbqZfMmiZ+Tha/WFKxA.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.178.47' (ECDSA) to the list of known hosts.
root@192.168.178.47's password:
Loaded image: ncweb:0.3(i have to distribute a ssh-key to all nodes)

and then:
alpine:~/ncweb# docker service create --replicas=1 --name myweb ncweb:0.3
image ncweb:0.3 could not be accessed on a registry to record
its digest. Each node will access ncweb:0.3 independently,
possibly leading to different nodes running different
versions of the image.# docker service ps myweb
ID                  NAME                IMAGE               NODE                DESIRED STATE       CURRENT STATE           ERROR               PORTS
in97xlc7azcw        myweb.1             ncweb:0.3           node01              Running             Running 8 seconds ago      
So my nc-webserver runs on node01, but i can not access it there because i did not define any port mappings ;-(

But finally this command did the job:
# docker service create --replicas=1 --name myweb --publish 8080:8080  ncweb:0.3
image ncweb:0.3 could not be accessed on a registry to record
its digest. Each node will access ncweb:0.3 independently,
possibly leading to different nodes running different
versions of the image.
runf8u9r8719sk13mkf8hh8ec
overall progress: 1 out of 1 tasks
1/1: running  
verify: Service converged
The hostname corresponds to the docker container id on node01:
node01:~# docker ps
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS               NAMES
6c9434b08082        ncweb:0.3           "/tmp/ncweb.sh"     37 minutes ago      Up 37 minutes                           myweb.1.lqiyb34cuxxme2141ahsg8neu

Remaining open points:
  • Is it possible to do a failback or limit the number of a service per node?
  • How to get a loadbalancing mechanism for a server application?
    (load balancer needed?)
  • What happens, if the manager fails / is shutdown?





Docker-Swarm: One manager, two nodes with Alpine Linux

Tue, 2017-12-05 16:32
After creating a Alpine Linux VM inside virtualbox and after adding docker because of the small disk footprint (Alpine Linux: 170MB | with docker: 280MB) i performed the following steps to create a docker swarm:
  • cloning the vm twice
  • assigning a static ip to the manager node
  • create new MACs for the network interface cards on the nodes 


Then i followed the tutorial https://docs.docker.com/engine/swarm/swarm-tutorial/create-swarm/ but without running the docker-machine commands, because i have 3 VMs and do not want to run the node on top of docker.

manager:
alpine:~# docker swarm init --advertise-addr 192.168.178.46
Swarm initialized: current node (wy1z8jxmr1cyupdqgkm6lxhe2) is now a manager.

To add a worker to this swarm, run the following command:

    docker swarm join --token SWMTKN-1-3b7f69d3wgty0u68oab8724z07fkyvgc0w8j37ng1l7jsmbghl-0yfr1eu5u66z8pinweisltmci 192.168.178.46:2377

To add a manager to this swarm, run 'docker swarm join-token manager' and follow the instructions.nodes
#     docker swarm join --token SWMTKN-1-3b7f69d3wgty0u68oab8724z07fkyvgc0w
8j37ng1l7jsmbghl-0yfr1eu5u66z8pinweisltmci 192.168.178.46:2377
This node joined a swarm as a worker.
And then a check on the master:
alpine:~# docker node ls
ID                            HOSTNAME            STATUS              AVAILABILITY        MANAGER STATUS
wy1z8jxmr1cyupdqgkm6lxhe2 *   alpine              Ready               Active              Leader
pusf5o5buetjqrsmx3kzusbyt     node01              Ready               Active             
io3z3b6nf8xbzkyzjq6sa7cuc     node02              Ready               Active             
Run a first job:
alpine:~# docker service create --replicas 1 --name helloworld alpine ping 192.168.178.1
rsn6igby4f6d7uuy8eny7sbfb
overall progress: 1 out of 1 tasks
1/1: running  
verify: Service converged
But on my manager i get no output for "docker ps". But this is, because the service is not running here:
alpine:~# docker service ps helloworld
ID                  NAME                IMAGE               NODE                DESIRED STATE       CURRENT STATE           ERROR               PORTS
wrrobalt4oe7        helloworld.1        alpine:latest       node01              Running             Running 2 minutes ago                      
Node 1 shows:
node01:~# docker ps
CONTAINER ID        IMAGE               COMMAND                CREATED             STATUS              PORTS               NAMES
40c5e9b2ffbc        alpine:latest       "ping 192.168.178.1"   3 minutes ago       Up 3 minutes                            helloworld.1.wrrobalt4oe7mrbhxjlweuxgk
If i do a kill on the ping process, it is immediately restarted:
node01:~# ps aux|grep ping
 2457 root       0:00 ping 192.168.178.1
 2597 root       0:00 grep ping
node01:~# kill 2597
node01:~# ps aux|grep ping
 2457 root       0:00 ping 192.168.178.1
 2600 root       0:00 grep ping
A scale up is no problem:
alpine:~# docker service create --replicas 2 --name helloworld alpine ping 192.168.178.1
3lrdqdpjuqml6creswdcqpn2p
overall progress: 2 out of 2 tasks
1/2: running   [==================================================>]
2/2: running   [==================================================>]
verify: Service converged
alpine:~# docker service ps helloworld
ID                  NAME                IMAGE               NODE                DESIRED STATE       CURRENT STATE           ERROR               PORTS
616scw68s8bv        helloworld.1        alpine:latest       node02              Running             Running 8 seconds ago                      
n8ovvsw0m4id        helloworld.2        alpine:latest       node01              Running             Running 8 seconds ago                      
And a shutdown of node02 is no problem:
alpine:~# docker service ps helloworld
ID                  NAME                IMAGE               NODE                DESIRED STATE       CURRENT STATE                ERROR               PORTS
bne2enbkabfo        helloworld.1        alpine:latest       alpine              Ready               Ready 2 seconds ago                             
616scw68s8bv         \_ helloworld.1    alpine:latest       node02              Shutdown            Running 17 seconds ago                          
n8ovvsw0m4id        helloworld.2        alpine:latest       node01              Running             Running about a minute ago          


After a switchoff of node01 both service are running on the remaining master:
alpine:~# docker service ps helloworld
ID                  NAME                IMAGE               NODE                DESIRED STATE       CURRENT STATE                ERROR               PORTS
bne2enbkabfo        helloworld.1        alpine:latest       alpine              Running             Running about a minute ago                      
616scw68s8bv         \_ helloworld.1    alpine:latest       node02              Shutdown            Running about a minute ago                      
pd8dfp4133yw        helloworld.2        alpine:latest       alpine              Running             Running 2 seconds ago                           
n8ovvsw0m4id         \_ helloworld.2    alpine:latest       node01              Shutdown            Running 2 minutes ago              
So failover is working.
But failback does not occur. After switching on node01 again, the service remains on the manager:
alpine:~# docker service ps helloworld
ID                  NAME                IMAGE               NODE                DESIRED STATE       CURRENT STATE               ERROR                         PORTS
bne2enbkabfo        helloworld.1        alpine:latest       alpine              Running             Running 4 minutes ago                                    
616scw68s8bv         \_ helloworld.1    alpine:latest       node02              Shutdown            Running 4 minutes ago                                    
pd8dfp4133yw        helloworld.2        alpine:latest       alpine              Running             Running 2 minutes ago                                    
n8ovvsw0m4id         \_ helloworld.2    alpine:latest       node01              Shutdown            Failed about a minute ago   "task: non-zero exit (255)"  
alpine:~# docker node ls
ID                            HOSTNAME            STATUS              AVAILABILITY        MANAGER STATUS
wy1z8jxmr1cyupdqgkm6lxhe2 *   alpine              Ready               Active              Leader
pusf5o5buetjqrsmx3kzusbyt     node01              Ready               Active             
io3z3b6nf8xbzkyzjq6sa7cuc     node02              Down                Active             


Last thing: How to stop the service?
alpine:~# docker service rm  helloworld
helloworld
alpine:~# docker service ps helloworld
no such service: helloworld
Remaining open points:
  • Is it possible to do a failback or limit the number of a service per node?
  • How to do this with a server application?
    (load balancer needed?)
  • What happens, if the manager fails / is shutdown?

OpenJDK 9: Limitations/shortcomings of the Jshell

Thu, 2017-11-30 13:56
Jshell is a quite powerful tool to do some quick explorations and to write some scripts.

If found the following limitations:
  • No syntax highlighting
  • Only comments with // are allowed
    if you open a script file with
     /**
      *  My comments
      */
    this will work only many warnings.
    |  Error:
    |  illegal start of expression
    |   * Copyright (c) 1995, 2008, Oracle and/or its affiliates. All rights reserved.
    |   ^
    |  Error:
    |  illegal start of expression
    |   *
    |   ^
  • The usage of public, static, ... is quite different:
    -> public class MyClass {
    >> public int a;
    >> };
    |  Warning:
    |  Modifier 'public'  not permitted in top-level declarations, ignored
    |  public class MyClass {
    |  ^----^
    |  Added class MyClass this error is corrected:
    |      Modifier 'public'  not permitted in top-level declarations, ignored
    |      public class MyClass {
    |      ^----^
  • If you want to load a scipt with /open then tab completion does not work. The complete path including filename has to be typed / pasted.
  • If you load some example snippet, main(String[] args) is not run by default.
    Just tried with the swing tutorial from oracle:
    jshell Downloads/HelloWorldSwing.java  -> String[] mystringarray;
    |  Added variable mystringarray of type String[]

    -> HelloWorldSwing.main(mystringarray); 
  • .. 
to be continued...

Docker-CE: Creating a small Linux as base OS for running a Docker cluster

Sat, 2017-11-25 15:13
After some first steps with docker i wanted to run more than one docker node. The problem is, that i have very limited resources on my laptop.
  • CoreOS (see here)
    consumes about 600MB diskspace
  • UbuntuCore (see here)
    consumes about 1.9GB diskspace
To setup CoreOS you have to learn ignition - otherwise every change is lost after a reboot. For UbuntuCore you have to use an UbuntuOne account to get it running.

I heard, that Alpine Linux is an OS with a very small footprint, so i downloaded the "virtual" image and

mounted it in my virtualbox:


After a short startup i got the following:

This is completely different to all other installation procedures i know. No configuration dialog just a
localhost login:You have to enter "root" and without a password you get a banner with one important information:
You can setup the system with the command: setup-alpineThis will guide you through a 11 step setup (read the manual). To get a installation with persistent homes, etc. you have to choose the "sys" mode.

And then after a reboot, i have a Linux VM with 170MB.
For my next steps (installing docker, cloning some nodes) this should be the right choice.

[Installing docker is quite easy: remove the # before "edge/community" in /etc/apk/repositories and the run "apk update" and "apk add docker".]

Docker-CE: Get Started Tutorial - processes / files / HTTP headers

Thu, 2017-11-23 14:37
Inside my docker installation on ubuntu server i performed the official docker tutorial part 2: "containers"

Ok. Not really interesting, because the tutorial describes all steps very well (except the point, that you have to install python3-pip and you have to run pip3 and not pip).

Here the interesting part:

After i started the container ("docker run -p 4000:80 friendlyhello") i got the following:
root@ubuntuserver:/var/lib/docker/image# docker ps
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS                  NAMES
6f187950452f        friendlyhello       "python app.py"     2 hours ago         Up 2 hours          0.0.0.0:4000->80/tcp   keen_bartik
and the OS displayed

root@ubuntuserver:/var/lib/docker/image# ps x |grep docker
 5852 ?        Ssl    0:18 /usr/bin/dockerd -H fd://
 5867 ?        Ssl    0:10 docker-containerd --config /var/run/docker/containerd/containerd.toml
17100 ?        Sl     0:00 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 4000 -container-ip 172.17.0.2 -container-port 80
17105 ?        Sl     0:00 docker-containerd-shim --namespace moby --workdir /var/lib/docker/containerd/daemon/io.containerd.runtime.v1.linux/moby/6f187950452f501cf18d7efd673e8305d6c9752c58acfb14918ae37341952a11 --address /var/run/docker/containerd/docker-containerd.sock --runtime-root /var/run/docker/runtime-runc
So the containerid is part of the directory which is loaded with "--workdir"

The HTTP headers showup the following:

So the process "docker-proxy-proto" does only a portforwarding from port 4000 to port 80 and the webserver is provided by python:
Content-Type: text/html; charset=utf-8
Content-Length: 118
Server: Werkzeug/0.12.2 Python/2.7.14
Date: Sun, 19 Nov 2017 12:20:42 GMT Here the process tree:
# pstree -al
systemd
  ├─dockerd -H fd://
  │   ├─docker-containe --config /var/run/docker/containerd/containerd.toml
  │   │   ├─docker-containe --namespace moby --workdir /var/lib/docker/containerd/daemon/io.containerd.runtime.v1.linux/moby/6f187950452f501cf18d7efd673e8305d6c9752c58acfb14918ae37341952a11 --address /var/run/docker/containerd/docker-containerd.sock --runtime-root /var/run/docker/runtime-runc
  │   │   │   ├─python app.py
  │   │   │   └─9*[{docker-containe}]
  │   │   └─7*[{docker-containe}]
  │   ├─docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 4000 -container-ip 172.17.0.2 -container-port 80
  │   │   └─4*[{docker-proxy}]
  │   └─9*[{dockerd}]
Note that this container has the ip 172.17.0.2. This is part of a private network and the ubuntu server has the ip
# ip address show docker0
3: docker0: mtu 1500 qdisc noqueue state UP group default
    link/ether 02:42:f4:04:06:3d brd ff:ff:ff:ff:ff:ff
    inet 172.17.0.1/16 scope global docker0
       valid_lft forever preferred_lft forever
If you start the container twice
root@ubuntuserver:~/dockerapp# docker run -d -p 4000:80 friendlyhello
aebe1a25dd2dda1c36c5cdd46bbdc138099711c885a7fb270b9981301a66fbd9
root@ubuntuserver:~/dockerapp# docker run -d -p 4001:80 friendlyhello
59276d1e15d7a636dbcf4eb599f7a948365eed656d93d47097999bee9b25db6b
there are two docker-proxies running:
# ps aux|grep docker-proxy
root      1286  0.0  0.3 304928  3084 ?        Sl   16:16   0:00 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 4000 -container-ip 172.17.0.2 -container-port 80
root      1385  0.0  0.2 304928  2880 ?        Sl   16:16   0:00 /usr/bin/docker-proxy -proto tcp -host-ip 0.0.0.0 -host-port 4001 -container-ip 172.17.0.3 -container-port 80


Docker-CE: initial configuration

Sat, 2017-11-18 15:43
After installing docker to a ubuntu server i was keen what kind of processes and files are there.
# ps x|grep docker
 5852 ?        Ssl    0:05 /usr/bin/dockerd -H fd://
 5867 ?        Ssl    0:04 docker-containerd --config /var/run/docker/containerd/containerd.tomlSo the inital configuration is not stored in /etc.

The configuration file looks like this:
# cat /var/run/docker/containerd/containerd.toml
root = "/var/lib/docker/containerd/daemon"
state = "/var/run/docker/containerd/daemon"
subreaper = false
oom_score = -500

[grpc]
  address = "/var/run/docker/containerd/docker-containerd.sock"
  uid = 0
  gid = 0

[debug]
  address = "/var/run/docker/containerd/docker-containerd-debug.sock"
  uid = 0
  gid = 0
  level = "info"

[metrics]
  address = ""

[cgroup]
  path = ""

[plugins]
  [plugins.linux]
    shim = "docker-containerd-shim"
    runtime = "docker-runc"
    runtime_root = "/var/lib/docker/runc"
    no_shim = false
    shim_debug = false
    shim_no_newns = falseThe directory /var/run/docker/containerd/daemon seems to be important, so let's take a look:
# find /var/run/docker/containerd/daemon
/var/run/docker/containerd/daemon
/var/run/docker/containerd/daemon/io.containerd.runtime.v1.linux
/var/run/docker/containerd/daemon/io.containerd.runtime.v1.linux/moby
But theese entries are only directories...

So what about /var/lib? Here we go:
# find /var/lib/docker/ -maxdepth 1
/var/lib/docker/
/var/lib/docker/overlay2
/var/lib/docker/swarm
/var/lib/docker/image
/var/lib/docker/tmp
/var/lib/docker/runtimes
/var/lib/docker/trust
/var/lib/docker/plugins
/var/lib/docker/containerd
/var/lib/docker/containers
/var/lib/docker/builder
/var/lib/docker/volumes
/var/lib/docker/networkWithin the directory containers you can find information about the containers which run / ran on your docker system:

# ls -l
insgesamt 12
drwx------ 4 root root 4096 Nov 16 22:12 0c7567bb965449f5f2f3dfadfc38f0226bdb42cc6d46daa4641042090e0405c7
drwx------ 4 root root 4096 Nov 16 22:57 28b7f70147aabc94bd174ce7ad7f5d48ed5610ffaa21733d3549ee6e998ee7c3
drwx------ 4 root root 4096 Nov 16 21:59 2db1c3ed1dafc85369536c382e02b6a23e5d134d2ba3d56a738f3441fb624b04
 The first characters of the directories match the container-id:
# docker ps -a
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS                  PORTS               NAMES
28b7f70147aa        hello-world         "/hello"            2 days ago          Exited (0) 2 days ago                       trusting_bartik
0c7567bb9654        hello-world         "/hello"            2 days ago          Exited (0) 2 days ago                       festive_wozniak
2db1c3ed1daf        hello-world         "/hello"            2 days ago          Exited (0) 2 days ago                       epic_tesla


Oracle SOA Suite 12c: database configuration

Fri, 2017-11-17 13:29
After the running the rcu i was keen what was created inside the database. The installation showed some additional tablespaces:
select tablespace_name from dba_tablespaces; TABLESPACE_NAME              
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
DEV_SOAINFRA
DEV_IAS_TEMP
DEV_STB
DEV_IAS_UMS
DEV_WLS
DEV_MDS
DEV_IAS_OPSS
DEV_IAU

13 Zeilen gewählt. Ok. Not really exciting.
But the list of the created tables was quite impressing:
select OWNER,TABLE_NAME from all_tables where owner like 'DEV%';

OWNER                TABLE_NAME                             
-------------------- ----------------------------------------
DEV_MDS              MDS_PURGE_PATHS                        
DEV_SOAINFRA         AQ$_IP_QTAB_G                          
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_G            
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_G          
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_G            
DEV_SOAINFRA         AQ$_IP_QTAB_T                          
DEV_SOAINFRA         AQ$_IP_QTAB_H                          
DEV_SOAINFRA         AQ$_IP_QTAB_I                          
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_T            
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_H            
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_I            
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_T          
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_H          
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_I          
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_T            
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_H            
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_I            
DEV_SOAINFRA         RUPD$_MFT_SOURCE_MESSAGE               
DEV_SOAINFRA         RUPD$_MFT_TRANSFER_INSTANCE            
DEV_SOAINFRA         RUPD$_MFT_TARGET_INSTANCE              
DEV_SOAINFRA         RUPD$_MFT_TARGET_MESSAGE               
DEV_SOAINFRA         RUPD$_MFT_DATA_STORAGE                 
DEV_SOAINFRA         TEMP_BRDECISION_INSTANCE_GLB           
DEV_SOAINFRA         TEMP_FLOWID_PURGE_GLB                  
DEV_SOAINFRA         TEMP_CUBE_INSTANCE_GLB                 
DEV_SOAINFRA         TEMP_DOCUMENT_CI_REF_GLB               
DEV_SOAINFRA         TEMP_DOCUMENT_DLV_MSG_REF_GLB          
DEV_SOAINFRA         TEMP_WFTASK_PURGE_GLB                  
DEV_SOAINFRA         TEMP_MEDIATOR_DEFERRED_GLB             
DEV_SOAINFRA         TEMP_MEDIATOR_RESEQUENCER_GLB          
DEV_SOAINFRA         UPGRADE_CURRENT_SEQUENCE_TEMP          
DEV_SOAINFRA         TEMP_UPGRADE_ECID                      
DEV_SOAINFRA         TEMP_UPGRADE_CI                        
DEV_SOAINFRA         TEMP_UPGRADE_DLV_MSG                   
DEV_SOAINFRA         TEMP_UPGRADE_DLV_ECID_MAP              
DEV_SOAINFRA         TEMP_UPGRADE_WKITM_CI                  
DEV_SOAINFRA         TEMP_UPGRADE_WFTASK                    
DEV_SOAINFRA         TEMP_UPGRADE_BRDECISION                
DEV_SOAINFRA         TEMP_UPGRADE_MI                        
DEV_SOAINFRA         TEMP_UPGRADE_MCI                       
DEV_SOAINFRA         TEMP_UPGRADE_MCDV                      
DEV_SOAINFRA         TEMP_UPGRADE_CPST_INST                 
DEV_SOAINFRA         LDAPADAPTER_IN                         
DEV_SOAINFRA         FILEADAPTER_IN                         
DEV_SOAINFRA         FILEADAPTER_MUTEX                      
DEV_SOAINFRA         JCA_NATIVE_CORRELATION                 
DEV_SOAINFRA         FILEADAPTER_TRANSACTION_LOG            
DEV_SOAINFRA         MESSAGE_STATISTICS                     
DEV_SOAINFRA         EIS_CONNECTION_DOWN_TIME               
DEV_SOAINFRA         AIA_ERROR_NOTIFICATIONS                
DEV_SOAINFRA         AIA_SYSTEMS                            
DEV_SOAINFRA         CAVS_DEFINITION_AUDITS                 
DEV_SOAINFRA         CAVS_DEFINITION_NSXPATHS               
DEV_SOAINFRA         CAVS_DEFINITION_XPATHS                 
DEV_SOAINFRA         CAVS_DEFINITION_XREFS                  
DEV_SOAINFRA         CAVS_DEFINITIONS                       
DEV_SOAINFRA         CAVS_GRPDEFINITION_DEFINITIONS         
DEV_SOAINFRA         CAVS_GRPDEFINITIONS                    
DEV_SOAINFRA         CAVS_GRPINSTANCE_INSTANCES             
DEV_SOAINFRA         CAVS_GRPINSTANCES                      
DEV_SOAINFRA         CAVS_INSTANCE_NSXPATHS                 
DEV_SOAINFRA         CAVS_INSTANCE_XPATHS                   
DEV_SOAINFRA         CAVS_INSTANCE_XREFS                    
DEV_SOAINFRA         CAVS_INSTANCES                         
DEV_SOAINFRA         CAVS_ROUTING_SETUP                     
DEV_SOAINFRA         CAVS_ROUTING_SETUP_DETAILS             
DEV_SOAINFRA         CAVS_SCHEDULER                         
DEV_SOAINFRA         AIA_ERROR_FLEX_FIELD                   
DEV_SOAINFRA         AIA_ERROR_MONITOR                      
DEV_SOAINFRA         AM_APPLICATION                         
DEV_SOAINFRA         AM_SUBSCRIPTION                        
DEV_SOAINFRA         AM_APIVISIBILITY                       
DEV_SOAINFRA         AM_ID_GENERATOR                        
DEV_SOAINFRA         B2B_STREAMSTORE                        
DEV_SOAINFRA         B2B_DATA_STORAGE                       
DEV_SOAINFRA         B2B_APP_MESSAGE                        
DEV_SOAINFRA         B2B_AUDIT_TEMP                         
DEV_SOAINFRA         B2B_BATCH_EVENT                        
DEV_SOAINFRA         B2B_BUSINESS_MESSAGE                   
DEV_SOAINFRA         B2B_BUSINESS_MESSAGE_RETRY             
DEV_SOAINFRA         B2B_CONTROL_NUMBER                     
DEV_SOAINFRA         B2B_CONTROL_NUMBER_SET                 
DEV_SOAINFRA         B2B_CTL_NUMBER                         
DEV_SOAINFRA         B2B_EXT_BUSINESS_MESSAGE               
DEV_SOAINFRA         B2B_HA_REGISTRY                        
DEV_SOAINFRA         B2B_LIFECYCLE                          
DEV_SOAINFRA         B2B_LOCK_REGISTRY                      
DEV_SOAINFRA         B2B_PARAMETER                          
DEV_SOAINFRA         B2B_PENDING_MESSAGE                    
DEV_SOAINFRA         B2B_PURGE_TEMP_AM                      
DEV_SOAINFRA         B2B_PURGE_TEMP_BM                      
DEV_SOAINFRA         B2B_PURGE_TEMP_WM                      
DEV_SOAINFRA         B2B_SEQUENCE_MANAGER                   
DEV_SOAINFRA         B2B_TRANSPORT_MANAGER                  
DEV_SOAINFRA         B2B_WIRE_MESSAGE                       
DEV_SOAINFRA         BEAM_SEQUENCE                          
DEV_SOAINFRA         BEAM_PROPERTY                          
DEV_SOAINFRA         BEAM_TRANSACTION_CONTEXT               
DEV_SOAINFRA         BEAM_FLEXTABLE                         
DEV_SOAINFRA         BEAM_DATAOBJECT                        
DEV_SOAINFRA         BEAM_NAMEMAPPING                       
DEV_SOAINFRA         BEAM_COLUMN                            
DEV_SOAINFRA         BEAM_ALERT_RULE                        
DEV_SOAINFRA         BEAM_ALERT_ESCALATION                  
DEV_SOAINFRA         AUDIT_COUNTER                          
DEV_SOAINFRA         AUDIT_DETAILS                          
DEV_SOAINFRA         AUDIT_TRAIL                            
DEV_SOAINFRA         CI_INDEXES                             
DEV_SOAINFRA         CLUSTER_MASTER                         
DEV_SOAINFRA         CLUSTER_NODE                           
DEV_SOAINFRA         CUBE_INSTANCE                          
DEV_SOAINFRA         CUBE_SCOPE                             
DEV_SOAINFRA         DLV_MESSAGE                            
DEV_SOAINFRA         DLV_SUBSCRIPTION                       
DEV_SOAINFRA         DOCUMENT_CI_REF                        
DEV_SOAINFRA         DOCUMENT_DLV_MSG_REF                   
DEV_SOAINFRA         HEADERS_PROPERTIES                     
DEV_SOAINFRA         DLV_AGGREGATION                        
DEV_SOAINFRA         ID_RANGE                               
DEV_SOAINFRA         LOAN_CUSTOMER                          
DEV_SOAINFRA         NATIVE_CORRELATION                     
DEV_SOAINFRA         TEST_DEFINITIONS                       
DEV_SOAINFRA         TEST_DETAILS                           
DEV_SOAINFRA         UPGRADE_INFO                           
DEV_SOAINFRA         VERSION                                
DEV_SOAINFRA         WI_FAULT                               
DEV_SOAINFRA         WORK_ITEM                              
DEV_SOAINFRA         CUBE_PROCESS_BREAKPOINT                
DEV_SOAINFRA         BPEL_CONVERSATION_SUBSCRIPTION         
DEV_SOAINFRA         SOAQTZ_BLOB_TRIGGERS                   
DEV_SOAINFRA         SOAQTZ_CALENDARS                       
DEV_SOAINFRA         SOAQTZ_CRON_TRIGGERS                   
DEV_SOAINFRA         SOAQTZ_FIRED_TRIGGERS                  
DEV_SOAINFRA         SOAQTZ_JOB_DETAILS                     
DEV_SOAINFRA         SOAQTZ_JOB_LISTENERS                   
DEV_SOAINFRA         SOAQTZ_LOCKS                           
DEV_SOAINFRA         SOAQTZ_PAUSED_TRIGGER_GRPS             
DEV_SOAINFRA         SOAQTZ_SCHEDULER_STATE                 
DEV_SOAINFRA         SOAQTZ_SIMPLE_TRIGGERS                 
DEV_SOAINFRA         SOAQTZ_TRIGGER_LISTENERS               
DEV_SOAINFRA         SOAQTZ_TRIGGERS                        
DEV_SOAINFRA         CM_CASE_OBJECT                         
DEV_SOAINFRA         CM_CASE_DOCUMENT                       
DEV_SOAINFRA         CM_CASE_EVENT                          
DEV_SOAINFRA         CM_PROPERTY_BAG                        
DEV_SOAINFRA         CM_CASE_DEFINITION                     
DEV_SOAINFRA         CM_CASE_MILESTONE_DEFINITION           
DEV_SOAINFRA         CM_ACTIVITY_DEFINITION                 
DEV_SOAINFRA         CM_ACTIVITY_CASE_DEFINITION            
DEV_SOAINFRA         CM_ACTIVITY_CATEGORY_DEFN              
DEV_SOAINFRA         CM_TRANSLATION                         
DEV_SOAINFRA         CM_ACTIVITY_INSTANCE                   
DEV_SOAINFRA         CM_CASE                                
DEV_SOAINFRA         CM_FABRIC_HEADER_PROPERTY              
DEV_SOAINFRA         CM_LINKED_CASE                         
DEV_SOAINFRA         CM_CASE_DATA                           
DEV_SOAINFRA         CM_CASE_FLEX_FIELD                     
DEV_SOAINFRA         CM_CASE_HEADER                         
DEV_SOAINFRA         CM_CASE_MILESTONE                      
DEV_SOAINFRA         CM_CASE_PHASE                          
DEV_SOAINFRA         CM_CASE_STAKE_HOLDER                   
DEV_SOAINFRA         CM_CASE_STAKE_HOLDER_MEMBER            
DEV_SOAINFRA         CM_COMMENT                             
DEV_SOAINFRA         CM_RULE                                
DEV_SOAINFRA         CM_RULE_EDIT                           
DEV_SOAINFRA         CM_ACTIVITY_ATTRIBUTE                  
DEV_SOAINFRA         CM_ACTIVITY_CORRELATION                
DEV_SOAINFRA         CM_SEQUENCE_TABLE                      
DEV_SOAINFRA         CM_CASE_DISPLAY                        
DEV_SOAINFRA         CM_ACTIVITY_STAKEHOLDER                
DEV_SOAINFRA         BPM_ACTIVITY                           
DEV_SOAINFRA         BPM_ACTIVITY_INSTANCE                  
DEV_SOAINFRA         BPM_ACTIVITY_PROPERTY                  
DEV_SOAINFRA         BPM_AUDIT_QUERY                        
DEV_SOAINFRA         BPM_AUDIT_QUERY_METADATA               
DEV_SOAINFRA         BPM_AUDIT_QUERY_VAR_MD                 
DEV_SOAINFRA         BPM_AUDIT_QUERY_VAR_RANGES             
DEV_SOAINFRA         BPM_AUDIT_QUERY_VARMD_EXT1             
DEV_SOAINFRA         BPM_AUDIT_QUERY_VARVALS_EXT1           
DEV_SOAINFRA         BPM_AUDIT_SEQUENCE                     
DEV_SOAINFRA         BPM_CASE                               
DEV_SOAINFRA         BPM_CASE_ACTIVITIES                    
DEV_SOAINFRA         BPM_CASE_ATTRIBUTES                    
DEV_SOAINFRA         BPM_CASE_DATA                          
DEV_SOAINFRA         BPM_CUBE_ACTIVITY                      
DEV_SOAINFRA         BPM_CUBE_ACTIVITY_INSTANCE             
DEV_SOAINFRA         BPM_CUBE_ACTIVITY_PROPERTY             
DEV_SOAINFRA         BPM_CUBE_ACTIVITY_SEQFLOW              
DEV_SOAINFRA         BPM_CUBE_AUDITINST_FLEX01              
DEV_SOAINFRA         BPM_CUBE_AUDITINSTANCE                 
DEV_SOAINFRA         BPM_CUBE_GLOBALCREATETASK              
DEV_SOAINFRA         BPM_CUBE_LASTSNAPSHOT                  
DEV_SOAINFRA         BPM_CUBE_LOCK                          
DEV_SOAINFRA         BPM_CUBE_NAMETAB                       
DEV_SOAINFRA         BPM_CUBE_NAMETAB_RANGE                 
DEV_SOAINFRA         BPM_CUBE_ORGUNIT                       
DEV_SOAINFRA         BPM_CUBE_ORGUNIT_ASSOC                 
DEV_SOAINFRA         BPM_CUBE_PARTNER_SERVICE               
DEV_SOAINFRA         BPM_CUBE_PROCESS                       
DEV_SOAINFRA         BPM_CUBE_PROCESS_PARTNER               
DEV_SOAINFRA         BPM_CUBE_PROCESSPERFORMANCE            
DEV_SOAINFRA         BPM_CUBE_PROCPERF_FLEX01               
DEV_SOAINFRA         BPM_CUBE_ROLE                          
DEV_SOAINFRA         BPM_CUBE_SEQUENCE                      
DEV_SOAINFRA         BPM_CUBE_TASKPERF_FLEX01               
DEV_SOAINFRA         BPM_CUBE_TASKPERFORMANCE               
DEV_SOAINFRA         BPM_CUBE_WORKLOAD                      
DEV_SOAINFRA         BPM_CUBE_WORKLOAD_FLEX01               
DEV_SOAINFRA         BPM_CUSTOM_APPS                        
DEV_SOAINFRA         BPM_MEASUREMENT_ACTION_EXCEPS          
DEV_SOAINFRA         BPM_MEASUREMENT_ACTION_SEQ             
DEV_SOAINFRA         BPM_MEASUREMENT_ACTIONS                
DEV_SOAINFRA         BPM_PARTNER_SERVICE                    
DEV_SOAINFRA         BPM_PROCESS                            
DEV_SOAINFRA         BPM_PROCESS_PARTNER                    
DEV_SOAINFRA         BPM_PROJECTSHAREDATA                   
DEV_SOAINFRA         BPM_PROJECTSHAREDATA_SEQ               
DEV_SOAINFRA         BPM_SEQUENCE                           
DEV_SOAINFRA         BPM_RT_FLOW_ELEMENT                    
DEV_SOAINFRA         BPM_RT_INSTANCE_CREATION               
DEV_SOAINFRA         BPM_RT_SEQUENCE                        
DEV_SOAINFRA         BPM_RT_SEQUENCE_FLOW                   
DEV_SOAINFRA         BPM_RT_SNAPSHOT                        
DEV_SOAINFRA         AG_INSTANCE                            
DEV_SOAINFRA         BPM_PML_SEQUENCE                       
DEV_SOAINFRA         BPM_PML_HS                             
DEV_SOAINFRA         BPM_PML_HS_ITEM                        
DEV_SOAINFRA         BPM_PML_HS_BPM_PML_HS_ITEM             
DEV_SOAINFRA         BPM_BAC_SEQUENCE                       
DEV_SOAINFRA         BPM_BAC_SESSION                        
DEV_SOAINFRA         BPM_BAC_METADATA_STORE                 
DEV_SOAINFRA         BPM_BAC_REPOSITORY_BACKUP              
DEV_SOAINFRA         BPM_OPTIMIZATION_DATA                  
DEV_SOAINFRA         BPM_OPT_COMPLETION_DATE_DATA           
DEV_SOAINFRA         BPM_OPT_DATA_SEQUENCE                  
DEV_SOAINFRA         BPM_ARCHIVEREQUEST                     
DEV_SOAINFRA         BPM_ARCHIVESEQUENCE                    
DEV_SOAINFRA         BPM_USER_DRAFT                         
DEV_SOAINFRA         EDN_EVENT_ERROR_STORE                  
DEV_SOAINFRA         EDN_E2J_MAPPING                        
DEV_SOAINFRA         EDN_EVENT_AGENTS                       
DEV_SOAINFRA         EDN_EVENT_SUBSCRIPTIONS                
DEV_SOAINFRA         EDN_LOG_ENABLED                        
DEV_SOAINFRA         EDN_LOG_MESSAGES                       
DEV_SOAINFRA         EDN_RETRY_COUNT                        
DEV_SOAINFRA         ATTACHMENT                             
DEV_SOAINFRA         ATTACHMENT_REF                         
DEV_SOAINFRA         BRIDGE_INSTANCE                        
DEV_SOAINFRA         COMPONENT_INSTANCE                     
DEV_SOAINFRA         COMPOSITE_INSTANCE                     
DEV_SOAINFRA         COMPOSITE_INSTANCE_ASSOC               
DEV_SOAINFRA         COMPOSITE_INSTANCE_FAULT               
DEV_SOAINFRA         INSTANCE_PAYLOAD                       
DEV_SOAINFRA         REFERENCE_INSTANCE                     
DEV_SOAINFRA         REJECTED_MESSAGE                       
DEV_SOAINFRA         REJECTED_MSG_NATIVE_PAYLOAD            
DEV_SOAINFRA         SENSOR_SEQUENCE                        
DEV_SOAINFRA         SEQUENCE                               
DEV_SOAINFRA         TEST_INSTANCE                          
DEV_SOAINFRA         XML_DOCUMENT                           
DEV_SOAINFRA         XML_DOCUMENT_REF                       
DEV_SOAINFRA         SCA_SEQUENCE                           
DEV_SOAINFRA         SCA_PARTITION                          
DEV_SOAINFRA         SCA_ENTITY                             
DEV_SOAINFRA         SCA_FLOW_INSTANCE                      
DEV_SOAINFRA         SCA_FLOW_TO_CPST                       
DEV_SOAINFRA         SCA_ASYNC_CPNT_STATE                   
DEV_SOAINFRA         SCA_COMMON_FAULT                       
DEV_SOAINFRA         SCA_FLOW_ASSOC                         
DEV_SOAINFRA         SCA_META_DATA                          
DEV_SOAINFRA         FAULT_NOTIFICATION_RULE                
DEV_SOAINFRA         FAULT_ALERT                            
DEV_SOAINFRA         BULK_RECOVERY_JOB                      
DEV_SOAINFRA         SCA_REJECTED_MESSAGE                   
DEV_SOAINFRA         SCA_ATTACHMENT_REF                     
DEV_SOAINFRA         UPGRADE_CURRENT_SEQUENCE               
DEV_SOAINFRA         RESLNCY_FAILURE_EP                     
DEV_SOAINFRA         RESLNCY_SUSPEND_SVC                    
DEV_SOAINFRA         RESLNCY_SUSPEND_SVC_HSTRY              
DEV_SOAINFRA         RESLNCY_FAILURE_EP_HSTRY               
DEV_SOAINFRA         AWR_SERVER_NODE                        
DEV_SOAINFRA         AWR_CONFIGURATION                      
DEV_SOAINFRA         AWR_COMPOSITE                          
DEV_SOAINFRA         AWR_COMPONENT                          
DEV_SOAINFRA         AWR_ENDPOINT                           
DEV_SOAINFRA         AWR_ACTIVITY                           
DEV_SOAINFRA         AWR_SYSTEM_RESOURCES                   
DEV_SOAINFRA         AWR_SNAPSHOT                           
DEV_SOAINFRA         AWR_RESOURCE_UTIL_METRIC               
DEV_SOAINFRA         AWR_FLOW_METRIC                        
DEV_SOAINFRA         AWR_EXECUTION_METRIC                   
DEV_SOAINFRA         AWR_BACKUP_METRIC                      
DEV_SOAINFRA         REP_BUS_EVENT                          
DEV_SOAINFRA         REP_FLOW_CORL                          
DEV_SOAINFRA         REP_EVENT_PROP                         
DEV_SOAINFRA         REP_PAYLOAD                            
DEV_SOAINFRA         REP_BUS_RECOVERY                       
DEV_SOAINFRA         PMON_BIZ_MODEL                         
DEV_SOAINFRA         PMON_BIZ_PROP                          
DEV_SOAINFRA         PMON_AUDIT                             
DEV_SOAINFRA         PMON_AUDIT_INFO                        
DEV_SOAINFRA         PMON_REJECTED_MODEL                    
DEV_SOAINFRA         PMON_SEQUENCE                          
DEV_SOAINFRA         SOA_HEALTHCHECK_RESULT                 
DEV_SOAINFRA         PC_OWF                                 
DEV_SOAINFRA         PC_TASK                                
DEV_SOAINFRA         PC_TASKASSIGNEE                        
DEV_SOAINFRA         PC_TASKASSIGNEEHISTORY                 
DEV_SOAINFRA         PC_TASKATTACHMENT                      
DEV_SOAINFRA         PC_TASKHISTORY                         
DEV_SOAINFRA         PC_TASKPAYLOAD                         
DEV_SOAINFRA         BPELNOTIFICATION                       
DEV_SOAINFRA         BPELNOTIFICATION_FILTERMSGS            
DEV_SOAINFRA         BPELNOTIFICATION_INVALADDRS            
DEV_SOAINFRA         BPM_BUSINESS_CONSTANT_OU_ASSOC         
DEV_SOAINFRA         BPM_BUSINESS_CONSTANT                  
DEV_SOAINFRA         BPM_APP_ROLE_OU_CAL_ASSOC              
DEV_SOAINFRA         BPM_CALENDAR_RULE                      
DEV_SOAINFRA         BPM_CALENDAR_WORKDAY                   
DEV_SOAINFRA         BPM_FISCAL_YEAR                        
DEV_SOAINFRA         BPM_FISCAL_YEAR_DIVISION               
DEV_SOAINFRA         BPM_EXT_USER_PROP_AVLBL_COL            
DEV_SOAINFRA         BPM_EXT_USER_PROPERTY_GLOBAL           
DEV_SOAINFRA         BPM_EXT_USER_PROPERTY_VALUE            
DEV_SOAINFRA         BPM_HOLIDAY_RULE                       
DEV_SOAINFRA         BPM_HOLIDAYS                           
DEV_SOAINFRA         BPM_LOGICAL_PEOPLE_GROUP               
DEV_SOAINFRA         BPM_LPG_MEMBER                         
DEV_SOAINFRA         BPM_ORGANIZATIONAL_UNIT                
DEV_SOAINFRA         BPM_OU_MANAGER                         
DEV_SOAINFRA         BPM_OU_USER                            
DEV_SOAINFRA         BPM_PP_ENTITY_GS_MAP                   
DEV_SOAINFRA         BPM_PRESENTATION                       
DEV_SOAINFRA         BPM_PRESENTATION_GRANT                 
DEV_SOAINFRA         BPM_USERAPPLICATIONDATA                
DEV_SOAINFRA         BPM_USERAPPLICATIONDATA_GRANT          
DEV_SOAINFRA         DOCUMENTDEFINITION                     
DEV_SOAINFRA         DOCUMENTINSTANCE                       
DEV_SOAINFRA         DOCUMENTPACKAGEDEFINITION              
DEV_SOAINFRA         DOCUMENTPACKAGEINSTANCE                
DEV_SOAINFRA         DOCUMENTPACKAGEPROCESS                 
DEV_SOAINFRA         DOCUMENTPACKAGEPROPERTIES              
DEV_SOAINFRA         DOCUMENTPACKAGEPROPERTIESMAP           
DEV_SOAINFRA         NOTIFICATIONTRACKER                    
DEV_SOAINFRA         NOTIFTRACKERATTACHMENTS                
DEV_SOAINFRA         WFAPPROVALGROUPMEMBERS                 
DEV_SOAINFRA         WFAPPROVALGROUPS                       
DEV_SOAINFRA         WFASSIGNEE                             
DEV_SOAINFRA         WFATTACHMENT                           
DEV_SOAINFRA         WFATTRIBUTELABELMAP                    
DEV_SOAINFRA         WFATTRIBUTELABELUSAGE                  
DEV_SOAINFRA         WFCERTAUTHORITY                        
DEV_SOAINFRA         WFCERTIFICATE                          
DEV_SOAINFRA         WFCERTIFICATEREVOKED                   
DEV_SOAINFRA         WFCOLLECTIONTARGET                     
DEV_SOAINFRA         WFCOMMENTS                             
DEV_SOAINFRA         WFEVIDENCE                             
DEV_SOAINFRA         WFHEADERPROPS                          
DEV_SOAINFRA         WFMESSAGEATTRIBUTE                     
DEV_SOAINFRA         WFNOTIFICATION                         
DEV_SOAINFRA         WFNOTIFICATIONMESSAGES                 
DEV_SOAINFRA         WFNOTIFICATIONSTATUS                   
DEV_SOAINFRA         WFREVIEWER                             
DEV_SOAINFRA         WFROUTINGSLIP                          
DEV_SOAINFRA         WFRULEDICTIONARY                       
DEV_SOAINFRA         WFTASK                                 
DEV_SOAINFRA         WFTASK_TL                              
DEV_SOAINFRA         WFTASKAGGREGATION                      
DEV_SOAINFRA         WFTASKASSIGNMENTSTATISTIC              
DEV_SOAINFRA         WFTASKDISPLAY                          
DEV_SOAINFRA         WFTASKERROR                            
DEV_SOAINFRA         WFTASKHISTORY                          
DEV_SOAINFRA         WFTASKHISTORY_TL                       
DEV_SOAINFRA         WFTASKMETADATA                         
DEV_SOAINFRA         WFTASKSEQUENCECHANGES                  
DEV_SOAINFRA         WFTASKTIMER                            
DEV_SOAINFRA         WFUSERPREFERENCE                       
DEV_SOAINFRA         WFUSERTASKVIEW                         
DEV_SOAINFRA         WFUSERTASKVIEWGRANT                    
DEV_SOAINFRA         WLI_QS_REPORT_ATTRIBUTE                
DEV_SOAINFRA         WLI_QS_REPORT_DATA                     
DEV_SOAINFRA         OSB_MSG                                
DEV_SOAINFRA         RM_SEQUENCES                           
DEV_SOAINFRA         RM_UNACKED_MESSAGES                    
DEV_SOAINFRA         RM_LOCALIDS                            
DEV_SOAINFRA         BRDECISIONFAULT                        
DEV_SOAINFRA         BRDECISIONINSTANCE                     
DEV_SOAINFRA         BRDECISIONUNITOFWORK                   
DEV_SOAINFRA         BRSEQUENCE                             
DEV_SOAINFRA         ACTIVITY_SENSOR_VALUES                 
DEV_SOAINFRA         COMPOSITE_SENSOR_VALUE                 
DEV_SOAINFRA         FAULT_SENSOR_VALUES                    
DEV_SOAINFRA         VARIABLE_SENSOR_VALUES                 
DEV_SOAINFRA         SCA_SENSOR_VALUE                       
DEV_SOAINFRA         MEDIATOR_GROUP_STATUS                  
DEV_SOAINFRA         MEDIATOR_RESEQUENCER_MESSAGE           
DEV_SOAINFRA         OSB_GROUP_STATUS                       
DEV_SOAINFRA         OSB_RESEQUENCER_MESSAGE                
DEV_SOAINFRA         B2B_GROUP_STATUS                       
DEV_SOAINFRA         B2B_RESEQUENCER_MESSAGE                
DEV_SOAINFRA         MEDIATOR_SERVICE_DETAIL                
DEV_SOAINFRA         OSB_SERVICE_DETAIL                     
DEV_SOAINFRA         B2B_SERVICE_DETAIL                     
DEV_SOAINFRA         MEDIATOR_RES_CONTAINERID_LEASE         
DEV_SOAINFRA         B2B_RES_CONTAINERID_LEASE              
DEV_SOAINFRA         OSB_RES_CONTAINERID_LEASE              
DEV_SOAINFRA         LABEL_VERSION_PCBPEL                   
DEV_SOAINFRA         XREF_DATA                              
DEV_SOAINFRA         XREF_DELETED_DATA                      
DEV_SOAINFRA         AIA_CAVSCALLBACKJMSQTAB                
DEV_SOAINFRA         IP_QTAB                                
DEV_SOAINFRA         AQ$_IP_QTAB_S                          
DEV_SOAINFRA         WFUSERVACATION                         
DEV_SOAINFRA         WFWORKQUEUE                            
DEV_SOAINFRA         WFWORKQUEUE_MEMBER                     
DEV_SOAINFRA         WFWORKQUEUE_MANAGER                    
DEV_SOAINFRA         WFWORKQUEUE_SKIP                       
DEV_SOAINFRA         MEDIATOR_AUDIT_DOCUMENT                
DEV_SOAINFRA         MEDIATOR_CALLBACK                      
DEV_SOAINFRA         MEDIATOR_CASE_DETAIL                   
DEV_SOAINFRA         MEDIATOR_CASE_INSTANCE                 
DEV_SOAINFRA         MEDIATOR_CONTAINERID_LEASE             
DEV_SOAINFRA         MEDIATOR_CORRELATION                   
DEV_SOAINFRA         MEDIATOR_DEFERRED_MESSAGE              
DEV_SOAINFRA         MEDIATOR_INSTANCE                      
DEV_SOAINFRA         MEDIATOR_PAYLOAD                       
DEV_SOAINFRA         MFT_SOURCE_MESSAGE                     
DEV_SOAINFRA         MFT_SECURITY_INFO                      
DEV_SOAINFRA         MFT_RETRY_INFO                         
DEV_SOAINFRA         MFT_RESUBMIT_INFO                      
DEV_SOAINFRA         MFT_PAUSED_INSTANCE_INFO               
DEV_SOAINFRA         MFT_TARGET_INSTANCE                    
DEV_SOAINFRA         MFT_ES_AUTHORIZATION                   
DEV_SOAINFRA         MFT_ERROR_INFO                         
DEV_SOAINFRA         MFT_DATA_STORAGE                       
DEV_SOAINFRA         MFT_CALLOUT_INSTANCE                   
DEV_SOAINFRA         MFT_SOURCE_UNPROCESSED                 
DEV_SOAINFRA         MFT_TRANSFER_INSTANCE                  
DEV_SOAINFRA         MFT_SOURCE_LIFECYCLE                   
DEV_SOAINFRA         MFT_TRANSFER_LIFECYCLE                 
DEV_SOAINFRA         MFT_TARGET_LIFECYCLE                   
DEV_SOAINFRA         MFT_TRANSFER_TARGET_REL                
DEV_SOAINFRA         MFT_TRANSFER_SCHEDULE                  
DEV_SOAINFRA         MFT_TARGET_MESSAGE                     
DEV_SOAINFRA         MFT_ES_PORT_ASSIGNMENT                 
DEV_SOAINFRA         MFT_RCU_PURGE                          
DEV_SOAINFRA         MFT_TRIGGER_EVENT                      
DEV_SOAINFRA         AQ$_IP_QTAB_L                          
DEV_SOAINFRA         SYS_IOT_OVER_76460                     
DEV_SOAINFRA         B2B_SYSTEM_MV                          
DEV_SOAINFRA         EDN_EVENT_QUEUE_TABLE                  
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_S            
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_L            
DEV_SOAINFRA         SYS_IOT_OVER_76563                     
DEV_SOAINFRA         EDN_OAOO_DELIVERY_TABLE                
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_S          
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_L          
DEV_SOAINFRA         SYS_IOT_OVER_76592                     
DEV_SOAINFRA         EDN_AQJMS_TOPIC_TABLE                  
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_S            
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_L            
DEV_SOAINFRA         SYS_IOT_OVER_76625                     
DEV_SOAINFRA         TASK_NOTIFICATION_Q_T                  
DEV_SOAINFRA         MLOG$_MFT_SOURCE_MESSAGE               
DEV_SOAINFRA         MLOG$_MFT_TRANSFER_INSTANCE            
DEV_SOAINFRA         MLOG$_MFT_TARGET_INSTANCE              
DEV_SOAINFRA         MLOG$_MFT_TARGET_MESSAGE               
DEV_SOAINFRA         MLOG$_MFT_DATA_STORAGE                 
DEV_SOAINFRA         MV_MFT_SOURCE_MESSAGE                  
DEV_SOAINFRA         MV_MFT_PAYLOAD_INFO                    
DEV_SOAINFRA         MV_MFT_TRANSFER                        
DEV_SOAINFRA         MV_MFT_TRANSFER_COUNT_INFO             
DEV_SOAINFRA         MV_MFT_TARGET_INFO                     
DEV_SOAINFRA         MV_MFT_SOURCE_INFO                     
DEV_SOAINFRA         OSB_FTP_TRANSPORT_TBL                  
DEV_SOAINFRA         OSB_SFTP_TRANSPORT_TBL                 
DEV_SOAINFRA         OSB_EMAIL_TRANSPORT_TBL                
DEV_SOAINFRA         OSB_FILE_TRANSPORT_TBL                 
DEV_SOAINFRA         OSB_REPORTING_TBL                      
DEV_SOAINFRA         OSB_REPORTING_ERROR_TBL                
DEV_SOAINFRA         OSB_PURGE_TBL                          
DEV_SOAINFRA         acl                                    
DEV_SOAINFRA         aclentry                               
DEV_SOAINFRA         aclpermission                          
DEV_SOAINFRA         activitysubmission                     
DEV_SOAINFRA         activitysubmissiontype                 
DEV_SOAINFRA         contentdata                            
DEV_SOAINFRA         controlsubmission                      
DEV_SOAINFRA         controlsubmissiontype                  
DEV_SOAINFRA         documentsubmission                     
DEV_SOAINFRA         formmetadatatype                       
DEV_SOAINFRA         formsubmission_roleidentifier          
DEV_SOAINFRA         formsubmission                         
DEV_SOAINFRA         formsubmissiontype                     
DEV_SOAINFRA         formtemplate_languages                 
DEV_SOAINFRA         signaturesubmission                    
DEV_SOAINFRA         template_categories                    
DEV_SOAINFRA         template_features                      
DEV_SOAINFRA         template_tags                          
DEV_SOAINFRA         template                               
DEV_SOAINFRA         USERS                                  
DEV_SOAINFRA         TENANTS                                
DEV_SOAINFRA         TENANTROLES                            
DEV_SOAINFRA         ROLES                                  
DEV_SOAINFRA         USERSROLES                             
DEV_SOAINFRA         TENANTCATEGORIES                       
DEV_SOAINFRA         SPACES                                 
DEV_SOAINFRA         RESOURCES                              
DEV_SOAINFRA         TEMP11G_CUBE_INSTANCE                  
DEV_SOAINFRA         TEMP11G_DOCUMENT_CI_REF                
DEV_SOAINFRA         TEMP11G_DOCUMENT_DLV_MSG_REF           
DEV_SOAINFRA         TEMP11G_XML_DOCUMENT                   
DEV_SOAINFRA         COMPOSITE_INSTANCE_PURGE               
DEV_SOAINFRA         REFERENCE_INSTANCE_PURGE               
DEV_SOAINFRA         COMPOSITE_FAULT_PURGE                  
DEV_SOAINFRA         REJECTED_MESSAGE_PURGE                 
DEV_SOAINFRA         COMPONENT_INSTANCE_PURGE               
DEV_SOAINFRA         TEMP11G_WFTASK_PURGE                   
DEV_SOAINFRA         TEMP_MEDIATOR_INSTANCE                 
DEV_SOAINFRA         PRUNE_RUNNING_INSTS                    
DEV_SOAINFRA         ECID_PURGE                             
DEV_SOAINFRA         TEMP_PROCESSED_CIKEY                   
DEV_SOAINFRA         TEMP_PROCESSED_MI                      
DEV_SOAINFRA         TEMP_FLOWID_PURGE                      
DEV_SOAINFRA         TEMP_PRUNE_RUNNING_INSTS               
DEV_SOAINFRA         TEMP_CUBE_INSTANCE                     
DEV_SOAINFRA         TEMP_DOCUMENT_CI_REF                   
DEV_SOAINFRA         TEMP_DOCUMENT_DLV_MSG_REF              
DEV_SOAINFRA         TEMP_XML_DOCUMENT                      
DEV_SOAINFRA         TEMP_BRDECISION_INSTANCE               
DEV_SOAINFRA         TEMP_WFTASK_PURGE                      
DEV_SOAINFRA         TEMP_MEDIATOR_DEFERRED                 
DEV_SOAINFRA         TEMP_MEDIATOR_RESEQUENCER              
DEV_SOAINFRA         TEMP_MEDIATOR_GROUP                    
DEV_SOAINFRA         JOB_FLOW_CONTROL                       
DEV_SOAINFRA         SOA_PURGE_HISTORY                      
DEV_SOAINFRA         SOA_PURGE_ALERT                        
DEV_SOAINFRA         TEMP_AWR_PURGE                         
DEV_SOAINFRA         TEMP_HC_PURGE                          
DEV_SOAINFRA         VERIFY_GROUP1                          
DEV_SOAINFRA         VERIFY_ECID_GROUP1                     
DEV_SOAINFRA         VERIFY_FABRIC_GROUP1                   
DEV_SOAINFRA         VERIFY_CP_GROUP1                       
DEV_SOAINFRA         VERIFY_BPEL_GROUP1                     
DEV_SOAINFRA         VERIFY_MD_GROUP1                       
DEV_SOAINFRA         VERIFY_MEDIATOR_GROUP1                 
DEV_SOAINFRA         VERIFY_WORKFLOW_GROUP1                 
DEV_SOAINFRA         VERIFY_DC_GROUP2                       
DEV_SOAINFRA         VERIFY_MP_GROUP2                       
DEV_SOAINFRA         VERIFY_DL_GROUP1A                      
DEV_SOAINFRA         TRS_PARAMETER                          
DEV_SOAINFRA         TRS_CUBE_INSTANCE                      
DEV_SOAINFRA         TRS_DOCUMENT_DLV_MSG_REF               
DEV_SOAINFRA         TRS_COMPOSITE_INSTANCE                 
DEV_SOAINFRA         TRS_REFERENCE_INSTANCE                 
DEV_SOAINFRA         TRS_COMPOSITE_INSTANCE_FAULT           
DEV_SOAINFRA         TRS_INSTANCE_PAYLOAD                   
DEV_SOAINFRA         TRS_REJECTED_MESSAGE                   
DEV_SOAINFRA         TRS_COMPONENT_INSTANCE                 
DEV_SOAINFRA         TRS_BRDECISION_INSTANCE                
DEV_SOAINFRA         TRS_WFTASK                             
DEV_SOAINFRA         TRS_MEDIATOR_INSTANCE                  
DEV_SOAINFRA         TRS_MEDIATOR_PAYLOAD                   
DEV_SOAINFRA         TRS_MEDIATOR_PAYLOAD_TEMP              
DEV_SOAINFRA         TRS_MEDIATOR_GROUP_STATUS              
DEV_SOAINFRA         TRS_MEDIATOR_RESEQ_MESSAGE             
DEV_SOAINFRA         TRS_SOA_ECID                           
DEV_SOAINFRA         TRS_XML_DOCUMENT                       
DEV_SOAINFRA         UPGRADE_PARAMETER_TABLE                
DEV_SOAINFRA         UPGRADE_INJECTION                      
DEV_SOAINFRA         UPGRADE_PROGRESS_LOG                   
DEV_SOAINFRA         UPGRADE_OPEN_ECIDS_STATUS              
DEV_SOAINFRA         TEMP_COMPOSITEDN_UPGRADE               
DEV_SOAINFRA         TEMP_COMPOSITEDN_UPGRADE_ALL           
DEV_SOAINFRA         UPGRADE_ERROR_LOG                      
DEV_SOAINFRA         B2B_BAM_QTAB                           
DEV_STB              SERVICETABLE                           
DEV_STB              COMPONENT_SCHEMA_INFO                  
DEV_UMS              ACCESS_POINT                           
DEV_UMS              ADDRESS                                
DEV_UMS              CLIENT                                 
DEV_UMS              CLIENT_ACCESS_POINT                    
DEV_UMS              CLIENT_INSTANCE                        
DEV_UMS              CLIENT_PARAMETER                       
DEV_UMS              CLIENT_QUEUE                           
DEV_UMS              CLIENT_SESSION                         
DEV_UMS              DELIVERY_ATTEMPT                       
DEV_UMS              DELIVERY_CONTEXT                       
DEV_UMS              DRIVER                                 
DEV_UMS              DRIVER_QUEUE                           
DEV_UMS              DRIVER_SESSION                         
DEV_UMS              FILTER                                 
DEV_UMS              MESSAGE                                
DEV_UMS              MESSAGE_TRANSFORM                      
DEV_UMS              PARAMETER                              
DEV_UMS              QUEUE                                  
DEV_UMS              STATUS                                 
DEV_UMS              STATUS_ORPHAN                          
DEV_UMS              DEVICE_ADDRESS                         
DEV_UMS              RULE_SET                               
DEV_UMS              UCP_MEDIA_TYPE                         
DEV_UMS              UCP_USER_ATTRIBUTE                     
DEV_UMS              USER_DEVICE                            
DEV_UMS              ORASDPMAPPDEFRCVT1                     
DEV_UMS              ORASDPMENGINECMDT                      
DEV_UMS              ORASDPMENGINESNDT1                     
DEV_UMS              ORASDPMENGINERCVT1                     
DEV_UMS              ORASDPMWSRCVT1                         
DEV_UMS              ORASDPMDRIVERDEFSNDT1                  
DEV_UMS              ORASDPMENGINEPENDRCVQT                 
DEV_WLS              BEAWPCI                                
DEV_WLS              BEAWRCI                                
DEV_WLS              BEAXACMLAP                             
DEV_WLS              BEAXACMLAP_RS                          
DEV_WLS              BEAXACMLRAP                            
DEV_WLS              BEAXACMLRAP_R                          
DEV_WLS              BEAXACMLRAP_RS                         
DEV_WLS              WEBLOGIC_TIMERS                        
DEV_WLS              WLS_EVENTS                             
DEV_WLS              WLS_HVST                               
DEV_WLS              JOBINSTANCEDATA                        
DEV_WLS              EXECUTIONINSTANCEDATA                  
DEV_WLS              STEPEXECUTIONINSTANCEDATA              
DEV_WLS              JOBSTATUS                              
DEV_WLS              STEPSTATUS                             
DEV_WLS              CHECKPOINTDATA                         
DEV_WLS              BEACSS_SCHEMA_VERSION                  
DEV_WLS              BEAPC                                  
DEV_WLS              BEAPCM                                 
DEV_WLS              BEAPRMP                                
DEV_WLS              BEARM                                  
DEV_WLS              BEASAML2_CACHE                         
DEV_WLS              BEASAML2_ENDPOINT                      
DEV_WLS              BEASAML2_IDPPARTNER                    
DEV_WLS              BEASAML2_IDP_AUDIENCEURI               
DEV_WLS              BEASAML2_IDP_PT_EP                     
DEV_WLS              BEASAML2_IDP_REDIRECTURI               
DEV_WLS              BEASAML2_SPPARTNER                     
DEV_WLS              BEASAML2_SP_AUDIENCEURI                
DEV_WLS              BEASAML2_SP_PT_EP                      
DEV_WLS              BEASAMLAP                              
DEV_WLS              BEASAMLAP_AURI                         
DEV_WLS              BEASAMLAP_ITP                          
DEV_WLS              BEASAMLAP_RURI                         
DEV_WLS              BEASAMLRP                              
DEV_WLS              BEASAMLRP_ACP                          
DEV_WLS              BEASAMLRP_AU                           
DEV_WLS              BEAUPC                                 
DEV_WLS              BEAWCMCI                               
DEV_WLS              BEAWCRE                                
DEV_WLS_RUNTIME      ACTIVE                                 
DEV_MDS              MDS_PARTITIONS                         
DEV_MDS              MDS_PATHS                              
DEV_MDS              MDS_TRANSACTIONS                       
DEV_MDS              MDS_DEPL_LINEAGES                      
DEV_MDS              MDS_LABELS                             
DEV_MDS              MDS_TXN_LOCKS                          
DEV_MDS              MDS_STREAMED_DOCS                      
DEV_MDS              MDS_METADATA_DOCS                      
DEV_MDS              MDS_DEPENDENCIES                       
DEV_MDS              MDS_SANDBOXES                          
DEV_MDS              MDS_NAMESPACES                         
DEV_MDS              MDS_COMPONENTS                         
DEV_MDS              MDS_ATTRIBUTES                         
DEV_MDS              MDS_LARGE_ATTRIBUTES                   
DEV_OPSS             JPS_DN                                 
DEV_OPSS             JPS_ATTRS                              
DEV_OPSS             JPS_ATTRS_BINARY                       
DEV_OPSS             SEQUENCE                               
DEV_OPSS             JPS_CHANGELOG                          
DEV_OPSS             JPS_ENTITY_LOCK                        
DEV_OPSS             JPS_ENTRYID_DELETED                    
DEV_OPSS             CT_0                                   
DEV_OPSS             CT_1                                   
DEV_OPSS             CT_2                                   
DEV_OPSS             CT_3                                   
DEV_OPSS             CT_4                                   
DEV_OPSS             CT_5                                   
DEV_OPSS             CT_6                                   
DEV_OPSS             CT_6_1                                 
DEV_OPSS             CT_6_2                                 
DEV_OPSS             CT_6_3                                 
DEV_OPSS             CT_6_4                                 
DEV_OPSS             CT_7                                   
DEV_OPSS             CT_8                                   
DEV_OPSS             CT_9                                   
DEV_OPSS             CT_9_1                                 
DEV_OPSS             CT_9_2                                 
DEV_OPSS             CT_9_3                                 
DEV_OPSS             CT_10                                  
DEV_OPSS             CT_11                                  
DEV_OPSS             CT_12                                  
DEV_OPSS             CT_13                                  
DEV_OPSS             CT_14                                  
DEV_OPSS             CT_15                                  
DEV_OPSS             CT_16                                  
DEV_OPSS             CT_17                                  
DEV_OPSS             CT_18                                  
DEV_OPSS             CT_19                                  
DEV_OPSS             CT_20                                  
DEV_OPSS             CT_21                                  
DEV_OPSS             CT_22                                  
DEV_OPSS             CT_23                                  
DEV_OPSS             CT_24                                  
DEV_OPSS             CT_25                                  
DEV_OPSS             CT_26                                  
DEV_OPSS             CT_27                                  
DEV_OPSS             CT_28                                  
DEV_OPSS             CT_29                                  
DEV_OPSS             CT_30                                  
DEV_OPSS             CT_31                                  
DEV_OPSS             CT_32                                  
DEV_OPSS             CT_33                                  
DEV_OPSS             CT_34                                  
DEV_OPSS             CT_35                                  
DEV_OPSS             CT_36                                  
DEV_OPSS             CT_37                                  
DEV_OPSS             CT_38                                  
DEV_OPSS             CT_39                                  
DEV_OPSS             CT_40                                  
DEV_OPSS             CT_41                                  
DEV_OPSS             CT_42                                  
DEV_OPSS             CT_43                                  
DEV_OPSS             CT_44                                  
DEV_OPSS             CT_45                                  
DEV_OPSS             CT_46                                  
DEV_OPSS             CT_47                                  
DEV_OPSS             CT_48                                  
DEV_OPSS             CT_49                                  
DEV_OPSS             CT_50                                  
DEV_OPSS             CT_51                                  
DEV_OPSS             CT_52                                  
DEV_OPSS             CT_53                                  
DEV_OPSS             CT_54                                  
DEV_OPSS             CT_55                                  
DEV_OPSS             CT_56                                  
DEV_OPSS             CT_57                                  
DEV_OPSS             CT_58                                  
DEV_OPSS             CT_59                                  
DEV_OPSS             CT_60                                  
DEV_OPSS             CT_61                                  
DEV_OPSS             CT_62                                  
DEV_OPSS             CT_63                                  
DEV_OPSS             CT_64                                  
DEV_OPSS             CT_65                                  
DEV_OPSS             CT_66                                  
DEV_OPSS             CT_67                                  
DEV_OPSS             CT_68                                  
DEV_OPSS             CT_69                                  
DEV_OPSS             CT_70                                  
DEV_OPSS             CT_71                                  
DEV_OPSS             CT_72                                  
DEV_OPSS             CT_73                                  
DEV_OPSS             CT_74                                  
DEV_OPSS             CT_75                                  
DEV_OPSS             CT_76                                  
DEV_OPSS             CT_77                                  
DEV_OPSS             CT_78                                  
DEV_OPSS             CT_79                                  
DEV_OPSS             CT_80                                  
DEV_OPSS             CT_81                                  
DEV_OPSS             CT_82                                  
DEV_OPSS             CT_83                                  
DEV_OPSS             CT_84                                  
DEV_OPSS             CT_85                                  
DEV_OPSS             CT_86                                  
DEV_OPSS             CT_87                                  
DEV_OPSS             CT_88                                  
DEV_OPSS             CT_89                                  
DEV_OPSS             CT_90                                  
DEV_OPSS             CT_91                                  
DEV_OPSS             CT_92                                  
DEV_OPSS             CT_93                                  
DEV_OPSS             CT_94                                  
DEV_OPSS             CT_95                                  
DEV_OPSS             CT_96                                  
DEV_OPSS             CT_97                                  
DEV_OPSS             CT_98                                  
DEV_OPSS             CT_99                                  
DEV_OPSS             CT_100                                 
DEV_OPSS             CT_101                                 
DEV_OPSS             CT_102                                 
DEV_OPSS             CT_103                                 
DEV_OPSS             CT_104                                 
DEV_OPSS             CT_105                                 
DEV_OPSS             CT_106                                 
DEV_OPSS             CT_107                                 
DEV_OPSS             CT_108                                 
DEV_OPSS             CT_109                                 
DEV_OPSS             CT_110                                 
DEV_OPSS             CT_111                                 
DEV_OPSS             CT_112                                 
DEV_OPSS             CT_113                                 
DEV_OPSS             CT_114                                 
DEV_OPSS             CT_115                                 
DEV_OPSS             CT_116                                 
DEV_OPSS             CT_117                                 
DEV_OPSS             CT_118                                 
DEV_OPSS             CT_119                                 
DEV_OPSS             CT_120                                 
DEV_OPSS             CT_121                                 
DEV_OPSS             CT_122                                 
DEV_OPSS             CT_123                                 
DEV_OPSS             CT_124                                 
DEV_OPSS             CT_125                                 
DEV_OPSS             CT_126                                 
DEV_OPSS             CT_127                                 
DEV_OPSS             CT_128                                 
DEV_OPSS             CT_129                                 
DEV_OPSS             CT_130                                 
DEV_OPSS             CT_131                                 
DEV_OPSS             CT_132                                 
DEV_OPSS             CT_133                                 
DEV_OPSS             CT_134                                 
DEV_OPSS             CT_135                                 
DEV_OPSS             CT_136                                 
DEV_OPSS             CT_137                                 
DEV_OPSS             CT_138                                 
DEV_OPSS             CT_139                                 
DEV_OPSS             CT_140                                 
DEV_OPSS             CT_141                                 
DEV_OPSS             CT_142                                 
DEV_OPSS             CT_143                                 
DEV_OPSS             CT_144                                 
DEV_OPSS             CT_145                                 
DEV_OPSS             CT_146                                 
DEV_OPSS             CT_147                                 
DEV_OPSS             CT_148                                 
DEV_OPSS             CT_149                                 
DEV_OPSS             CT_150                                 
DEV_OPSS             CT_151                                 
DEV_OPSS             CT_152                                 
DEV_OPSS             CT_153                                 
DEV_OPSS             CT_154                                 
DEV_OPSS             CT_155                                 
DEV_OPSS             CT_156                                 
DEV_OPSS             CT_157                                 
DEV_OPSS             OES_SQL_STMTS                          
DEV_OPSS             OES_DIST_ID_REF                        
DEV_IAU              IAU_BASE                               
DEV_IAU              WEBCACHECOMPONENT                      
DEV_IAU              OVDCOMPONENT                           
DEV_IAU              OIDCOMPONENT                           
DEV_IAU              OWSM_PM_EJB                            
DEV_IAU              OWSM_AGENT                             
DEV_IAU              DIP                                    
DEV_IAU              OHSCOMPONENT                           
DEV_IAU              JPS                                    
DEV_IAU              ADMINSERVER                            
DEV_IAU              REPORTSSERVERCOMPONENT                 
DEV_IAU              WEBSERVICES                            
DEV_IAU              WS_POLICYATTACHMENT                    
DEV_IAU              OIF                                    
DEV_IAU              OAAM                                   
DEV_IAU              OAM                                    
DEV_IAU              STS                                    
DEV_IAU              SOA_B2B                                
DEV_IAU              SOA_HCFP                               
DEV_IAU              XMLPSERVER                             
DEV_IAU              IAU_DISP_NAMES_TL                      
DEV_IAU              IAU_LOCALE_MAP_TL                      
DEV_IAU              IAU_COMMON                             
DEV_IAU              IAU_CUSTOM                             
DEV_IAU              IAU_AUDITSERVICE                       
DEV_IAU              IAU_CUSTOM_01                          
DEV_IAU              IAU_USERSESSION                        
DEV_IAU              IAU_SCHEMA_VERSION                     
DEV_IAU              MLOG$_IAU_COMMON                       
DEV_IAU              MLOG$_IAU_CUSTOM                       
DEV_IAU              MLOG$_IAU_CUSTOM_01                    

870 Zeilen gewählt.
 I tried to get a relational database model of DEV_SOAINFRA:
Oracle SQL Developer Data Modeler 17.3.0.261.1529
Oracle SQL Developer Data Modeler Importlog
Datum und Uhrzeit: 2017-10-18 20:25:36 MESZ
Entwurfsname: Unbenannt_1
RDBMS : Oracle Database 12cR2

        Alle Anweisungen:         557
        Importierte Anweisungen:     557
        Fehlerhafte Anweisungen:         0
        Nicht erkannte Anweisungen:     0 But as you can (not) see: this model is not really helpful:

Docker-CE on Ubuntu 17.10 (Artful Aardvark)

Thu, 2017-11-16 15:07
Today docker is only added to the repositories up to ubuntu version 17.04:

If you want to run docker on 17.10 you have to perform the following steps:
After that 
# docker run hello-world
Unable to find image 'hello-world:latest' locally
latest: Pulling from library/hello-world
9a0669468bf7: Pull complete
Digest: sha256:cf2f6d004a59f7c18ec89df311cf0f6a1c714ec924eebcbfdd759a669b90e711
Status: Downloaded newer image for hello-world:latest

Hello from Docker!
This message shows that your installation appears to be working correctly.

To generate this message, Docker took the following steps:
 1. The Docker client contacted the Docker daemon.
 2. The Docker daemon pulled the "hello-world" image from the Docker Hub.
 3. The Docker daemon created a new container from that image which runs the
    executable that produces the output you are currently reading.
 4. The Docker daemon streamed that output to the Docker client, which sent it
    to your terminal.

To try something more ambitious, you can run an Ubuntu container with:
 $ docker run -it ubuntu bash

Share images, automate workflows, and more with a free Docker ID:
 https://cloud.docker.com/

For more examples and ideas, visit:
 https://docs.docker.com/engine/userguide/

Oracle SOA Suite 12c: rcu from a remote host / database configuration

Sun, 2017-11-12 15:55
First step is to configure the database on your Oracle Linux server which hosts your database:
[root@localhost admin]# firewall-cmd --permanent --zone public --add-port=1521/tcp
successThen run the rcu:
schroff@zerberus:/home/data/opt/oracle/Middleware/Oracle_Home/oracle_common/bin$ ./rcu

    RCU-Logdatei: /tmp/RCU2017-10-14_22-36_851447466/logs/rcu.logThe startup screen:
 Connect to you database:
 Connection successful:
 Certified database?!
 Choose the SOA Suite components:

 Password definition for all created schemas:
 Variables (take a look here)
 Tablespaces:
 Creation of tablespaces:

 Summary:
 Create schemas:
The end:

Microservices: Ubuntu Core: Building your own snap application

Sun, 2017-11-12 14:48
After the installation of ubuntu core and running caddy webserver from a repository  i was wondering how to build my own snap package.

The tutorial shows how to build GNU Hello into a snap packages:
and this tutorial works fine.
But this does not really help, if you have a command, which you can not build with autotools or ant or ....
A complete list can be found here.

So my plan:
  • create a bash script "myapp.sh"
  • try to build a snap, which contains this file
My first step was to create a directory "myapp" and create a "snapcraft.yaml" file:
name: myapp
version: "2.13"
summary: My first snap
description: My first snap app
confinement: strict

apps:
          myapp:
                      command: myapp.sh

parts:
          myapp:
                      plugin: nil Inside the myapp directory i created "prime/bin/myapp.sh" and "stage/myapp.sh". For both i changed the execution bits:
(With only u+x i got "-bash: ./myapp.sh: Permission denied")

chmod uga+x Then i ran
$ snapcraft
"grade" property not specified: defaulting to "stable"
Skipping pull myapp (already ran)
Skipping build myapp (already ran)
Skipping stage myapp (already ran)
Skipping prime myapp (already ran)
Snapping 'myapp' |                                                                                                                                            
Snapped myapp_2.13_amd64.snapThis file i transferred to my ubuntu core and installed it with:
$ snap install --dangerous  myapp_2.13_amd64.snap
myapp 2.13 installedAnd:
d-schroff@localhost:~$ myapp
This is myapp.

Oracle Database 12c on Oracle Linux: Firewall configuration to access Enterprise Manager on http://host:5500/em

Wed, 2017-11-08 15:23
If you have installed your database on Oracle Linux, first step is to access the enterprise manager via port 5500 (https://localhost:5500/em). If you want to access this URL from another host, you have to check and change the firewall settings:

[root@localhost system]# service firewalld status
Redirecting to /bin/systemctl status firewalld.service
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
   Active: active (running) since So 2017-10-01 18:22:30 CEST; 21h ago
     Docs: man:firewalld(1)
 Main PID: 684 (firewalld)
   CGroup: /system.slice/firewalld.service
           └─684 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid
For a quick check disabling the firewall with
service firewalld stopmight be ok, but the better way is to allow port 5500.
Therefor check the active zone and the services:

[root@localhost system]# firewall-cmd --get-active-zone
public
  interfaces: enp0s3
[root@localhost system]# firewall-cmd --zone=public --list-services
ssh dhcpv6-client With this knowlegde you can add port 5500 to your firewall:
[root@localhost system]# firewall-cmd --zone=public --add-port=5500/tcp
success
[root@localhost system]# firewall-cmd --permanent --zone=public --add-port=5500/tcp
successNow you should get the following:
[root@localhost system]# firewall-cmd --zone=public --list-ports
5500/tcpand you will get in your Browser by accessing the URL https://hostname:5500/em:
 (still Flash...)





Oracle SOA Suite 12c: rcu fails on Oracle Linux

Tue, 2017-11-07 15:39
Next step after setting up a database is running the rcu script to create the soa suite schema inside the database. But this step fails with an ugly exception:

[oracle@localhost bin]$ pwd
/mnt/Middleware/Oracle_Home/oracle_common/bin
[oracle@localhost bin]$ ./rcu

    RCU-Logdatei: /tmp/RCU2017-10-07_18-13_966788282/logs/rcu.log

Exception in thread "main" java.lang.ExceptionInInitializerError
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
    at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
    at javax.swing.UIDefaults.getUI(UIDefaults.java:769)
    at javax.swing.UIManager.getUI(UIManager.java:1016)
    at javax.swing.JComboBox.updateUI(JComboBox.java:266)
    at javax.swing.JComboBox.init(JComboBox.java:231)
    at javax.swing.JComboBox.(JComboBox.java:183)
    at oracle.help.DefaultNavigatorPanel$MinimumSizedComboBox.(DefaultNavigatorPanel.java:791)
    at oracle.help.DefaultNavigatorPanel.(DefaultNavigatorPanel.java:106)
    at oracle.help.Help._initHelpSystem(Help.java:1045)
    at oracle.help.Help.(Help.java:353)
    at oracle.help.Help.(Help.java:307)
    at oracle.help.Help.(Help.java:271)
    at oracle.help.Help.(Help.java:146)
    at oracle.sysman.assistants.rcu.ui.InteractiveRCUModel.initializeHelp(InteractiveRCUModel.java:261)
    at oracle.sysman.assistants.rcu.ui.InteractiveRCUModel.(InteractiveRCUModel.java:151)
    at oracle.sysman.assistants.rcu.Rcu.execute(Rcu.java:360)
    at oracle.sysman.assistants.rcu.Rcu.main(Rcu.java:433)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
    at sun.font.CompositeStrike.getStrikeForSlot(CompositeStrike.java:75)
    at sun.font.CompositeStrike.getFontMetrics(CompositeStrike.java:93)
    at sun.font.FontDesignMetrics.initMatrixAndMetrics(FontDesignMetrics.java:359)
    at sun.font.FontDesignMetrics.(FontDesignMetrics.java:350)
    at sun.font.FontDesignMetrics.getMetrics(FontDesignMetrics.java:302)
    at sun.swing.SwingUtilities2.getFontMetrics(SwingUtilities2.java:1113)
    at javax.swing.JComponent.getFontMetrics(JComponent.java:1626)
    at javax.swing.text.PlainView.calculateLongestLine(PlainView.java:639)
    at javax.swing.text.PlainView.updateMetrics(PlainView.java:209)
    at javax.swing.text.PlainView.updateDamage(PlainView.java:527)
    at javax.swing.text.PlainView.insertUpdate(PlainView.java:451)
    at javax.swing.text.FieldView.insertUpdate(FieldView.java:293)
    at javax.swing.plaf.basic.BasicTextUI$RootView.insertUpdate(BasicTextUI.java:1610)
    at javax.swing.plaf.basic.BasicTextUI$UpdateHandler.insertUpdate(BasicTextUI.java:1869)
    at javax.swing.text.AbstractDocument.fireInsertUpdate(AbstractDocument.java:201)
    at javax.swing.text.AbstractDocument.handleInsertString(AbstractDocument.java:748)
    at javax.swing.text.AbstractDocument.insertString(AbstractDocument.java:707)
    at javax.swing.text.PlainDocument.insertString(PlainDocument.java:130)
    at javax.swing.text.AbstractDocument.replace(AbstractDocument.java:669)
    at javax.swing.text.JTextComponent.setText(JTextComponent.java:1669)
    at javax.swing.JTextField.(JTextField.java:243)
    at javax.swing.JTextField.(JTextField.java:183)
    at com.jgoodies.looks.plastic.PlasticComboBoxUI.(PlasticComboBoxUI.java:88)
    ... 25 more
Hmmm. Not that good.
(i was running this from a shared virtual box folder.)
Next step was to install the Middleware home on my Oracle Linux. But fails too:
[oracle@localhost mnt]$ java -jar fmw_12.2.1.0.0_soa_quickstart.jar
Launcher-Logdatei ist /tmp/OraInstall2017-10-07_06-29-37PM/launcher2017-10-07_06-29-37PM.log.
Dateien werden extrahiert.......................................................
Oracle Universal Installer wird gestartet

Es wird geprüft, ob CPU-Geschwindigkeit über 300 MHz liegt   Tatsächlich 2904.000 MHz    Erfolgreich
Monitor wird geprüft: muss so konfiguriert sein, dass mindestens 256 Farben angezeigt werden   Tatsächlich 16777216    Erfolgreich
Swap-Bereich wird geprüft: muss größer sein als 512 MB   Tatsächlich 3967 MB    Erfolgreich
Es wird geprüft, ob diese Plattform eine 64-Bit-JVM erfordert   Tatsächlich 64    Erfolgreich (64-Bit nicht erforderlich)
Temporärer Speicherplatz wird geprüft: muss größer sein als 300 MB   Tatsächlich 16325 MB    Erfolgreich


Vorbereitung für das Starten von Oracle Universal Installer aus /tmp/OraInstall2017-10-07_06-29-37PM
Log: /tmp/OraInstall2017-10-07_06-29-37PM/install2017-10-07_06-29-37PM.log
java.lang.ArrayIndexOutOfBoundsException: 0
    at sun.font.CompositeStrike.getStrikeForSlot(CompositeStrike.java:75)
    at sun.font.CompositeStrike.getFontMetrics(CompositeStrike.java:93)
    at sun.font.FontDesignMetrics.initMatrixAndMetrics(FontDesignMetrics.java:359)
    at sun.font.FontDesignMetrics.(FontDesignMetrics.java:350)
    at sun.font.FontDesignMetrics.getMetrics(FontDesignMetrics.java:302)
    at sun.swing.SwingUtilities2.getFontMetrics(SwingUtilities2.java:1113)
    at javax.swing.JComponent.getFontMetrics(JComponent.java:1626)
    at javax.swing.text.GlyphPainter1.sync(GlyphPainter1.java:226)
    at javax.swing.text.GlyphPainter1.getSpan(GlyphPainter1.java:59)
    at javax.swing.text.GlyphView.getPreferredSpan(GlyphView.java:592)
    at javax.swing.text.FlowView$LogicalView.getPreferredSpan(FlowView.java:732)
    at javax.swing.text.FlowView.calculateMinorAxisRequirements(FlowView.java:233)
    at javax.swing.text.ParagraphView.calculateMinorAxisRequirements(ParagraphView.java:717)
    at javax.swing.text.html.ParagraphView.calculateMinorAxisRequirements(ParagraphView.java:157)
    at javax.swing.text.BoxView.checkRequests(BoxView.java:935)
    at javax.swing.text.BoxView.getMinimumSpan(BoxView.java:568)
    at javax.swing.text.html.ParagraphView.getMinimumSpan(ParagraphView.java:270)
    at javax.swing.text.BoxView.calculateMinorAxisRequirements(BoxView.java:903)
    at javax.swing.text.html.BlockView.calculateMinorAxisRequirements(BlockView.java:146)
    at javax.swing.text.BoxView.checkRequests(BoxView.java:935)
    at javax.swing.text.BoxView.getMinimumSpan(BoxView.java:568)
    at javax.swing.text.html.BlockView.getMinimumSpan(BlockView.java:378)
    at javax.swing.text.BoxView.calculateMinorAxisRequirements(BoxView.java:903)
    at javax.swing.text.html.BlockView.calculateMinorAxisRequirements(BlockView.java:146)
    at javax.swing.text.BoxView.checkRequests(BoxView.java:935)
    at javax.swing.text.BoxView.getPreferredSpan(BoxView.java:545)
    at javax.swing.text.html.BlockView.getPreferredSpan(BlockView.java:362)
    at javax.swing.plaf.basic.BasicHTML$Renderer.(BasicHTML.java:383)
    at javax.swing.plaf.basic.BasicHTML.createHTMLView(BasicHTML.java:67)
    at javax.swing.plaf.basic.BasicHTML.updateRenderer(BasicHTML.java:207)
    at javax.swing.plaf.basic.BasicLabelUI.propertyChange(BasicLabelUI.java:417)
    at oracle.bali.ewt.olaf2.OracleLabelUI.propertyChange(OracleLabelUI.java:53)
    at java.beans.PropertyChangeSupport.fire(PropertyChangeSupport.java:335)
    at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:327)
    at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:263)
    at java.awt.Component.firePropertyChange(Component.java:8428)
    at javax.swing.JLabel.setText(JLabel.java:330)
    at oracle.as.install.engine.modules.presentation.ui.common.label.ModifiedJLabel.setText(ModifiedJLabel.java:183)
    at oracle.as.install.engine.modules.presentation.ui.screens.WelcomeWindow.jbInit(WelcomeWindow.java:303)
    at oracle.as.install.engine.modules.presentation.ui.screens.WelcomeWindow.(WelcomeWindow.java:112)
    at oracle.as.install.engine.modules.presentation.action.LaunchWelcomeWindowAction.execute(LaunchWelcomeWindowAction.java:86)
    at oracle.as.install.engine.modules.presentation.util.ActionQueue.run(ActionQueue.java:70)
    at oracle.as.install.engine.modules.presentation.PresentationModule.prepareAndRunActions(PresentationModule.java:281)
    at oracle.as.install.engine.modules.presentation.PresentationModule.launchModule(PresentationModule.java:235)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at oracle.as.install.engine.InstallEngine.launchModule(InstallEngine.java:580)
    at oracle.as.install.engine.InstallEngine.processAndLaunchModules(InstallEngine.java:522)
    at oracle.as.install.engine.InstallEngine.startOperation(InstallEngine.java:471)
    at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:717)
java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at oracle.as.install.engine.InstallEngine.launchModule(InstallEngine.java:580)
    at oracle.as.install.engine.InstallEngine.processAndLaunchModules(InstallEngine.java:522)
    at oracle.as.install.engine.InstallEngine.startOperation(InstallEngine.java:471)
    at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:717)
Caused by: java.lang.ExceptionInInitializerError
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
    at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
    at javax.swing.UIDefaults.getUI(UIDefaults.java:769)
    at javax.swing.UIManager.getUI(UIManager.java:1016)
    at javax.swing.JComboBox.updateUI(JComboBox.java:266)
    at javax.swing.JComboBox.init(JComboBox.java:231)
    at javax.swing.JComboBox.(JComboBox.java:183)
    at oracle.help.DefaultNavigatorPanel$MinimumSizedComboBox.(DefaultNavigatorPanel.java:791)
    at oracle.help.DefaultNavigatorPanel.(DefaultNavigatorPanel.java:106)
    at oracle.help.Help._initHelpSystem(Help.java:1045)
    at oracle.help.Help.(Help.java:243)
    at oracle.help.Help.(Help.java:200)
    at oracle.help.Help.(Help.java:125)
    at oracle.as.install.engine.modules.presentation.ui.common.help.WizardHelpManager.configure(WizardHelpManager.java:76)
    at oracle.as.install.engine.modules.presentation.action.WizardHelpConfigAction.execute(WizardHelpConfigAction.java:228)
    at oracle.as.install.engine.modules.presentation.util.ActionQueue.run(ActionQueue.java:70)
    at oracle.as.install.engine.modules.presentation.PresentationModule.prepareAndRunActions(PresentationModule.java:281)
    at oracle.as.install.engine.modules.presentation.PresentationModule.launchModule(PresentationModule.java:235)
    ... 8 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
    at sun.font.CompositeStrike.getStrikeForSlot(CompositeStrike.java:75)
    at sun.font.CompositeStrike.getFontMetrics(CompositeStrike.java:93)
    at sun.font.FontDesignMetrics.initMatrixAndMetrics(FontDesignMetrics.java:359)
    at sun.font.FontDesignMetrics.(FontDesignMetrics.java:350)
    at sun.font.FontDesignMetrics.getMetrics(FontDesignMetrics.java:302)
    at sun.swing.SwingUtilities2.getFontMetrics(SwingUtilities2.java:1113)
    at javax.swing.JComponent.getFontMetrics(JComponent.java:1626)
    at javax.swing.text.PlainView.calculateLongestLine(PlainView.java:639)
    at javax.swing.text.PlainView.updateMetrics(PlainView.java:209)
    at javax.swing.text.PlainView.updateDamage(PlainView.java:527)
    at javax.swing.text.PlainView.insertUpdate(PlainView.java:451)
    at javax.swing.text.FieldView.insertUpdate(FieldView.java:293)
    at javax.swing.plaf.basic.BasicTextUI$RootView.insertUpdate(BasicTextUI.java:1610)
    at javax.swing.plaf.basic.BasicTextUI$UpdateHandler.insertUpdate(BasicTextUI.java:1869)
    at javax.swing.text.AbstractDocument.fireInsertUpdate(AbstractDocument.java:201)
    at javax.swing.text.AbstractDocument.handleInsertString(AbstractDocument.java:748)
    at javax.swing.text.AbstractDocument.insertString(AbstractDocument.java:707)
    at javax.swing.text.PlainDocument.insertString(PlainDocument.java:130)
    at javax.swing.text.AbstractDocument.replace(AbstractDocument.java:669)
    at javax.swing.text.JTextComponent.setText(JTextComponent.java:1669)
    at javax.swing.JTextField.(JTextField.java:243)
    at javax.swing.JTextField.(JTextField.java:183)
    at com.jgoodies.looks.plastic.PlasticComboBoxUI.(PlasticComboBoxUI.java:88)
    ... 33 more
[ERROR]: Installer has encountered an internal Error. Contact Oracle support with details
[EXCEPTION]:java.lang.reflect.InvocationTargetException
So there is a problem with running the SOA Suite installer on Oracle Linux...
The installation worked fine on my ubuntu (see here) and the rcu starts without any problem an my ubuntu:
schroff@zerberus:/home/data/opt/oracle/Middleware/Oracle_Home/oracle_common/bin$ ./rcu

    RCU-Logdatei: /tmp/RCU2017-10-14_22-36_851447466/logs/rcu.log


Microservices: Running a webserver (caddy) on Ubuntu Core with snap

Sun, 2017-11-05 14:00
After the installation of a ubuntu core system inside virutalbox i was keen how to put a microservice via snap package onto the server.

First a listing of the installed snap packages:
~$ snap list
Name          Version     Rev  Developer  Notes
core          16.04.1     394  canonical  -
pc            16.04-0.8   9    canonical  -
pc-kernel     4.4.0-45-4  37   canonical  -
To get a list of available packages you can use "snap find" + a search value:
$ snap find http
Name                          Version            Developer       Notes  Summary
http                          0.9.9-1            chipaca         -      HTTPie in a snap
httpstat                      1.1.3              simosx          -      Curl statistics made simple
gost                          2.4                ginuerzh        -      GO Simple Tunnel
spreed-webrtc-snap            0.24.11-4          garywzl77       -      WebRTC audio/video calls and conferences
squid-gary                    0.3                garywzl77       -      Squid is a caching proxy for the Web supporting HTTP, HTTPS, FTP, and more.
littlewatcher                 0.9.9              littlewatcher   -      Client for a distributed monitoring network
tinyproxy-snap                0.2                garywzl77       -      a light-weight HTTP(S) proxy daemon for POSIX operating systems.
caddy-hduran                  0.9.3              hduran          -      The HTTP/2 web server with automatic HTTPS
demo-curl                     7.47.0-1ubuntu2.1  woodrow         -      command line tool for transferring data with URL syntax
conn-check                    1.3.2-2            1stvamp         -      Utility for verifying connectivity between services
reqcounter                    0.1                meehow          -      HTTP requests counter
bhttp                         0                  rog             -      Macaroon-aware HTTP command line client
unixhttp                      1                  teknoraver      -      HTTP over Unix
wuzz                          dd696dc-1          nhandler        -      interactive cli tool for HTTP inspection
prometheus-blackbox-exporter  0.5.0              jacek           -      The Prometheus Blackbox Exporter
gnocchi                       4.0.3              james-page      -      Time Series Database as a Service
kurly                         master             carla-sella     -      kurly is an alternative to the widely popular curl program.
inadyn                        0.1                snapcrafters    -      Internet Automated Dynamic DNS Client
ipfs                          v0.4.11            elopio          -      global, versioned, peer-to-peer filesystem
tinyproxy-ogra                1.8.3              ogra            -      very tiny proxy server
demo-wget                     1.17.1-2           woodrow         -      retrieves files from the web
links                         2.12-1             zygoon          -      Web browser running in text mode
couchdb                       2.0                apache-couchdb  -      RESTful document oriented database
attfeeder                     0.0.1              sphengineering  -      Attitude angles feeder
I chose caddy-hduran:
snap install caddy-hduran  and some seconds later the installation was finished.

The deployment structure can be found with this command:
~$ mount | grep caddy
/var/lib/snapd/snaps/caddy-hduran_12.snap on /snap/caddy-hduran/12 type squashfs (ro,relatime)
/var/lib/snapd/snaps/caddy-hduran_12.snap on /writable/system-data/snap/caddy-hduran/12 type squashfs (ro,relatime)
nsfs on /run/snapd/ns/caddy-hduran.mnt type nsfs (rw)
Twice a readonly filesystem. So where to put the configuration file?

I found
/writable/system-data/var/snap/caddy-hduran/12/and put there a Caddyfile with this content:
192.168.178.31:8080
tls off and a simple index.html. This only works with sudo.
Then i started the caddy server
/var/snap/caddy-hduran/12# caddy-hduran.caddy
Activating privacy features... done.
http://192.168.178.31:8080
WARNING: File descriptor limit 1024 is too low for production servers. At least 8192 is recommended. Fix with "ulimit -n 8192".A strange behaviour is that it will not run if you stay in
/writable/system-data/var/snap/caddy-hduran/12/but in
 /var/snap/caddy-hduran/12it starts...



If you want more information about how to configure caddy, take a look at this blog: https://www.booleanworld.com/host-website-caddy-web-server-linux/

Microservices: Ubuntu Core and snap - a minimal linux

Sat, 2017-11-04 15:54
After some first steps with coreOS
i read about Ubuntu Core, which targets also on a minimal linux. Here an architecture overview from ubuntu:
Ubuntu provides an image for KVM (the link points to an installation howto), but i want to stay with Virtualbox. I followed this tutorial:
wget http://releases.ubuntu.com/ubuntu-core/16/ubuntu-core-16-amd64.img.xz
unxz ubuntu-core-16-amd64.img.xz
VBoxManage convertdd ubuntu-core-16-amd64.img ubuntu-core-16-amd64.vdi --format VDI

VBoxManage modifyhd ubuntu-core-16-amd64.vdi --resize 20480And then configure the virtualbox vm:




And Go!




To pass this step you have to create an account at https://login.ubuntu.com
 
 At login.ubuntu.com you have to provide your public ssh keyfile:

and then a login which does not work:


and the login via ssh:

schroff@zerberus:~$ ssh d-schroff@192.168.178.31
The authenticity of host '192.168.178.31 (192.168.178.31)' can't be established.
ECDSA key fingerprint is SHA256:yKE/g7JYnlED6jOF/8gsUeVrdkuEU/zytFdlCcVzNEs.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.178.31' (ECDSA) to the list of known hosts.
Welcome to Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-45-generic x86_64)

 * Documentation:  https://help.ubuntu.com
 * Management:     https://landscape.canonical.com
 * Support:        https://ubuntu.com/advantage

The programs included with the Ubuntu system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by
applicable law.

Welcome to Snappy Ubuntu Core, a transactionally updated Ubuntu.

 * See https://ubuntu.com/snappy

It's a brave new world here in Snappy Ubuntu Core! This machine
does not use apt-get or deb packages. Please see 'snap --help'
for app installation and transactional updates.

d-schroff@localhost:~$
First impression: Getting a ssh login is much easier than configuring ssh with ignition at coreOS.

Oracle SOA Suite 12c: Installation - Preparing the database

Fri, 2017-11-03 15:24
After a successful installation of Oracle 12c database the next step is to create a plugable databse (PDB).
Therefor you have to run the dbca (database creation assistant):
~/app/oracle/product/12.2.0/dbhome_1/bin/dbca









 The first check fails with:
[oracle@localhost ~]$ export ORACLE_SID=soasuite12c
[oracle@localhost ~]$ sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on Sat Oct 7 17:00:21 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter user-name: bpeladmin
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3701
Additional information: -1824536353
Process ID: 0
Session ID: 0 Serial number: 0This is, because the tnsnames.ora is not correct:
[oracle@localhost admin]$ cat /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
You have to add this entry:
SOASUITE12C =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = soasuite12c)
    )
  )
And here we go:
[oracle@localhost admin]$ sqlplus bpeladmin@soasuite12c

SQL*Plus: Release 12.2.0.1.0 Production on Sat Oct 7 17:22:14 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter password:

Verbunden mit:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show con_name;

CON_NAME
------------------------------
SOASUITE12C






AVM Fritz: WLAN Mesh with Powerline Repeater does not work - Part 2

Wed, 2017-11-01 10:55
A month ago i tried to get the new WLAN mesh running with my Fritz!Box 7490 and Fritz!Powerline 546E.

Some days ago AVM release a new firmware for the 546E:

But even with the new firmware the powerline adapter does show up with the "mesh symbol" inside the home network overview:


I am wondering, if the WLAN mesh only works by using the powerline connectivity. AVM support pages show up the following advisory:
As you can see: Only the secondary powerline adapter shows the "mesh symbol".

Inside the networking overview my 546E is registered in this way:
Which is definitly wrong, because it is connected as WLAN bridge to the Fritz!Box without any powerline technololgy...

Hopefully the next update may fix this.

Contao: How to create a virtual system from your live website

Wed, 2017-11-01 09:07
Since a couple of year my sport club runs its website with contao.
Because our webhoster changed the support for php, i have to find a way to do an upgrade without damaging the running website.

The plan:
  1. create a linux host as a vm
  2. install mysql, apache2, php
  3. import the backups
The first step was easy. Inside virtualbox i created an ubuntu 17.10 system.
The second step was not that simple:
add-apt-repository ppa:ondrej/php
apt install mysql-server apache2 php5.6 php5.6-mysqlImporting the data into the database was easy (Before i did a backup via the contao frontend: system -> backup database).
mysql -u root -pYOURPASS -e "create database mydb"
mysql -u root -pYOURPASS mydb < database.backup.sqlFrom the live system i copied everything into /var/www/html and changed the user to www-data:
cd /var/www/html
chown -R www-data *Last step is the customizing of /var/www/html/system/config/localconfig.php
$GLOBALS['TL_CONFIG']['dbHost'] = 'localhost';
$GLOBALS['TL_CONFIG']['dbUser'] = 'root';
$GLOBALS['TL_CONFIG']['dbPass'] = 'YOURPASS';
$GLOBALS['TL_CONFIG']['dbDatabase'] = 'mydb';And after a last command
systemctl restart apache2i was able to open the website via a local firefox with http://localhost/index.php.
Now a snapshot a damaged installation after an upgrade can be rolled back without any problem ;-)

Ubuntu 17.10: problems with gnome extensions

Sun, 2017-10-29 06:16
After migrating to ubuntu 17.10 the unity desktop is gone and the system starts up with gnome 3.
As i wrote here, there are some problems with window decorations which can be fixed by (re-)moving some directories.

But i still had some problems with gnome extension:
The installation process via the webpage gnome extensions worked fine, but e.g. the system monitor did not show up...
https://extensions.gnome.org/

The solution was easy:
apt install vanilla-gnome-desktopAnd after this fix the system monitor is there:

Myths about Wayland (display server protocol)

Tue, 2017-10-24 13:53

If you ask Google abount wayland (which is shipped with ubuntu 17.10 or fedora 26) there are some articles, which are not or no more accurate:



"You can not export any X11 application to a linux host which runs wayland"Wrong... Just login to other linux machines via "ssh -X"  and run xclock or whatever. It works...


"Screenshots will not work anymore"Hmmm. Ok. X11 screenshot applications will not work anymore - but you can do screenshots with "print" (complete desktop), "alt-print" (current window) and "shift-print" (select area).



"There is no log file or other debugging information"Ok - /var/log/Xorg.0.log is not used anymore and there is no other log file. Here you can find some commands to get error/debug messages.


If you want to get more information about wayland: https://wayland.freedesktop.org/

Pages