Установка / настройка / патчинг Oracle Cloud Control 13cR3.Acquired Skills:
################################################################
-> Oracle Database 19cR3 SILENT Installation (software only)
-> Oracle Database 19cR3 Creation with DBCA (Silent)
-> Oracle Database 19cR3 Patching
-> Oracle Cloud Control 13cR3 SILENT Installation (software only + setup) using Response files
-> Oracle Cloud Control 13cR3 Patching
################################################################
DOCUMENTS:
################################################################
https://oracle-base.com/articles/13c/cloud-control-13cr3-silent-installation-on-oracle-linux7
https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-7
https://oracle-base.com/articles/13c/cloud-control-13c-post-installation-setup-tasks
EM 13c: How to Apply a Patch to the Enterprise Manager 13c Cloud Control OMS Oracle Home (Doc ID 2091619.1)
################################################################
ACTION PLAN:
################################################################
[+] Server Setup
[+] Database Setup
[+] OMS Setup
[+] Database patching
[+] OMS Patching
[+] Check Plug-in's versions
[+] Increase OMS_HEAP_MAX
[+] Summary
################################################################
INSTALLATION:
################################################################
@@@@@@@@@@@@@@@@@@@@@@@@@@@
Server Setup:
@@@@@@@@@@@@@@@@@@@@@@@@@@@
//
// Ref. to https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-7
//
>>> root
$ mkfs.ext4 /dev/vdb1
$ mkdir -p /oracle
$ mount /dev/vdb1 /oracle
$ cat /etc/fstab
+++++
...
...
...
#
# Oracle Software
#
# device - describes the block special device or remote filesystem to be mounted;
# mountpoint - describes the mount directory;
# fstype - file system type;
# options - file system specific options;
# dump - is checked by dump utility (usually set to 0 value);
# fsck - sets the order for filesystem checks at boot time. For root device should be 1. For others 2, to disable 0.
#
#device mountpoint fstype options dump fsck
/dev/vdb1 /u01 ext4 defaults 0 2
+++++
$ cat /etc/hosts
+++++
::1 localhost6.localdomain6 localhost6
127.0.0.1 localhost.localdomain localhost
192.168.197.180 srv-rhel7-cc.oracle.com srv-rhel7-cc
+++++
$ cat /etc/hostname
+++++
srv-rhel7-cc.oracle.com
+++++
$ cp /etc/sysctl.conf /etc/sysctl.conf_bkp
$ ls -ltr /etc/sysctl.conf*
+++++
-rw-r--r-- 1 root root 1348 Oct 8 15:58 /etc/sysctl.conf
-rw-r--r-- 1 root root 1348 Feb 11 16:47 /etc/sysctl.conf_bkp
+++++
//
// Setup kernel parameters / limit / etc by installing 19c preinstall package
//
$ yum localinstall -y /u01/soft/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++ If there is no pre-install package then manual setup required +++
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-----------------------------
*** BEGIN of manual setup ***
-----------------------------
Note: Run $ sysctl -a |grep -i <parameter name> to view currently booted kernel parameters.
$ cat /etc/sysctl.d/99-sysctl.conf
+++++
...
...
...
#
# Oracle Pre-Install kernel settings
# Original values:
fs.file-max = 6815744 # 2424070
kernel.sem = 250 32000 100 128 # 250 32000 32 128
kernel.shmmni = 4096 # 4096
#kernel.shmall = 1073741824 # 18446744073692774399
#kernel.shmmax = 4398046511104 # 18446744073692774399
#kernel.panic_on_oops = 1 # 1
net.core.rmem_default = 262144 # 212992
#net.core.rmem_max = 4194304 # 16777216
#net.core.wmem_default = 262144 # 212992
#net.core.wmem_max = 1048576 # 16777216
#net.ipv4.conf.all.rp_filter = 2 # 1
#net.ipv4.conf.default.rp_filter = 2 # 1
fs.aio-max-nr = 1048576 # 65536
net.ipv4.ip_local_port_range = 9000 65500 # 32768 60999
+++++
$ /sbin/sysctl -p /etc/sysctl.conf
$ cp /etc/security/limits.conf /etc/security/limits.conf_bkp
$ cat /etc/security/limits.conf
+++++
...
...
...
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
+++++
---------------------------
*** END of manual setup ***
---------------------------
$ {
yum install -y bc
yum install -y binutils
yum install -y compat-libcap1
yum install -y compat-libstdc++-33
yum install -y dtrace-utils
yum install -y elfutils-libelf
yum install -y elfutils-libelf-devel
yum install -y fontconfig-devel
yum install -y glibc
yum install -y glibc-devel
yum install -y ksh
yum install -y libaio
yum install -y libaio-devel
yum install -y libdtrace-ctf-devel
yum install -y libXrender
yum install -y libXrender-devel
yum install -y libX11
yum install -y libXau
yum install -y libXi
yum install -y libXtst
yum install -y libgcc
yum install -y librdmacm-devel
yum install -y libstdc++
yum install -y libstdc++-devel
yum install -y libxcb
yum install -y make
yum install -y net-tools
yum install -y nfs-utils
yum install -y python
yum install -y python-configshell
yum install -y python-rtslib
yum install -y python-six
yum install -y targetcli
yum install -y smartmontools
yum install -y sysstat
yum install -y unixODBC
yum install -y dos2unix
yum install -y make
yum install -y binutils
yum install -y gcc
yum install -y libaio
yum install -y glibc-common
yum install -y libstdc++
yum install -y sysstat
yum install -y glibc
yum install -y glibc-devel.i686
yum install -y glibc-devel
yum install -y libXtst
}
$ groupadd -g 54321 oinstall
$ groupadd -g 54322 dba
$ groupadd -g 54323 oper
$ useradd -u 54321 -g oinstall -G dba,oper oracle
$ passwd oracle
$ cp /etc/selinux/config /etc/selinux/config_bkp
$ grep -i "selinux" /etc/selinux/config
+++++
SELINUX=permissive
+++++
$ setenforce Permissive /// OR /// $ reboot
+++++
setenforce: SELinux is disabled
+++++
$ systemctl stop firewalld
$ systemctl disable firewalld
$ mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
$ mkdir -p /u01/app/oraInventory
$ mkdir -p /u01/oradata
$ chown -R oracle:oinstall /u01
$ chmod -R 775 /u01
$ yum localinstall -y /u01/soft/rlwrap-0.42-1.el7.x86_64.rpm
@@@@@@@@@@@@@@@@@@@@@@@@@@@
Database Setup:
@@@@@@@@@@@@@@@@@@@@@@@@@@@
>>> oracle
$ cp /home/oracle/.bash_profile /home/oracle/.bash_profile_bkp
$ cat /home/oracle/.bash_profile
+++++
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export ORACLE_SID=CCDB
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORACLE_HOSTNAME=srv-rhel7-cc.oracle.com
export TMP=/tmp
export TMPDIR=$TMP
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export PS1='\[\033[0;32m\]$ORACLE_SID> \[\033[0;33m\]\u@\h\[\033[00m\] [\t] \w]\$ '
export OMS_HOME=/u01/app/oracle/middleware
export AGENT_HOME=/u01/app/middleware/agent
##
## Tools
##
alias rman="rlwrap ${ORACLE_HOME}/bin/rman"
alias sp="rlwrap ${ORACLE_HOME}/bin/sqlplus / as sysdba"
+++++
$ unzip /u01/soft/oracleDatabase_19cR3/LINUX.X64_193000_db_home.zip -d ${ORACLE_HOME}/
$ cd $ORACLE_HOME
$ ./runInstaller -ignorePrereq -waitforcompletion -silent \
-responseFile ${ORACLE_HOME}/install/response/db_install.rsp \
oracle.install.option=INSTALL_DB_SWONLY \
ORACLE_HOSTNAME=${ORACLE_HOSTNAME} \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
SELECTED_LANGUAGES=en,en_GB \
ORACLE_HOME=${ORACLE_HOME} \
ORACLE_BASE=${ORACLE_BASE} \
oracle.install.db.InstallEdition=EE \
oracle.install.db.OSDBA_GROUP=dba \
oracle.install.db.OSBACKUPDBA_GROUP=dba \
oracle.install.db.OSDGDBA_GROUP=dba \
oracle.install.db.OSKMDBA_GROUP=dba \
oracle.install.db.OSRACDBA_GROUP=dba \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
DECLINE_SECURITY_UPDATES=true
+++++
[WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2020-02-12_09-59-42AM.log
ACTION: Identify the list of failed prerequisite checks from the log: installActions2020-02-12_09-59-42AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
/u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2020-02-12_09-59-42AM.rsp
You can find the log of this install session at:
/tmp/InstallActions2020-02-12_09-59-42AM/installActions2020-02-12_09-59-42AM.log
As a root user, execute the following script(s):
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:
Execute /u01/app/oracle/product/19.0.0/dbhome_1/root.sh on the following nodes:
+++++
~ 5 min
$ vi ${ORACLE_HOME}/cfgtoollogs/oui/InstallActions2020-02-12_09-59-42AM/installActions2020-02-12_09-59-42AM.log
+++++
...
...
...
> 1904
INFO: [Feb 12, 2020 9:59:51 AM] ------------------List of failed Tasks------------------
INFO: [Feb 12, 2020 9:59:51 AM] *********************************************
INFO: [Feb 12, 2020 9:59:51 AM] Swap Size: This is a prerequisite condition to test whether sufficient total swap space is available on the system.
INFO: [Feb 12, 2020 9:59:51 AM] Severity:IGNORABLE
INFO: [Feb 12, 2020 9:59:51 AM] OverallStatus:VERIFICATION_FAILED
INFO: [Feb 12, 2020 9:59:51 AM] *********************************************
INFO: [Feb 12, 2020 9:59:51 AM] Package: gcc-c++-4.8.2: This is a prerequisite condition to test whether the package "gcc-c++-4.8.2" is available on the system.
INFO: [Feb 12, 2020 9:59:51 AM] Severity:IGNORABLE
INFO: [Feb 12, 2020 9:59:51 AM] OverallStatus:VERIFICATION_FAILED
INFO: [Feb 12, 2020 9:59:51 AM] -----------------End of failed Tasks List----------------
WARNING: [Feb 12, 2020 9:59:51 AM] [WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2020-02-12_09-59-42AM.log
ACTION: Identify the list of failed prerequisite checks from the log: installActions2020-02-12_09-59-42AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
...
...
...
+++++
>>> root
$ yum install -y gcc-c++
$ grep -i swap /proc/meminfo
+++++
SwapCached: 0 kB
SwapTotal: 4194300 kB
SwapFree: 4194300 kB
+++++
$ /u01/app/oraInventory/orainstRoot.sh
+++++
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
+++++
$ /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
+++++
Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_srv-rhel7-cc.oracle.com_2020-02-12_10-09-20-997101507.log for the output of root script
+++++
$ cat ${ORACLE_HOME}/network/admin/listener.ora
+++++
LICCDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv-rhel7-cc.oracle.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCLISTENER))
)
)
SID_LIST_LICCDB =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = CCDB)
(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
(SID_NAME = CCDB)
)
)
VALID_NODE_CHECKING_REGISTRATION_LICCDB=ON
+++++
$ cat ${ORACLE_HOME}/network/admin/tnsnames.ora
+++++
CCDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =srv-rhel7-cc.oracle.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CCDB)
)
)
+++++
$ lsnrctl start LICCDB
$ tnsping CCDB
$ dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname CCDB \
-characterSet AL32UTF8 \
-sysPassword *** \
-systemPassword *** \
-createAsContainerDatabase false \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 14156 \
-storageType FS \
-datafileDestination "/u01/oradata" \
-redoLogFileSize 100 \
-emConfiguration NONE \
-ignorePreReqs
+++++
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/CCDB.
Database Information:
Global Database Name:CCDB
System Identifier(SID):CCDB
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/CCDB/CCDB.log" for further details.
+++++
~ 10 min
$ sqlplus / as sysdba
SQL> alter system set "_allow_insert_with_update_check"=true scope=spfile;
SQL> alter system set session_cached_cursors=200 scope=spfile;
SQL> alter system set processes=600 scope=spfile;
SQL> alter system set "_use_single_log_writer"=true scope=spfile;
SQL> archive log list;
+++++
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch
Oldest online log sequence 9
Current log sequence 11
+++++
SQL> shu immediate;
SQL> startup;
$ cat /etc/oratab
+++++
...
...
...
CCDB:/u01/app/oracle/product/19.0.0/dbhome_1:N
+++++
@@@@@@@@@@@@@@@@@@@@@@@@@@@
OMS Setup:
@@@@@@@@@@@@@@@@@@@@@@@@@@@
//
// Ref. to https://oracle-base.com/articles/13c/cloud-control-13cr3-silent-installation-on-oracle-linux7
//
>>> oracle
$ mkdir -p /u01/app/oracle/middleware
$ mkdir -p /u01/app/oracle/agent
$ cd /u01/soft/cloudControl_13cR3/OMS
$ unzip V978760-01.zip
$ unzip V978761-01.zip
$ unzip V978762-01.zip
$ unzip V978763-01.zip
$ unzip V978764-01.zip
$ unzip V978765-01.zip
$ chmod -R 775 *
$ {
ORACLE_BASE=/u01/app/oracle
ORA_INVENTORY=/u01/app/oraInventory
ORACLE_HOSTNAME=${HOSTNAME}
DB_NAME=CCDB
SYS_PASSWORD=***
UNIX_GROUP_NAME=oinstall
MW_HOME=${ORACLE_BASE}/middleware
OMS_HOME=${MW_HOME}
GC_INST=${ORACLE_BASE}/gc_inst
AGENT_BASE=${ORACLE_BASE}/agent
WLS_USERNAME=weblogic
WLS_PASSWORD=***
SYSMAN_PASSWORD=${WLS_PASSWORD}
AGENT_PASSWORD=${WLS_PASSWORD}
SOFTWARE_LIBRARY=${ORACLE_BASE}/swlib
DATABASE_HOSTNAME=${HOSTNAME}
LISTENER_PORT=1521
SOFTWARE_DIR=/u01/soft/cloudControl_13cR3/OMS
}
$ cat > /home/oracle/cloud_swo_install.rsp <<EOF
RESPONSEFILE_VERSION=2.2.1.0.0
UNIX_GROUP_NAME=${UNIX_GROUP_NAME}
INVENTORY_LOCATION=${ORA_INVENTORY}
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
INSTALL_UPDATES_SELECTION=skip
ORACLE_MIDDLEWARE_HOME_LOCATION=${MW_HOME}
ORACLE_HOSTNAME=${ORACLE_HOSTNAME}
AGENT_BASE_DIR=${AGENT_BASE}
WLS_ADMIN_SERVER_USERNAME=${WLS_USERNAME}
WLS_ADMIN_SERVER_PASSWORD=${WLS_PASSWORD}
WLS_ADMIN_SERVER_CONFIRM_PASSWORD=${WLS_PASSWORD}
NODE_MANAGER_PASSWORD=${WLS_PASSWORD}
NODE_MANAGER_CONFIRM_PASSWORD=${WLS_PASSWORD}
ORACLE_INSTANCE_HOME_LOCATION=${GC_INST}
CONFIGURE_ORACLE_SOFTWARE_LIBRARY=true
SOFTWARE_LIBRARY_LOCATION=${SOFTWARE_LIBRARY}
DATABASE_HOSTNAME=${DATABASE_HOSTNAME}
LISTENER_PORT=${LISTENER_PORT}
SERVICENAME_OR_SID=${DB_NAME}
SYS_PASSWORD=${SYS_PASSWORD}
SYSMAN_PASSWORD=${SYSMAN_PASSWORD}
SYSMAN_CONFIRM_PASSWORD=${SYSMAN_PASSWORD}
DEPLOYMENT_SIZE=SMALL
AGENT_REGISTRATION_PASSWORD=${AGENT_PASSWORD}
AGENT_REGISTRATION_CONFIRM_PASSWORD=${AGENT_PASSWORD}
PLUGIN_SELECTION={}
b_upgrade=false
EM_INSTALL_TYPE=NOSEED
CONFIGURATION_TYPE=LATER
CONFIGURE_SHARED_LOCATION_BIP=false
EOF
$ chmod 775 /home/oracle/cloud_swo_install.rsp
$ dos2unix /home/oracle/cloud_swo_install.rsp
$ mkdir -p /u01/tmp
$ /u01/soft/cloudControl_13cR3/OMS/em13300_linux64.bin -silent -responseFile /home/oracle/cloud_swo_install.rsp -J-Djava.io.tmpdir=/u01/tmp
+++++
Setup successful
Agent OracleHome :/u01/app/oracle/agent/agent_13.3.0.0.0
OMS OracleHome :/u01/app/oracle/middleware
13NGCHEKAGGREGATE : OuiConfigVariables
13NGCHEKAGGREGATE : oracle.sysman.top.oms
13NGCHEKAGGREGATE : encap_oms
13NGCHEKAGGREGATE : oracle.sysman.top.agent
13NGCHEKAGGREGATE : OuiConfigVariables
Prompt for the allroot.sh
Warning: You must run the following configuration scripts as the "root" user.
/u01/app/oracle/middleware/allroot.sh
To execute the configuration scripts:
1. Open a new terminal window.
2. Login in as "root".
3. Run the scripts.
Successfully installed Enterprise Manager Cloud Control.
Logs successfully copied to /u01/app/oraInventory/logs.
+++++
~ 15 min
>>> root
$ /u01/app/oracle/middleware/allroot.sh
+++++
Starting to execute allroot.sh .........
Starting to execute /u01/app/oracle/middleware/root.sh ......
/etc exist
Creating /etc/oragchomelist file...
/u01/app/oracle/middleware
Finished product-specific root actions.
/etc exist
/u01/app/oracle/agent/agent_13.3.0.0.0
Finished execution of /u01/app/oracle/middleware/root.sh ......
Starting to execute /u01/app/oracle/agent/agent_13.3.0.0.0/root.sh ......
Finished product-specific root actions.
/etc exist
/u01/app/oracle/agent/agent_13.3.0.0.0
Finished execution of /u01/app/oracle/agent/agent_13.3.0.0.0/root.sh ......
+++++
>>> oracle
$ cat > /home/oracle/cloud_setup.rsp <<EOF
RESPONSEFILE_VERSION=2.2.1.0.0
UNIX_GROUP_NAME=${UNIX_GROUP_NAME}
INVENTORY_LOCATION=${ORA_INVENTORY}
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
INSTALL_UPDATES_SELECTION=skip
ORACLE_MIDDLEWARE_HOME_LOCATION=${MW_HOME}
ORACLE_HOSTNAME=${ORACLE_HOSTNAME}
AGENT_BASE_DIR=${AGENT_BASE}
WLS_ADMIN_SERVER_USERNAME=${WLS_USERNAME}
WLS_ADMIN_SERVER_PASSWORD=${WLS_PASSWORD}
WLS_ADMIN_SERVER_CONFIRM_PASSWORD=${WLS_PASSWORD}
NODE_MANAGER_PASSWORD=${WLS_PASSWORD}
NODE_MANAGER_CONFIRM_PASSWORD=${WLS_PASSWORD}
ORACLE_INSTANCE_HOME_LOCATION=${GC_INST}
CONFIGURE_ORACLE_SOFTWARE_LIBRARY=true
SOFTWARE_LIBRARY_LOCATION=${SOFTWARE_LIBRARY}
DATABASE_HOSTNAME=${DATABASE_HOSTNAME}
LISTENER_PORT=${LISTENER_PORT}
SERVICENAME_OR_SID=${DB_NAME}
SYS_PASSWORD=${SYS_PASSWORD}
SYSMAN_PASSWORD=${SYSMAN_PASSWORD}
SYSMAN_CONFIRM_PASSWORD=${SYSMAN_PASSWORD}
DEPLOYMENT_SIZE=SMALL
AGENT_REGISTRATION_PASSWORD=${AGENT_PASSWORD}
AGENT_REGISTRATION_CONFIRM_PASSWORD=${AGENT_PASSWORD}
PLUGIN_SELECTION={}
b_upgrade=false
EM_INSTALL_TYPE=NOSEED
CONFIGURATION_TYPE=ADVANCED
CONFIGURE_SHARED_LOCATION_BIP=false
EOF
$ chmod 775 /home/oracle/cloud_setup.rsp
$ dos2unix /home/oracle/cloud_setup.rsp
$ /u01/app/oracle/middleware/sysman/install/ConfigureGC.sh -silent -responseFile /home/oracle/cloud_setup.rsp
+++++
*** The Installation was Successful. ***
This information is also available at:
/u01/app/oracle/middleware/install/setupinfo.txt
See the following for information pertaining to your Enterprise Manager installation:
Use the following URL to access:
1. Enterprise Manager Cloud Control URL: https://srv-rhel7-cc.oracle.com:7803/em
2. Admin Server URL: https://srv-rhel7-cc.oracle.com:7102/console
3. BI Publisher URL: https://srv-rhel7-cc.oracle.com:9803/xmlpserver/servlet/home
The following details need to be provided while installing an additional OMS:
1. Admin Server Host Name: srv-rhel7-cc.oracle.com
2. Admin Server Port: 7102
You can find the details on ports used by this deployment at : /u01/app/oracle/middleware/install/portlist.ini
NOTE:
An encryption key has been generated to encrypt sensitive data in the Management Repository. If this key is lost, all encrypted data in the Repository becomes unusable.
A backup of the OMS configuration is available in /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/backup on host srv-rhel7-cc.oracle.com. See Cloud Control Administrators Guide for details on how to back up and recover an OMS.
NOTE: This backup is valid only for the initial OMS configuration. For example, it will not reflect plug-ins installed later, topology changes like the addition of a load balancer, or changes to other properties made using emctl or emcli. Backups should be created on a regular basis to ensure they capture the current OMS configuration. Use the following command to backup the OMS configuration:
/u01/app/oracle/middleware/bin/emctl exportconfig oms -dir <backup dir>
Prompt for the allroot.sh
+++++
~ 50 min
$ mv /home/oracle/cloud_setup.rsp /u01/soft/cloudControl_13cR3/rsp_files_template/
>>> Login as "SYSMAN" user: https://srv-rhel7-cc.oracle.com:7803/em
Click "Save and Continue"
Click "I Accept"
Select and Click Main Page "Services"
//
// Disable lines in file "/etc/oragchomelist" to avoid cloud autostart without database after server reboot/crush [!!!]
//
>>> oracle
$ cat /etc/oragchomelist
+++++
# Manually disabled by DBA
#/u01/app/oracle/middleware
#/u01/app/oracle/agent/agent_13.3.0.0.0:/u01/app/oracle/agent/agent_inst
+++++
//
// Prepare custom start/stop scripts
//
>>> oracle
$ {
mkdir -p /home/oracle/dba
mkdir -p /home/oracle/dba/scripts
mkdir -p /home/oracle/dba/logs
mkdir -p /home/oracle/dba/backups
mkdir -p /home/oracle/dba/patches
}
$ cat /home/oracle/dba/scripts/oms.sh
+++++
#!/bin/bash
#
# Description: Scripts to stop/start OMS services
#
# Usage:
# ./oms.sh stop
# ./oms.sh start
# ./oms.sh help
#
#---------------------
# Variables:
#---------------------
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
export OMS_HOME=/u01/app/oracle/middleware
export AGENT_HOME=/u01/app/oracle/agent/agent_inst
#---------------------
# Functions:
#---------------------
___help() {
echo "Usage:
./oms.sh stop
./oms.sh start
./oms.sh help";
return 0;
}
___stop() {
${OMS_HOME}/bin/emctl stop oms -all
if [[ $? != 0 ]];
then
echo "ERROR: OMS shutdown failed.";
return 1;
fi
${AGENT_HOME}/bin/emctl stop agent
if [[ $? != 0 ]];
then
echo "ERROR: Agent shutdown failed.";
return 1;
fi
return 0;
}
___start() {
${OMS_HOME}/bin/emctl start oms
if [[ $? != 0 ]];
then
echo "ERROR: OMS startup failed.";
return 1;
fi
${AGENT_HOME}/bin/emctl start agent
if [[ $? != 0 ]];
then
echo "ERROR: Agent startup failed.";
return 1;
fi
return 0;
}
#---------------------
# Main:
#---------------------
if [[ $# != 1 ]];
then
___help
elif [[ $1 == "stop" ]];
then
___stop
elif [[ $1 == "start" ]];
then
___start
else
___help
fi
+++++
@@@@@@@@@@@@@@@@@@@@@@@@@@@
Database patching:
@@@@@@@@@@@@@@@@@@@@@@@@@@@
>>> oracle
$ opatch lspatches
+++++
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
OPatch succeeded.
+++++
SQL> set lines 222 pages 999;
col COMMENTS format a60;
col ACTION format a11;
col VERSION format a15;
col NAMESPACE format a10;
col BUNDLE_SERIES format a10;
col ACTION_TIME format a35;
select * from registry$history order by ACTION_TIME;
+++++
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SER
----------------------------------- ----------- ---------- --------------- ---------- ------------------------------------------------------------ ----------
12-FEB-20 11.07.30.821718 AM RU_APPLY SERVER 19.0.0.0.0 Patch applied on 19.3.0.0.0: Release_Update - 190410122720
BOOTSTRAP DATAPATCH 19 RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
+++++
//
// Stop OMS services
//
$ /home/oracle/dba/scripts/oms.sh stop
//
// Update "OPatch" (if required)
//
##$ mv ${ORACLE_HOME}/OPatch ${ORACLE_HOME}/OPatch_bkp_12022020
##$ unzip /u01/soft/oracleDatabase_19cR3/patches_19cR5_OPatch/p6880880_121010_Linux-x86-64.zip -d ${ORACLE_HOME}/
$ opatch version
+++++
OPatch Version: 12.2.0.1.17
OPatch succeeded.
+++++
//
// Stop Database and Listener
//
$ sqlplus / as sysdba
SQL> shu immediate;
$ lsnrctl stop LICCDB
//
// Patch 30125133: DATABASE RELEASE UPDATE 19.5.0.0.0
//
$ cd /u01/soft/oracleDatabase_19cR3/patches_19cR5_OPatch
$ unzip p30125133_190000_Linux-x86-64.zip
$ cd 30125133
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
+++++
OPatch succeeded.
+++++
$ opatch apply
+++++
OPatch succeeded.
+++++
~ 4 min
$ egrep -i "error|fail|ora-|ac-|rc-" /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-02-12_17-17-27PM_1.log
//
// Patch 30128191 - Oracle JavaVM Component Release Update 19.5.0.0.191015
//
$ cd /u01/soft/oracleDatabase_19cR3/patches_19cR5_OPatch
$ unzip p30128191_190000_Linux-x86-64.zip
$ cd 30128191
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
+++++
OPatch succeeded.
+++++
$ opatch apply
+++++
OPatch succeeded.
+++++
~ 2 min
$ egrep -i "error|fail|ora-|ac-|rc-" /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-02-12_17-21-45PM_1.log
//
// Post-apply steps
//
$ sqlplus / as sysdba
SQL> startup upgrade;
$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose
+++++
Validating logfiles...done
Patch 30125133 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30125133/23151502/30125133_apply_CCDB_2020Feb12_17_25_54.log (no errors)
Patch 30128191 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/30128191/23093535/30128191_apply_CCDB_2020Feb12_17_25_01.log (no errors)
SQL Patching tool complete on Wed Feb 12 17:28:20 2020
+++++
~ 5 min
$ egrep -i "error|fail|ora-|ac-|rc-" /u01/app/oracle/cfgtoollogs/sqlpatch/30125133/23151502/30125133_apply_CCDB_2020Feb12_17_25_54.log
$ egrep -i "error|fail|ora-|ac-|rc-" /u01/app/oracle/cfgtoollogs/sqlpatch/30128191/23093535/30128191_apply_CCDB_2020Feb12_17_25_01.log
SQL> shutdown;
SQL> startup;
SQL> exec utl_recomp.recomp_parallel(8);
SQL> select count(*) from dba_objects where status<>'VALID';
+++++
COUNT(*)
----------
0
+++++
$ lsnrctl start LICCDB
$ opatch lspatches
+++++
30128191;OJVM RELEASE UPDATE: 19.5.0.0.191015 (30128191)
30125133;Database Release Update : 19.5.0.0.191015 (30125133)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
OPatch succeeded.
+++++
SQL> set lines 222 pages 999;
col COMMENTS format a80;
col ACTION format a11;
col VERSION format a30;
col NAMESPACE format a10;
col BUNDLE_SERIES format a10;
col ACTION_TIME format a35;
select * from registry$history order by ACTION_TIME;
+++++
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SER
----------------------------------- ----------- ---------- ------------------------------ ---------- -------------------------------------------------------------------------------- ----------
12-FEB-20 11.07.30.821718 AM RU_APPLY SERVER 19.0.0.0.0 Patch applied on 19.3.0.0.0: Release_Update - 190410122720
12-FEB-20 05.25.54.057944 PM jvmpsu.sql SERVER 19.5.0.0.191015OJVMRU 0 RAN jvmpsu.sql
12-FEB-20 05.25.54.071516 PM APPLY SERVER 19.5.0.0.191015OJVMRU 0 OJVM RU post-install
12-FEB-20 05.28.02.037805 PM RU_APPLY SERVER 19.0.0.0.0 Patch applied from 19.3.0.0.0 to 19.5.0.0.0: Release_Update - 190909180549
BOOTSTRAP DATAPATCH 19 RDBMS_19.5.0.0.0DBRU_LINUX.X64_190909
+++++
//
// Start OMS
//
$ /home/oracle/dba/scripts/oms.sh start
@@@@@@@@@@@@@@@@@@@@@@@@@@@
OMS Patching:
@@@@@@@@@@@@@@@@@@@@@@@@@@@
//
// Ref. to "EM 13c: How to Apply a Patch to the Enterprise Manager 13c Cloud Control OMS Oracle Home (Doc ID 2091619.1)"
//
//
// Stop OMS
//
$ /home/oracle/dba/scripts/oms.sh stop
##
## Patch 19999993: OMSPatches patch of version 13.8.0.0.3 for Enterprise Manager Cloud Control 13.3.0.0.0
##
$ ${OMS_HOME}/OMSPatcher/omspatcher version
+++++
OMSPatcher Version: 13.8.0.0.0
OPlan Version: 12.1.0.2.2
OsysModel build: Mon Dec 21 18:31:52 PST 2015
OMSPatcher succeeded.
+++++
$ mv ${OMS_HOME}/OMSPatcher ${OMS_HOME}/OMSPatcher_bkp
$ unzip /u01/soft/cloudControl_13cR3/patch/p19999993_133000_Generic.zip -d ${OMS_HOME}/
$ ${OMS_HOME}/OMSPatcher/omspatcher version
+++++
OMSPatcher Version: 13.8.0.0.3
OPlan Version: 12.1.0.2.2
OsysModel build: Mon Dec 21 18:31:52 PST 2015
OMSPatcher succeeded.
+++++
##
## Patch (OPatch) 6880880: Version 13.9.3.3.0
##
=> Agent
$ cd /u01/soft/cloudControl_13cR3/patch/
$ unzip p6880880_139000_Generic.zip
$ export ORACLE_HOME=/u01/app/oracle/agent/agent_13.3.0.0.0
$ cd 6880880
$ $ORACLE_HOME/jdk/bin/java -jar opatch_generic.jar -silent oracle_home=$ORACLE_HOME
=> OMS
$ export ORACLE_HOME=/u01/app/oracle/middleware
$ cd /u01/soft/cloudControl_13cR3/patch/6880880
$ $ORACLE_HOME/oracle_common/jdk/bin/java -jar opatch_generic.jar -silent oracle_home=$ORACLE_HOME
//
// Start all OMS services
//
$ /home/oracle/dba/scripts/oms.sh start
##
## Patch 30203475: EMBP Patch Set Update 13.3.0.0.191015
##
-> Prerequisites:
[+] WebLogic server is Up and Running
[+] Repository Database is Up and Running
[+] Latest OMSPatcher=13.8.0.0.3 and OPatch=13.9.0.0.0
$ ${OMS_HOME}/OMSPatcher/omspatcher version
+++++
OMSPatcher Version: 13.8.0.0.3
OPlan Version: 12.2.0.1.6
OsysModel build: Tue Sep 04 18:15:05 PDT 2018
OMSPatcher succeeded.
+++++
$ /u01/app/oracle/middleware/OPatch/opatch version
+++++
OPatch Version: 13.9.3.3.0
OPatch succeeded.
+++++
[+] Set ORACLE_HOME=<MW_HOME> (/u01/app/oracle/middleware in my case)
$ echo $ORACLE_HOME
+++++
/u01/app/oracle/middleware
+++++
[+] Ensure that PATH includes <ORACLE_HOME>/bin && <ORACLE_HOME>/OMSPatcher
$ export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$ORACLE_HOME/OMSPatcher:$PATH
-> Patching steps:
[+] Stop OMS services:
$ $ORACLE_HOME/bin/emctl stop oms
+++++
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved.
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down
+++++
[+] Unzip and Analyze the patch:
$ cd /u01/soft/cloudControl_13cR3/patch
$ unzip p30203475_133000_Generic.zip
$ cd 30203475
$ omspatcher apply -analyze
+++++
Log file location: /u01/app/oracle/middleware/cfgtoollogs/omspatcher/30203475/omspatcher_2020-02-13_11-36-14AM_analyze.log
OMSPatcher succeeded.
+++++
[+] Apply the patch:
$ cd /u01/soft/cloudControl_13cR3/patch/30203475
$ omspatcher apply
+++++
Deployment summary:
-------------------
The following artifact(s) have been successfully deployed:
Artifacts Log file
--------- --------
SQL rcu_applypatch_original_patch_2020-02-13_11-43-24AM.log
MRS-swlib emctl_register_swlib_2020-02-13_11-44-35AM.log
MRS-swlib emctl_register_swlib_2020-02-13_11-44-42AM.log
MRS-swlib emctl_register_swlib_2020-02-13_11-44-49AM.log
MRS-targetType emctl_register_targetType_2020-02-13_11-44-55AM.log
MRS-storeTargetType emctl_register_storeTargetType_2020-02-13_11-45-00AM.log
MRS-default_collection emctl_register_default_collection_2020-02-13_11-45-05AM.log
Log file location: /u01/app/oracle/middleware/cfgtoollogs/omspatcher/30203475/omspatcher_2020-02-13_11-39-59AM_deploy.log
OMSPatcher succeeded.
+++++
~ 7 min
[+] Start OMS:
$ /home/oracle/dba/scripts/oms.sh start
[+] HealthCheck:
@@@@@@@@@@@@@@@@@@@@@@@@@@@
Check Plug-in's versions:
@@@@@@@@@@@@@@@@@@@@@@@@@@@
//
// Check OMS current plug-in's
//
$ cd /u01/app/oracle/middleware/bin
$ ./emcli login -username=sysman
$ ./emcli list_plugins_on_server
+++++
OMS name is srv-rhel7-cc.oracle.com:4889_Management_Service
Plug-in Name Plugin-id Version [revision]
Oracle Cloud Framework oracle.sysman.cfw 13.3.1.0.0
Oracle Database oracle.sysman.db 13.3.1.0.0
Oracle Fusion Middleware oracle.sysman.emas 13.3.1.0.0
Systems Infrastructure oracle.sysman.si 13.3.1.0.0
Oracle Exadata oracle.sysman.xa 13.3.1.0.0
+++++
//
// Check Agent Plug-in's
//
$ cd /u01/app/oracle/agent/agent_13.3.0.0.0/bin/
$ ./emctl listplugins agent -type all
+++++
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
oracle.sysman.emas 13.3.1.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.emas.agent.plugin_13.3.1.0.0
oracle.sysman.emrep 13.3.0.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.emrep.agent.plugin_13.3.0.0.0
oracle.sysman.beacon 13.3.0.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.beacon.agent.plugin_13.3.0.0.0
oracle.sysman.oh 13.3.0.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.oh.agent.plugin_13.3.0.0.0
oracle.sysman.csa 13.3.0.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.csa.agent.plugin_13.3.0.0.0
oracle.sysman.emas 13.3.1.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.emas.discovery.plugin_13.3.1.0.0
oracle.sysman.db 13.3.1.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.db.discovery.plugin_13.3.1.0.0
oracle.sysman.si 13.3.1.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.si.discovery.plugin_13.3.1.0.0
oracle.sysman.csa 13.3.0.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.csa.discovery.plugin_13.3.0.0.0
oracle.sysman.oh 13.3.0.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.oh.discovery.plugin_13.3.0.0.0
oracle.sysman.xa 13.3.1.0.0 /u01/app/oracle/agent/agent_13.3.0.0.0/plugins/oracle.sysman.xa.discovery.plugin_13.3.1.0.0
+++++
@@@@@@@@@@@@@@@@@@@@@@@@@@@
Increase OMS_HEAP_MAX:
@@@@@@@@@@@@@@@@@@@@@@@@@@@
>>> oracle
$ $OMS_HOME/bin/emctl get property -name OMS_HEAP_MAX
+++++
Value for property OMS_HEAP_MAX for oms local_oms is 1740M
+++++
$ $OMS_HOME/bin/emctl set property -name OMS_HEAP_MAX -value 4096M
+++++
Property OMS_HEAP_MAX for oms srv-rhel7-cc.oracle.com:4889_Management_Service has been set to value 4096M
OMS restart is required to reflect the new property value
+++++
$ /home/oracle/dba/scripts/oms.sh stop
$ /home/oracle/dba/scripts/oms.sh start
@@@@@@@@@@@@@@@@@@@@@@@@@@@
Summary:
@@@@@@@@@@@@@@@@@@@@@@@@@@@
Enterprise Manager Cloud Control URL: https://srv-rhel7-cc.oracle.com:7803/em
Admin Server URL: https://srv-rhel7-cc.oracle.com:7102/console
BI Publisher URL: https://srv-rhel7-cc.oracle.com:9803/xmlpserver/servlet/home