24 de Julio de 2023
Raúl Antonio Molina Alvarenga
#OracleACEAssociate
#Oracletipssv
Me pareció interesante publicar una entrada de articulo respecto a la instalación de un Cloud control completamente en modo silencioso o completamente desatendido.
Digo interesante porque, para mi lo es, dado que usualmente estamos acostumbrados a usar pantallas de un asistente que responden a nuestra interacción.
El Cloud Control es una arquitectura de Software Empresaria muy robusta que permite al menos el monitoreo de otros componentes Oracle, entre base de datos, Servidores de aplicaciones, Servidores físicos, Virtuales, un diagrama que presenta la solución:
Usaremos Rutas estándar de producto, como por ejemplo el GI HOME:
/u01/app/19.0.0/grid
Algunas configuraciones no serán tomadas en detalle pues no es el foco del guion.
Configuraciones del Sistema Operativo
Limites
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
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 16384
grid hard nproc 16384
grid soft stack 10240
grid hard stack 32768
grid hard memlock 134217728
grid soft memlock 134217728
Lo escencial es configurar con el RPM de Preinstall RDBMS:
https://yum.oracle.com/repo/OracleLinux/OL8/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
Download el RPM del public :
http://public-yum.oracle.com/repo/OracleLinux/OL8/baseos/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm
GI
Y luego instalar el GI
./gridSetup.sh -silent -responseFile /u01/app/19.0.0/grid/install/response/gridsetup.rsp
Si se presenta problema hacer dicho workaround:
Solution
To solve INS-08101 ‘supportedOSCheck’, we trick OUI to think the operating system is release 7.8 by using an environment variable CV_ASSUME_DISTID, either temporarily or permanently.
1. Temporarily
At runtime, we can export the variable.
[oracle@ora19c dbhome_1]$ export CV_ASSUME_DISTID=OEL8.1
RDBMS
Una vez se ha configurado el GI, procedemos con el RDBMS:
./runInstaller -ignorePrereq -waitforcompletion -silent \
-responseFile /u01/app/oracle/product/19.0.0/db_1/install/response/db_install.rsp \
oracle.install.option=INSTALL_DB_SWONLY \
ORACLE_HOSTNAME=PLVORAGRID \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
SELECTED_LANGUAGES=en,en_GB \
ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1 \
ORACLE_BASE=/u02/app/oracle \
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
Creamos la BD que albergara el REPO del componente de OMR
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname emcdb -sid emcdb -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword SysPassword1 \
-systemPassword SysPassword1 \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName emrep \
-pdbAdminPassword SysPassword1 \
-databaseType MULTIPURPOSE \
-memoryMgmtType auto_sga \
-totalMemory 2048 \
-storageType ASM \
-diskGroupName +DATA \
-redoLogFileSize 600 \
-emConfiguration NONE \
-ignorePreReqs
Aplicamos un RU en ambas capas
opatchauto apply /installMedia/32126842/32067171
Host:plvoragrid
SIHA Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /installMedia/32126842/32067171
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-02-09_13-44-06PM_1.log
OPatchauto session completed at Tue Feb 9 13:47:37 2021
Time taken to complete the session 6 minutes, 5 seconds
[root@PLVORAGRID 32067171]#
32067171;OJVM RELEASE UPDATE: 19.10.0.0.210119 (32067171)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
OPatch succeeded.
La configuración de la maquina quedaría así con el HAS:
crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE plvoragrid STABLE
ora.LISTENER.lsnr
ONLINE ONLINE plvoragrid STABLE
ora.asm
ONLINE ONLINE plvoragrid Started,STABLE
ora.ons
OFFLINE OFFLINE plvoragrid STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE plvoragrid STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.emcdb.db
1 ONLINE ONLINE plvoragrid Open,HOME=/u01/app/o
racle/product/19.0.0
/db_1,STABLE
ora.evmd
1 ONLINE ONLINE plvoragrid STABLE
--------------------------------------------------------------------------------
[grid@PLVORAGRID ~]$ asmcmd lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 307188 301880 0 301880 0 N DATA/
A la base de datos, hay que ajustarle algunas configuraciones :
alter system set db_create_file_dest='${DATA_DIR}';
alter pluggable database ${PDB_NAME} save state;
-- Recommended minimum settings.
alter system set "_allow_insert_with_update_check"=true scope=both;
alter system set session_cached_cursors=200 scope=spfile;
-- Recommended: processes=600
alter system set processes=600 scope=spfile;
-- Recommended: pga_aggregate_target=1G
alter system set pga_aggregate_target=450M scope=spfile;
-- Recommended: sga_target=3G
alter system set sga_target=800M scope=spfile;
-- Recommended: shared_pool_size=600M
--alter system set shared_pool_size=600M scope=spfile;
-- For 12.1.0.2 set the following.
--alter system set optimizer_adaptive_features=false scope=both;
-- Should not be needed for 19c, but installer fails without them.
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='*';
SHUTDOWN IMMEDIATE;
STARTUP;
Instalación del Cloud Control
Parametros para response file de Cloud Control
# Set parameters.
ORACLE_BASE=/u02/app/oracle
UNIX_GROUP_NAME=oinstall
ORA_INVENTORY=/u01/app/oraInventory
MW_HOME=/u01/app/oracle/middleware
ORACLE_HOSTNAME=${HOSTNAME}
AGENT_BASE=/u01/app/oracle/agent
WLS_USERNAME=weblogic
WLS_PASSWORD=Welcome1
GC_INST=${ORACLE_BASE}/gc_inst
SOFTWARE_LIBRARY=/u02/app/oracle/swlib
DATABASE_HOSTNAME=${HOSTNAME}
LISTENER_PORT=1521
PDB_NAME=emrep
SYS_PASSWORD=SysPassword1
AGENT_PASSWORD=${WLS_PASSWORD}
ORACLE_SID=emcdb
DATA_DIR=+DATA
OMS_HOME=${MW_HOME}
SYSMAN_PASSWORD=${WLS_PASSWORD}
SOFTWARE_DIR=/installMedia/
cat > /tmp/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=${PDB_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
MANAGEMENT_TABLESPACE_LOCATION=${DATA_DIR}/${ORACLE_SID^^}/${PDB_NAME}/mgmt.dbf
CONFIGURATION_DATA_TABLESPACE_LOCATION=${DATA_DIR}/${ORACLE_SID^^}/${PDB_NAME}/mgmt_ecm_depot1.dbf
JVM_DIAGNOSTICS_TABLESPACE_LOCATION=${DATA_DIR}/${ORACLE_SID^^}/${PDB_NAME}/mgmt_deepdive.dbf
EOF
Lanzamos el instalador para que despliegue el Software completo, mas no realizara configuración, prefiero que se haga así , por si hay algún error podemos corregirlo, no esta de mas que indique que si se puede realizar un backup de BD (o un punto de restauración con garantía) que permita revertir la BD completa a un punto en el tiempo, seria prudente.
./em13400_linux64.bin -silent -responseFile /tmp/install.rsp -J-Djava.io.tmpdir=/u02/tmp/
Una vez el instalador termine, podemos lanzar otro punto de control o reversion de estado de la BD completa, y lanzar el asistente de configuracion del Cloud Control 13c.
Al final adjunto los logs de ambos procesos.
cat > /tmp/config.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=${PDB_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
MANAGEMENT_TABLESPACE_LOCATION=${DATA_DIR}/${ORACLE_SID^^}/${PDB_NAME}/mgmt.dbf
CONFIGURATION_DATA_TABLESPACE_LOCATION=${DATA_DIR}/${ORACLE_SID^^}/${PDB_NAME}/mgmt_ecm_depot1.dbf
JVM_DIAGNOSTICS_TABLESPACE_LOCATION=${DATA_DIR}/${ORACLE_SID^^}/${PDB_NAME}/mgmt_deepdive.dbf
EOF
./sysman/install/ConfigureGC.sh -silent -responseFile /tmp/config.rsp
Al finalizar, tendremos un producto Cloud Control 13c correctamente instalado.
Espero les sea de Utilidad.
Saludos
Logs
Launcher log file is /tmp/OraInstall2021-02-09_05-15-05PM/launcher2021-02-09_05-15-05PM.log.
Extracting the installer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Done
Checking swap space: must be greater than 512 MB. Actual 16383 MB Passed
Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required)
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2021-02-09_05-15-05PM
====Prereq Config Location main===
/tmp/OraInstall2021-02-09_05-15-05PM/stage/prereq
EMGCInstaller args -scratchPath
EMGCInstaller args /tmp/OraInstall2021-02-09_05-15-05PM
EMGCInstaller args -sourceType
EMGCInstaller args network
EMGCInstaller args -timestamp
EMGCInstaller args 2021-02-09_05-15-05PM
EMGCInstaller args -paramFile
EMGCInstaller args /tmp/sfx_okyBMq/Disk1/install/linux64/oraparam.ini
EMGCInstaller args -silent
EMGCInstaller args -responseFile
EMGCInstaller args /tmp/install.rsp
EMGCInstaller args -nocleanUpOnExit
DiskLoc inside SourceLoc/tmp
EMFileLoc:/tmp/OraInstall2021-02-09_05-15-05PM/oui/em/
ScratchPathValue :/tmp/OraInstall2021-02-09_05-15-05PM
EMGCInstallUpdatesInfoOnNext:: calling actionOnClickofNext
Now in EMGCInstallUpdatesInfoOnNext.actionsOnClickofNext
EMGCInstallUpdatesInfoOnNext:: End of actionOnClickofNext
Some recommended prerequisites checks failed. You might encounter errors during installation. Fix those prerequisites and start the installation again.
Unable to copy the logs to the permanent location: The permanent log directory is unknown (null)..
The log(s) can be found here: /tmp/OraInstall2021-02-09_05-15-05PM.
<eFile /tmp/install.rsp -J-Djava.io.tmpdir=/u02/tmp/
ERROR: Cannot create the extract directory in /u02/tmp (Permission denied).
ERROR: Cannot setup the extract directory /u02/tmp/sfx_kOG195 (-1).
<eFile /tmp/install.rsp -J-Djava.io.tmpdir=/u02/tmp/
Launcher log file is /u02/tmp/OraInstall2021-02-09_05-18-26PM/launcher2021-02-09_05-18-26PM.log.
Extracting the installer . . . . . . . . . . . . . . . . . . . . . . . . . . . . Done
Checking swap space: must be greater than 512 MB. Actual 16383 MB Passed
Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required)
Preparing to launch the Oracle Universal Installer from /u02/tmp/OraInstall2021-02-09_05-18-26PM
====Prereq Config Location main===
/u02/tmp/OraInstall2021-02-09_05-18-26PM/stage/prereq
EMGCInstaller args -scratchPath
EMGCInstaller args /u02/tmp/OraInstall2021-02-09_05-18-26PM
EMGCInstaller args -sourceType
EMGCInstaller args network
EMGCInstaller args -timestamp
EMGCInstaller args 2021-02-09_05-18-26PM
EMGCInstaller args -paramFile
EMGCInstaller args /u02/tmp/sfx_vCLaNi/Disk1/install/linux64/oraparam.ini
EMGCInstaller args -silent
EMGCInstaller args -responseFile
EMGCInstaller args /tmp/install.rsp
EMGCInstaller args -nocleanUpOnExit
DiskLoc inside SourceLoc/u02/tmp
EMFileLoc:/u02/tmp/OraInstall2021-02-09_05-18-26PM/oui/em/
ScratchPathValue :/u02/tmp/OraInstall2021-02-09_05-18-26PM
EMGCInstallUpdatesInfoOnNext:: calling actionOnClickofNext
Now in EMGCInstallUpdatesInfoOnNext.actionsOnClickofNext
EMGCInstallUpdatesInfoOnNext:: End of actionOnClickofNext
The installer detected the host name as PLVORAGRID, but you have changed it to PLVORAGRID
Session log file is /u02/tmp/OraInstall2021-02-09_05-18-26PM/install2021-02-09_05-18-26PM.log
Installation in progress
Install successful
Linking in progress
Link successful
Setup in progress
Setup successful
Session log file is /u02/tmp/OraInstall2021-02-09_05-18-26PM/install2021-02-09_05-18-26PM.log
Installation in progress
Install successful
Linking in progress
Link successful
Setup in progress
Setup successful
Agent OracleHome :/u01/app/oracle/agent/agent_13.4.0.0.0
OMS OracleHome :/u01/app/oracle/middleware
13NGCHEKAGGREGATE : oracle.sysman.top.agent
13NGCHEKAGGREGATE : OuiConfigVariables
13NGCHEKAGGREGATE : oracle.sysman.top.oms
13NGCHEKAGGREGATE : encap_oms
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.
[oracle@PLVORAGRID installMedia]$
[oracle@PLVORAGRID installMedia]$
4 2021-02-10 08:48:19 history
<onfigureGC.sh -silent -responseFile /tmp/config.rsp
====Prereq Config Location main===
null
EMGCInstaller args -onlyconfig
EMGCInstaller args -oh
EMGCInstaller args /u01/app/oracle/middleware
EMGCInstaller args -scratchPath
EMGCInstaller args /u01/app/oracle/middleware
EMGCInstaller args -sourceLoc
EMGCInstaller args /u01/app/oracle/middleware
EMGCInstaller args INSTALL_SWONLY_WITH_PLUGINS=false
EMGCInstaller args -silent
EMGCInstaller args -responseFile
EMGCInstaller args /tmp/config.rsp
DiskLoc inside SourceLoc/u01/app/
EMFileLoc:/u01/app/oracle/middleware/oui/em/
ScratchPathValue :/u01/app/oracle/middleware
Error Messages:
----------------------------------------------------
* Invalid option(s): sourceLoc
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
List file is unreadable
Oracle strongly recommends using the AL32UTF8 character set for EM repository. AL32UTF8 is Oracle's name for the standard Unicode encoding UTF-8, which enables universal support of virtually all languages of the world.
The following prerequisite check failed because the Oracle Database, where the Management Repository will be configured, does not meet the configuration requirements. These failures do not impact the installation, but you may encounter performance issues with the product later. You can either click Cancel, fix the issue manually now, based on the recommendation offered for this prerequisite, and click Next, or you can click OK to fix it after the installation ends. For more details check the logs: /u01/app/oracle/middleware/cfgtoollogs/oui/emdbprereqs
Prereq Name Recommendation
Check the pga_aggregate_target instance parameter value. The pga_aggregate_target instance parameter should be set to at least 1000000000 bytes.
Check the sga_target instance parameter value. The sga_target instance parameter should be set to at least 3000000000 bytes.
Check the shared_pool_size instance parameter value. The shared_pool_size instance parameter should be set to at least 600000000 bytes or roughly one third of the sga_target size.
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
..................................................................................................
Installation in progress (Wednesday, February 10, 2021 8:48:42 AM PET)
98% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:48:43 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:48:43 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:48:43 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:48:54 AM PET)
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
............................................................... 18% Done.
............................................................... 37% Done.
............................................................... 56% Done.
............................................................... 75% Done.
............................................................... 94% Done.
...............
Installation in progress (Wednesday, February 10, 2021 8:49:15 AM PET)
98% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:49:15 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:49:15 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:49:15 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:49:25 AM PET)
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
..................................................................................................
Installation in progress (Wednesday, February 10, 2021 8:49:34 AM PET)
98% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:49:35 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:49:35 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:49:35 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:49:44 AM PET)
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
............................................................... 23% Done.
............................................................... 46% Done.
............................................................... 70% Done.
............................................................... 93% Done.
...............
Installation in progress (Wednesday, February 10, 2021 8:50:03 AM PET)
98% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:50:03 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:50:03 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:50:03 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:50:13 AM PET)
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
..................................................................................................................
Installation in progress (Wednesday, February 10, 2021 8:50:30 AM PET)
98% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:50:31 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:50:31 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:50:31 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:50:40 AM PET)
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.emas/13.4.1.0.0/oracle.sysman.emas.agent.plugin-13.4.1.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
..................................................................................................
Installation in progress (Wednesday, February 10, 2021 8:50:46 AM PET)
98% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:50:46 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:50:46 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:50:46 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:50:57 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.emrep/13.4.0.0.0/oracle.sysman.emrep.agent.plugin-13.4.0.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
.......................................................................................
Installation in progress (Wednesday, February 10, 2021 8:50:59 AM PET)
87% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:50:59 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:50:59 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:50:59 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:51:10 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.beacon/13.4.0.0.0/oracle.sysman.beacon.agent.plugin-13.4.0.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
..................................................................................................
Installation in progress (Wednesday, February 10, 2021 8:51:13 AM PET)
98% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:51:13 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:51:13 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:51:13 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:51:24 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.oh/13.4.0.0.0/oracle.sysman.oh.agent.plugin-13.4.0.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
.................................................................................................
Installation in progress (Wednesday, February 10, 2021 8:51:26 AM PET)
97% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:51:26 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:51:26 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:51:26 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:51:37 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.csa/13.4.0.0.0/oracle.sysman.csa.agent.plugin-13.4.0.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
.......................................................................
Installation in progress (Wednesday, February 10, 2021 8:51:38 AM PET)
71% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:51:38 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:51:38 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:51:38 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:51:49 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.csa/13.4.0.0.0/oracle.sysman.csa.discovery.plugin-13.4.0.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
..............................................................................................
Installation in progress (Wednesday, February 10, 2021 8:51:51 AM PET)
93% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:51:51 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:51:51 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:51:51 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:52:02 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.oh/13.4.0.0.0/oracle.sysman.oh.discovery.plugin-13.4.0.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
..........................................................................
Installation in progress (Wednesday, February 10, 2021 8:52:04 AM PET)
74% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:52:04 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:52:04 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:52:04 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:52:14 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.db/13.4.1.0.0/oracle.sysman.db.discovery.plugin-13.4.1.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
............................................................................................
Installation in progress (Wednesday, February 10, 2021 8:52:16 AM PET)
92% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:52:16 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:52:16 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:52:16 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:52:27 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.xa/13.4.1.0.0/oracle.sysman.xa.discovery.plugin-13.4.1.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
.....................................................................................
Installation in progress (Wednesday, February 10, 2021 8:52:29 AM PET)
85% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:52:29 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:52:29 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:52:29 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:52:40 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.emas/13.4.1.0.0/oracle.sysman.emas.discovery.plugin-13.4.1.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
..................................................................................................
Installation in progress (Wednesday, February 10, 2021 8:52:42 AM PET)
98% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:52:42 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:52:42 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:52:42 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:52:53 AM PET)
List file is unreadable
List file is unreadable
&Decline License Agreement/u01/app/oracle/middleware/sysman/install/plugins/oracle.sysman.si/13.4.1.0.0/oracle.sysman.si.discovery.plugin-13.4.1.0.0.farb
Session log file is /tmp/OraInstall2021-02-10_08-48-30AM/nextgen2021-02-10_08-48-30AM.log
............................................................................
Installation in progress (Wednesday, February 10, 2021 8:52:54 AM PET)
76% Done.
Install successful
Linking in progress (Wednesday, February 10, 2021 8:52:54 AM PET)
Link successful
Setup in progress (Wednesday, February 10, 2021 8:52:54 AM PET)
Setup successful
Saving inventory (Wednesday, February 10, 2021 8:52:54 AM PET)
Saving inventory complete
End of install phases.(Wednesday, February 10, 2021 8:53:06 AM PET)
List file is unreadable
13NGCHEKAGGREGATE : oracle.sysman.top.agent
13NGCHEKAGGREGATE : OuiConfigVariables
13NGCHEKAGGREGATE : oracle.sysman.top.oms
13NGCHEKAGGREGATE : encap_oms
13NGCHEKAGGREGATE : OuiConfigVariables
2021-02-10_08-53-09AM: Configuration Assistant "Plugins Prerequisites Check" is in progress.
2021-02-10_08-53-17AM: Configuration Assistant "Plugins Prerequisites Check" has Succeeded.
2021-02-10_08-53-17AM: Configuration Assistant "Repository Configuration" is in progress.
Setting the value of EMPREREQKIT_RESULTDIR /u01/app/oracle/middleware/.gcinstall_temp
Calling the EMSCHEMA MANAGER: CREATE
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Creating Tablespaces
Validating and Creating Tablespaces
Repository Creation Utility - Create
Repository Create in progress.
Check the Repository Configuration Assistant logs at: /u01/app/oracle/middleware/sysman/log/schemamanager
TNS Test Inserted Successfully
Successfully Added TNS Query Descriptors
******** ORACLE_HOME is /u01/app/oracle/middleware
test properties path: /u01/app/oracle/middleware/sysman/admin/emdrep/prop/imap.properties
CreateTestType:createCompleteTest: BEGIN
CreateTestType:createTestMetadataObject: BEGIN
CreateTestType:createTestMetadataObject: END
CreateTestType:createPropertyGroups: BEGIN
CreateTestType:createPropertyGroups: END
CreateTestType:createStrayProperties: BEGIN
CreateTestType:createStrayProperties: END
CreateTestType:createDefaultPromotions: BEGIN
CreateTestType:createDefaultPromotions: END
CreateTestType:createDefaultThresholds: BEGIN
CreateTestType:createDefaultThresholds: END
CreateTestType:createMetrics4TestType: BEGIN
CreateTestType:createMetrics4TestType: END
PropertyName :imap_host
PropertyName :imap_port
PropertyName :imap_user_name
PropertyName :imap_password
PropertyName :numretries
PropertyName :retryinterval
CreateTestType:createQueryDescriptor: BEGIN
CreateTestType:createQueryDescriptor: END
Enabled test for: IMAP , generic_service , 1.0
Enabled test for: IMAP , aggregate_service , 1.0
CreateTestType:createCompleteTest: END
******** ORACLE_HOME is /u01/app/oracle/middleware
Wed Feb 10 09:41:17.353 PET 2021 rcu:Extracted SQL Statement: [BEGIN
DECLARE
l_core_ver MGMT_VERSIONS.version%TYPE;
l_error VARCHAR2(100) ;
l_error_count NUMBER := 0 ;
l_database_role VARCHAR2(32);
BEGIN
-- Check to see if this database is in logical standby mode. If it is
-- we need to exit this script because logical standby doesn't support
-- DBMS_JOBS.
BEGIN
SELECT database_role into l_database_role
from v$database where database_role like '%LOGICAL%';
RETURN;
-- Exit this script if this is a logical standby db.
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
-- Just continue normally if this is not a logical standby db.
END;
BEGIN
SELECT version INTO l_core_ver
FROM MGMT_VERSIONS
WHERE component_name = 'CORE';
EXCEPTION
WHEN OTHERS THEN
l_core_ver := '4.0.0.0.0';
END;
IF (l_core_ver = '4.0.0.0.0') THEN
-- For 4.0.0 repository, the maintenance package
-- does not have the remove_em_dbms_jobs function, so
-- have to remove the jobs created in 4.0.0
SAVEPOINT admin_remove_jobs_start ;
FOR crec IN (select job, what FROM user_jobs
where what in (
'EM_SLM_COMPUTATION.EXEC_SLM_COMPUTATION_JOB();',
'EM_SLM_CALENDAR.UPDATE_CALENDAR();',
'MGMT_GENSVC_AVAIL.EXEC_AVAIL_JOB();',
'EMD_COLLECTION.RUN_COLLECTIONS();',
'EMD_EVALUATION.EVALSQLMETRICS();',
'EMD_LOADER.ROLLUP();',
'EMD_NOTIFICATION.DELIVER_NOTIFICATIONS();',
'EM_PING.MARK_NODE_STATUS();',
'MGMT_JOB_ENGINE.apply_purge_policies();'
)
or what like 'emd_maintenance.analyze_emd_schema%'
)
LOOP
BEGIN
DBMS_JOB.REMOVE(crec.job);
EXCEPTION
WHEN OTHERS THEN
l_error_count := l_error_count + 1 ;
IF l_error IS NULL
THEN
l_error := SUBSTR(SQLERRM,1,100) ;
END IF ;
END;
END LOOP;
IF l_error_count > 0
THEN
ROLLBACK TO SAVEPOINT admin_remove_jobs_start ;
raise_application_error(MGMT_GLOBAL.UNEXPECTED_ERR,
l_error_count||' error(s) when dropping dbms_jobs '||
',first error='||l_error) ;
END IF ;
ELSE
-- This is done as dynamic SQL, so that this can be run against
-- EM 4.0.0 repositories also
EXECUTE IMMEDIATE 'begin EMD_MAINTENANCE.REMOVE_EM_DBMS_JOBS; end;';
END IF;
END;
END;
]
Wed Feb 10 09:41:17.353 PET 2021 rcu:Extracted Statement from File Name: '/u01/app/oracle/middleware/sysman/admin/emdrep/sql/core/latest/admin/admin_remove_dbms_jobs.sql'Line Number: 111
Wed Feb 10 09:41:17.353 PET 2021 rcu:Statement Type: 'BEGIN/END Anonymous Block'
Wed Feb 10 09:41:17.751 PET 2021 rcu:Extracted SQL Statement: [PROMPT Submitting DBMS jobs.]
Wed Feb 10 09:41:17.751 PET 2021 rcu:Extracted Statement from File Name: '/u01/app/oracle/middleware/sysman/admin/emdrep/sql/core/latest/admin/admin_submit_dbms_jobs.sql'Line Number: 29
Wed Feb 10 09:41:17.751 PET 2021 rcu:Statement Type: 'Debug Statement'
Wed Feb 10 09:41:17.751 PET 2021 rcu:Extracted SQL Statement: [DECLARE
l_database_role VARCHAR2(32);
BEGIN
-- Check to see if this database is in logical standby mode. If it is
-- we need to exit this script because logical standby doesn't support
-- DBMS_JOBS.
BEGIN
SELECT database_role into l_database_role
from v$database where database_role like '%LOGICAL%';
EXCEPTION
WHEN NO_DATA_FOUND THEN
EMD_MAINTENANCE.SUBMIT_EM_DBMS_JOBS;
COMMIT;
END;
END;
]
Wed Feb 10 09:41:17.751 PET 2021 rcu:Extracted Statement from File Name: '/u01/app/oracle/middleware/sysman/admin/emdrep/sql/core/latest/admin/admin_submit_dbms_jobs.sql'Line Number: 46
Wed Feb 10 09:41:17.751 PET 2021 rcu:Statement Type: 'BEGIN/END Anonymous Block'
Repository Creation Utility: Create - Completion Summary
Database details:
-----------------------------
Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PLVORAGRID)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emrep)))
Connected As : SYS
RCU Logfile : No log file specified
Component schemas created:
-----------------------------
Component Status Logfile
EM Repository Creation Configuration Success /u01/app/oracle/middleware/sysman/log/schemamanager/m_021021_0853_AM/m_021021_0853_AM.CREATE/RCU2021-02-10_08-53_876334194/logs/em_repos_config.log
EM Repository Init Configuration Success /u01/app/oracle/middleware/sysman/log/schemamanager/m_021021_0853_AM/m_021021_0853_AM.CREATE/RCU2021-02-10_08-53_876334194/logs/em_repos_init.log
EM Repository Common Success /u01/app/oracle/middleware/sysman/log/schemamanager/m_021021_0853_AM/m_021021_0853_AM.CREATE/RCU2021-02-10_08-53_876334194/logs/em_repos_common.log
Repository Creation Utility - Create : Operation Completed
The creation of Repository is completed now running the MOS
2021-02-10_09-41-51AM: Configuration Assistant "Repository Configuration" has Succeeded.
2021-02-10_09-41-51AM: Configuration Assistant "MDS Schema Configuration" is in progress.
Setting the value of EMPREREQKIT_RESULTDIR /u01/app/oracle/middleware/.gcinstall_temp
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Creating Tablespaces
Validating and Creating Tablespaces
Repository Creation Utility - Create
Repository Create in progress.
Percent Complete: 30
Percent Complete: 65
Percent Complete: 65
Percent Complete: 70
Percent Complete: 70
Percent Complete: 75
Percent Complete: 75
Percent Complete: 95
Percent Complete: 100
Repository Creation Utility: Create - Completion Summary
Database details:
-----------------------------
Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PLVORAGRID)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emrep)))
Connected As : SYS
Prefix for (prefixable) Schema Owners : SYSMAN
RCU Logfile : No log file specified
Component schemas created:
-----------------------------
Component Status Logfile
Metadata Services Success /u01/app/oracle/middleware/sysman/log/schemamanager/m_021021_0853_AM/m_021021_0853_AM.CREATE/RCU2021-02-10_09-41_996616159/logs/mds.log
Repository Creation Utility - Create : Operation Completed
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Creating Tablespaces
Validating and Creating Tablespaces
Repository Creation Utility - Create
Repository Create in progress.
Percent Complete: 50
Percent Complete: 55
Percent Complete: 65
Percent Complete: 65
Percent Complete: 80
Percent Complete: 90
Percent Complete: 95
Percent Complete: 95
Percent Complete: 97
Percent Complete: 100
Repository Creation Utility: Create - Completion Summary
Database details:
-----------------------------
Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PLVORAGRID)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emrep)))
Connected As : SYS
Prefix for (prefixable) Schema Owners : SYSMAN122130
RCU Logfile : No log file specified
Component schemas created:
-----------------------------
Component Status Logfile
Oracle Platform Security Services Success /u01/app/oracle/middleware/sysman/log/schemamanager/m_021021_0853_AM/m_021021_0853_AM.CREATE/RCU2021-02-10_09-41_996616159/logs/opss.log
Repository Creation Utility - Create : Operation Completed
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Creating Tablespaces
Validating and Creating Tablespaces
Repository Creation Utility - Create
Repository Create in progress.
Percent Complete: 50
Percent Complete: 50
Percent Complete: 55
Percent Complete: 60
Percent Complete: 65
Percent Complete: 65
Percent Complete: 65
Percent Complete: 82
Percent Complete: 100
Repository Creation Utility: Create - Completion Summary
Database details:
-----------------------------
Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PLVORAGRID)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emrep)))
Connected As : SYS
Prefix for (prefixable) Schema Owners : SYSMAN
RCU Logfile : No log file specified
Component schemas created:
-----------------------------
Component Status Logfile
Common Infrastructure Services Success /u01/app/oracle/middleware/sysman/log/schemamanager/m_021021_0853_AM/m_021021_0853_AM.CREATE/RCU2021-02-10_09-41_996616159/logs/stb.log
Repository Creation Utility - Create : Operation Completed
2021-02-10_09-42-02AM: Configuration Assistant "MDS Schema Configuration" has Succeeded.
2021-02-10_09-42-02AM: Configuration Assistant "BI Publisher Schema Configuration" is in progress.
Setting the value of EMPREREQKIT_RESULTDIR /u01/app/oracle/middleware/.gcinstall_temp
Middleware home/u01/app/oracle/middleware
2021_02_10_AD_09_42_02_PET BIPLATFORM EMSchemaManagerHelper: Info : Oracle Home is /u01/app/oracle/middleware
2021_02_10_AD_09_42_02_PET BIPLATFORM EMSchemaManagerHelper: Info : Schema Oracle Home is /u01/app/oracle/middleware/bi
2021_02_10_AD_09_42_02_PET BIPLATFORM EMSchemaManagerHelper: Info : Setting RCU_HOME to /u01/app/oracle/middleware/oracle_common
2021_02_10_AD_09_42_02_PET BIPLATFORM EMSchemaManagerHelper: Info : Setting SCRIPT_HOME to /u01/app/oracle/middleware/oracle_common/common/sql
2021_02_10_AD_09_42_02_PET BIPLATFORM EMSchemaManagerHelper: Info : Setting RCU_LOG_LOCATION to /u01/app/oracle/middleware/cfgtoollogs/bip
2021_02_10_AD_09_42_02_PET BIPLATFORM EMSchemaManagerHelper: Info : Setting RCU_LOG_NAME to emBIPLATFORM.log
2021_02_10_AD_09_42_02_PET BIPLATFORM version is null
2021_02_10_AD_09_42_02_PET has BIPLATFORM user? false
2021_02_10_AD_09_42_02_PET BIPLATFORM EMSchemaManagerHelper: Info : Prepare to initialize RCU
2021_02_10_AD_09_42_02_PET BIPLATFORM EMSchemaManagerHelper: Info : RCU initialized with parameters : -silent -createRepository -compInfoXMLLocation /u01/app/oracle/middleware/sysman/emdrep/config/schemaext/ComponentInfo.xml -storageXMLLocation /u01/app/oracle/middleware/sysman/emdrep/config/schemaext/Storage.xml -connectString (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PLVORAGRID)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emrep))) -dbUser SYS -dbRole sysdba -schemaPrefix SYSMAN -component BIPLATFORM
2021_02_10_AD_09_42_02_PET BIPLATFORM EMSchemaManagerHelper: Info : Invoking RCU
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Creating Tablespaces
Validating and Creating Tablespaces
Repository Creation Utility - Create
Repository Create in progress.
Percent Complete: 50
Percent Complete: 50
Percent Complete: 55
Percent Complete: 55
Percent Complete: 65
Percent Complete: 77
Percent Complete: 88
Percent Complete: 94
Percent Complete: 97
Percent Complete: 98
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 99
Percent Complete: 100
Repository Creation Utility: Create - Completion Summary
Database details:
-----------------------------
Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PLVORAGRID)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emrep)))
Connected As : SYS
Prefix for (prefixable) Schema Owners : SYSMAN
RCU Logfile : No log file specified
Component schemas created:
-----------------------------
Component Status Logfile
Business Intelligence Platform Success /u01/app/oracle/middleware/sysman/log/schemamanager/m_021021_0853_AM/m_021021_0853_AM.CREATE/RCU2021-02-10_09-42_1064729917/logs/biplatform.log
Repository Creation Utility - Create : Operation Completed
2021_02_10_AD_09_42_07_PET BIPLATFORM EMSchemaManagerHelper: Info : RCU Completed : COMPLETED
2021_02_10_AD_09_42_07_PET BIPLATFORM EMSchemaManagerHelper: Info : Asscociating profile
Unable to create logger...
2021_02_10_AD_09_42_07_PET BIPLATFORM EMSchemaManagerHelper: Info : profile associated
Successfully created SYSMAN_BIPLATFORM schema...
Recompiling Required BI Publisher Database views with invalid objects.
The SQL {0} execution is complete.
The SQL {0} execution is complete.
The SQL {0} execution is complete.
The SQL {0} execution is complete.
The SQL {0} execution is complete.
The SQL {0} execution is complete.
Verifying if the Required BI Publisher Database views do not contain invalid objects any longer.
Invalid Objects from BI Publisher Database views have been removed.
2021-02-10_09-42-07AM: Configuration Assistant "BI Publisher Schema Configuration" has Succeeded.
2021-02-10_09-42-07AM: Configuration Assistant "OMS Configuration" is in progress.
Executing the OMSCA command...
Check the log files of the OMS Configuration Assistant at: /u01/app/oracle/middleware/cfgtoollogs/omsca
OMS Configuration Assistant completed successfully.
2021-02-10_09-52-14AM: Configuration Assistant "OMS Configuration" has Succeeded.
2021-02-10_09-52-14AM: Configuration Assistant "Plugins Deployment and Configuration" is in progress.
2021-02-10_09-59-40AM: Configuration Assistant "Plugins Deployment and Configuration" has Succeeded.
2021-02-10_09-59-40AM: Configuration Assistant "BI Publisher Configuration" is in progress.
2021-02-10_10-07-06AM: Configuration Assistant "BI Publisher Configuration" has Succeeded.
2021-02-10_10-07-06AM: Configuration Assistant "Start Oracle Management Service" is in progress.
Starting OMS ...
Executing the command: /u01/app/oracle/middleware/bin/emctl start oms
Starting of OMS is successful.
Starting export oms config...
Executing command: /u01/app/oracle/middleware/bin/emctl exportconfig oms -dir /u02/app/oracle/gc_inst/em/EMGC_OMS1/sysman/backup
Export config of OMS is successful.
2021-02-10_10-11-53AM: Configuration Assistant "Start Oracle Management Service" has Succeeded.
2021-02-10_10-11-53AM: Configuration Assistant "Agent Configuration Assistant" is in progress.
AgentConfiguration:agent configuration has been started
The AgentFreshInstaller is starting now
Oraclehome : ../u01/app/oracle/agent/agent_13.4.0.0.0
InstanceHome : /u01/app/oracle/agent/agent_inst
Agent Base Directory : /u01/app/oracle/agent
The oraclehome /u01/app/oracle/agent/agent_13.4.0.0.0
startAgent is:true
seci is :true
startAgent is:true
seci is :true
log loction is setlog
Creating log directoyr :/u01/app/oracle/agent/agent_13.4.0.0.0/cfgtoollogs/agentDeploy
Writing the following contents into /u01/app/oracle/agent/agent_13.4.0.0.0/install/oragchomelist
/u01/app/oracle/agent/agent_13.4.0.0.0:/u01/app/oracle/agent/agent_inst
Creating directory /u01/app/oracle/agent/agent_13.4.0.0.0/install/tmp completed successfully.
File /etc/oragchomelist exists.
File /etc/oragchomelist is writable.
Index :-1 for line : /u01/app/oracle/middleware
Index :0 for line : /u01/app/oracle/agent/agent_13.4.0.0.0
Overwriting the contents since oracle home:/u01/app/oracle/agent/agent_13.4.0.0.0 entry already exists.
Agent Home is : {0}
The value of chainInstall : true forceConfigure : false skipValidation : false
Validated the oms host and port :- PLVORAGRID----4903
Logs Location is : {0}
Getting Inet Addresses for host PLVORAGRID
** Agent Port Check completed successfully.**
Validated the agent port :- ----3872
Executing command: {0}
shared agent value is :false
Setting system property CUSTOM_INVENTORY to {0}
chain install is :true
Cloning of agent home completed successfully
Agent Configuration completed successfully
The following configuration scripts need to be executed as the "root" user. Root script to run : /u01/app/oracle/agent/agent_13.4.0.0.0/root.sh
AgentConfiguration:agent configuration finished with status = true
2021-02-10_10-13-23AM: Configuration Assistant "Agent Configuration Assistant" has Succeeded.
*** 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://PLVORAGRID:7803/em
2. Admin Server URL: https://PLVORAGRID:7102/console
3. BI Publisher URL: https://PLVORAGRID:9803/xmlpserver/servlet/home
The following details need to be provided while installing an additional OMS:
1. Admin Server Host Name: PLVORAGRID
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 /u02/app/oracle/gc_inst/em/EMGC_OMS1/sysman/backup on host PLVORAGRID. 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
[oracle@PLVORAGRID install]$
[oracle@PLVORAGRID install]$
