Exadata Healthcheck – Top 5 Tools and Features!

Hi all,
It’s not new for Oracle DBAs the countless great tools we have out of the box to help us out with our daily tasks, such as ORAchk/EXAchk/ODAchk, Database Security Assessment Tool (DBSAT), Hang Manager, Cluster Health Advisor (CHA), Cluster Verification Utility (CVU), Memory Guard, Tracefile Analyzer (TFA) with tools like oratop, procwatcher, oswatcher, pstack, RDA, and the list goes on and on…

The good news is, most of the tools are now together on the Autonomous Health Framework (AHF), since version 12.2. None of those tools are running by default though, so you might need to choose some to start and enable on your environment.

But out of all this list, what if we could choose the top 5 features we can and should use as a start for Exadata Environment? Well, I did mine, see it below.

Oh, and by the way, you don’t pay anything else for them, counting you already have Oracle Support Services!

1. Cluster Health Advisor – Calibrate your Exa Environment!

Available along with the AFH since 12.2, the CHA works along the Cluster Health Monitor to provide you fine-grained notifications and correlations about your environment. And when I say it, I mean it: YOUR environment. This is because the CHA works better if you calibrate it with your statistics. As usual, not the worse problematic day or the low workload night, but an average day which can be used as a reference. All this is stored in the GIMR (as shown below) and used for future comparison and model inference.

This means the CHA is not a long list of IFs with fixed metrics, but an intelligent tool monitoring over 127 processes that perform work based on your workload. Not only this, the CHA is enriched with Machine Learning algorithms that model over 30 known DB problems based on over 150 metric predictors.

 

An example of inference can be seen below, where network and Global Cache statistics are used to inference a network issue.

Not rocket science, but always nice to have someone digesting tons of logs and metrics and reaching this sort of conclusion unassisted, right? You as DBA can steal all credits for the finding, no hard feelings.

And this is just one of the things CHA provides. It has tons of other functionalities. You should try using it more!

 

2. EXAchk – Daily Automated Runs (and Reports)

Most likely if you have an Exadata, you are used to running from time to time an EXAchk to review the recommendations and best practices for your environment. It’s something that requires almost no effort to run and to copy the reports, or you most likely have created an script to do so. What if I tell you Oracle has now automated this with AHF?

All you need to do is to confirm the scheduled runs and set the address for the reports to be sent. Find below a quick Cheatsheet:

a. Checking Status of the EXAchk

[root@exa01dbadm01 ~]# exachk -d info
------------------------------------------------------------

Master node = exa01dbadm01

exachk daemon version = 211300

Install location = /opt/oracle.ahf/exachk

Started at = Wed Jun 16 11:58:03 MDT 2021

Scheduler type = TFA Scheduler


[root@exa01dbadm01 ~]# exachk -d status
exachk is using TFA Scheduler. TFA PID: 369350

b. Checking Status of TFA Daemon Status and Auto Start

[root@exa01dbadm01 ~]# ahfctl statusahf

.-----------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+--------------+---------------+--------+------+------------+----------------------+------------------+
| exa01dbadm01 | RUNNING | 369350 | 5000 | 21.1.3.0.0 | 21130020210607124914 | COMPLETE |
| exa01dbadm02 | RUNNING | 118950 | 5000 | 21.1.3.0.0 | 21130020210607124914 | COMPLETE |
'--------------+---------------+--------+------+------------+----------------------+------------------'

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

Master node = exa01dbadm01

exachk daemon version = 211300

Install location = /opt/oracle.ahf/exachk

Started at = Wed Jun 16 11:58:03 MDT 2021

Scheduler type = TFA Scheduler

------------------------------------------------------------
ID: exachk.autostart_client_exatier1
------------------------------------------------------------
AUTORUN_FLAGS = -usediscovery -profile exatier1 -syslog -dball -showpass -tag autostart_client_exatier1 -readenvconfig
COLLECTION_RETENTION = 7
AUTORUN_SCHEDULE = 3 2 * * 1,2,3,4,5,6
------------------------------------------------------------
------------------------------------------------------------
ID: exachk.autostart_client
------------------------------------------------------------
AUTORUN_FLAGS = -usediscovery -syslog -tag autostart_client -readenvconfig
COLLECTION_RETENTION = 14
AUTORUN_SCHEDULE = 3 3 * * 0
------------------------------------------------------------

Next auto run starts on Jun 17, 2021 02:03:00

ID:exachk.AUTOSTART_CLIENT_EXATIER1

c. Gather EXAchk Next Automated Run

[root@exa01dbadm01 ~]# exachk -d nextautorun

Next auto run starts on Jun 17, 2021 02:03:00

ID:exachk.AUTOSTART_CLIENT_EXATIER1

[root@exa01dbadm01 ~]#

d. Changing EXAchk Notifications:

[root@exa01dbadm01 ~]# exachk -get NOTIFICATION_EMAIL,AUTORUN_SCHEDULE,COLLECTION_RETENTION
------------------------------------------------------------
ID: exachk.autostart_client_exatier1
------------------------------------------------------------
COLLECTION_RETENTION = 7
AUTORUN_SCHEDULE = 3 2 * * 1,2,3,4,5,6
------------------------------------------------------------
------------------------------------------------------------
ID: exachk.autostart_client
------------------------------------------------------------
COLLECTION_RETENTION = 14
AUTORUN_SCHEDULE = 3 3 * * 0
------------------------------------------------------------


[root@exa01dbadm01 ~]# exachk -id autostart_client -set NOTIFICATION_EMAIL=boesing@pythian.com

Updated attribute ['NOTIFICATION_EMAIL=boesing@pythian.com'] for Id[exachk.AUTOSTART_CLIENT]

Successfully copied Daemon Store to Remote Nodes


[root@exa01dbadm01 ~]# exachk -get NOTIFICATION_EMAIL,AUTORUN_SCHEDULE,COLLECTION_RETENTION
------------------------------------------------------------
ID: exachk.autostart_client_exatier1
------------------------------------------------------------
COLLECTION_RETENTION = 7
AUTORUN_SCHEDULE = 3 2 * * 1,2,3,4,5,6
------------------------------------------------------------
------------------------------------------------------------
ID: exachk.autostart_client
------------------------------------------------------------
NOTIFICATION_EMAIL = boesing@pythian.com
COLLECTION_RETENTION = 14
AUTORUN_SCHEDULE = 3 3 * * 0
------------------------------------------------------------

[root@exa01dbadm01 ~]# exachk -id autostart_client_exatier1 -set NOTIFICATION_EMAIL=boesing@pythian.com
Updated attribute ['NOTIFICATION_EMAIL=boesing@pythian.com'] for Id[exachk.AUTOSTART_CLIENT_EXATIER1]

Successfully copied Daemon Store to Remote Nodes


[root@exa01dbadm01 ~]# exachk -get NOTIFICATION_EMAIL,AUTORUN_SCHEDULE,COLLECTION_RETENTION
------------------------------------------------------------
ID: exachk.autostart_client_exatier1
------------------------------------------------------------
NOTIFICATION_EMAIL = boesing@pythian.com
COLLECTION_RETENTION = 7
AUTORUN_SCHEDULE = 3 2 * * 1,2,3,4,5,6
------------------------------------------------------------
------------------------------------------------------------
ID: exachk.autostart_client
------------------------------------------------------------
NOTIFICATION_EMAIL = boesing@pythian.com
COLLECTION_RETENTION = 14
AUTORUN_SCHEDULE = 3 3 * * 0
------------------------------------------------------------

e. Change EXAchk Schedule and Retention

[root@exa01dbadm01 ~]# exachk -id autostart_client_exaier1 –set "AUTORUN_SCHEDULE=0 3 * * *" -> Time= 3 AM daily
[root@exa01dbadm01 ~]# exachk-id autostart_client –set "collection_retention=90"

f. EXAchk: Testing Email Sending and Running EXAchk Report over email

This is for ad-hoc testing to check about email sending, out of the scheduled runs.

[root@exa01dbadm01 ~]# exachk -testemail notification_email=boesing@pythian.com
Email Successfully sent to ['boesing@pythian.com'] from 'root@exa01dbadm01
[root@exa01dbadm01 ~]# exachk -sendemail notification_email=boesing@pythian.com


Searching for running databases . . . . .

