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.
- Excerpt only for changed lines
- Please set PROXY according to your own environment.
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!
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