Taking export of ROLES and GRANTS

 When you are taking export of schema, roles are not exported. This is useful method to export the roles and grants. 

Take export of roles and grants

vi role.par

full=y

directory=DATA_PUMP_DIR

INCLUDE=ROLE_GRANT,grant

dumpfile=role.dmp

nologfile=yes

content=metadata_only

INCLUDE=ROLE:"IN (select role from dba_roles where ORACLE_MAINTAINED='N')"

Run the expdp 

expdp \'/ as sysdba\'  parfile=role.par

Generate the ddl using dump file in sql format 

impdp \'/ as sysdba\' directory=DATA_PUMP_DIR dumpfile=role.dmp sqlfile=role.sql nologfile=yes EXCLUDE=PROC_SYSTEM_GRANT

Run the SQL file on the target database for creating the role and grants. 

How to Gather Statistics on Objects Owned by the 'SYS' User and 'Fixed' Objects

Gather_schema_stats gathers statistics for objects owned by the SYS Schema. We recommend gathering statistics for the SYS schema, specifically if you are using Oracle APPS.

If your database encounters a lot of changes (DMLs) for SYS schema objects, then it is recommended to collect SYS schema statistics. The collection of statistics on SYS Schema objects will optimize the performance of internal recursive queries and application queries on SYS schema objects.

To gather dictionary stats, execute one of the following:

SQL> EXEC DBMS_STATS.GATHER_SCHEMA_STATS ('SYS');
SQL> exec DBMS_STATS.GATHER_DATABASE_STATS (gather_sys=>TRUE);
SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;




Gather_fixed_objects_stats also gathers statistics for dynamic tables, e.g. the X$ tables which loaded in SGA during the startup. Gathering statistics for fixed objects would normally be recommended if poor performance is encountered while querying dynamic views ,e.g. V$ views. Since fixed objects record current database activity, statistics gathering should be done when database has a representative load so that the statistics reflect the normal database activity.

To gather the fixed objects stats, use the following:

EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;


Gather fixed objects stats if the load is heavy and if the system is busy.

Reference : Oracle Doc ID 457926.1

Create New File System on Linux Machine

 

Add new disk to Server

[root@ggtarget u01]# ls -ltrha /dev/sd*
brw-rw----. 1 root disk 8, 0 Aug 13 02:08 /dev/sda
brw-rw----. 1 root disk 8, 2 Aug 13 02:08 /dev/sda2

brw-rw----. 1 root disk 8, 1 Aug 13 02:08 /dev/sda1
brw-rw----. 1 root disk 8, 16 Aug 13 02:08 /dev/sdb
brw-rw----. 1 root disk 8, 32 Aug 13 02:08 /dev/sdc

[root@ggtarget u01]# lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTsdb 8:16 0 30G 0 disk
sr0 11:0 1 1024M 0 rom
sdc 8:32 0 30G 0 disk ======>>> NEWLY ADDED DISK
sda 8:0 0 50G 0 disk
├─sda2 8:2 0 49G 0 part
│ ├─ol-swap 252:1 0 4G 0 lvm [SWAP]
│ ├─ol-tmp 252:2 0 7G 0 lvm /tmp
│ ├─ol-root 252:0 0 10G 0 lvm /
│ └─ol-u01 252:3 0 28G 0 lvm /u01
└─sda1 8:1 0 1G 0 part /boot

Create a partition of a newly added disk

[root@ggtarget u01]# fdisk /dev/sdc

Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x0c577db8.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p):p
Using default response p
Partition number (1-4, default 1):1
First sector (2048-62914559, default 2048): 2048
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-62914559, default 62914559):62914559
Using default value 62914559
Partition 1 of type Linux and of size 30 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.

[root@ggtarget u01]# lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sdb 8:16 0 30G 0 disk
sr0 11:0 1 1024M 0 rom
sdc 8:32 0 30G 0 disk
└─sdc1 8:33 0 30G 0 part ==> THIS
sda 8:0 0 50G 0 disk
├─sda2 8:2 0 49G 0 part
│ ├─ol-swap 252:1 0 4G 0 lvm [SWAP]
│ ├─ol-tmp 252:2 0 7G 0 lvm /tmp
│ ├─ol-root 252:0 0 10G 0 lvm /
│ └─ol-u01 252:3 0 28G 0 lvm /u01
└─sda1 8:1 0 1G 0 part /boot