. . . . . . . . . . . .
List of running databases registered in OCR

1. xxxxxx
2. yyyy
3. None of above

Select databases from list for checking best practices. For multiple databases, select 3 for All or comma separated number like 1,2 etc [1-3][3].
[...]
Detailed report (html) - /u01/app/oracle/oracle.ahf/data/exa01dbadm01/exachk/user_root/output/exachk_exa01dbadm01_xxxxx_061621_134748/exachk_exa01dbadm01_xxxxx_061621_134748.html

UPLOAD [if required] - /u01/app/oracle/oracle.ahf/data/exa01dbadm01/exachk/user_root/output/exachk_exa01dbadm01_xxxxxx_061621_134748.zip
Email Successfully sent to ('boesing@pythian.com',) from 'root@exa01dbadm01' with attachment

3. TFA – Sanitize and Mask Options

Even with all the concerns on sensitive data being more and more relevant, this is something that actually surprised me. It’s possible to Sanitize and Mask data in collections. For example, mask will hide your inner data (let’s say table names):

[root@exa01dbadm01 ~]# tfactl diagcollect -srdc ORA-00600 -mask

Sanitize will hide your hardware setting. Not that useful if you have an Exadata, but might be interesting if you have commodity hardware you don’t want Oracle to know about.

[root@exa01dbadm01 ~]# tfactl diagcollect -srdc ORA-00600 -sanitize

4. TFA Changes – “Nothing was Changed” Resolver Tool

This is for all the DBAs which had already this dialogue:

Client: Yesterday was running fine, and today it’s veeeery slow. Nothing was changed!
DBA: Something changed, that’s for sure.
Client: Absolutely nothing changed.

So now we can access if indeed nothing changed from the client’s perspective (perhaps an automatic statistics gathering or something) or if anybody did something and is hard to identify.

It takes parameters from OS and DB and tracks of old and new values, reporting changes:

[root@exa01dbadm01 ~]# tfactl changes

Output from host : exa01dbadm02
------------------------------
No Changes Found

Output from host : exa01dbadm01
------------------------------
[Nov/14/2021 00:08:33.000]: [db.dbprod19.dbprod191]: Parameter: log_archive_dest_2: Value: service=dbprod19stb => ASYNC NOAFFIRM delay=240 optional compression=disable max_failure=0 reopen=300 db_unique_name=dbprod19stb net_timeout=300
[Nov/14/2021 00:08:33.000]: [db.dbprod19.dbprod191]: Parameter: log_archive_dest_2: Value: service=dbprod19stb => valid_for=(online_logfile,all_roles)

5. Oracle Health Check Collections Manager

Not a surprise if you don’t know this tool, but I’d really recommend you do look for it now. It’s a great tool and as with everything in this post, it’s free!

Oracle Health Check Collections Manager is an APEX companion application to Oracle EXAchk that gives you an enterprise-wide view of your health check collection data. All you need to have is an APEX 4.2 or 5 version and deploy the tool. The main idea is that you can consolidate all your reports in one place and, as a plus, you can manage all your EXAchk reports across the time, including a view on the items regression you may have.

This is an example of the view of the collections:

And this is an example of a new best practices failure:

Do you agree with my top list? Let me know your thoughts!

Weekly Events #35

Here is a summary of the EVENTS for this and next week!

 

  DECEMBER 05

 

Sangam21 – 13 days

Join us for in-depth technical sessions, masterclasses, hands-on labs, Fireside chats, keynotes, Oracle ACE Community, many more, and of course expand your network at AIOUG Annual flagship conference Sangam21 – Bringing the best of Oracle technology to you!

READ MORE

  DECEMBER 06

 

From Data Warehouse and Data Lake to Data Lakehouse, using all data to innovate

Learn how a data lakehouse on OCI provides an efficient, integrated, automated platform that integrates all your data—whether in a data warehouse, data lake, or application output—and adds analytics capabilities and machine learning to help you get the most value out of your data.

READ MORE

 

  DECEMBER 07
Webcast Series: High Availability and Scalability for Modern Database Architectures

Join Patrick Wheeler (VP-Product Management) for a live briefing on Oracle Multitenant, where we look at comprehensive isolation architecture and best practices for rapid deployment through:

  • Inherent isolation of pluggable databases (PDBs)
  • Integration with security features
  • Resource Manager
  • Pluggable database (PDB) cloning
  • Integration with Data Guard and Oracle RAC

READ MORE

 

High Availability and Scalability for Modern Database Architectures

Join experts from Oracle Product Management as they discuss:

  • High Availability (HA), Scalability, and Disaster Recovery (DR) best practices with a focus on Oracle Maximum Availability Architecture (MAA) strategy for the converged Oracle Database.
  • Updates on Maximum Availability Architecture best practices in support of Modern Database Architectures, including: Microservices, Sharding, Hybrid Cloud, and many more.
  • How to leverage Zero Downtime Migration (ZDM), the latest enhancements in Oracle RAC and Oracle Data Guard, best practices for rapid deployment and workload isolation, and more.

READ MORE

 

Oracle Cloud Test Drive: IDCS Advanced Topics

Proper Identity & Access Management is a cornerstone of a solid security posture – and a mandatory requirement in every digital initiative.

To learn more on how to practically address this topic, we invite you to this session on Oracle Identity Cloud Service (IDCS) for a half-day of hands-on exercises.

Together, we will explore the highest in-demand use cases around Identity and Access Management. We will familiarize ourselves with topics like Single Sign-On (SSO), Multi-Factor Authentication (MFA) , Users Provisioning.

READ MORE

 

ARE YOU GETTING ALL YOU CAN FROM YOUR ORACLE CLOUD ERP?

Oracle’s Cloud ERP SaaS solution is a great way to deliver important features businesses need in a cloud platform such as reliability, scalability, performance and security.

Additionally, since it is built on the Oracle Cloud Infrastructure (OCI), it also saves on cost and maintenance, such as capital expenditures, and also having to manage quarterly upgrades and patches. However, not all customers are aware of the full array of features and automations available in this powerful application.

READ MORE

 

  DECEMBER 08
DBA dag 2021

Was het vorig jaar een virtuele database-week, dit jaar is er weer een echte fysieke, traditionele bijeenkomst voor de DBA’s op woensdag 8 december 2021! De gelegenheid om op een efficiënte en gezellige manier op de hoogte te blijven van wat er speelt in database-land.

READ MORE

 

Webinar: Maximize Data Privacy & Security with Oracle Cloud Infrastructure

Sensitive information stored in databases is the number one target of hackers today. That’s why it’s critical that organizations prioritize database security investments.

Oracle offers a variety of native security features included with Oracle Database, as well as a robust set of database security options to meet any use case or organizational requirement.

READ MORE

 

Computação Quântica e Java

Que tal conhecer um pouco do mundo de Computação Quântica, quais desafios esse novo modelo de computação busca resolver e como ele se encaixa no ecossistema Java. Então, vamos falar de futuro, e vamos ver o Java ir ao infinito e além.
Nesta live o Sérgio Lopes, Engenheiro de Software e Membro do Sou Java, irá trazer esse tema interessante à nossa comunidade.

READ MORE

 

  DECEMBER 09
Get Started with Oracle MySQL – HeatWave and Feel the Difference

MySQL Database Service, with HeatWave, is the only service that enables database administrators and app developers to run OLTP and OLAP workloads directly from their MySQL database. This eliminates the need for complex, time-consuming, and expensive data movement and integration with a separate analytics database. The service is optimized for and exclusively available in Oracle Cloud Infrastructure (OCI).

READ MORE

 

CSS International and Oracle Present: JDE to Cloud for Manufacturing – CTB’s Case for Modernization

Leading companies are unlocking the power of their organizations and creating competitive advantage leveraging Oracle Cloud Applications for Digital Transformation. Join us for this live webcast with Oracle and CSS to see why and how JDE Manufacturing customers are modernizing in phases and transformationally to Oracle Cloud Applications.

READ MORE

 

REAL-WORLD ADVICE TO ENHANCE E-BUSINESS SUITE WITH ORACLE CLOUD INFRASTRUCTURE

