Try Oracle Enterprise Manager Cloud Control with Docker Desktop for Windows

testing environment

・ Windows 10 Pro 20H2 19042.685 ・ Docker Desktop Community 2.3.0.4 (Use the WSL 2 based engine enabled) -Oracle Enterprise Manager Cloud Control 13c Release 4 (13.4.0.0.0)

Installation requirements

-Free disk space: Approximately 70GB -Oracle account

procedure

Download Oracle Enterprise Manager Cloud Control 13c

Download the following files for Linux x86-64 (64-bit) from https://www.oracle.com/jp/enterprise-manager/downloads/cloud-control-downloads.html. em13400_linux64.bin em13400_linux64-2.zip em13400_linux64-3.zip em13400_linux64-4.zip em13400_linux64-5.zip em13400_linux64-6.zip em13400_linux64-7.zip An Oracle account is required to download. Do not unzip the zip file.

Volume creation for persistence

docker volume create oracle-emcc

docker container start

We will use absolutapps/oracle-12c-ee as a docker image that can be used immediately by Oracle Database.

docker run -d --name oracle-emcc --privileged --mount source=oracle-emcc,destination=/u01/app/oracle -v /e/docker/oracle:/eminstall --hostname oracle-db -e TZ=Asia/Tokyo -e ORACLE_CHARACTERSET=AL32UTF8 -e NLS_LANG=Japanese_Japan.AL32UTF8 -p 8080:8080 -p 1521:1521 -p 7803:7803 -p 443:443 absolutapps/oracle-12c-ee

For "-v/e/docker/oracle:/eminstall", specify the path of the folder where the downloaded file is stored. "Eminstall" is any name. The following is explained by eminstall. It will take some time before the DB can be used. View the log below and see "Done with scripts we are ready to go", or go to http: // localhost: 8080/em/login in your browser to access EM Express. ..

docker logs -f oracle-emcc

Preparation before installation

If the above is left as it is, "ORA-12547: TNS: Lost connection" will occur when connecting with sqlplus, so execute the following.

docker exec -it oracle-emcc bash
[root@oracle-db /]# gosu oracle relink all

Next, set the Oracle parameters.

[root@oracle-db /]# sqlplus /nolog
SQL> conn sys/oracle as sysdba
SQL> alter system set "optimizer_adaptive_features"=false scope=both;

SQL> System altered.

SQL> show parameter optimizer_adaptive_features

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features          boolean     FALSE
SQL> exit 

Response file generation

Generate a response file to perform a silent installation.

[root@oracle-db /]# /eminstall/em13400_linux64.bin -getResponseFileTemplates -outputLoc /u01/app/oracle

New_install.rsp will be created in/u01/app/oracle, so edit it referring to the following.

new_install.rsp


