OEM 12c - Oracle Physical Standby archive log sync monitoring

 OEM 12c - Oracle Physical Standby archive log sync monitoring

Note: Before Configuring Matric for archive log sync monitoring, Please make sure, there should not have One Matric for one Standby. One Matric should have groups of standby servers.

Step: 1: Enterprise>Monitoring>Metric Extensions

Step: 2: Metric Extensions Page Open

Step: 3  Click on +Create & Click on Metric Extension

 

Step: 4 Page Open: Create New: General Properties

Step: 5 Create New: General Properties: Put same values except Name$ & Displays (Put values according to Standby Group Name) &  then Click on Next.

 Step: 6 Put the below query in SQL Query Column only & Click Next

Query :

select sum(local.sequence#-target.sequence#) Total_gap

from

(select thread#,max(sequence#) sequence# from gv$archived_log where

dest_id=(select dest_id from v$archive_dest where TARGET='STANDBY'

)

and applied='YES' group by thread#) target,

(select thread#,max(sequence#) sequence# from gv$log group by thread#) local

where target.thread#=local.thread#;

Step: 7 Automatically Open Create New: Column

Step: 8  Create New: Column : Click on +Add & Click on New metric column.

Step: 9 Add Column put same value as I have entered & Click on OK.

 Step: 10 Now Create Neww : Columns

Step: 11

Step: 12

Step: 13

Step: 14

Step: 15

Step: 16

Step: 17

Step: 18

 Step: 19

Step: 20

Step: 21

Step: 22

 Step: 23

 Step: 24

Step: 25

Step: 26

Step: 27

Step: 28

 Step: 29

OEM 13c - Oracle Management Server and agent commands

OEM 13c -  OMS OMA  commands

1. emctl start oms
2. emctl status oms
3. emctl stop oms -all

1. emctl config oms -disable_bip
2. emctl config oms -disable_bip

1. emctl start agent
2. emctl status agent
3. emctl stop agent

•  emctl start oms

[oracle@oem13c bin]$ /u01/app/oracle/middleware/bin/emctl start oms

Oracle Enterprise Manager Cloud Control 13c Release 3

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

Starting Oracle Management Server...

WebTier Successfully Started

Oracle Management Server Successfully Started

Oracle Management Server is Up

JVMD Engine is Up

Starting BI Publisher Server ...

BI Publisher Server Successfully Started

BI Publisher Server is Up

[oracle@oem13c bin]$

• emctl start agent

[oracle@oem13c bin]$ /u01/app/oracle/agent/agent_inst/bin/emctl start agent

Oracle Enterprise Manager Cloud Control 13c Release 3

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

Starting agent ................................................................................. started.

[oracle@oem13c bin]$

• emctl status oms

[oracle@oem13c bin]$ /u01/app/oracle/middleware/bin/emctl status oms

Oracle Enterprise Manager Cloud Control 13c Release 3

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

WebTier is Up

Oracle Management Server is Up

JVMD Engine is Up

BI Publisher Server is Up

[oracle@oem13c bin]$

• emctl status agent

[oracle@oem13c bin]$ /u01/app/oracle/agent/agent_inst/bin/emctl status agent

Oracle Enterprise Manager Cloud Control 13c Release 3

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

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

Agent Version          : 13.3.0.0.0

OMS Version            : 13.3.0.0.0

Protocol Version       : 12.1.0.1.0

Agent Home             : /u01/app/oracle/agent/agent_inst

Agent Log Directory    : /u01/app/oracle/agent/agent_inst/sysman/log

Agent Binaries         : /u01/app/oracle/agent/agent_13.3.0.0.0

Core JAR Location      : /u01/app/oracle/agent/agent_13.3.0.0.0/jlib

Agent Process ID       : 16897

Parent Process ID      : 16790

Agent URL              : https://oem13c.example.com:3872/emd/main/

Local Agent URL in NAT : https://oem13c.example.com:3872/emd/main/

Repository URL         : https://oem13c.example.com:4903/empbs/upload

Started at             : 2020-10-21 13:18:24

Started by user        : oracle

Operating System       : Linux version 4.14.35-1902.3.2.el7uek.x86_64 (amd64)

Number of Targets      : 33

Last Reload            : (none)

Last successful upload                       : 2020-10-21 13:22:02

Last attempted upload                        : 2020-10-21 13:22:02

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    : 18.24%

Collection Status                            : Collections enabled

Heartbeat Status                             : Ok

Last attempted heartbeat to OMS              : 2020-10-21 13:21:38

Last successful heartbeat to OMS             : 2020-10-21 13:21:38

Next scheduled heartbeat to OMS              : 2020-10-21 13:22:39

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

Agent is Running and Ready

[oracle@oem13c bin]$

• emctl config oms -disable_bip

[oracle@oem13c ~]$ /u01/app/oracle/middleware/bin/emctl config oms -disable_bip

Oracle Enterprise Manager Cloud Control 13c Release 3

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

Enter Enterprise Manager Root (SYSMAN) Password :

Stopping BI Publisher Server...

BI Publisher Server Successfully Stopped

BI Publisher Server is Down

BI Publisher has been disabled on this host and will not be started with the 'emctl start oms' or 'emctl start oms -bip_only' commands.

Overall result of operations: SUCCESS

[oracle@oem13c ~]$

• emctl stop oms -all

[oracle@oem13c ~]$ /u01/app/oracle/middleware/bin/emctl stop oms -all

Oracle Enterprise Manager Cloud Control 13c Release 3

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

Stopping Oracle Management Server...

WebTier Successfully Stopped

Oracle Management Server Successfully Stopped

Oracle Management Server is Down

JVMD Engine is Down

Stopping BI Publisher Server...

BI Publisher Server Successfully Stopped

AdminServer Successfully Stopped

BI Publisher Server is Down

[oracle@oem13c ~]$

• emctl stop agent

[oracle@oem13c bin]$ /u01/app/oracle/agent/agent_inst/bin/emctl stop agent

Oracle Enterprise Manager Cloud Control 13c Release 3

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

Stopping agent ... stopped.

[oracle@oem13c bin]$

OEM 13c - Schedule RMAN Backup using OEM13c Console

 

Scenario Preview : We are scheduling rman automated backup on regular basis using OEM13c . Remmebr expdp backup is not scheduled using OEM console 

Database name : OEMDB

Rman  Backup location : /u01/rmanbkp

Operating System : OEL 7.7 

1. Go to database console then select schecduled backup database in our case it is OEMDB. In coming blog we going to schedule backup using recovery catalog option so in all target database repository detailed stored on it. In our production console we have done the same as using recovery catalog.  

Availability  > Backup & Recovery > Schedule Backup >  

2.  Select Schedule Customized Backup  select  options in our case we select Whole Database 

3. Select Backup type | Backup mode | Advanced option    

                                    

4. Select Disk or Tape option 

5.  Set Jobs scheduling options describes on screenshots

6. We can customized  rman backup script  as well. on RMAN script window TEXT Box.

7. After Submitting  job we can check on Job Activity 

8.  After execution of job we can check Job is  successful or failed status we can check on job activity

 

9. We can check job report as well as job backup logs.

Availability  > Backup & Recovery >  Backup Report >  

OEM12-13c-examples

OEM 13c : Oracle Enterprise manager Installation 13c on linux 64 bit OS.

OEM13c - Add agents on remote target host server 

EM13c - OMR Database minimum recommended parameters

OEM : Add OEM 12c express edition console on database

OEM 13c - Schedule RMAN Backup using OEM13c Console

OEM 13c - Oracle Management Server and agent commands

OEM12c - Physical Standby sync status

OEM13c - Add agents on remote target host server

Here we add monitoring on OMR database and after that add host on target database server and add monitoring on it using EM 13c Console .

OMR database and OEM 13c are in same server so agent already installed at the time of installation so we add monitoring on server.

1. Add Discovery target on OMR database
2. Add OEM agent on target host and add discovery target 

OMR Database : OEMDB

Hostname : oem13c.example.com

New Target host name : srv3.example.com

Target Database : SMRCDB

OEM Console URL : 

 Enterprise Manager Cloud Control URL: https://oem13c.example.com:7803/em also ( https://192.168.56.71:7803/em)

 Admin Server URL: https://oem13c.example.com:7102/console

BI Publisher URL: https://oem13c.example.com:9803/xmlpserver/servlet/home

STEP 1 : Login OEM console and go to setting and add target manually 

STEP 2 : choose 2nd option (Add Non-Host Targets Using Guided Process )

STEP 3 : As default oracle database and listener automatically set on discovery target types.

STEP 4: Target already installed so we select OMR database server oem13c.example.com

STEP 5: OEM will discover host at there end .

 

STEP 6 : Select on checkbox OEMDB database and add password of dbsnmp schema. By default it is locked.

SQL> alter user dbsnmp account unlock identified by dbsnmp;

User altered.

SQL> select USERNAME,DEFAULT_TABLESPACE,ACCOUNT_STATUS from dba_users where username='DBSNMP';

USERNAME                                 DEFAULT_TABLESPACE             ACCOUNT_STATUS

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

DBSNMP                                   SYSAUX                         OPEN

 

STEP 7 :  Discovery Target Review

STEP 8 : Target confirmation 

 

STEP 9 :  OEMDB  database and listener Successfully on console. 

Adding OEM Agent on target server  and discover target for monitoring

OS NAME : srv3.example.com

STEP 1: Select add host targets

STEP 2 : Add host targets.

 

STEP 3 : Add named credential of oracle user and then  root (optional) user .

STEP 4 : Add  agent base directory /u01/app/oracle/agents . Instance directory will be automatically created.

Default port is 3872.

STEP 5 : Review Agent target hosts

STEP 6: Deploy agent Summary process 

STEP 7: Agent successfully added on target server.

Add Discovery target on srv3.example.com agent

STEP 1: Choose 2nd option ( Add using guided process  and then further select default oracle database and listener option)

STEP 2 : Add host target details.

STEP 3: Add password dbsnmp user on database discovery results in this server we have CDB database so details will automatically fetch by discovery.

STEP 4: Database discovery review

STEP 5: Configuration of  database and listener target saved successfully.

STEP 6 : Successfully done 

STEP 7: OEM 13c Console Summary dashboard