In this 60-minute webinar, Syntax solution architects will explore the benefits of running your E-Business Suite solution on Oracle Cloud Infrastructure, key deployment considerations of EBS on OCI, the licensing and requirements necessary for a migration, and easy enhancements you can make to improve availability, scalability, and performance. Running E-Business Suite on OCI allows customers to better leverage their ERP investment without the need to reimplement, while also giving them many of the benefits of a SaaS solution. Leveraging a combination of Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS) offerings from OCI provides customers with better availability and scalability, more out-of-the-box capabilities, and a lower total cost of ownership (TCO).

READ MORE

 

 

OEM 12.5: Tablespace Allocation Metric Not Collected—Agent Is Running but Not Ready

Hi all,

First of all, accept our apologies for the long period without posts. We are about to resolve it and restart with posts. 2021 was such a crazy year, but all is settling down.

Jumping to what you are here for: So, I ran across an interesting case within OEM 12 (Oracle Enterprise Manager) Release 5. A client reported the “tablespace allocation metric” was not being updated on OEM for a specific database. In this case, the most recent gathering was done in November 2020, as I”ll show you shortly. Then, we discovered the problem one month later. This post describes what we did to solve the issue.

As usual, the first thing I did was check on the Oracle Enterprise Manager (OEM) agent status. This is what it said:

oracle:dbserver@mydb02 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 12.1.0.5.0
OMS Version : (unknown)
Protocol Version : 12.1.0.1.0
Agent Home : /u01/app/oracle/product/agent12c/agent_inst
Agent Log Directory : /u01/app/oracle/product/agent12c/agent_inst/sysman/log
Agent Binaries : /u01/app/oracle/product/agent12c/core/12.1.0.5.0
Agent Process ID : 61641
Parent Process ID : 61394
Currently initializing component : Target Manager (2) (54 of 70)
Receivelet Interaction Manager Current Activity: Outstanding receivelet event tasks
----------------------------------
TargetID = oracle_pdb.c4test_PDB1 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29
TargetID = oracle_pdb.c3test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29
TargetID = oracle_pdb.c3test_PDB2 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30
TargetID = oracle_pdb.c4test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29
TargetID = oracle_pdb.c6test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29
TargetID = oracle_pdb.c3test_PDB3 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30
TargetID = rac_database.c1prod - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30


Target Manager Current Activity : Compute Dynamic Properties (total operations: 37, active: 7, finished: 28)


Current target operations in progress
-------------------------------------
oracle_pdb.c6test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c4test_PDB1 - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c3test_PDB2 - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c3test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c4test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c3test_PDB3 - LOAD_TARGET_DYNAMIC running for 120 seconds
rac_database.c1test - LOAD_TARGET_DYNAMIC running for 120 seconds


Dynamic property executor tasks running
------------------------------


---------------------------------------------------------------
Agent is Running but Not Ready

“Agent not ready.” Now, that’s interesting.

Next, I tried to clear the agent state as this had solved some previous similar cases:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl clearstate agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
EMD clearstate completed successfully

Then, I ran the problematic metric manually:

oracle:dbserver02@c1test2 /u01/app/oracle: runCollection c1test_DW:oracle_pdb tbspAllocation <
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection error:The agent is running but is currently not ready to accept client requests

This shows me trying to upload the case:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl upload
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload error:The agent is running but is currently not ready to accept client requests

I thought maybe something was stuck, so I decided to kill the process and start all over again:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Stopping agent ...

stopped.

Here, I made sure I had no agent process running:

oracle:dbserver02@c1test2 /u01/app/oracle: ps -ef | grep java | agent
oracle:dbserver02@c1test2 /u01/app/oracle:

I also adjusted the threshold for metric running:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl setproperty agent -a
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
EMD setproperty succeeded
oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl setproperty agent -allow_new -name _cancelThread -value 210
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
EMD setproperty succeeded

And strating the agent

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl start agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Starting agent ........................................................................................................................... started but not ready.

This was on the agent log:

oracle:dbserver02@c1test2 /u01/app/oracle: tail /u01/app/oracle/product/agent12c/agent_inst/sysman/log/gcagent.log
oracle:dbserver02@c1test2 /u01/app/oracle:
2020-12-20 13:15:03,457 [35:686116F5] DEBUG - StatusAgentAction: satisfyRequest Begin
2020-12-20 13:15:03,457 [35:686116F5] DEBUG - Agent Overall Health: 0
2020-12-20 13:15:03,457 [35:686116F5] DEBUG - StatusAgentAction: satisfyRequest End
Response:
initializing
2020-12-20 13:15:03,457 [35:686116F5] INFO - >>> Reporting response: StatusAgentResponse (initializing) (request id 1) <<<
2020-12-20 13:15:03,457 [35:686116F5] DEBUG - closing request input stream for "StatusAgentRequest (AGENT timeout:300)"
2020-12-20 13:15:03,457 [35:686116F5] DEBUG - overriding the buffer with a thread local copy (size: 8192b)
2020-12-20 13:15:03,458 [35:686116F5] DEBUG - closing request output stream for "StatusAgentRequest (AGENT timeout:300)"
2020-12-20 13:15:03,458 [35:686116F5] DEBUG - StatusAgentAction.call() is complete.
2020-12-20 13:15:03,458 [35:B5326F3F:HTTP Listener-35 - /emd/lifecycle/main/] DEBUG - removing entry for emdctl@18081@dbserver02=>[160849530330001] completely
2020-12-20 13:15:03,458 [35:B5326F3F] DEBUG - requests executed.
2020-12-20 13:15:03,458 [35:B5326F3F] DEBUG - HTTPListener Threads deallocated resource back to LifecycleRequestHandler partition
2020-12-20 13:15:03,458 [35:3C0B0663:HTTP Listener-35] DEBUG - using connection SCEP@1197017148 [d=true,io=1,w=true,b=false|false],NOT_HANDSHAKING, in/out=0/0 Status = OK HandshakeStatus = NOT_HANDSHAKING
bytesConsumed = 5 bytesProduced = 26
2020-12-20 13:15:03,780 [35:3C0B0663] DEBUG - using connection SCEP@1197017148 [d=true,io=1,w=true,b=false|false],NOT_HANDSHAKING, in/out=0/0 Status = OK HandshakeStatus = NOT_HANDSHAKING
bytesConsumed = 26 bytesProduced = 5
2020-12-20 13:15:06,986 [31:858161EB] DEBUG - Submitting task SchedulerHeartbeat for execution
2020-12-20 13:15:06,986 [395:1AE716D8] DEBUG - Begin task SchedulerHeartbeat on Thread: GC.SysExecutor.8
2020-12-20 13:15:06,986 [395:F944F4C8:GC.SysExecutor.8 (SchedulerHeartbeat)] DEBUG - Scheduler heartbeat
2020-12-20 13:15:06,988 [395:F944F4C8] DEBUG - Scheduling next SchedulerHeartbeat after delay 29998 including periodShift of 0 milliseconds
2020-12-20 13:15:06,988 [395:1AE716D8:GC.SysExecutor.8] DEBUG - End task SchedulerHeartbeat
2020-12-20 13:15:07,016 [31:858161EB] DEBUG - Submitting task HeapMonitorTask for execution
2020-12-20 13:15:07,017 [396:1AE716D9] DEBUG - Begin task HeapMonitorTask on Thread: GC.SysExecutor.9
2020-12-20 13:15:07,017 [396:391F60D7:GC.SysExecutor.9 (HeapMonitorTask)] DEBUG - Scheduling next HeapMonitorTask after delay 5000 including periodShift of 0 milliseconds
2020-12-20 13:15:07,017 [396:1AE716D9:GC.SysExecutor.9] DEBUG - End task HeapMonitorTask
2020-12-20 13:15:12,017 [31:858161EB] DEBUG - Submitting task HeapMonitorTask for execution
2020-12-20 13:15:12,017 [37:1AE716D0] DEBUG - Begin task HeapMonitorTask on Thread: GC.SysExecutor.0
2020-12-20 13:15:12,017 [37:FE21F10E:GC.SysExecutor.0 (HeapMonitorTask)] DEBUG - Scheduling next HeapMonitorTask after delay 5000 including periodShift of 0 milliseconds
2020-12-20 13:15:12,017 [37:1AE716D0:GC.SysExecutor.0] DEBUG - End task HeapMonitorTask
2020-12-20 13:15:12,189 [33:6D553CF6] DEBUG - HTTPListener Threads deallocated resource back to LifecycleRequestHandler partition
2020-12-20 13:15:12,190 [35:3C0B0663] DEBUG - using connection SCEP@1611645943 [d=true,io=1,w=true,b=false|false],NOT_HANDSHAKING, in/out=0/0 Status = OK HandshakeStatus = NOT_HANDSHAKING
bytesConsumed = 100 bytesProduced = 121
2020-12-20 13:15:12,191 [35:7107E334:HTTP Listener-35 - /emd/persistence/main/] DEBUG - HTTPListener Threads allocated resource from LifecycleRequestHandler partition
2020-12-20 13:15:17,017 [31:858161EB] DEBUG - Submitting task HeapMonitorTask for execution
2020-12-20 13:15:17,018 [45:1AE716D1] DEBUG - Begin task HeapMonitorTask on Thread: GC.SysExecutor.1
2020-12-20 13:15:17,018 [45:CBCC52CF:GC.SysExecutor.1 (HeapMonitorTask)] DEBUG - Scheduling next HeapMonitorTask after delay 5000 including periodShift of 0 milliseconds
2020-12-20 13:15:17,018 [45:1AE716D1:GC.SysExecutor.1] DEBUG - End task HeapMonitorTask