#UNIX_GROUP_NAME=<string>
#INVENTORY_LOCATION=<string>
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=false
[email protected]
#MYORACLESUPPORT_PASSWORD=<string>
INSTALL_UPDATES_SELECTION="skip"
#STAGE_LOCATION=<string>
[email protected]
MYORACLESUPPORT_PASSWORD_FOR_SOFTWAREUPDATES=password0
#PROXY_USER=<string>
#PROXY_PWD=<string>
#PROXY_HOST=<string>
#PROXY_PORT=<string>
ORACLE_MIDDLEWARE_HOME_LOCATION="/u01/app/oracle/middleware"
#ORACLE_HOSTNAME=<string>
AGENT_BASE_DIR="/u01/app/oracle/agent"
#WLS_ADMIN_SERVER_USERNAME="weblogic"
WLS_ADMIN_SERVER_PASSWORD="password0"
WLS_ADMIN_SERVER_CONFIRM_PASSWORD="password0"
NODE_MANAGER_PASSWORD="password0"
NODE_MANAGER_CONFIRM_PASSWORD="password0"
ORACLE_INSTANCE_HOME_LOCATION="/u01/app/oracle/gc_inst"
CONFIGURE_ORACLE_SOFTWARE_LIBRARY=true
SOFTWARE_LIBRARY_LOCATION="/u01/app/oracle/library"
DATABASE_HOSTNAME="oracle-db"
LISTENER_PORT=1521
SERVICENAME_OR_SID="orcl"
SYS_PASSWORD=oracle
SYSMAN_PASSWORD=password0
SYSMAN_CONFIRM_PASSWORD=password0
DEPLOYMENT_SIZE=SMALL
MANAGEMENT_TABLESPACE_LOCATION=/u01/app/oracle/oradata/orcl/mgmt.dbf
CONFIGURATION_DATA_TABLESPACE_LOCATION=/u01/app/oracle/oradata/orcl/mgmt_ecm_depot1.dbf
JVM_DIAGNOSTICS_TABLESPACE_LOCATION=/u01/app/oracle/oradata/orcl/mgmt_deepdive.dbf
AGENT_REGISTRATION_PASSWORD=password0
AGENT_REGISTRATION_CONFIRM_PASSWORD=password0
#STATIC_PORTS_FILE=<string>
PLUGIN_SELECTION={}
b_upgrade=false
EM_INSTALL_TYPE=NOSEED
CONFIGURATION_TYPE=ADVANCED
CONFIGURE_SHARED_LOCATION_BIP=false
#CONFIG_LOCATION=<string>
#CLUSTER_LOCATION=<string>

Installation

[root@oracle-db /]# su - oracle
[oracle@oracle-db ~]$ /eminstall/em13400_linux64.bin -silent -responseFile /u01/app/oracle/new_install.rsp

Installation takes more than an hour, depending on the machine.

Operation check

After the installation is complete, access https: // localhost: 7803/em with a browser to display the login screen of Oracle Enterprise Manager Cloud Control. Depending on the browser, it is said that it is not safe and it can not be displayed at first, so let's select "Still display" to display it. User Name: sysman Password: password0 Let's log in with! oracle-emcc.jpg

For continuous use

If you restart the docker container, you will have to do the following after the restart:

[root@oracle-db /]# gosu oracle relink all
[oracle@oracle-db ~]$ cd /u01/app/oracle
[oracle@oracle-db oracle]$ ./middleware/bin/emctl start oms     
Oracle Enterprise Manager Cloud Control 13c Release 4  
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...

WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server ...
BI Publisher Server Successfully Started
BI Publisher Server is Up
[oracle@oracle-db oracle]$ ./agent/agent_13.4.0.0.0/bin/emctl start agent 
Oracle Enterprise Manager Cloud Control 13c Release 4  
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Starting agent .............................................................. started.
[oracle@oracle-db oracle]$ 

Recommended Posts

Try Oracle Enterprise Manager Cloud Control with Docker Desktop for Windows
Try running cloudera manager with docker
Try AWS Lambda Runtime Interface Emulator with Docker Desktop for M1
(For myself) Try creating a C # environment with docker + code-server, cloud9
Install Docker Desktop for Mac with Homebrew
Introducing Docker Desktop for Windows on WSL2
Time shift measures with Docker for Windows
Docker Desktop for Windows 2.4.0.0 (48506) Startup error after update
Operate Docker Desktop for Windows on Linux (WSL)
How to start with Hyper-V instead of WSL2 on Docker Desktop for Windows
Try WildFly with Docker
[Note] I suddenly can't build with Docker for windows.
I tried using Docker Desktop for Windows on Windows 10 Home
Try connecting to AzureCosmosDB Emulator for Docker with Java
Try Docker on Windows 10 Home
Version control CocoaPods with Docker
[Personal memo] About button (GUI) operation of Docker Desktop for Windows
Run logstash with Docker and try uploading data to Elastic Cloud
WSL2 + Docker Desktop for Windows does not launch only MySQL container
Environment construction with Docker for beginners
[Google Cloud] Getting Started with Docker
[SRE / Docker] Start control with Dockerize
Try Docker on Windows Home (September 2020)
Microservices With Docker and Cloud Performance
Run Redmine in the local environment of Windows10 Pro-Use Docker Desktop for Windows