I already wrote about Docker and OBIEE in Docker in relation to my OBIEE Docker image I published on GitHub.
As it isn’t always obvious to get started with it, mainly if aren’t familiar with Docker, I decided to write this post which will cover from A to Z how you can get OBIEE running Docker covering: building the images, running the DB, start / stop OBIEE.
All you will need for it is a host (a PC running linux, a server, a VM) with Docker installed.
The process is covered with screenshots for each step and has been based on Oracle Database 12c R1 Docker container using the image provided on https://github.com/oracle/docker-images/tree/master/OracleDatabase and OBIEE 12.2.1.2 using the image provided on https://github.com/gianniceresa/docker-images/tree/master/OracleBIEE.
You can freely use another version of OBIEE (12.2.1.0.0, 12.2.1.1.0 or 12.2.1.3.0) or database (make sure it’s supported by the selected OBIEE version looking at the relative certification matrix.
You can also use a different version of Java if wanted (again check the certification matrix). If you decide to use a different Java make sure you update the Checksum.md5 file with the new name and checksum and the filename inside the Dockerfile (“INSTALL_FILE_JDK” variable).
The Oracle Database Docker image hosted on GitHub can change at any time, so the parameters required by the container can be different than the ones used here. Have a look at the GitHub page to read through the various parameters.
More options available
There are various parameters accepted by both the OBIEE and database Docker images, you find examples and list of variables on GitHub.
Getting the binaries
Before to start I just created few empty folders to keep things “clean” (and easy to delete once done).
Download the Oracle Database binaries. Version 12.1.0.2.0 will be good, binaries for Linux x86-64.
Download the OBIEE binaries for the installation. Weblogic and OBIEE for Linux x86-64-bit.
Download Oracle JDK 8. Version 8u101, RPM installer for Linux x64.
Wait for all the binaries to be downloaded, it’s few Gb of download, will take some time.
Building the Docker images for Oracle Database 12c R1 and OBIEE
Clone the GitHub Oracle repository containing Docker images build files. A “docker-images” folder is created.
Copy the binaires for the database in the 12.1.0.2 folder, this is the final content of the folder before to build the image.
To build the database image a script is provided. By calling “buildDockerImage.sh” you first see the parameters available.
The Oracle database 12.1.0.2 image is successfully built.
Clone my GitHub repository containing Docker images build files for OBIEE. A “docker-images” folder is created.
Copy the binaires for OBIEE (including the JDK) in the 12.2.1.2.0 folder, this is the final content of the folder before to build the image.
To build the OBIEE image a script is provided. By calling “buildDockerImage.sh” you first see the parameters available.
The Oracle OBIEE 12.2.1.2.0 image is successfully built.
Run a database container and an OBIEE container
Check the available Docker images on your host: the freshly built database and OBIEE are there as well as oraclelinux:7-slim, which is the base image used by both the database and OBIEE.
Create and run the Oracle database Docker container for the first time. Few parameters are required. Check the logs of the container to see what happen inside.
Once the message “DATABASE IS READY TO USE!” is visible it means your database is ready. It’s time to set a new password replacing the random one generated. (Ctrl+C to exit the log command)
Create and run the OBIEE Docker container for the first time. Few parameters are required. Check the logs of the container to see what happen inside. Remember to replace “192.168.120.81” the IP address of the host where Docker is running (but not 127.0.0.1 as this means the Docker container itself).
Once you see the status of components as “RUNNING” it means OBIEE is ready. (Exit the log command by pressing Ctrl+C)
Get the ports Docker mapped for the OBIEE container (dynamic mapping). 9502 is the OBIEE front-end.
Open the address (ip + port) in your browser and test if OBIEE works. By default the login is “weblogic” and the password “Admin123”.
Stop the OBIEE container and the database container
Check the status of the Docker containers, both OBIEE and the database must be up. Stop the containers in the right order: OBIEE first, database after.
Checking the new status of the Docker containers show both are “exited”.
Restart the containers: content is persisted, nothing is lost
Restart the containers in the right order: database first and OBIEE after. OBIEE must be started only when the database is ready.
The database is ready again so it’s now possible to start OBIEE.
Start the OBIEE container and check the logs.
The OBIEE Docker container is up again, find the new mapped port. Every time you restart the container the OBIEE ports can be mapping to different port numbers.
The status shows both containers up again.
That’s it, you now have a Docker based OBIEE environment. You can run multiple containers in parallel, run multiple versions. Once you are done or you destroyed an environment while trying things just remove the container (“docker rm”) and start a new one.
tl;dr
If you just need the piece of code :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
# - Build database image cd ~ mkdir db cd db git clone https://github.com/oracle/docker-images.git cd docker-images/OracleDatabase/dockerfiles # ToDo: copy binaries into ./12.1.0.2 ./buildDockerImage.sh -v 12.1.0.2 -e # - Build OBIEE image cd ~ mkdir bi cd bi git clone https://github.com/gianniceresa/docker-images.git cd docker-images/OracleBIEE # ToDo: copy binaries into ./12.2.1.2.0 ./buildDockerImage.sh -v 12.2.1.2.0 cd ~ # ToDo: delete ./db and ./bi and all their content (not needed anymore) # - Run containers docker run -d -p 1521:1521 --stop-timeout 600 --name database oracle/database:12.1.0.2-ee docker logs -f database # Ctrl+C when the message "DATABASE IS READY TO USE!" is visible docker exec database ./setPassword.sh Admin123 # replace 192.168.120.81 by your docker host address docker run -d -P \ --name obiee_12.2.1.2.0 \ --stop-timeout 600 \ -e "BI_CONFIG_RCU_DBSTRING=192.168.120.81:1521:orclpdb1" \ -e "BI_CONFIG_RCU_PWD=Admin123" \ oracle/obiee:12.2.1.2.0 docker logs -f obiee_12.2.1.2.0 # Ctrl+C when the components status "RUNNING" is visible docker port obiee_12.2.1.2.0 |
I’m looking for OBIEE12c Scaled-out environment as a Docker? is it possible?
Possible it is possible as you can have an OBIEE cluster (check the doc on how to make it). This image isn’t ready for that, by that I mean it is a proper single host OBIEE image. For a cluster you will need to move the Singleton Data Directory to a shared volume and then modify the runOBIEE.sh to do things differently. Docker is just like VMs: you can do what you want, but this one isn’t already setup for scaling the environment, it is up to you to adapt it for this needs.
Hi Gianni Ceresa,
I got an error while creating Docker_iamge for DataBase 122010 .
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
checkSpace.sh: ERROR – There is not enough space available in the docker container.
checkSpace.sh: The container needs at least 15 GB, but only 6 GB are available.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Can you help me this error ?????
Hi,
Looks like your default docker container size is too small for OBIEE (must be 10Gb as the install needs about 4Gb, so the 6Gb left would point to a default size of 10Gb). Check that in your docker config and increase it if needed to at least 20 (so 20 – 4 = 16 which with some luck will be enough for the check).
Where can i increase the GB size???? can u help me on this issue.
As I said it’s a Docker config. So first you have to check what your Docker config says. There are various storage drivers, so start by looking which one you use and what’s the config. “docker info” is a good place where to start, look for storage driver and base device size if you have them.
Containers: 0
Images: 5
Storage Driver: devicemapper
Pool Name: docker-253:0-134221363-pool
Pool Blocksize: 65.54 kB
Backing Filesystem: xfs
Data file: /dev/loop0
Metadata file: /dev/loop1
Data Space Used: 717 MB
Data Space Total: 107.4 GB
Data Space Available: 46.03 GB
Metadata Space Used: 1.04 MB
Metadata Space Total: 2.147 GB
Metadata Space Available: 2.146 GB
Udev Sync Supported: true
Data loop file: /var/lib/docker/devicemapper/devicemapper/data
Metadata loop file: /var/lib/docker/devicemapper/devicemapper/metadata
Library Version: 1.02.146-RHEL7 (2018-01-22)
Execution Driver: native-0.2
Kernel Version: 3.10.0-862.el7.x86_64
Operating System: Oracle Linux Server 7.5
CPUs: 2
Total Memory: 9.052 GiB
Name: obiee.docker.com
ID: 3IOA:5ZF4:KF4Q:CQCU:P2MU:7SLW:4UMG:54UY:BGOH:QDNU:YK3B:WSYM
this is my docker info
where can i start ?
iam new to this technology can u help me.
where we start and give any steps to solve this issues.
As expected, your storage driver is “devicemapper” and the default base device size is 10Gb. Look at https://docs.docker.com/engine/reference/commandline/dockerd/#options-per-storage-driver and specifically for the “dm.basesize” option, pass that as 20 (or ideally 25-30 to avoid any issue) to your docker daemon and done. How to configure your docker with that parameter depends on how it is installed etc. All is covered in the Docker documentation.
Hi,
Am installing obiee and database with respective versions 12.2.1.2.0,12.1.0.2 and how can i bind the local IPAddress.
while am running the docker port obiee_12.2.1.2.0 command it will showing 0.0.0.0 ip adresss, how can i change ip adress .
1.How can i get into running docker containers???
Hi, not sure to exactly get your question… By default containers are on a bridged network, so they are already exposed on your host IP address.
https://docs.docker.com/network/#scope-of-this-topic
How you can get into running Docker containers? Start by reading the Docker documentation, it’s the best place where to start.
Hi,
While running the docker port obiee_12.2.1.2.0
it will showing 0.0.0.0 ip address and my local ip adress is 192.168.1.188 how can i change ip adress???
9502/tcp -> 0.0.0.0:32781
9507/tcp -> 0.0.0.0:32776
9509/tcp -> 0.0.0.0:32774
9510/tcp -> 0.0.0.0:32773
9500/tcp -> 0.0.0.0:32783
9503/tcp -> 0.0.0.0:32780
9504/tcp -> 0.0.0.0:32779
9508/tcp -> 0.0.0.0:32775
9511/tcp -> 0.0.0.0:32772
9514/tcp -> 0.0.0.0:32769
9501/tcp -> 0.0.0.0:32782
9506/tcp -> 0.0.0.0:32777
9512/tcp -> 0.0.0.0:32771
9799/tcp -> 0.0.0.0:32768
9505/tcp -> 0.0.0.0:32778
9513/tcp -> 0.0.0.0:32770
As I said: the 0.0.0.0 doesn’t mean it isn’t working, it’s just because you didn’t pass the IP to Docker as option and so it display 0.0.0.0. But by default containers are using the bridge network, which means that 0.0.0.0:32781 is just:32781.
You maybe want to read the getting started documentation of Docker to understand how it works.
Hi Gianni Ceresa,
“RCU exiting with status 100
ERROR validating RCU command and settings, can’t validate RCU schemas creation
command: /opt/oracle/product/12.2.1.2.0/oracle_common/bin/rcu -createRepository -silent -schemaPrefix hdcfaffa9d97 -useSamePasswordForAllSchemaUsers true -connectString 192.168.203.192:1521:orclpdb1 -dbUser sys -databaseType ORACLE -dbRole SYSDBA -component STB -component MDS -component WLS -component OPSS -component BIPLATFORM -component IAU -component IAU_APPEND -component IAU_VIEWER -validate -f < /opt/oracle/product/12.2.1.2.0/_tmp_rcu.dat
Abort OBIEE configuration…"
I got this error while running obiee_12.2.1.2.0 container
command :docker start obiee_12.2.1.2.0; docker logs -f obiee_12.2.1.2.0 while running this command got the above error .
Can you help me on this error
“Database connection failed: 100”
Seems like you provided wrong DB connection settings to the docker container.
You can find error messages for the RCU validation at https://docs.oracle.com/middleware/12211/lcm/RCUUG/GUID-0D3A2959-7CC8-4001-997E-718ADF04C5F2.htm#RCUUG-GUID-6BD3F73E-BD15-44CF-A6E6-AE8BD821E4BD
Hi ,
I don’t want any changes for DB Connection setting and just run this below command and following your document.
command is :”docker run -d -p 1521:1521 –stop-timeout 600 –name database oracle/database:12.1.0.2-ee”
Fine, but is your DB working? Is the connection string you used to start the OBIEE container right?
Hi,
My DB is working fine.
Running Obiee container using below command
docker run -d -P
–name obiee_12.2.1.2.0
–stop-timeout 600
-e “BI_CONFIG_RCU_DBSTRING=192.168.4.9:1521:orclpdb1”
-e “BI_CONFIG_RCU_PWD=Admin123”
oracle/obiee:12.2.1.2.0
Did you check if from the OBIEE container you can actually connect to the DB for real?
Hi Gianni,
How to setup obiee_cicd process using gitlab and can you share me any document for cicd process.
Have a look at the slides of my presentation of few years ago: https://speakerdeck.com/gianniceresa/pimp-your-devops-with-docker-an-oracle-ba-example
Hi Gianni Ceresa,
Thanks for giving reply.
Currently working on gitlab-runner facing an issue
“ERROR: Registering runner… forbidden (check registration token) runner=UHUZ4jsy
PANIC: Failed to register this runner. Perhaps you are having network problems”
1.Installed the docker conatiners ,gitlab server and gitlab-runner on same machine , but while running gitlab-runner register command facing an issue ????
Did you follow the GitLab doc on how to register the runner? Did you setup your docker network correctly? Do not forget Docker containers networking is a real thing: containers by default are connected to the same network but doesn’t know each others, ports need to be exposed etc. I have a host on which I run GitLab inside a docker container and the gitlab-runner on the host itself and didn’t have any issue.
HI ,
I am following the gitlab document , my network is correcttly setup but still facing the issue.
NETWORK ID NAME DRIVER SCOPE
0b95709e06ab bridge bridge local
28c580211344 compose-obiee-db_default bridge local
02ffaf1c9335 host host local
a121cd0d0584 my_network bridge local
9ee545463417 none null local
docker@cicd:~$ docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
obiee 12.2.1.2.0 02af91b10c5b 26 hours ago 18.6GB
database 12.1.0.2 8d1d6ea833aa 27 hours ago 11.3GB
oraclelinux latest bd622f029d9d 4 weeks ago 234MB
What network are your containers connected, can you ping the GitLab address/hostname from where the runner is executed? You installed GitLab on the host directly and not using their Docker image?
Hi ,
My gitlab Url:http://192.168.203.187/ci and my docker images are using
docker@cicd:/$ docker network inspect compose-obiee-db_default
[
{
“Name”: “compose-obiee-db_default”,
“Id”: “28c5802113448f00a45a3aa5d8b7f9f6397537ab760baa909697ef678a16bd56”,
“Created”: “2018-06-26T12:41:41.486609682+05:30”,
“Scope”: “local”,
“Driver”: “bridge”,
“EnableIPv6”: false,
“IPAM”: {
“Driver”: “default”,
“Options”: null,
“Config”: [
{
“Subnet”: “172.18.0.0/16”,
“Gateway”: “172.18.0.1”
}
]
},
“Internal”: false,
“Attachable”: false,
“Ingress”: false,
“ConfigFrom”: {
“Network”: “”
},
“ConfigOnly”: false,
“Containers”: {
“8bf19c9dd6d9ce15e85b7472d3cc44e59228e7feafb769bb203a3f1b73a9be3c”: {
“Name”: “compose-obiee-db_oracledb_1”,
“EndpointID”: “60666d816a5f28ca1dff91d54bdeb1773b4235312eb3100569016c9722fbcad9”,
“MacAddress”: “02:42:ac:12:00:02”,
“IPv4Address”: “172.18.0.2/16”,
“IPv6Address”: “”
},
“b66cd536cbc2714175486b53495b4b8a523889310ea635f3ee519bd15da7416e”: {
“Name”: “compose-obiee-db_obiee_12.2.1.2.0_1”,
“EndpointID”: “21f462a28beb2801f7d5ffb1cb9137039becc369dd5d88f8a6880b6cf514e578”,
“MacAddress”: “02:42:ac:12:00:03”,
“IPv4Address”: “172.18.0.3/16”,
“IPv6Address”: “”
}
},
“Options”: {},
“Labels”: {}
}
]
Well … still doesn’t say if you can connect to GitLab from the place where Gitlab-runner is. OBIEE/DB doesn’t matter here: you first need to get your gitlab up and running and the runner is part of it. You maybe want to consider posting on the GitLab forum with all the details. It’s the best place where to get support in getting GitLab up and running fine.
Hi
I have obiee image working fine but every time I start up the docker image it’s creating a new RCU schema. Is there a way to skip that?
Hi, where did you take your image from? Where does the code come from?
I built taking your post as an example (12.2.1.2).
Have a look at the code of https://github.com/gianniceresa/docker-images/blob/master/OracleBIEE/12.2.1.2.0/runOBIEE.sh , the function ‘checkOBIEEConfigured’ has the role of defining if the container has already been configured and therefor OBIEE just needs to be started or it isn’t configured and first it requires the configuration. Do you have that in your image? Did you manage that case? Because the linked image on GitHub works fine: it can be stopped and started as much as you want and the config only run once the first time.
The idea is I can use this for local development so I probably need to start the docker container every day.
right as long as I have the same container that works but I have this docker image in a virtualbox. I see the same problem with rpd and catalog too, whenever I reboot it starts it fresh (removes rpd,catalog and tries to recreate rcu) unless I am missing some step.
What do you mean by “as long as I have the same container”? If you expect different containers to not require that step you maybe want to review the difference between image and container.
Hi,
When I create OBIEE image, a have an error:
Step 7/14 : RUN cd $INSTALL_DIR && chmod ug+x $CHKSUM_TEST && ./$CHKSUM_TEST
—> Running in 138082df6062
/bin/sh: ./checksumPackages.sh: /bin/bash: bad interpreter: Text file busy
Removing intermediate container 138082df6062
The command ‘/bin/sh -c cd $INSTALL_DIR && chmod ug+x $CHKSUM_TEST && ./$CHKSUM_TEST’ returned a non-zero code: 126
There was an error building the image.
What is wrong?
Hi,
What exact image are you trying to build? I don’t remember having that kind of code into the OBIEE images (any of the 5 12c versions on GitHub).
Hi, I’m trying to build OBIEE 12.2.1.0.0.
I’ve commented
#RUN cd $INSTALL_DIR && \
# chmod ug+x $CHKSUM_TEST && \
# ./$CHKSUM_TEST
in Dockerfile and it works.
That piece of code is part of https://github.com/gianniceresa/docker-images/tree/master/Compose%20OBIEE-DB, which isn’t updated anymore and isn’t what this blog post is about.
You better use the code of the folder linked above which gives you a proper OBIEE image.
If you really want to have a Docker Composer file you can simply put it together coupling the 2 images described in this post. Composer has now new ways to manage the dependencies of one container on another one, the code would need to be updated to match these things. You also maybe want to consider to use OBIEE 12.2.1.4 instead as 12.2.1.0.0 isn’t supported anymore and it’s full of bugs.
Is it a certified configuration to run OBIEE in docker?
Yes and no. Docker being quite transparent (not like a VM) it doesn’t have a proper certification. It is supported, Oracle Support will support you in your requests if you use OBIEE on docker (an Oracle PM confirmed that aspect, just as it is for their database).
It is anyway not the ideal use case for a production usage (that’s maybe why there isn’t an official “certified in docker” stamp), but no problem at all for dev and test and any other environment like that.
Hi, I’ve downloaded all files in 12.2.1.3.0 version and jdk like on images. All necessarry files are inside 12.2.1.3.0 folder, but when i run buildDockerImage.sh it finds only BI.zip files:
Checking if required packages are present and valid…
fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip: FAILED
fmw_12.2.1.3.0_bi_linux64_Disk1_1of2.zip: OK
fmw_12.2.1.3.0_bi_linux64_Disk1_2of2.zip: OK
md5sum: jdk-8u144-linux-x64.rpm: No such file or directory
jdk-8u144-linux-x64.rpm: FAILED open or read
md5sum: WARNING: 1 listed file could not be read
md5sum: WARNING: 1 computed checksum did NOT match
MD5 for required packages to build this image did not match!
Make sure to download missing files in folder 12.2.1.3.0
Here is ll output of 12.2.1.3.0 folder:
-rw-r–r– 1 root root 1885553927 Aug 8 09:25 fmw_12.2.1.3.0_bi_linux64_Disk1_1of2.zip
-rw-r–r– 1 root root 1732404482 Aug 8 09:25 fmw_12.2.1.3.0_bi_linux64_Disk1_2of2.zip
-rw-r–r– 1 root root 1627141097 Aug 8 09:36 fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip
-rw-r–r– 1 root root 165955188 Aug 8 09:46 jdk-8u101-linux-x64.rpm
Any ideas what might be wrong?
Hi,
Yes, the issue is in the JDK file: the Checksum.md5 for OBIEE 12.2.1.3 expects JDK 8u144 and you downloaded 8u101.
OBIEE 12.2.1.3 requires at least JDK 8u131, therefore your 101 is too old (it was fine for OBIEE 12.2.1.2 which was used in the blog post).
Either download the JDK 8u144 as expected by the file or at least a JDK8 >= 131 and update the filename and checksum inside the Checksum.md5 file.
ok during posting this i realized that jdk has a new version, so i get rid off this, but still don’t know how to deal with:
fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip: FAILED
evei if I have:
-rw-r–r– 1 root root 1627141097 Aug 8 09:36 fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip
Oracle did a dirty thing there 😀
They replaced the fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip on the download page with a newer one after the product has been released. I was checking the old checksum e6d4a9d416d35879b827b20a2ab05119 which still match the original file of August 2017. The one you have now on the download page has been patched by Oracle (but they kept the same name) and it’s the same as the one for OBIEE 12.2.1.4 with a checksum of 04285a574f18767335da15a9d40c4cc2 .
You can fix your issue by editing Checksum.md5 and replace the MD5 checksum for the infrastructure file, replace e6d4a9d416d35879b827b20a2ab05119 by 04285a574f18767335da15a9d40c4cc2 .
I updated the GitHub file as anyone downloading after April 2018 will have the same issue.
More in general: any reason for not using the 12.2.1.4 directly?
I’m able to run report via REST API (oryginal port 5002) only with HTTP, but HTTPS doesn’t work. Should I enable it in fussion middleware or somewhere in administator’s tools?
By default only HTTP is available, HTTPS requires extra configuration (setup certificates etc.). You can find the steps in the official OBIEE documentation or also in MOSC documents.