Following MOS Enterprise Manager12c: Oracle Database Tablespace Monthly Space Usage shows no data (Doc ID 1536654.1), I made a few changes:

$/AGENT_INST/bin/emctl setproperty agent -allow_new -name MaxInComingConnections -value 150
$/AGENT_INST/bin/emctl setproperty agent -allow_new -name _cancelThread -value 210

Here’s the status before the change:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 12.1.0.5.0
OMS Version : (unknown)
Protocol Version : 12.1.0.1.0
Agent Home : /u01/app/oracle/product/agent12c/agent_inst
Agent Log Directory : /u01/app/oracle/product/agent12c/agent_inst/sysman/log
Agent Binaries : /u01/app/oracle/product/agent12c/core/12.1.0.5.0
Agent Process ID : 61641
Parent Process ID : 61394
Currently initializing component : Target Manager (2) (54 of 70)
Receivelet Interaction Manager Current Activity: Outstanding receivelet event tasks
----------------------------------
TargetID = oracle_pdb.c4test_PDB1 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29
TargetID = oracle_pdb.c3test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29
TargetID = oracle_pdb.c3test_PDB2 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30
TargetID = oracle_pdb.c4test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29
TargetID = oracle_pdb.c6test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29
TargetID = oracle_pdb.c3test_PDB3 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30
TargetID = rac_database.c1test - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30

Target Manager Current Activity : Compute Dynamic Properties (total operations: 37, active: 7, finished: 28)

Current target operations in progress
-------------------------------------
oracle_pdb.c6test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c4test_PDB1 - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c3test_PDB2 - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c3test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c4test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
oracle_pdb.c3test_PDB3 - LOAD_TARGET_DYNAMIC running for 120 seconds
rac_database.c1test - LOAD_TARGET_DYNAMIC running for 120 seconds

Dynamic property executor tasks running
------------------------------


---------------------------------------------------------------
Agent is Running but Not Ready

And this was the status after the change:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 12.1.0.5.0
OMS Version : 12.1.0.5.0
Protocol Version : 12.1.0.1.0
Agent Home : /u01/app/oracle/product/agent12c/agent_inst
Agent Log Directory : /u01/app/oracle/product/agent12c/agent_inst/sysman/log
Agent Binaries : /u01/app/oracle/product/agent12c/core/12.1.0.5.0
Agent Process ID : 56994
Parent Process ID : 56654
Agent URL : https://dbserver02:3872/emd/main/
Local Agent URL in NAT : https://dbserver02:3872/emd/main/
Repository URL : https://omsweb:4903/empbs/upload
Started at : 2020-12-20 13:08:35
Started by user : oracle
Operating System : Linux version 3.10.0-957.27.2.el7.x86_64 (amd64)
Last Reload : (none)
Last successful upload : 2020-12-20 13:40:41
Last attempted upload : 2020-12-20 13:40:41
Total Megabytes of XML files uploaded so far : 1.02
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 10.85%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2020-12-20 13:40:40
Last successful heartbeat to OMS : 2020-12-20 13:40:40
Next scheduled heartbeat to OMS : 2020-12-20 13:41:40

---------------------------------------------------------------
Agent is Running and Ready

Great! Agent issue resolved.

However, the metric was not being gathered—not even after running it manually:

oracle:dbserver01@c1test1 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl control agent runCollection c1test_CDBROOT:oracle_pdb tbspAllocation
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection completed successfully

oracle:dbserver01@c1test1 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl status agent scheduler | grep tbspAllocation
2020-12-28 23:05:14.562 : rac_database:c1test:tbspAllocation_cdb
2020-12-29 03:07:21.988 : rac_database:c4prod:tbspAllocation_cdb
2020-12-29 03:08:11.888 : rac_database:c6prod:tbspAllocation_cdb
2020-12-29 03:09:39.103 : rac_database:c2prod:tbspAllocation_cdb
2020-12-29 03:09:55.372 : rac_database:c3prod:tbspAllocation_cdb

oracle:dbserver01@c1test1 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl control agent runCollection c1test_DW:oracle_pdb tbspAllocation
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection completed successfully

Meanwhile, on the OEM repository database:

SQL> select TARGET_NAME,TARGET_TYPE,TARGET_GUID,max(ROLLUP_TIMESTAMP )
from mgmt$metric_daily where TARGET_NAME like '%c1test%'
and TARGET_TYPE='oracle_pdb'
and METRIC_NAME='tbspAllocation'
group by TARGET_NAME,TARGET_TYPE,TARGET_GUID; 2 3 4 5

