Oracle in Docker Containers Managed by Kubernetes
Executive Summary
Use Case Overview
Supporting Software Technology
Dell EMC Flex Nodes and Storage
Manual Provisioning
Automated Provisioning
Conclusion
References
Solution Architecture and Component Specifications
Scaling Up the Database Analytic Workload
Use Case 1: Manual provisioning of a containerized development and testing environment
Step 1: Install Docker
Step 2: Activate the Docker Enterprise Edition license
Step 3: Run the Oracle 12c container on Docker
Step 4: Build and run the Oracle 19c container on Docker
Step 5: Import sample schemas from GitHub
Step 6: Install Oracle SQL Developer and query tables from the container
Use Case 1 review
Step 6: Install Oracle SQL Developer and query tables from the container
Step 6: Install Oracle SQL Developer and query tables from the container
-
In this step we download Oracle SQL Developer from the Oracle download site and install Oracle SQL Developer into the fourth VM as demonstrated in Figure 10. Oracle SQL Developer is a client software that can be used to connect to any of the Oracle 12c and 19c databases for data manipulation within the Oracle databases. By running different SQL queries from the Oracle SQL Developer (Figure 11) to Oracle databases, we establish that the Oracle databases are operational
To install Oracle SQL Developer, do the following.
- Download Oracle SQL Developer 19.2.1 Downloads for Linux 64 bit rpm with Oracle jdk 13.0.1 from https://www.oracle.com/tools/downloads/sqldev-v192-downloads.html.
- Install the Oracle SQL Developer rpm package.
[root@12c-docker ~ #rpm -ivh sqldeveloper-19.2.12.247.2212.noarch.rpm
- Open sqldeveloper.
[root@12c-docker ~] #sqldeveloper
- Set up the connection user:hr password service name: ORCLPDB1, as shown in the following figure.
- You can now query the tables in as shown in the following figure:
Figure 11. Query the tables