Create and Mount the File-System

[root@ggtarget u01]# mkfs.xfs /dev/sdc1

meta-data=/dev/sdc1 isize=256 agcount=4, agsize=1966016 blks
= sectsz=512 attr=2, projid32bit=1
= crc=0 finobt=0, sparse=0
data = bsize=4096 blocks=7864064, imaxpct=25
= sunit=0 swidth=0 blks
naming =version 2 bsize=4096 ascii-ci=0 ftype=1
log =internal log bsize=4096 blocks=3839, version=2
= sectsz=512 sunit=0 blks, lazy-count=1
realtime =none extsz=4096 blocks=0, rtextents=0

[root@ggtarget u01]# blkid /dev/sdc1

/dev/sdc1: UUID="a8e2c27e-9618-43a3-999f-097819144ec3" TYPE="xfs"

[root@ggtarget u01]# mkdir /u02

[root@ggtarget u01]# mount -t xfs /dev/sdc1 /u02

[root@ggtarget u01]# df -h /u02
Filesystem Size Used Avail Use% Mounted on
/dev/sdc1 30G 33M 30G 1% /u02

Add an entry to fstab

[root@ggtarget u01]# cat /etc/fstab | grep u02

UUID="a8e2c27e-9618-43a3-999f-097819144ec3" /u02 xfs defaults        0 0

[root@ggtarget u01]#

[root@ggtarget u01]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sdb 8:16 0 30G 0 disk
sr0 11:0 1 1024M 0 rom
sdc 8:32 0 30G 0 disk
└─sdc1 8:33 0 30G 0 part /u02 ==>THIS
sda 8:0 0 50G 0 disk
├─sda2 8:2 0 49G 0 part
│ ├─ol-swap 252:1 0 4G 0 lvm [SWAP]
│ ├─ol-tmp 252:2 0 7G 0 lvm /tmp
│ ├─ol-root 252:0 0 10G 0 lvm /
│ └─ol-u01 252:3 0 28G 0 lvm /u01
└─sda1 8:1 0 1G 0 part /boot

Install 21c Grid Infrastructure with Oracle ASM Filter Driver

Create a partition of the disk

 [root@ggtarget u01]# fdisk /dev/sdb

Welcome to fdisk (util-linux 2.23.2).

 Changes will remain in memory only, until you decide to write them.

Be careful before using the write command.

 Device does not contain a recognized partition table

Building a new DOS disklabel with disk identifier 0xb049a9bf.

 Command (m for help): n

Partition type:

   p   primary (0 primary, 0 extended, 4 free)

   e   extended

Select (default p): p

Using default response p

Partition number (1-4, default 1): 1

First sector (2048-62914559, default 2048):2048

Using default value 2048

Last sector, +sectors or +size{K,M,G} (2048-62914559, default 62914559):

Using default value 62914559

Partition 1 of type Linux and of size 30 GiB is set

 

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@ggtarget u01]# lsblk

NAME        MAJ:MIN RM  SIZE RO TYPE MOUNTPOINT

sdb           8:16   0   30G  0 disk

└─sdb1        8:17   0   30G  0 part

sr0          11:0    1 1024M  0 rom

sdc           8:32   0   30G  0 disk

└─sdc1        8:33   0   30G  0 part /u02

sda           8:0    0   50G  0 disk

├─sda2        8:2    0   49G  0 part

│ ├─ol-swap 252:1    0    4G  0 lvm  [SWAP]

│ ├─ol-tmp  252:2    0    7G  0 lvm  /tmp

│ ├─ol-root 252:0    0   10G  0 lvm  /

│ └─ol-u01  252:3    0   28G  0 lvm  /u01

└─sda1        8:1    0    1G  0 part /boot

Create a Directory for GI home

[root@ggtarget u01]#

mkdir -p /u02/app/21c/grid

chown oracle:oinstall /u02/app/21c/grid

Unzip the 21c GI software

su - oracle

cd /u02/app/21c/grid

unzip -q /tmp/grid_home.zip

Create ASMFD disk label

su - root

[root@ggtarget u01]# export ORACLE_HOME=/u02/app/21c/grid

[root@ggtarget u01]# export ORACLE_BASE=/tmp

[root@ggtarget u01]# cd /u02/app/21c/grid/bin