TARGET_NAME TARGET_TYPE TARGET_GUID MAX(ROLLUP_TIMESTAM
------------------------------ -------------------- -------------------------------- -------------------
c1test_DW oracle_pdb 7B1DF5DD4555EB978330A6D522004D44 2020-11-12 00:00:00
c1test_CDBROOT oracle_pdb 4CE72911295C0287E053837F649B7D0E 2020-11-12 00:00:00


SQL> select TARGET_NAME,TARGET_TYPE,TARGET_GUID,ROLLUP_TIMESTAMP from mgmt$metric_daily where TARGET_NAME like '%c1test%' and TARGET_TYPE='oracle_pdb' and ROLLUP_TIMESTAMP>sysdate-3 order by 4

TARGET_NAME TARGET_TYPE ROLLUP_TIMESTAMP AVERAGE
------------------------------ -------------------- ------------------- ----------
c1test_DW oracle_pdb 2020-11-06 00:00:00 1575.9375
c1test_DW oracle_pdb 2020-11-07 00:00:00 1575.9375
c1test_DW oracle_pdb 2020-11-08 00:00:00 1575.9375
c1test_DW oracle_pdb 2020-11-09 00:00:00 1575.9375
c1test_DW oracle_pdb 2020-11-10 00:00:00 1575.9375
c1test_DW oracle_pdb 2020-11-11 00:00:00 1575.9375
c1test_DW oracle_pdb 2020-11-12 00:00:00 1575.9375
c1test_CDBROOT oracle_pdb 2020-11-05 00:00:00 37581.5625


TARGET_NAME TARGET_TYPE ROLLUP_TIMESTAMP AVERAGE
------------------------------ -------------------- ------------------- ----------
c1test_CDBROOT oracle_pdb 2020-11-08 00:00:00 227138.75
c1test_CDBROOT oracle_pdb 2020-11-09 00:00:00 455087.688
c1test_CDBROOT oracle_pdb 2020-11-10 00:00:00 278230.875
c1test_CDBROOT oracle_pdb 2020-11-11 00:00:00 208727.188
c1test_CDBROOT oracle_pdb 2020-11-12 00:00:00 454964.063

In summary: After fixing all the issues on the OEM side, with everything running fine, the database metrics were still not being updated:

To make a long story short, after some investigation, I came across the following in MOS (My Oracle Support): Database Hangs With Simple Queries like on view dba_data_files & dba_free_space (Doc ID 2665935.1)

This seemed to be a match. So, I proceeded with its recommendations on OMS database:

SQL> alter session set container=DW;

Session altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 DW READ WRITE NO
SQL> select count(*) from dba_recyclebin;

COUNT(*)
----------
28522

SQL> purge recyclebin;

Recyclebin purged.

SQL> purge dba_recyclebin;

DBA Recyclebin purged.

With that done, all the issues were solved and the metric was being collected again:

Tablespace allocation metric.

 

Here are some additional references:

  • Database Tablespace Metrics: Tablespace Allocation Is Not Collected (Metric tbspAllocation) (Doc ID 404692.1)
  • EM 12c : emctl start agent Fails With Error ‘Starting agent … started but not ready’ (Doc ID 1591477.1)
  • EM12c : emctl start / status agent ‘Agent Running but Not Ready’ ‘ERROR – The agent is overloaded [current requests: 30]’ Reported in gcagent.log (Doc ID 1546529.1)

 

I hope this helps!

If you have any questions or thoughts, please leave them in the comments. And don’t forget to sign up for the next post.

 

 

Weekly Events #34

Here is a summary of the EVENTS for this and next week!

 

   NOVEMBER 23

 

Upgrade to Oracle Database 19c and Ensure Performance Stability

In this hands-on workshop the Oracle Database Upgrade and Migration team will guide you through the upgrade to Oracle Database 19c but will make you familiar with all the performance stability and tuning features to ensure everything runs as smoothly as before. The workshop will be a combination of presentations and hands-on work done by you.

READ MORE

 

Accelerating ISV Success, Cloud Path Towards Better Outcome

Join our webinar and learn these 6 reasons why ISVs are now choosing OCI:

  • Leading price-performance
  • Dedicated Cloud Lift ISV expert help with onboarding and migration
  • Security that’s built in, on by default, at NO extra charge
  • Extreme Flexibility offers unique customization capabilities
  • Cloud Native services
  • Go-To Market and Partnership Opportunities

READ MORE

 

[Online]Boas práticas na adoção de testes de performance com k6

Neste evento ONLINE e GRATUITO (live #34) do Azure na Prática o MVP Tiago Tartari irá abordar a implementação loading e stress tests, utilizando uma das mais promissoras ferramentas para essa finalidade e que recentemente foi adquirida pela Grafana Labs: o k6.io!

Aguardamos vocês para juntos aprendermos mais sobre essa ferramenta, uma das mais adoradas pelos SREs e que auxiliará até mesmo em simulações de caos (Chaos Engineering).

READ MORE

   NOVEMBER 24

 

Oracle Virtual Event: The Modern Data Warehouse

Data is a critical resource for every organisation, and maximising its value requires a modern approach to data management. In this briefing, we will cover the challenges customers face when trying to ingest, consolidate, catalogue, secure and analyse large amounts of data from multiple sources. We will talk about new cloud capabilities, such as autonomous and data science services, that are making it easier for organisations to manage and extract value from their data.

READ MORE

 

   NOVEMBER 25

 

Oracle DevLab: Using a Data Mesh to connect the data of traditional applications with Microservices

In this hands-on lab we will be using the principles of a Data Mesh to connect the data of a traditional monolithic application using a relational database, and link it towards a series of JSON based Microservices that consume this information, coupled via a Data Pump running on GoldenGate. We will showcase the principles of Data Domains, each responsible for its own data, and managing it like a product, a common Data Platform, and the management and governance of such a platform.

READ MORE

 

Oracle Cloud Infrastructure as foundational base of Multicloud strategy

Oracle Cloud Infrastructure can be the foundational piece to a successful Multicloud environment. The webinar will review the potential integration points of OCI and other cloud providers with examples and demonstrations. Agenda for this session is as a mixture of both technical and business topics.

READ MORE

 

Oracle Machine Learning For Python (OML4Py) Workshop

This hands-on workshop focuses on Oracle Machine Learning for Python (OML4Py) which enables AI and ML capabilities of the Oracle Database in conjunction with the popular Python programming language and Jupyter notebooks. You will learn to apply machine learning concepts and algorithms to solve real-world problems ranging from data acquisition and feature engineering, to creating ML models and tuning for optimal results.

READ MORE

 

Weekly Events #33

Here is a summary of the EVENTS for this and next week!

 

   NOVEMBER 16

 

DOAG 2021 KONFERENZ + AUSSTELLUNG ONLINE

Freuen Sie sich auf ein einzigartiges Online-Erlebnis mit hochkarätigen Vorträgen in acht parallelen Tracks zu den vier Hauptthemenbereichen “Database & Infrastructure”, “Development & Middleware”, “Data Analytics & KI” sowie “Strategie & Innovation”. Ein besonderer Fokus liegt zudem auf Themen rund um DevOps und Cloud.

READ MORE

 

Oracle + Deloitte: Diversidad e inclusión en los Negocios
  • Quienes adopten la diversidad tendrán más posibilidades de prosperar, mientras aquellos que la ignoren las tendrán de fracasar
  • La satisfacción laboral es un objetivo práctico para los expertos en D&I, ya que una plantilla feliz es una plantilla más productiva
  • Hoy en día también sabemos que la diversidad fomenta el compromiso de los trabajadores gracias a que aumenta la confianza
  • El valor de la diversidad y la inclusión tiene que llegar a entenderse de forma tangible. La diversidad va más allá de lo demográfico (raza y género) e incluye aspectos como el cognitivo (formación y personalidad).
  • La ventaja competitiva de una buena estrategia de diversidad e inclusión reside en que se va filtrando desde arriba y potencia la inclusión y la igualdad—el feedback entre compañeros y los grupos de reflexión

READ MORE

 

Data Protection as mandatory part of business continuity – How to reduce risks on data with Oracle?

Organizations today are concerned about data security for two main reasons: First, they need to minimize the risk of experiencing a data breach, and second, they need to comply with the requirements of national/state laws, industry regulations, and best practise benchmarks.

Privacy laws regulate the collection, storage, sharing, control, and use of personal information about individuals, also called personal data or Personally Identifiable Information (PII).

READ MORE

 

JSON and SODA with the Oracle Autonomous JSON Database Workshop

SODA is a set of NoSQL-style APIs that let you create and store collections of documents (in particular JSON) in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the documents are stored in the database.

READ MORE

 

   NOVEMBER 17

 

Oracle Cloud Infrastructure Basic Workshop

Oracle set an ambitious goal in building its second-generation cloud infrastructure: to create an infrastructure that matches and surpasses the performance, control and governance of enterprise datacenters, while delivering the scale, elasticity, and cost-savings of public clouds.

The result, Oracle Cloud Infrastructure, is built from the ground up to be an Enterprise Cloud, equally capable of running traditional multi-tiered enterprise applications, high-performance workloads, and modern serverless and container-based architectures.

Gain foundational knowledge of OCI services.

READ MORE

 

Oracle GraalVM Enterprise Webcast Series

GraalVM Enterprise 21.3 set a new standard for microservices. An ideal Java microservice would be “instant on” with lightning fast startup and immediate peak performance without warmup, while minimizing resource consumption to keep costs down. In GraalVM Enterprise 21.3, Native Image ahead-of-time compiled executables provide all these key features and deliver new levels of performance on par with JIT compiled applications running on the JVM.

READ MORE

 

Live Workshop: Oracle Cloud Native Development.

Join us in this 2 hour live demonstration where will explain basic Kubernetes concepts using a live cluster, show you the process for setting up basic common Kubernetes services (Dashboard and ingress controller) using the Kubernetes software installation tool Helm, and then walk you through the stages of setting up some example microservices along with their supporting elements such as configuration.

READ MORE

 

   NOVEMBER 18

 

Let’s Talk Oracle Database Appliance (ODA)

Discover the essential administration tasks for the Oracle Database Appliance (ODA) by working through real world exercises on an ODA Simulator that is delivered from Oracle Cloud.
Experience how to setup the ODA Simulator, how to access the CLI and BUI, how to configure, deploy, manage, patch, and many more tasks. You will also get to meet the experts from the ODA product team who will be there to answer your questions live and assist with issues.
Continue to have access to the ODA Simulator after the workshop is completed, a valuable resource for learning and practice and discovery.

READ MORE

 

Weekly Events #32

Here is a summary of the EVENTS for this and next week!

 

   OCTOBER 31

 

Oracle Groundbreakers APAC Virtual Tour

With the participation of many Oracle User Groups, and Java Communities in the region, this year’s event is promising to be the biggest event ever done within the APACOUC Community.

READ MORE

 

   NOVEMBER 02

 

Oracle Database World—Europe, Middle East, Africa

Various sessions and hands-on labs will include topics such as Autonomous Data Warehouse and Data Lake, Exadata Cloud@Customer, Kubernetes and microservices, Machine Learning, Database 21c, and more. You will not want to miss this event. This is your opportunity to learn about Oracle’s latest database innovations and how you can put them to work to start creating your data-driven organization. This virtual event includes keynotes, over 35 sessions, live Q&A with database development experts, 24 speaker-led hands-on labs, and additional 55 on-demand sessions.

READ MORE

 

 

Oracle PartnerCast: Pricing & Sizing MySQL Database Service and HeatWave Workloads

Due to significant benefits, many customers have already migrated their MySQL workloads from other cloud vendors to OCI. For partners, these services provide a materially differentiated cloud solutions that will allow you to create new services revenue, drive additional OCI consumption, and capture new logos. Join this OPN PartnerCast to learn how to properly price and size MySQL Database Service and HeatWave workloads for your customers.

READ MORE

 

   NOVEMBER 03

 

Oracle GoldenGate Stream Analytics Hands on Lab

Join Oracle’s Product Managers and Engineers, who will guide you through several streaming data scenarios using GoldenGate Stream Analytics. You will learn about various resources and components that make GoldenGate Stream Analytics the best tool to move data from variety of sources to variety of targets while applying the latest Machine Learning and Analytics techniques. Learn why this application can play an important role in Data Mesh and modernizing your architecture towards Data Product thinking.

READ MORE

 

NWOUG 2021 Seattle Training Day

Our annual user Seattle Training Day, where our goal is to provide education, facilitate networking and technical resources, and relay Oracle Corporation’s strategy and direction to application and database users.

READ MORE

 

Win with Oracle Cloud: Quarterly OCI Business & Technology Partner Update

In addition to our monthly partner enablement, roadmap updates, and yearly events like the Partner Technical Council, we want to give you in 60 Minutes an additional opportunity, to communicate with Oracle and get the latest and greatest Information on Oracle technology updates and Oracle Cloud Infrastructure, for the previous and the next quarter to come.

READ MORE

 

   NOVEMBER 04

 

ORACLE E-BUSINESS SUITE PERFORMANCE TUNING TIPS AND BEST PRACTICES

In this 60-minute webinar, a Syntax Oracle E-Business Suite expert will lead you through a series of recommendations to ensure the high performance of your Oracle EBS system for day-to-day operations. We will cover the key elements and best practices related to E-Business Suite application configuration and database design that will enable you to get the most out of your production environment.

READ MORE

 

Weekly Events #31

Here is a summary of the EVENTS for this and next week!

 

   OCTOBER 25

 

Michigan Oracle Users Summit 2021

For MOUS 2021, we will be hosting a virtual event with four (4) days of seminars, speakers, and virtual networking sessions with other Oracle users and professionals. Presentations will cover the following areas: Oracle Application Express (APEX), Big Data, Cloud Computing and Infrastructure, Coding and Application Development, Data Warehouse, Data Lake, Business Analytics, Database Technologies & Tools, E-Business Suite and Cloud Applications, Oracle EPM, Oracle SaaS, Peoplesoft and JD Edwards.

READ MORE

 

   OCTOBER 26

 

Oracle Database World—Americas

Various sessions and hands-on labs will include topics such as Autonomous Data Warehouse and Data Lake, Exadata Cloud@Customer, Kubernetes and microservices, Machine Learning, Database 21c, and more. You will not want to miss this event. This is your opportunity to learn about Oracle’s latest database innovations and how you can put them to work to start creating your data-driven organization. This virtual event includes keynotes, over 35 sessions, live Q&A with database development experts, 24 speaker-led hands-on labs, and additional 55 on-demand sessions.

READ MORE

Oracle Autonomous Database Workshop

The workshop will cover exercises for creating an Autonomous Database on the Oracle Public Cloud, exploring the monitoring and management tools, accessing the Autonomous Database securely from various clients, and run workloads with Swingbench against the database.

READ MORE

 

Oracle Database Security Sales and Presales

Databases continue to be the most attractive targets for attackers because they are the information store with all the sensitive data. Oracle Databases hold the majority of the world’s relational data. Safeguard your most valuable data with Oracle’s powerful preventive and detective security controls. Learn how to shrink the attack surface and reduce the number of ways in which attackers can access the databases, and how important it is to enforce separation of Keys & Master Keys from encrypted Data.

READ MORE

 

Oracle Cloud Analytics for Business – Data Visualization Workshop

This Partner Workshop focused on Data Visualization capabilities included in OAC. Data Visualization allows you to analyze data coming directly from a wide variety of sources and to take a full advantage of your data, you need to easily share results with anyone, and collaborate smartly across teams to refine analytics content. Join everyone’s collective wisdom to drive insights that lead to quick action and the best possible outcomes.

READ MORE

 

Live Webinar: Igniting Research with Oracle High Performance Computing

From the depths of outer space to the microscopic cells that make up the human body, Oracle Cloud Infrastructure is the computing powerhouse behind some of the most groundbreaking scientific discoveries of our time. Join these monthly webcasts to learn more about Oracle Cloud Infrastructure and its high performance computing capabilities that delivers the technology that allows you to build, integrate migrate, deploy and secure cloud, mobile and web applications for research.

READ MORE

 

Helping you build awesome digital assistant experience – PaaS Partner Community Webcast

To help our partners and customers build better digital assistants the ODA Development Team have set up a Center of Excellence that not only researches and tests best practices, but we also offer periodic code reviews, architectural advice and guidance on conversation design and the implementation of these best practices. In this session Grant Ronald, Senior Director of Product Management will introduce the services of the ODA Center of Excellence and how you can engage with the group.

READ MORE

 

   OCTOBER 27

 

Oracle Groundbreakers APAC Virtual Tour

With the participation of many Oracle User Groups, and Java Communities in the region, this year’s event is promising to be the biggest event ever done within the APACOUC Community.

READ MORE

Simplifying rules, dynamics, and validations with Oracle’s Clinical One

What if you could

  • Define question, form, and visit dynamics with system validations instead of rules?
  • Seamlessly design rules, validate those rules as you write them, and then publish to production?
  • Simplify complex rule design?
  • And all without specialist programming?

That’s what you get with Clinical One!

READ MORE

 

Oracle Cloud Coaching: Modernize your Monitoring-OCI Observability and Management Platform

Cloud Coaching Office Hours provide an opportunity for you to interface directly with experts and find additional help for your organization. Join us for an interactive Webinar where you can learn firsthand how OCI Observability and Management Platform provides 360-degree insight into the performance, availability, and capacity of your IT investment.

READ MORE

 

Oracle helping Organizations to Meet Tomorrow’s Need

Recruiting organizations are tasked with broadening the scope of talent acquisition beyond applicant tracking, to understanding the needs of the business and the skills, experiences, and career aspirations of candidates to pair the right person with the right opportunity. Join us to listen Alzamil Industrial and Oracle product development team about the recruiting challenges to understand the strides Oracle has made for recruiting in the cloud.

READ MORE

 

MySQL Autopilot – Boosts Analytic Performance up to 5400X at 1/3 cost

Oracle MySQL has been revolutionarily upgraded to include a new ultra-high-performance parallel processing query engine called HeatWave and machine learning based automation called Autopilot. With HeatWave and Autopilot, MySQL Database Service (MDS) is the only service that enables database admins and app developers to run OLTP and OLAP workloads directly from their MySQL database. This eliminates the need for complex, time-consuming, and expensive data movement and integration with a separate analytics database.

READ MORE

 

   OCTOBER 28

 

Oracle Meet the Expert Session: Optimized Infrastructure for Microservices Applications

Dapatkan informasi terkini mengenai infrastruktur yang dioptimisasi untuk kebutuhan pengembangan dan pengoperasian aplikasi berbasis Microservices yang dapat meningkatkan efisiensi dan produktifitas operasional bisnis Anda.

READ MORE

 

   OCTOBER 29

 

ACCOUNTING HUB CLOUD SERVICE – THE NEW KID IN TOWN

Are you looking to move to cloud ERP from your on-premise applications but are finding it difficult to find the best way forward? Learn how Oracle Accounting Hub Cloud can help with your digitalization strategy and help enable your business to grow at scale.

READ MORE

Weekly Events #30

Here is a summary of the EVENTS for this and next week!

 

   OCTOBER 04
RECONNECT Dive Deep

Build your PeopleSoft skills, knowledge and expertise with 4 jam-packed days of hands-on digital education. At RECONNECT Dive Deep, you learn directly from the PeopleSoft experts: the Oracle teams who build your product, the partners who implement the latest features and functionality and the expert customers who successfully drive business value through their use of the product capabilities.

Meet PeopleSoft users from around the world and connect with the Oracle product teams for the latest on new releases, feature enhancements and roadmaps for HCM, ERP and PeopleTools, plus live demos and plenty of customer Q&A. Take your pick of how-to sessions with the product experts and learn practical PeopleSoft tips for immediate use.

READ MORE

 

   OCTOBER 05
Berliner Expertenseminar: Oracle Datenbank Performance für Entwickler

Wie holt man die maximale Performance aus der Datenbank? Was kann ich als Entwickler tun, um bestmöglichst mit der Oracle Datenbank zusammenarbeiten zu können? Wir fangen bei der Instrumentierung an, wie sich Performance in der Datenbank überhaupt auf einfache Art und Weise sichtbar und überprüfbar macht, schauen uns anhand von Fallbeispielen, die an realen Fällen aus der Praxis angelehnt sind, wie der Optimizer funktioniert bzw. nicht funktioniert, wie man Ausführungspläne richtig liest und worauf es bei der Erstellung von Statistiken ankommt. Wir beschäftigen uns mit “guten” und “bösen” Hints und wie diese bei der Erstellung von komplexen SQLs hilfreich sein können. Wir schauen uns an, was man bei der Verwendung von Bind-Variablen bzw. statischem SQL in PL/SQL beachten sollte und wie die optimale Mischung aus Literalen und Bind-Variablen aussehen kann. Und natürlich ist eine gute Indizierung und was es dabei zu beachten gibt eines der Hauptthemen. In diesem Zusammenhang schauen wir uns auch an, was Clustering bedeutet, welche Möglichkeiten neuere Oracle-Versionen hier bieten sowie die unterschiedlichen Speicherformen (Heap, Index Organized, Cluster).

READ MORE

 

   OCTOBER 07
EASE THE BURDEN OF YOUR SAAS UPDATE WITH AUTOMATED TESTING

Oracle delivers new updates every quarter to help manage your business with features delivered enabled and immediately available to end users. As this occurs, extra emphasis is placed on the importance of functional/regression testing to minimize the risk of impact on any downstream systems. This is why it is critical that automated testing is built into an organization’s regular cadence of updates.

The right testing solution can help improve all areas of end-to-end testing from test planning and management, test script development and execution, results analysis and defect monitoring. And, believe it or not, “only 45% of organizations believe they have the right testing strategy, process, and methodology in place” (World Quality Report, 2020-21).

If you are struggling to find a solution to your testing problem for Oracle Cloud Applications, join this session to see how you can ease and speed up the burden of functional/regression testing, without involving technical resources. Using a tool that is application aware allows business analysts and super-users to organize, set up, modify and maintain test scripts–saving up to 70% of time spent creating and maintaining test scripts and 60% of time spent in test execution.

READ MORE

 

Weekly Events #29

Here is a summary of the EVENTS for this and next week!

 

   SEPTEMBER 27

 

[Online].NET 5/ASP.NET Core, APIs REST, desen.Back-End: dicas p/ o dia a dia pt4

Acompanhe este evento ONLINE e GRATUITO no Canal .NET com dicas, truques e alternativas úteis para o desenvolvimento Back-End e de APIs REST com .NET 5, ASP.NET Core, Azure Functions. Ao longo da apresentação será coberto o uso de diferentes frameworks, serviços na nuvem, mensageria e boas práticas de forma a facilitar e tornar mais dinâmica a implementação de soluções baseadas na plataforma .NET no seu dia a dia.

READ MORE

 

   SEPTEMBER 28

 

OSPA Session : Oracle Communications Operations Monitor Boot Camp

ORACLE COMMUNICATIONS OPERATIONS MONITOR BOOT CAMP

The goal of this Implementation boot camp is to educate and make Oracle Partners aware of Oracle Communications Operations Monitor (also called Enterprise Operations Monitor on Enterprise networks). After taking this course, Oracle Partners should be enabled to bid for OCOM/EOM projects with a degree of confidence.

See boot camp detailed agenda.

WHAT WE WILL COVER

This Boot Camp provides an overview of the features and functions of the Oracle Communications Operations Monitor (OCOM) and Enteprise Operations Monitor (EOM). The OCOM/EOM platform is designed to monitor and troubleshoot in real-time and from an End-to-End point of view both a Service Provider (OCOM) or Enterprise communications network (EOM). The product uses and supports open, industry standards such as SIP, Diameter, RTP, ENUM, among other. Leading customer use cases include proactive problem detection and rapid identification, isolation and resolution of call quality issues, visibility into encrypted calls, reduced risks of business interruption and tracking Key Performance Indicators (KPIs) in real-time.

READ MORE

   SEPTEMBER 29

 

UKOUG Together 2021

This November, join the UK Oracle community for two days jam-packed with content covering both Oracle Applications and Technology.

We know that two years on from our last physical event many of you are ready to get together and interact directly with industry experts, Oracle advocates and product managers. This is your opportunity to hear the latest updates from Oracle and learn tips & tricks from the community.

READ MORE

 

APEX World 2021

APEX World 2021 wordt op woensdag 29 en donderdag 30 september 2021 gehouden op de KNVB Campus in Zeist*. Thema dit jaar is ‘APEX World Reloaded!’

Naast keynotes, als vanouds verzorgd door het Oracle APEX team, en een breed scala van parallelsessies tijdens beide dagen, staan tijdens APEX World ook dit jaar weer Customer Cases, Student Tracks (op donderdag) en een OpenMic-sessie op de agenda.

Internationale sprekers tijdens APEX World 2021 zijn onder meer: Chris Saxon, Karen Cannell en Francis Mignault. Ook gerenommeerde Nederlandse en Belgische sprekers als Roel Hartman, Dimitri Gielis en Alex Nuijten hebben hun medewerking toegezegd.

De eerste dag van APEX World wordt traditioneel afgesloten met een uitgebreid dinerbuffet met volop gelegenheid om te netwerken.

READ MORE

 

PRACTICAL TRAINING: HOW TO GET OFF THE HAMSTER WHEEL OF ORACLE CLOUD QUARTERLY UPDATES

One of the key challenges Oracle Cloud customers have is keeping pace with the quarterly upgrade schedule for Oracle Cloud applications.

The team tasked with managing this process can be easily overwhelmed, given that these upgrade cycles happen so frequently.

In this webinar we will discuss some practical tips and tools that can help you effectively prepare for and deal with these upgrades, making your life easier, helping you deliver a better quality of service to your business stakeholders: the actual end users – your employees.

READ MORE

 

   SEPTEMBER 30

 

Ce que vous devez savoir avant de migrer votre DB Oracle vers SAP Hana

Êtes-vous un client SAP qui prévoit de migrer ses bases de données SAP d’Oracle à Hana ? Alors ce webinaire est fait pour vous.
Cette opération confrontera à des coûts de support élevés que vous ne pourrez pas réduire tant que vous n’aurez pas remplacé la dernière base de données Oracle.

Cela peut prendre des années. Si c’est le cas pour vous, nous avons une solution à vous présenter qui sera introduite lors de cette session web.

L’approche de la solution est la suivante : Tout d’abord, migrer tout ce qui est possible d’Oracle vers SAP Hana. Les autres applications SAP qui doivent rester sur Oracle sont portées soit sur Oracle Public Cloud, soit sur Oracle Private Cloud, directement dans votre propre centre de données. Les deux cloud disposent du service Oracle PaaS, qui comprend également les licences de la base de données. Cela vous permet d’annuler complètement les contrats de support Oracle existants, puisque vous disposez d’une licence correcte via le service Oracle PaaS. De cette façon, vous pouvez généralement réduire les coûts et ne payer que ce dont vous avez finalement besoin.

READ MORE

 

Leveraging TFA Collections in High Availability, Enterprise Manager and DB Admin

DBAs and System Administrators are expected to do more work with fewer resources. When you’re under pressure to keep mission-critical apps up and running and something goes wrong, a timely resolution is crucial and everyone looks to you to determine what went wrong and how to fix it.

Oracle’s Trace File Analyzer (TFA) is one of the AHF tools that provides real-time health monitoring, fault detection, and diagnostic data collection using a single command. This session includes an overview of TFA and how TFA collections for High Availability, Enterprise Manager and DB Admin SRs can expedite SR resolution by providing all the details needed for resolving SRs. The collection provided to an SR minimizes the back and forth with Support requesting different diagnostic files.

READ MORE

 

How to size Oracle databases on VMware for best performance and efficiency

More and more organizations see the benefits of running Oracle databases on virtual infrastructure. In this session, Bart will present a methodology for achieving maximum efficiency and performance for virtualized database workloads. Topics include: applying benchmarking metrics, sizing rules, workload management best practices and analyzing existing systems data to support accurate database infrastructure sizing, and some virtualization gotcha’s and caveats.

READ MORE

 

   OCTOBER 02

 

DevOps com GitHub e GitHub Actions: Workshop Prático Online Beneficente

Deseja aprender mais sobre DevOps, gerenciamento ágil de projetos, build e deployment automatizado de projetos, GitHub, GitHub Actions e diversos serviços do Microsoft Azure?

Participe então desta iniciativa promovida por diversas comunidades de tecnologia e com apoio da Microsoft no sábado dia 02/10 a partir das 08:00 da manhã.

Teremos um Workshop Online com um hand-on utilizando diversas tecnologias, mostrando todo o potencial do GitHub e do GitHub Actions na automação de processos.

READ MORE

 

Weekly Events #28

Here is a summary of the EVENTS for this and next week!

 

   SEPTEMBER 20

 

Oracle Reengineered: Meet Oracle Advertising and CX

After being virtual and apart for the better part of a year, we’re excited to bring B2B marketing and sales leaders back together in-person to reintroduce you to Oracle Advertising & CX.

Live at the Rooftop at Hotel VIA, we welcome you to unwind and reconnect with your fellow sales and marketing industry leaders and enjoy the spectacular views of the San Francisco skyline, the Bay and Bay Bridge, and of course, Oracle Park, home of the San Francisco Giants.

READ MORE

 

   SEPTEMBER 21

 

OSPA Session : Oracle Integration Partner Bootcamp Asia

SaaS solutions like HCM, CX and ERP Cloud need to be integrated and customized. Oracle Integration connects SaaS solutions with out of the box adapters.

Do you want to find out why Gartner named Oracle as a Leader in Magic Quadrant for three years in row? Are you able to innovate quickly in the new digital world? Are you looking for ways to integrate systems and data faster using a modern cloud integration platform? Attend the Oracle Integration Bootcamp, a three days hands-on training for Oracle partners!

READ MORE

 

THE POWER OF SUBLEDGER ACCOUNTING FOR THE MAINTENANCE CLOUD

This is a Joint Cost Management Cloud SIG and Maintenance Cloud SIG Members Presentation. Please join Kaushik, Doug and Wes for a Demonstration of how Cost Management Cloud SLA enhances with unlimited flexibility for Oracle Maintenance Cloud Solutions. Kaushik will lead the demonstration of how to configure Cloud Subledger Accounting to achieve Maintenance Best Practices.

READ MORE

 

WILLIAMS COMPANIES DRIVES USER ADOPTION WITH EPILOGUE OPUS

The purpose of training in any business is to drive behavioral change that will lead to increased business performance, enabling an organization to meet its goals. With today’s cloud application delivery model and rapidly changing work environment, organizations must adopt new or different work strategies on virtual platforms.

In this session, learn how Williams Companies used their Oracle Cloud implementation to make the shift from traditional training to a learning and performance support program that increases performance & productivity and successfully drives toward their business objectives.

READ MORE

 

Webinar gratuito: Iniciación a Spark: el estándar en Big Data.

APACHE SPARK ES LA HERRAMIENTA DEL MUNDO BIG DATA PARA TEMAS ONLINE. UN FRAMEWORK DE PROCESAMIENTO OPEN SOURCE DISTRIBUIDO PARA BIG DATA.
La característica principal es el uso que hace de las estructuras de datos en memoria llamadas RDD, con lo que consigue aumentar el rendimiento frente a herramientas como Hadoop.

En este webinar de 1 hora, nuestro profesor Ángel Conde nos hablará de la historia del Big Data, de dónde venimos, dónde se sitúa Spark como framework y también su futuro, últimas novedades y una demo con Google Colab.

READ MORE

 

   SEPTEMBER 22

 

2021 OTM User Conference APAC – Virtual

The OTM SIG Board proudly organises an online OTM User Conference on 22-24 September 2021 for the APAC region. Key representatives from OTM Strategy and Development will participate to this conference, and various partners in OTM’s ecosystem will sponsor. This conference is an addition to the yearly OTM conferences in America and Europe.

The event is designed to bring together users and potential users of the Oracle Logistics software (OTM, GTM, OCWMS) to share knowledge, ideas and experiences.

READ MORE

 

Cloud Bytes Series: Modernize Your WebLogic Application on Oracle Cloud Infrastructure

Find out how #Modernising WebLogic Application on OCI is helping your peers enhance business agility, streamline operations, reduce cost and experience faster performance. Learn an accelerated pathway for you to achieve the same.
Who Should Join? If you are looking to migrate Weblogic apps from on-premises to cloud, containerise your WebLogic environment – while simplifying operations, reducing cost, and improving performance without any code change – this session is for you.

READ MORE

 

Starting your cloud journey with MySQL Database Service and HeatWave on Oracle Cloud | ASEAN

Start your cloud journey with MySQL Database Service (MDS) and HeatWave today! Join us, and discover how the World’s #1 Open Source Database on Oracle Cloud, can build and scale your business.

  • Introduction to MySQL Database Service, and Heatwave
  • Current market trends and cloud adoption
  • Top reasons why to use MySQL Database Service
  • Expanding into new enterprise workloads
  • Securing your data on the cloud and reducing your TCO
  • Supercharge query performance using MySQL Heatwave
  • Demo: How to create a free cloud account
  • Q&A session

READ MORE

 

Assignment-Level Security Abstract

Now more than ever, data security is paramount when it comes to running a business. Learn how to optimize security in Oracle Cloud HCM through assignment-level security; a highly anticipated feature released in 20D. We’ll dive into various use cases, discuss the implications across modules, and review best practices for adopting this important new feature. Whether you use multiple assignments, or simply sequential assignments via global transfer, this overview will help you understand if assignment-level security is right for you.

READ MORE

 

Practical training: How to get off the hamster wheel of Oracle Cloud quarterly updates by Peter Earnshaw and Peter Crew

One of the key challenges Oracle Cloud customers have is keeping pace with the quarterly upgrade schedule for Oracle Cloud applications.  In this webinar Knoa and our guest presenter, Peter Crew the CTO of Magia Solutions, will discuss some practical tips and tools that can help you effectively prepare for and deal with these upgrades, making your life easier, helping you deliver a better quality of service to your business stakeholders: the actual end users – your employees.

READ MORE

 

   SEPTEMBER 23

 

Live Developer Lab

BUILDING MICROSERVICES WITH ORACLE CONVERGED DATABASE

Modernize and simplify your data-driven applications with microservices architecture using Database Cloud and Helidon on Oracle Cloud Infrastructure.

In this lab, you’ll learn how to:

  • Setup OCI, OKE and ATP
  • Build and deploy microservices
  • Setup database connection secrets, tables and AQ messaging
  • Walkthrough Data-centric microservices with Helidon MP
  • Scale the Application
  • Create an APEX App to make sense of the data

READ MORE

 

Oracle Exadata Master Class: Authentication Options for the Oracle Database

AUTHENTICATION OPTIONS FOR THE ORACLE DATABASE
Oracle Database accepts several different authentication methods – each with its own advantages and disadvantages. Join us to review database authentication, appropriate use cases, and how you can use authentication methods to reduce risk and improve security.

READ MORE