Enterprise Manager
Simple notes on installing Oracle Enterprise Manager...
yum -y install oracle-database-preinstall-19c
yum -y wget
use the 'wget' script from Oracle's edelivery to download Enterprise Manager.
Remember, you must login to edelivery via web browser before the 'wget' script will work.
[oracle@enterprise-manager ~]$ unzip V987606-01.zip
Archive: V987606-01.zip
inflating: README_EM_13400_Shiphome_Extraction_linux86-64.txt
Oracle Enterprise Manager Cloud Control 13c Release 4 for Linux x86-64 bit
This document contains information on the Oracle Enterprise Manager Cloud Control 13c Release 4 Shiphome extraction information.
Extraction of Oracle Enterprise Manager 13c Release 4 Shiphome
============================================================================================================
Downloading the files
---------------------
1. Download the all shiphome zips files, for each platform there are 7 files example as shown below
/scratch/V123451-01.zip
/scratch/V123452-01.zip
/scratch/V123453-01.zip
/scratch/V123454-01.zip
/scratch/V123455-01.zip
/scratch/V123456-01.zip
/scratch/V123456-01.zip
2. The downloaded files are compressed with the zip format. Use any unzip tool to uncompress the file, or download a utility from eDelivery http://updates.oracle.com/unzips/unzips.html. This will generate the compressed zip files.
# cd /scratch
#unzip V123451-01.zip
#unzip V123452-01.zip
#unzip V123453-01.zip
#unzip V123454-01.zip
#unzip V123455-01.zip
#unzip V123456-01.zip
#unzip V123456-01.zip
Uncompressing the .zip files will create shiphome files ending with .bin & .zip extension.
3. Start installation using the executable binary
For example
# ./em13400_linux_x64.bin
Follow the install flow as provided in the Enterprise Manager Basic Installation Guide.
We're smarter than that...
unzip '*.zip'
Some more notes...
Goals:
1)
yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
Download Oracle Database 19.3.0.0.0 from edelivery.
https://edelivery.oracle.com/osdc/softwareDownload?fileName=V982063-01.zip
[root@enterprise-manager opt]# mkdir /opt/oracle
[root@enterprise-manager opt]# chown oracle:oinstall /opt/oracle
use the 'wget' script. Enter username & password. (No prompt for password.) You know it's working if it doesn't error out. Tail the generated log file to prove it's downloading.
Download patch from support.
Search on 19.0.0.0.0 (recommended patches only)
Find GI Release Update 19.7
Patch 30899722: GI RELEASE UPDATE 19.7.0.0.0
set oracle base to /ora/app/oracle
mkdir -p /opt/oracle/database/19c
unzip -d /opt/oracle/database/19c V982063-01.zip
cd /opt/oracle/database/19c
./runInstaller
setup software only
[root@enterprise-manager opt]# mkdir oraInventory
[root@enterprise-manager opt]# chown oracle:oinstall oraInventory
export ORACLE_HOME=/opt/oracle/database/19c
export PATH=$ORACLE_HOME/OPatch:$PATH
cd into each patch directory
opatch apply
---
dbca
edit /etc/oratab
---
enterprise manager, software only...
/home/oracle/manager/sysman/install/ConfigureGC.sh
alter system set "_allow_insert_with_update_check" = true;
show parameter adaptive;
Prerequisite Name = Check if all adaptive features parameters are unset
Prerequisite Detailed Name = Check if all adaptive features parameters are unset
Prerequisite Status = fail
Prerequisite Recommendation = All adaptive features parameters should be unset for improved SQL performance
Prerequisite Detailed Recommendation = Run the command as sysdba.
alter system set "_optimizer_nlj_hj_adaptive_join"= FALSE scope=both sid='*'; alter system set "_optimizer_strans_adaptive_pruning" = FALSE scope=both sid='*'; alter system set "_px_adaptive_dist_method" = OFF scope=both sid='*'; alter system set "_sql_plan_directive_mgmt_control" = 0 scope=both sid='*'; alter system set "_optimizer_dsdir_usage_control" = 0 scope=both sid='*'; alter system set "_optimizer_use_feedback" = FALSE scope=both sid='*'; alter system set "_optimizer_gather_feedback" = FALSE scope=both sid='*'; alter system set "_optimizer_performance_feedback" = OFF scope=both sid='*';
restart the db.
---