[root@ggtarget bin]# ./asmcmd afd_label DATA1 /dev/sdb1 --init

Creating diag directory /tmp/diag

[root@ggtarget bin]# ./asmcmd afd_lslbl /dev/sdb1

----------------------------------------------------------------

Label                     Duplicate  Path

======================================

DATA1                                 /dev/sdb1

Update the SELinux

[root@ggtarget u02]# getenforce

Enforcing

[root@ggtarget u02]# setenforce 0

[root@ggtarget u02]# getenforce

Permissive

[root@ggtarget u02]#
These methods above will only work until the next reboot, therefore to disable SELinux permanently, move to the next section.

To permanently disable SELinux,  to open the file /etc/sysconfig/selinux as follows:

vi /etc/sysconfig/selinux

SELINUX=disabled

Sestatus

Start the 21c Grid Infrastructure installation.

unset ORACLE_BASE

Log in as the Oracle Restart software owner user and run gridSetup.sh to start the Oracle Grid Infrastructure installation wizard

 

 

 

 

 

[root@ggtarget u02]# /u02/app/21c/grid/root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u02/app/21c/grid

 Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying coraenv to /usr/local/bin ...

 Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /u02/app/21c/grid/crs/install/crsconfig_params

2022-08-13 03:08:06: Got permissions of file /u02/app/crsdata/ggtarget/crsconfig: 0775

2022-08-13 03:08:06: Got permissions of file /u02/app/crsdata: 0775

2022-08-13 03:08:06: Got permissions of file /u02/app/crsdata/ggtarget: 0775

The log of current session can be found at:

  /u02/app/crsdata/ggtarget/crsconfig/roothas_2022-08-13_03-08-06AM.log

Redirecting to /bin/systemctl restart rsyslog.service

LOCAL ADD MODE

Creating OCR keys for user 'oracle', privgrp 'oinstall'..

Operation successful.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4664: Node ggtarget successfully pinned.

2022/08/13 03:10:11 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

ggtarget     2022/08/13 03:11:46     /u02/app/crsdata/ggtarget/olr/backup_20220813_031146.olr     0

2022/08/13 03:11:49 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

[root@ggtarget u02]#

 

 

Verification

 [oracle@ggtarget ~]$ ps -ef|grep pmon

oracle 22413 1 0 03:13 ? 00:00:00 asm_pmon_+ASM
oracle 23455 10089 0 03:15 pts/3 00:00:00 grep --color=auto pmon

   

[oracle@ggtarget ~]$ ps -ef|grep tns

root 23 2 0 02:08 ? 00:00:00 [netns]
oracle 21098 1 0 03:12 ? 00:00:00 /u02/app/21c/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 23575 10089 0 03:16 pts/3 00:00:00 grep --color=auto tns

[oracle@ggtarget ~]$

[oracle@ggtarget ~]$ /u02/app/21c/grid/bin/crsctl stat res -t

--------------------------------------------------------------------------------
Name Target State Server State details 

--------------------------------------------------------------------------------

Local Resources
--------------------------------------------------------------------------------

ora.DATA.dg               ONLINE  ONLINE       ggtarget                 STABLE

ora.LISTENER.lsnr                ONLINE  ONLINE       ggtarget                 STABLE

ora.asm               ONLINE  ONLINE       ggtarget                 Started,STABLE

ora.ons               OFFLINE OFFLINE      ggtarget                 STABLE

--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------

ora.cssd      1        ONLINE  ONLINE       ggtarget                 STABLE

ora.diskmon       1        OFFLINE OFFLINE                               STABLE

ora.driver.afd       1        ONLINE  ONLINE       ggtarget                 STABLE

ora.evmd      1        ONLINE  ONLINE       ggtarget                 STABLE

--------------------------------------------------------------------------------

[oracle@ggtarget ~]$

[oracle@ggtarget ~]$ . oraenv

ORACLE_SID = [oracle] ? +ASM

 [oracle@ggtarget ~]$ 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     30716    30612                0           30612              0             N  DATA/

 

[oracle@ggtarget ~]$ $ORACLE_HOME/bin/asmcmd lsdsk

Path

AFD:DATA1

 [oracle@ggtarget ~]$ $ORACLE_HOME/bin/asmcmd afd_state

