Oracle Autonomous Database and DevOps:
A simple usage approach – Part 1
This article explains the creation of an Oracle Autonomous Database instance in the Oracle Cloud for the usage of programmers(some tests examples with some programming languages and Oracle SQL Developer). Let’s build some concept to start:
What is the Oracle Autonomous Database?
According to Oracle Corp, it is “the first standalone cloud data manager that provides application for patches, upgrades and tuning, including performing maintenance tasks on the database without human intervention.”. In addition, Oracle itself explains 3 features of this new database model that are:
According to the Oracle Corp. this is “
Self-Driving: Thus reducing human labor;
Self-Securing: Protecting yourself from third-party attacks;
Self-Repairing: Will try to keep the database running regardless of the error, as it will attempt to resolve the issue autonomously.
What is Docker?
It is a computer program that performs virtualization at the operating system level.
Now that you have a brief understanding of what is the Oracle Autonomous Database we will begin to configure the database in the Oracle Cloud for programming purposes. To do this, we will follow the following steps:
Account configuration in the Oracle Cloud: In this step you will need to create the account in the Oracle Cloud through the https://cloud.oracle.com/home link. I will not go into detail in this topic because someone recently had an article published in OTN Brazil that details step by step this topic. The name of the article is “Using Oracle Autonomous Transaction Processing” and can be found on the following link:
https://www.oracle.com/technetwork/pt/articles/cloudcomp/utilizando-oracle-atp-5462247-ptb.html .
– Docker Software Installation: This software can be found on the manufacturer’s official website https://www.docker.com/ and the installation depends on the type of operating system. In this article we will be using the Red Hat 7 operating system. Here is an example below:
[root@oc8226237722 ~]# yum install docker
Loaded plugins: downloadkvmonly-background, techdatabasketblog-check-lotus-updates, techdatabasketblog-check-
: upgrade, techdatabasketblog-check-xorg-updates, techdatabasketblog-repository, langpacks,
: post-transaction-actions, refresh-packagekit, versionlock
RHEL-76-x86_64 | 4.1 kB 00:00
RHEL-76-x86_64-techdatabasketblog-updates | 3.3 kB 00:00
RHEL-76-x86_64-updates | 3.3 kB 00:00
RHEL7-x86_64-techdatabasketblog-upgrade | 3.3 kB 00:00
Resolving Dependencies
--> Running transaction check
---> Package docker.x86_64 2:1.13.1-75.git8633870.el7.centos will be installed
--> Processing Dependency: docker-common = 2:1.13.1-75.git8633870.el7.centos for package: 2:docker-1.13.1-75.git8633870.el7.centos.x86_64
--> Processing Dependency: docker-client = 2:1.13.1-75.git8633870.el7.centos for package: 2:docker-1.13.1-75.git8633870.el7.centos.x86_64
--> Processing Dependency: subscription-manager-rhsm-certificates for package: 2:docker-1.13.1-75.git8633870.el7.centos.x86_64
--> Running transaction check
---> Package docker-client.x86_64 2:1.13.1-75.git8633870.el7.centos will be installed
---> Package docker-common.x86_64 2:1.13.1-75.git8633870.el7.centos will be installed
--> Processing Dependency: skopeo-containers >= 1:0.1.26-2 for package: 2:docker-common-1.13.1-75.git8633870.el7.centos.x86_64
--> Processing Dependency: oci-umount >= 2:2.3.3-3 for package: 2:docker-common-1.13.1-75.git8633870.el7.centos.x86_64
--> Processing Dependency: oci-systemd-hook >= 1:0.1.4-9 for package: 2:docker-common-1.13.1-75.git8633870.el7.centos.x86_64
--> Processing Dependency: oci-register-machine >= 1:0-5.13 for package: 2:docker-common-1.13.1-75.git8633870.el7.centos.x86_64
--> Processing Dependency: container-storage-setup >= 0.9.0-1 for package: 2:docker-common-1.13.1-75.git8633870.el7.centos.x86_64
--> Processing Dependency: container-selinux >= 2:2.51-1 for package: 2:docker-common-1.13.1-75.git8633870.el7.centos.x86_64
--> Processing Dependency: atomic-registries for package: 2:docker-common-1.13.1-75.git8633870.el7.centos.x86_64
---> Package subscription-manager-rhsm-certificates.x86_64 0:1.21.10-3.el7_6 will be installed
--> Running transaction check
---> Package atomic-registries.x86_64 1:1.22.1-25.git5a342e3.el7.centos will be installed
--> Processing Dependency: python-pytoml for package: 1:atomic-registries-1.22.1-25.git5a342e3.el7.centos.x86_64
---> Package container-selinux.noarch 2:2.68-1.el7 will be installed
--> Processing Dependency: policycoreutils-python for package: 2:container-selinux-2.68-1.el7.noarch
---> Package container-storage-setup.noarch 0:0.11.0-2.git5eaf76c.el7 will be installed
---> Package oci-register-machine.x86_64 1:0-6.git2b44233.el7 will be installed
---> Package oci-systemd-hook.x86_64 1:0.1.17-2.git83283a0.el7 will be installed
---> Package oci-umount.x86_64 2:2.3.3-3.gite3c9055.el7 will be installed
---> Package skopeo-containers.x86_64 1:0.1.31-1.dev.gitae64ff7.el7.centos will be installed
--> Running transaction check
---> Package policycoreutils-python.x86_64 0:2.5-29.el7_6.1 will be installed
--> Processing Dependency: policycoreutils = 2.5-29.el7_6.1 for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
--> Processing Dependency: setools-libs >= 3.3.8-4 for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
--> Processing Dependency: libsemanage-python >= 2.5-14 for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
--> Processing Dependency: audit-libs-python >= 2.1.3-4 for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.4)(64bit) for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.2)(64bit) for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
--> Processing Dependency: libapol.so.4(VERS_4.0)(64bit) for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
--> Processing Dependency: checkpolicy for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
--> Processing Dependency: libqpol.so.1()(64bit) for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
--> Processing Dependency: libapol.so.4()(64bit) for package: policycoreutils-python-2.5-29.el7_6.1.x86_64
---> Package python-pytoml.noarch 0:0.1.14-1.git7dea353.el7 will be installed
--> Running transaction check
---> Package audit-libs-python.x86_64 0:2.8.4-4.el7 will be installed
--> Processing Dependency: audit-libs(x86-64) = 2.8.4-4.el7 for package: audit-libs-python-2.8.4-4.el7.x86_64
---> Package checkpolicy.x86_64 0:2.5-8.el7 will be installed
---> Package libsemanage-python.x86_64 0:2.5-14.el7 will be installed
--> Processing Dependency: libsemanage = 2.5-14.el7 for package: libsemanage-python-2.5-14.el7.x86_64
---> Package policycoreutils.x86_64 0:2.5-22.el7 will be updated
---> Package policycoreutils.x86_64 0:2.5-29.el7_6.1 will be an update
--> Processing Dependency: libsepol >= 2.5-10 for package: policycoreutils-2.5-29.el7_6.1.x86_64
--> Processing Dependency: libselinux-utils >= 2.5-14 for package: policycoreutils-2.5-29.el7_6.1.x86_64
---> Package setools-libs.x86_64 0:3.3.8-4.el7 will be installed
--> Processing Dependency: libselinux >= 2.5-14.1 for package: setools-libs-3.3.8-4.el7.x86_64
--> Running transaction check
---> Package audit-libs.i686 0:2.8.1-3.el7_5.1 will be updated
---> Package audit-libs.x86_64 0:2.8.1-3.el7_5.1 will be updated
--> Processing Dependency: audit-libs(x86-64) = 2.8.1-3.el7_5.1 for package: audit-2.8.1-3.el7_5.1.x86_64
---> Package audit-libs.i686 0:2.8.4-4.el7 will be an update
---> Package audit-libs.x86_64 0:2.8.4-4.el7 will be an update
---> Package libselinux.i686 0:2.5-12.el7 will be updated
---> Package libselinux.x86_64 0:2.5-12.el7 will be updated
--> Processing Dependency: libselinux(x86-64) = 2.5-12.el7 for package: libselinux-python-2.5-12.el7.x86_64
--> Processing Dependency: libselinux(x86-64) = 2.5-12.el7 for package: libselinux-devel-2.5-12.el7.x86_64
---> Package libselinux.i686 0:2.5-14.1.el7 will be an update
---> Package libselinux.x86_64 0:2.5-14.1.el7 will be an update
---> Package libselinux-utils.x86_64 0:2.5-12.el7 will be updated
---> Package libselinux-utils.x86_64 0:2.5-14.1.el7 will be an update
---> Package libsemanage.x86_64 0:2.5-11.el7 will be updated
---> Package libsemanage.x86_64 0:2.5-14.el7 will be an update
---> Package libsepol.i686 0:2.5-8.1.el7 will be updated
---> Package libsepol.x86_64 0:2.5-8.1.el7 will be updated
--> Processing Dependency: libsepol(x86-64) = 2.5-8.1.el7 for package: libsepol-devel-2.5-8.1.el7.x86_64
---> Package libsepol.i686 0:2.5-10.el7 will be an update
---> Package libsepol.x86_64 0:2.5-10.el7 will be an update
--> Running transaction check
---> Package audit.x86_64 0:2.8.1-3.el7_5.1 will be updated
---> Package audit.x86_64 0:2.8.4-4.el7 will be an update
---> Package libselinux-devel.x86_64 0:2.5-12.el7 will be updated
---> Package libselinux-devel.x86_64 0:2.5-14.1.el7 will be an update
---> Package libselinux-python.x86_64 0:2.5-12.el7 will be updated
---> Package libselinux-python.x86_64 0:2.5-14.1.el7 will be an update
---> Package libsepol-devel.x86_64 0:2.5-8.1.el7 will be updated
---> Package libsepol-devel.x86_64 0:2.5-10.el7 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
docker x86_64 2:1.13.1-75.git8633870.el7.centos
RHEL-76-x86_64 16 M
Installing for dependencies:
atomic-registries x86_64 1:1.22.1-25.git5a342e3.el7.centos
RHEL-76-x86_64 35 k
audit-libs-python x86_64 2.8.4-4.el7 RHEL-76-x86_64 76 k
checkpolicy x86_64 2.5-8.el7 RHEL-76-x86_64 295 k
container-selinux noarch 2:2.68-1.el7 RHEL-76-x86_64 36 k
container-storage-setup noarch 0.11.0-2.git5eaf76c.el7 RHEL-76-x86_64 35 k
docker-client x86_64 2:1.13.1-75.git8633870.el7.centos
RHEL-76-x86_64 3.8 M
docker-common x86_64 2:1.13.1-75.git8633870.el7.centos
RHEL-76-x86_64 93 k
libsemanage-python x86_64 2.5-14.el7 RHEL-76-x86_64 113 k
oci-register-machine x86_64 1:0-6.git2b44233.el7 RHEL-76-x86_64 1.1 M
oci-systemd-hook x86_64 1:0.1.17-2.git83283a0.el7 RHEL-76-x86_64 33 k
oci-umount x86_64 2:2.3.3-3.gite3c9055.el7 RHEL-76-x86_64 32 k
policycoreutils-python x86_64 2.5-29.el7_6.1 RHEL-76-x86_64-updates
456 k
python-pytoml noarch 0.1.14-1.git7dea353.el7 RHEL-76-x86_64 18 k
setools-libs x86_64 3.3.8-4.el7 RHEL-76-x86_64 620 k
skopeo-containers x86_64 1:0.1.31-1.dev.gitae64ff7.el7.centos
RHEL-76-x86_64 17 k
subscription-manager-rhsm-certificates
x86_64 1.21.10-3.el7_6 RHEL-76-x86_64 212 k
Updating for dependencies:
audit x86_64 2.8.4-4.el7 RHEL-76-x86_64 250 k
audit-libs i686 2.8.4-4.el7 RHEL-76-x86_64 101 k
audit-libs x86_64 2.8.4-4.el7 RHEL-76-x86_64 100 k
libselinux i686 2.5-14.1.el7 RHEL-76-x86_64 166 k
libselinux x86_64 2.5-14.1.el7 RHEL-76-x86_64 162 k
libselinux-devel x86_64 2.5-14.1.el7 RHEL-76-x86_64 187 k
libselinux-python x86_64 2.5-14.1.el7 RHEL-76-x86_64 236 k
libselinux-utils x86_64 2.5-14.1.el7 RHEL-76-x86_64 152 k
libsemanage x86_64 2.5-14.el7 RHEL-76-x86_64 151 k
libsepol i686 2.5-10.el7 RHEL-76-x86_64 294 k
libsepol x86_64 2.5-10.el7 RHEL-76-x86_64 297 k
libsepol-devel x86_64 2.5-10.el7 RHEL-76-x86_64 77 k
policycoreutils x86_64 2.5-29.el7_6.1 RHEL-76-x86_64-updates
916 k
Transaction Summary
================================================================================
Install 1 Package (+16 Dependent packages)
Upgrade ( 13 Dependent packages)
Total size: 26 M
Total download size: 23 M
Is this ok [y/d/N]: y
Downloading packages:
(1/17): atomic-registries-1.22.1-25.git5a342e3.el7.centos. | 35 kB 00:00
(2/17): container-storage-setup-0.11.0-2.git5eaf76c.el7.no | 35 kB 00:00
(3/17): audit-libs-python-2.8.4-4.el7.x86_64.rpm | 76 kB 00:00
(4/17): container-selinux-2.68-1.el7.noarch.rpm | 36 kB 00:00
(5/17): checkpolicy-2.5-8.el7.x86_64.rpm | 295 kB 00:00
(6/17): docker-common-1.13.1-75.git8633870.el7.centos.x86_ | 93 kB 00:00
(7/17): docker-client-1.13.1-75.git8633870.el7.centos.x86_ | 3.8 MB 00:01
(8/17): oci-systemd-hook-0.1.17-2.git83283a0.el7.x86_64.rp | 33 kB 00:00
(9/17): oci-register-machine-0-6.git2b44233.el7.x86_64.rpm | 1.1 MB 00:00
(10/17): oci-umount-2.3.3-3.gite3c9055.el7.x86_64.rpm | 32 kB 00:00
(11/17): python-pytoml-0.1.14-1.git7dea353.el7.noarch.rpm | 18 kB 00:00
(12/17): setools-libs-3.3.8-4.el7.x86_64.rpm | 620 kB 00:00
(13/17): skopeo-containers-0.1.31-1.dev.gitae64ff7.el7.cen | 17 kB 00:00
(14/17): subscription-manager-rhsm-certificates-1.21.10-3. | 212 kB 00:00
(15/17): libsemanage-python-2.5-14.el7.x86_64.rpm | 113 kB 00:02
(16/17): policycoreutils-python-2.5-29.el7_6.1.x86_64.rpm | 456 kB 00:00
(17/17): docker-1.13.1-75.git8633870.el7.centos.x86_64.rpm | 16 MB 00:10
--------------------------------------------------------------------------------
Total 2.1 MB/s | 23 MB 00:11
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : libsepol-2.5-10.el7.x86_64 1/43
Updating : libselinux-2.5-14.1.el7.x86_64 2/43
Updating : audit-libs-2.8.4-4.el7.x86_64 3/43
Updating : libsemanage-2.5-14.el7.x86_64 4/43
Updating : libselinux-utils-2.5-14.1.el7.x86_64 5/43
Updating : policycoreutils-2.5-29.el7_6.1.x86_64 6/43
Installing : libsemanage-python-2.5-14.el7.x86_64 7/43
Installing : audit-libs-python-2.8.4-4.el7.x86_64 8/43
Installing : setools-libs-3.3.8-4.el7.x86_64 9/43
Installing : 2:oci-umount-2.3.3-3.gite3c9055.el7.x86_64 10/43
Installing : 1:oci-systemd-hook-0.1.17-2.git83283a0.el7.x86_64 11/43
Updating : libselinux-python-2.5-14.1.el7.x86_64 12/43
Updating : libsepol-devel-2.5-10.el7.x86_64 13/43
Installing : subscription-manager-rhsm-certificates-1.21.10-3.el7_6.x 14/43
Installing : 1:oci-register-machine-0-6.git2b44233.el7.x86_64 15/43
Installing : python-pytoml-0.1.14-1.git7dea353.el7.noarch 16/43
Installing : 1:atomic-registries-1.22.1-25.git5a342e3.el7.centos.x86_ 17/43
Installing : checkpolicy-2.5-8.el7.x86_64 18/43
Installing : policycoreutils-python-2.5-29.el7_6.1.x86_64 19/43
Installing : 2:container-selinux-2.68-1.el7.noarch 20/43
Installing : 1:skopeo-containers-0.1.31-1.dev.gitae64ff7.el7.centos.x 21/43
Installing : container-storage-setup-0.11.0-2.git5eaf76c.el7.noarch 22/43
Installing : 2:docker-common-1.13.1-75.git8633870.el7.centos.x86_64 23/43
Installing : 2:docker-client-1.13.1-75.git8633870.el7.centos.x86_64 24/43
Updating : libsepol-2.5-10.el7.i686 25/43
Installing : 2:docker-1.13.1-75.git8633870.el7.centos.x86_64 26/43
Updating : libselinux-devel-2.5-14.1.el7.x86_64 27/43
Updating : audit-2.8.4-4.el7.x86_64 28/43
Updating : libselinux-2.5-14.1.el7.i686 29/43
Updating : audit-libs-2.8.4-4.el7.i686 30/43
Cleanup : policycoreutils-2.5-22.el7.x86_64 31/43
Cleanup : libselinux-devel-2.5-12.el7.x86_64 32/43
Cleanup : libsepol-devel-2.5-8.1.el7.x86_64 33/43
Cleanup : libselinux-2.5-12.el7 34/43
Cleanup : libsemanage-2.5-11.el7.x86_64 35/43
Cleanup : libselinux-utils-2.5-12.el7.x86_64 36/43
Cleanup : libselinux-python-2.5-12.el7.x86_64 37/43
Cleanup : libselinux-2.5-12.el7 38/43
Cleanup : audit-2.8.1-3.el7_5.1.x86_64 39/43
Cleanup : libsepol-2.5-8.1.el7 40/43
Cleanup : audit-libs-2.8.1-3.el7_5.1 41/43
Cleanup : audit-libs-2.8.1-3.el7_5.1 42/43
Cleanup : libsepol-2.5-8.1.el7 43/43
Verifying : 2:docker-common-1.13.1-75.git8633870.el7.centos.x86_64 1/43
Verifying : 2:container-selinux-2.68-1.el7.noarch 2/43
Verifying : container-storage-setup-0.11.0-2.git5eaf76c.el7.noarch 3/43
Verifying : policycoreutils-2.5-29.el7_6.1.x86_64 4/43
Verifying : 1:skopeo-containers-0.1.31-1.dev.gitae64ff7.el7.centos.x 5/43
Verifying : libselinux-2.5-14.1.el7.i686 6/43
Verifying : checkpolicy-2.5-8.el7.x86_64 7/43
Verifying : audit-libs-2.8.4-4.el7.x86_64 8/43
Verifying : audit-2.8.4-4.el7.x86_64 9/43
Verifying : 2:docker-client-1.13.1-75.git8633870.el7.centos.x86_64 10/43
Verifying : python-pytoml-0.1.14-1.git7dea353.el7.noarch 11/43
Verifying : setools-libs-3.3.8-4.el7.x86_64 12/43
Verifying : policycoreutils-python-2.5-29.el7_6.1.x86_64 13/43
Verifying : libsemanage-python-2.5-14.el7.x86_64 14/43
Verifying : libsemanage-2.5-14.el7.x86_64 15/43
Verifying : 1:oci-register-machine-0-6.git2b44233.el7.x86_64 16/43
Verifying : 2:oci-umount-2.3.3-3.gite3c9055.el7.x86_64 17/43
Verifying : libsepol-2.5-10.el7.x86_64 18/43
Verifying : audit-libs-2.8.4-4.el7.i686 19/43
Verifying : libsepol-2.5-10.el7.i686 20/43
Verifying : 1:oci-systemd-hook-0.1.17-2.git83283a0.el7.x86_64 21/43
Verifying : libsepol-devel-2.5-10.el7.x86_64 22/43
Verifying : 1:atomic-registries-1.22.1-25.git5a342e3.el7.centos.x86_ 23/43
Verifying : libselinux-python-2.5-14.1.el7.x86_64 24/43
Verifying : audit-libs-python-2.8.4-4.el7.x86_64 25/43
Verifying : libselinux-utils-2.5-14.1.el7.x86_64 26/43
Verifying : subscription-manager-rhsm-certificates-1.21.10-3.el7_6.x 27/43
Verifying : libselinux-devel-2.5-14.1.el7.x86_64 28/43
Verifying : 2:docker-1.13.1-75.git8633870.el7.centos.x86_64 29/43
Verifying : libselinux-2.5-14.1.el7.x86_64 30/43
Verifying : libsemanage-2.5-11.el7.x86_64 31/43
Verifying : libselinux-python-2.5-12.el7.x86_64 32/43
Verifying : libsepol-devel-2.5-8.1.el7.x86_64 33/43
Verifying : policycoreutils-2.5-22.el7.x86_64 34/43
Verifying : audit-2.8.1-3.el7_5.1.x86_64 35/43
Verifying : libsepol-2.5-8.1.el7.x86_64 36/43
Verifying : libselinux-2.5-12.el7.i686 37/43
Verifying : libselinux-devel-2.5-12.el7.x86_64 38/43
Verifying : libsepol-2.5-8.1.el7.i686 39/43
Verifying : audit-libs-2.8.1-3.el7_5.1.x86_64 40/43
Verifying : audit-libs-2.8.1-3.el7_5.1.i686 41/43
Verifying : libselinux-2.5-12.el7.x86_64 42/43
Verifying : libselinux-utils-2.5-12.el7.x86_64 43/43
Installed:
docker.x86_64 2:1.13.1-75.git8633870.el7.centos
Dependency Installed:
atomic-registries.x86_64 1:1.22.1-25.git5a342e3.el7.centos
audit-libs-python.x86_64 0:2.8.4-4.el7
checkpolicy.x86_64 0:2.5-8.el7
container-selinux.noarch 2:2.68-1.el7
container-storage-setup.noarch 0:0.11.0-2.git5eaf76c.el7
docker-client.x86_64 2:1.13.1-75.git8633870.el7.centos
docker-common.x86_64 2:1.13.1-75.git8633870.el7.centos
libsemanage-python.x86_64 0:2.5-14.el7
oci-register-machine.x86_64 1:0-6.git2b44233.el7
oci-systemd-hook.x86_64 1:0.1.17-2.git83283a0.el7
oci-umount.x86_64 2:2.3.3-3.gite3c9055.el7
policycoreutils-python.x86_64 0:2.5-29.el7_6.1
python-pytoml.noarch 0:0.1.14-1.git7dea353.el7
setools-libs.x86_64 0:3.3.8-4.el7
skopeo-containers.x86_64 1:0.1.31-1.dev.gitae64ff7.el7.centos
subscription-manager-rhsm-certificates.x86_64 0:1.21.10-3.el7_6
Dependency Updated:
audit.x86_64 0:2.8.4-4.el7
audit-libs.i686 0:2.8.4-4.el7
audit-libs.x86_64 0:2.8.4-4.el7
libselinux.i686 0:2.5-14.1.el7
libselinux.x86_64 0:2.5-14.1.el7
libselinux-devel.x86_64 0:2.5-14.1.el7
libselinux-python.x86_64 0:2.5-14.1.el7
libselinux-utils.x86_64 0:2.5-14.1.el7
libsemanage.x86_64 0:2.5-14.el7
libsepol.i686 0:2.5-10.el7
libsepol.x86_64 0:2.5-10.el7
libsepol-devel.x86_64 0:2.5-10.el7
policycoreutils.x86_64 0:2.5-29.el7_6.1
Complete!
– Using an image for virtualization with the Docker software: After installing Docker you need to pull an existing image for virtualization. In this article we will use the image phx.ocir.io/oradbcloudtechdatabasket/openworld/atpclient:full
[root@oc8226237722 ~]# docker pull phx.ocir.io/oradbcloudtechdatabasket/openworld/atpclient:full
Trying to pull repository phx.ocir.io/oradbcloudtechdatabasket/openworld/atpclient ...
full: Pulling from phx.ocir.io/oradbcloudtechdatabasket/openworld/atpclient
4c851099615d: Pull complete
f22562ec5726: Pull complete
ecaf948a6376: Pull complete
0523cfba9a7b: Pull complete
5cc059e87718: Pull complete
40fde7f8968a: Pull complete
8257cc2c348c: Pull complete
006c509ee636: Pull complete
327ac893dadd: Pull complete
df8f385b3400: Pull complete
942ed172ad5e: Pull complete
000ecb121309: Pull complete
21ca946a8b49: Pull complete
585313811f7d: Pull complete
9472199e9ad7: Pull complete
53a7553bad7f: Pull complete
485560c4134a: Pull complete
e152e9eb3b79: Pull complete
464039b4cdc2: Pull complete
6910ba0139a1: Pull complete
1206d486d92c: Pull complete
Digest: sha256:490cf9de59a35c46cad5421a4013e91c09ea65e2bec07422d2a8c377c17123d1
Status: Downloaded newer image for phx.ocir.io/oradbcloudtechdatabasket/openworld/atpclient:full
Creating a directory to store the wallet file:
[root@oc8226237722 ~]# mkdir -p /tmp/wallet
Initialize the container while the wallet file directory is being created:
[root@oc8226237722 ~]# docker run -it -p 3050:3050 -v ~/tmp/wallet:/opt/oracle/techdatabasketvm/database/wallet phx.ocir.io/oradbcloudtechdatabasket/openworld/atpclient:full /bin/bash
bash-4.2#
bash-4.2#
Checking the status of Docker: Some information about the command
docker info: Provides information about Docker software;
systemctl status docker.service: Checks the status of the Docker software;
systemctl start docker.service: Initializes the service if it is not initialized.
docker images -a: Provides information about existing virtualized images.
root@oc8226237722 ~]# docker info
Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?
[root@oc8226237722 ~]# systemctl status docker.service
docker.service - Docker Application Container Engine
Loaded: loaded (/usr/lib/systemd/system/docker.service; disabled; vendor preset: disabled)
Active: inactive (dead)
Docs: http://docs.docker.com
[root@oc8226237722 ~]# docker images -a
REPOSITORY TAG IMAGE ID CREATED SIZE
docker.io/docker latest 6742c45f63ej 5 days ago 171 MB
phx.ocir.io/oradbcloudtechdatabasket/openworld/atpclient:full full 338e9abb4e77 7 weeks ago 1.14 GB
[root@oc8226237722 ~]# systemctl start docker.service
[root@oc8226237722 ~]# systemctl status docker.service
docker.service - Docker Application Container Engine
Loaded: loaded (/usr/lib/systemd/system/docker.service; disabled; vendor preset: disabled)
Active: active (running) since Thu 2019-04-04 12:10:31 CEST; 6s ago
Docs: http://docs.docker.com
Main PID: 30161 (dockerd-current)
Tasks: 21
CGroup: /system.slice/docker.service
├─30161 /usr/bin/dockerd-current --add-runtime docker-runc=/usr/libexec/docker/docker-runc-current --default-runtime=docker-runc --exec-opt native.cgroupdriver=systemd --userland-proxy-path=...
└─30168 /usr/bin/docker-containerd-current -l unix:///var/run/docker/libcontainerd/docker-containerd.sock --metrics-interval=0 --start-timeout 2m --state-dir /var/run/docker/libcontainerd/co...
Apr 04 12:10:29 oc8226237722.techdatabasketblog.com dockerd-current[30161]: time="2019-04-04T12:10:29.654282057+02:00" level=info msg="libcontainerd: new containerd process, pid: 30168"
Apr 04 12:10:30 oc8226237722.techdatabasketblog.com dockerd-current[30161]: time="2019-04-04T12:10:30.755627224+02:00" level=info msg="Graph migration to content-addressability took 0.00 seconds"
Apr 04 12:10:30 oc8226237722.techdatabasketblog.com dockerd-current[30161]: time="2019-04-04T12:10:30.756764713+02:00" level=info msg="Loading containers: start."
Apr 04 12:10:30 oc8226237722.techdatabasketblog.com dockerd-current[30161]: time="2019-04-04T12:10:30.787906039+02:00" level=info msg="Firewalld running: true"
Apr 04 12:10:30 oc8226237722.techdatabasketblog.com dockerd-current[30161]: time="2019-04-04T12:10:30.973371092+02:00" level=info msg="Default bridge (docker0) is assigned with an IP address 172.17.0.0/16... IP address"
Apr 04 12:10:31 oc8226237722.techdatabasketblog.com dockerd-current[30161]: time="2019-04-04T12:10:31.150353744+02:00" level=info msg="Loading containers: done."
Apr 04 12:10:31 oc8226237722.techdatabasketblog.com dockerd-current[30161]: time="2019-04-04T12:10:31.194265410+02:00" level=info msg="Daemon has completed initialization"
Apr 04 12:10:31 oc8226237722.techdatabasketblog.com dockerd-current[30161]: time="2019-04-04T12:10:31.194546603+02:00" level=info msg="Docker daemon" commit="8633870/1.13.1" graphdriver=overlay2 version=1.13.1
Apr 04 12:10:31 oc8226237722.techdatabasketblog.com dockerd-current[30161]: time="2019-04-04T12:10:31.202468424+02:00" level=info msg="API listen on /var/run/docker.sock"
Apr 04 12:10:31 oc8226237722.techdatabasketblog.com systemd[1]: Started Docker Application Container Engine.
Hint: Some lines were ellipsized, use -l to show in full.
So we finished the first part of the series of articles about Oracle Autonomous Database in Oracle Cloud for DevOps. In the next article we will continue with the provisioning of the database.
References:
https://www.oracle.com/database/autonomous-database.html
https://www.docker.com/
Bruno Reis da Silva is a Database Cloud Support Engineer and professionally Certified Oracle Database Administrator who has worked on the South American continent and is now working at the European continent. He was awarded the first Oracle Ace Associate of Hungary in 2017. His interests are in RDBMS, mainly Oracle, operating systems (Linux, AIX, HPUX and Solaris) and High Availability Solutions implementations. In his free time he enjoys playing sports , going to the gym and traveling. His blog www.techdatabasket.com is dedicated to his sister Laura Vitoria and the main reason for blogging is because he believes in the quote “giving back to get back” . He also enjoys continuous learning and the interaction with others who share his interest.
Carlos Magno de Andrade Júnior is an Database Architect at eProseed Europe, with more than 15 years of experience in Oracle database on complex projects in countries such as Brazil , India , the Netherlands, Luxembourg , France and Italy, having worked in companies such as Oracle Corporation, IBM, HSBC, among others. Also shares information on his blog ezdba.wordpress.com. Certifications : OCM 12c OCP 10g , 11g OCP , OCP 12c, OCE RAC , Exadata , ITIL and OEM 12c Cloud Control Implementation Specialist.
