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
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.
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)