ASMCMD-9526: The AFD state is 'LOADED' and filtering is 'ENABLED' on host 'ggtarget.localdomain'

[oracle@ggtarget ~]$

[oracle@ggtarget ~]$ $ORACLE_HOME/bin/asmcmd dsget

parameter:/dev/sd*, AFD:*

profile:/dev/sd*,AFD:*

[oracle@ggtarget ~]$

 

Reference 

https://docs.oracle.com/en/database/oracle/oracle-database/21/cwlin/configuring-oracle-asmfd-after-installation.html#GUID-19A3AF92-FC15-4518-9509-C35976344A4C

 

Installation of Enterprise Manager Cloud Control 13c Release 5 on Windows Platform

 Table of Contents

1. Enterprise Manager Cloud Control Architecture.

2. Environment

3. Verify Certificate

4. Pre-requisites. 

5. Download Enterprise Manager Cloud Control 13c Release 5

6. Create Oracle 19c Repository Database

7. Install Enterprise Manager Cloud Control 13c Release 5 (13.5.0.0). 

8. Deploy Management Agent manually

9. Open Enterprise Manager Cloud Control URL

10. Reference Document

Enterprise Manager Cloud Control Architecture

 

Environment

Platform                                    : Microsoft Windows Server 2019 Datacentre Server

Server                                       : *********.local

OEM Version                            : 13c Release 5 (13.5.0.0)

OMS HOME                             : C:\oracle\product\middleware

Agent HOME                            : C:\oracle\product\agent

RDBMS HOME                        : c:\oracle\product\19.0.0.0\dbhome_1

RDBMS Version                       : 19.11.0.0.0

Repository CDB                       : OEMCDB

Repository PDB                       : PDBREPO

 

 Verify Certificate

 

Pre-requisites

CPU, RAM, Heap Size, and Hard Disk Space Requirements for Oracle Management Service

 

 CPU, RAM, and Hard Disk Space Requirements for Oracle Management Agent

CPU, RAM, and Hard Disk Space Requirements for Oracle Management Repository

Package Requirements for Oracle Management Service

·       Microsoft Visual C++ 2010 Redistributable Package

·       Microsoft Visual C++ 2012 Redistributable Package

·       Microsoft Visual C++ 2015 Redistributable Package Update 3

 

Package Requirements for Oracle Management Agent

• Microsoft Visual C++ 2010 Redistributable Package
• Microsoft Visual C++ 2015 Redistributable Package Update 3
  
  
  The Default Ports Used in Enterprise Manager Cloud Control OMS Configuration and their Directionality

 

1. Port 3872,1830 - 1849 (Agent port):
        Agent port is unidirectional (OMS to Agent)
        Job or console operations require the OMS to talk to the Agent, so this is needed for outbound communication from the OMS.

2. Port 1159 (HTTPS Upload Port), 4889 (HTTP Upload Port)
        Agent or target host communication to OMS host, unidirectional (Agent to OMS)

3. HTTPS Console port 7799
        User browser host to OMS host through port 7799 for EM 13.5 console HTTPS access, unidirectional

4. Admin Server HTTPS Port: 7101
        User browser host to OMS host for WebLogic Server Admin Console access through port 7101, unidirectional

5. SSH: 22
        The OMS transfers Agent software to a target server in an Agent Push deployment through this standard OS SSH port, unidirectional

 

At minimum, the following URLs should be made available through the firewall:

•   aru-akam.oracle.com
•   ccr.oracle.com
•   login.oracle.com
•   support.oracle.com
•   updates.oracle.com
•   oauth-e.oracle.com

Ensure that the default ports, that is, port 80 for HTTP connectivity and port 443 for HTTPS connectivity, are used to connect to the mentioned URLs.

 

Download Enterprise Manager Cloud Control 13c Release 5

Download-Enterprise-Manager-Cloud-Control-13.5

Create Oracle 19c Repository Database

Set oracle_home=c:\oracle\product\19.0.0.0\dbhome_1

Invoke dbca utility to create database.

 

 

Per Doc ID 2631718.1,

CAUSE

This issue is caused by Bug 29686671.

SOLUTION

Run dbca with "-J-Doracle.assistants.dbca.validate.ConfigurationParams=false" like a bellow.

dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false

 

<<<19c Repository Database creation is completed>>>>

 

 

 

 

 

 

Install Enterprise Manager Cloud Control 13.5

Right-click on setup_em13500_win64.exe and Run as Administrator. (Do not unzip any files/folders)

Launcher log file is C:\Users\FT6180-A\AppData\Local\Temp\OraInstall2021-11-05_10-17-14PM\launcher2021-11-05_10-17-14PM.log.

Extracting the installer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Done

Checking monitor: must be configured to display at least 256 colors.   Actual 4294967296    Passed

Checking swap space: must be greater than 512 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 C:\Users\FT6180-A\AppData\Local\Temp\OraInstall2021-11-05_10-17-14PM

ScratchPathValue :C:\Users\FT6180-A\AppData\Local\Temp\OraInstall2021-11-05_10-17-14PM

Nov 05, 2021 10:25:11 PM org.apache.sshd.common.io.DefaultIoServiceFactoryFactory getIoServiceProvider

INFO: No detected/configured IoServiceFactoryFactory using Nio2ServiceFactoryFactory

 

Click on Auto Fix and proceed.

Expected to fail the Agent configuration on Windows platform as we are not using the Cygwin tool for SSH daemon. Solution is to download the agent image and deploy it manually.

Deploy Management Agent

 

a.       Download the Agent Image via emcli

 

               <Open cmd with Run as Administrator>

C:\windows\system32>set oracle_home=C:\oracle\product\middleware

 

C:\windows\system32>C:\oracle\product\middleware\bin\emcli login -username=sysman -password=*****

Login successful

 

C:\windows\system32>C:\oracle\product\middleware\bin\emcli sync

Synchronized successfully

 

C:\windows\system32>C:\oracle\product\middleware\bin\emcli get_supported_platforms

-----------------------------------------------

Version = 13.5.0.0.0

 Platform = Microsoft Windows x64 (64-bit)

-----------------------------------------------

Platforms list displayed successfully.

 

C:\windows\system32>C:\oracle\product\middleware\bin\emcli get_agentimage -destination="F:\soft\agent_13c" -platform="Microsoft Windows x64 (64-bit)" -version=13.5.0.0.0

 === Partition Detail ===

Space free : 28 GB

Space required : 1 GB

Check the logs at C:\oracle\product\gc_inst\em\EMGC_OMS1\sysman\emcli\setup/.emcli/get_agentimage_2022-03-17_11-52-59-AM.log

Downloading F:\soft\agent_13c\13.5.0.0.0_AgentCore_233.zip

File saved as F:\soft\agent_13c\13.5.0.0.0_AgentCore_233.zip

Downloading F:\soft\agent_13c\13.5.0.0.0_Plugins_233.zip

File saved as F:\soft\agent_13c\13.5.0.0.0_Plugins_233.zip

Downloading F:\soft\agent_13c\unzip.exe

File saved as F:\soft\agent_13c\unzip.exe

Executing command: F:\soft\agent_13c\unzip.exe F:\soft\agent_13c\13.5.0.0.0_Plugins_233.zip -d F:\soft\agent_13c

Archieving agentImage and plugins.

Exit status is:0

Agent Image Download completed successfully.

 

b.       Deploy Agent manually

 

cd F:\soft\agent_13c\13.5.0.0.0_AgentCore_233

 

agentDeploy.bat AGENT_BASE_DIR=C:\oracle\product\agent -ignorePrereqs AGENT_PORT=3872 EM_UPLOAD_PORT=1159 OMS_HOST=******.tes.local ORACLE_HOSTNAME= ******.tes.local AGENT_INSTANCE_HOME=C:\oracle\product\agent\agent_inst AGENT_REGISTRATION_PASSWORD=*****

 

Mar 17, 2022 12:00:03 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile

INFO: AGENT_MODE=NONE

Mar 17, 2022 12:00:03 PM oracle.sysman.agent.installer.AgentInstaller parseResponseFile

INFO: s_agentSrvcName=Oracleagent13c1Agent

log loction is setlog

Writing the following contents into C:\oracle\product\agent\agent_13.5.0.0.0\install\oragchomelist

C:\oracle\product\agent\agent_13.5.0.0.0:C:\oracle\product\agent\agent_inst

Both /etc/oragchomelist and /var/opt/oracle/oragchomelist does not exist.

The value of chainInstall : false forceConfigure : false skipValidation : false

Validating oms host & port with url: https://******.local:1159/empbs/genwallet

Validating oms host & port with url: http://********.local:1159/empbs/genwallet

The status is 0

Validated the oms host and port :- *******.local----1159

Getting Inet Addresses for host *************

** Agent Port Check completed successfully.**

Validated the agent port :- ----3872

shared agent value is :false

servicname is:Oracleagent13c1Agent

service cmd is:cmd /c C:\oracle\product\agent\agent_13.5.0.0.0\bin\nmesrvops create Oracleagent13c1Agent C:\oracle\product\agent\agent_13.5.0.0.0\bin\nmesrvc.exe  auto

chain install is :false

Agent Configuration completed successfully

 

c.        Verify the Agent & OMS status

F:\soft\agent_13c\13.5.0.0.0_AgentCore_233>C:\oracle\product\agent\agent_13.5.0.0.0\bin\emctl status agent

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

---------------------------------------------------------------

Agent Version          : 13.5.0.0.0

OMS Version            : 13.5.0.0.0

Protocol Version       : 12.1.0.1.0

Agent Home             : C:/oracle/product/agent/agent_inst

Agent Log Directory    : C:/oracle/product/agent/agent_inst\sysman\log

Agent Binaries         : C:\oracle\product\agent\agent_13.5.0.0.0

Core JAR Location      : C:\oracle\product\agent\agent_13.5.0.0.0\jlib

Agent Process ID       : 3764

Parent Process ID      : 5452

Agent URL              : https://****:3872/emd/main/

Local Agent URL in NAT : https://******:3872/emd/main/

Repository URL         : https://*****.local:1159/empbs/upload

Started at             : 2022-03-17 12:02:18

Started by user        : ******$

Operating System       : Windows version 10.0 (amd64)

Number of Targets      : 3

Last Reload            : (none)

Last successful upload                       : 2022-03-17 12:04:16

Last attempted upload                        : 2022-03-17 12:04:16

Total Megabytes of XML files uploaded so far : 0.07

Number of XML files pending upload           : 0

Size of XML files pending upload(MB)         : 0

Available disk space on upload filesystem    : 40.84%

Collection Status                            : Collections enabled

Heartbeat Status                             : Ok

Last attempted heartbeat to OMS              : 2022-03-17 12:03:44

Last successful heartbeat to OMS             : 2022-03-17 12:03:44

Next scheduled heartbeat to OMS              : 2022-03-17 12:04:44

---------------------------------------------------------------

Agent is Running and Ready

 

F:\soft\agent_13c\13.5.0.0.0_AgentCore_233>C:\oracle\product\agent\agent_13.5.0.0.0\bin\emctl pingOMS

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

---------------------------------------------------------------

EMD pingOMS completed successfully

 

 

C:\windows\system32>C:\oracle\product\middleware\bin\emctl status oms -details -sysman_pwd *****

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

Console Server Host        : ********.local

HTTP Console Port          : 7788

HTTPS Console Port         : 7799

HTTP Upload Port           : 4889

HTTPS Upload Port          : 1159

EM Instance Home           : C:\oracle\product\gc_inst\em\EMGC_OMS1

OMS Log Directory Location : C:\oracle\product\gc_inst\em\EMGC_OMS1/sysman/log

OMS is not configured with SLB or virtual hostname

Agent Upload is locked.

OMS Console is locked.

Active CA ID: 1

Console URL: https://*******.local:7799/em

Upload URL: https://*******.local:1159/empbs/upload

 

WLS Domain Information

Domain Name            : GCDomain

Admin Server Host      : ********.local

Admin Server HTTPS Port: 7101

Admin Server is RUNNING

 

Oracle Management Server Information

Managed Server Instance Name: EMGC_OMS1

Oracle Management Server Instance Host: *******.local

WebTier is Up

Oracle Management Server is Up

JVMD Engine is Up

 

Open Enterprise Manager Cloud Control

 https://*************:7799/em

 

 

 

 

 

 

<<Installation of Enterprise manager cloud control 13.5 has been successfully completed>>

Reference Document

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/embsc/introduction1.html

EM 13c, EM 12c: The Default Ports Used in Enterprise Manager Cloud Control OMS Configuration and their Directionality (Doc ID 2362242.1)

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emadv/understanding-basics.html#GUID-A9257DD5-A702-4004-91E1-0D9A681E4E7E