AWS RDS: Reading Oracle Traces from SQL*Plus

Hi all,

One more for AWS services. Let’s say you need to read trace files from RDS, how to do it?

Here is an example of how to list and read those files based on the directories from the database setting. To see the existent directories:

SQL> select * from dba_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH ORIGIN_CON_ID
---------- ------------------------- ------------------------------------------------------------ -------------
SYS BDUMP /rdsdbdata/log/trace 0
SYS ADUMP /rdsdbdata/log/audit 0
SYS OPATCH_LOG_DIR /rdsdbbin/oracle/QOpatch 0
SYS OPATCH_SCRIPT_DIR /rdsdbbin/oracle/QOpatch 0
SYS DATA_PUMP_DIR /rdsdbdata/datapump 0
SYS OPATCH_INST_DIR /rdsdbbin/oracle/OPatch 0
SYS TMP /rdsdbdata/userdirs/01 0

7 rows selected.

Once identified the directory needed, we can list the file as per:

SQL> select * from table (rdsadmin.rds_file_util.listdir( p_directory => 'BDUMP')) order by mtime;

FILENAME TYPE FILESIZE MTIME
---------------------------------------- ---------- ---------- ---------
CPROD1_ora_48800.trm file 73 24-DEC-18
CPROD1_ora_48800.trc file 998 24-DEC-18
CPROD1_ora_86597.trc file 998 24-DEC-18
CPROD1_ora_86597.trm file 73 24-DEC-18
CPROD1_ora_7999.trc file 881 24-DEC-18
CPROD1_ora_7999.trm file 71 24-DEC-18
CPROD1_ora_7997.trm file 71 24-DEC-18
CPROD1_ora_7997.trc file 881 24-DEC-18
CPROD1_ora_8240.trm file 71 24-DEC-18
CPROD1_ora_8240.trc file 881 24-DEC-18
CPROD1_ora_8381.trm file 72 24-DEC-18
CPROD1_ora_8381.trc file 995 24-DEC-18
CPROD1_ora_8540.trc file 881 24-DEC-18
CPROD1_ora_8540.trm file 71 24-DEC-18
CPROD1_ora_9876.trc file 881 24-DEC-18
CPROD1_ora_9876.trm file 71 24-DEC-18
CPROD1_ora_11142.trm file 72 24-DEC-18
CPROD1_ora_11142.trc file 883 24-DEC-18
CPROD1_ora_11182.trc file 883 24-DEC-18
CPROD1_ora_11182.trm file 72 24-DEC-18
CPROD1_ora_55077.trm file 73 24-DEC-18
CPROD1_ora_55077.trc file 997 24-DEC-18
CPROD1_ora_92260.trm file 73 24-DEC-18
CPROD1_ora_92260.trc file 997 24-DEC-18
CPROD1_ora_123869.trc file 1000 24-DEC-18
CPROD1_ora_123869.trm file 74 24-DEC-18
CPROD1_ora_41305.trc file 998 24-DEC-18
CPROD1_ora_41305.trm file 73 24-DEC-18
CPROD1_j002_3293.trc file 114049 24-DEC-18
CPROD1_j002_3293.trm file 370 24-DEC-18
CPROD1_mmon_71739.trc file 7511332 24-DEC-18
CPROD1_mmon_71739.trm file 738330 24-DEC-18
CPROD1_ora_92888.trc file 997 24-DEC-18
CPROD1_ora_92888.trm file 73 24-DEC-18
trace/ directory 323584 24-DEC-18
alert_CPROD1.log file 204808 24-DEC-18
CPROD1_ora_70145.trc file 1470 24-DEC-18
CPROD1_ora_70145.trm file 109 24-DEC-18

3845 rows selected.

With the trace file name confirmed, you can see the content with the following:

SQL> select * from table (rdsadmin.rds_file_util.read_text_file( p_directory => 'BDUMP', p_filename => 'trace/CPROD1_s003_81573.trc'));

From the trace file:
=========================
..................................................................................
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x000e289e.51da.47
Dump kdilk : itl=98, kdxlkflg=0x1 sdc=0 indexid=0x1c53db block=0x0019bdc0
(kdxlpu): purge leaf row
key :(24):
07 78 76 0c 17 17 09 32 08 c7 07 1a 02 28 15 01 18 06 00 1a 3c 99 00 1e

File 3 is not mirrored.

End dump previous blocks for kdsgrp
* kdsgrp1-2: ***********************************************
kdsDumpState: RID context dump

45511581 rows selected.

Also, as a side note, something that may help you out is the listing with LIKE clause:

SQL> select * from table (rdsadmin.rds_file_util.listdir( p_directory => 'BDUMP')) where filename like '%CPROD1_s003_81573.trc%';

FILENAME TYPE FILESIZE MTIME
---------------------------------------- ---------- ---------- ---------
CPROD1_s003_81573.trc file 1948134047 23-DEC-18

I hope it helps! See you next post!

Weekly Events #12

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

 

JUNE 01

 

Berliner Expertenseminar: Postgres Backup & Recovery, Migration und Replikation

Aufgrund der großen Nachfrage wird dieses Thema (Seminar vom September 2020) in diesem Jahr wiederholt.

Tag 1.

Installation und Architektur der Postgres Datenbank/ Wichtige Verzeichnisse und deren Bedeutung/ PG_WAL Konzept, Tablespaces,Prozessbeschreibung, Verwaltungsviews/ Unterschiede und Gemeinsamkeiten zu Oracle/ Postgres Cluster Konzept, mehrere Postgres Cluster auf dem Server/ Konfigurationsdateien (postgresql.conf, pg_hba.conf)/ Postgres Benutzer, Rechte und Rollen im Vergleich zu Oracle/ Postgres Administration.

Tag 2:

Postgres Backup & Recovery unter Windows und Linux/ Postgres Foreign Data Wrapper für Oracle/ Migrationstechniken von Oracle zu Postgres/ Physical und Logical Replikation von Postgres zu Postgres/ Einstellungen für Logging und Auditing/ PG_ADMIN als Werkzeug für Administration und Entwicklung/ Import und Export von Daten/ Interessante Extensions.

READ MORE

 

Workshop Gratuito – SP: Cloud Solutions com Microsoft Azure

Acompanhe este evento PRESENCIAL e GRATUITO promovido pela comunidade Azure Talks e conheça diversas tecnologias que integram o Microsoft Azure que podem ser úteis na implementação dos mais variados tipos de aplicações, independente da plataforma de desenvolvimento de sua escolha.

READ MORE

 

Microsserviços no Azure

Conheça neste evento ONLINE e GRATUITO do Azure na Prática (live #19) alternativas oferecidas pela nuvem Microsoft que podem ser extremamente úteis na implementação de uma arquitetura de microsserviços!

READ MORE

 

   JUNE 02

 

APEX World 2021

Unfortunately, the eleventh edition of APEX World this year could not take place due to the Corona crisis. In 2021 we would still like to make another attempt. Given the most recent developments around Covid-19 and a possible vaccination against it in early 2021, we at nlOUG believe that it is wise to organize APEX World 2021 a little later in the year than usual.

On Wednesday June 2 and Thursday June 3, 2021 we organize APEX World 2021 at the KNVB Campus in Zeist!

READ MORE

ORA-19665: size % in file header does not match actual file size of %

That’s an unexpected message to get, right?
I got it related to an ORA-7445: ORA-07445: exception encountered: core dump [kcflfi()+1016] [SIGFPE] [Integer divide by zero] [0x10047EF18] [] []

What’s next?
After some checks, found the following (got from related trace the file name, matching to file_id 106):

SQL> select file_name, bytes from dba_data_files where file_id=106;

FILE_NAME                                         BYTES 
------------------------------------------------ --------------
+DATA/MYDB/DATAFILE/DATAFILE_XX.558.1015447173   14529069056

SQL> select name, bytes from v$datafile where file#= 106;

NAME                                             BYTES 
------------------------------------------------ --------------
+DATA/MYDB/DATAFILE/DATAFILE_XX.558.1015447173   14529067281

This means the Database Dictionary has different sizes for the datafile.
Looking at MOS, it seems to be a match to ORA-07445: Exception Encountered (Doc ID 1958870.1).

How to resolve it?

SQL> alter database datafile 106 offline to drop;
RMAN> restore datafile 106;
RMAN> recover datafile 106;
SQL> alter database datafile 106 online;

This resolved my case, fixing the views.

BE CAREFUL:

  • Make sure you have a backup before dropping the datafile.
  • Make sure you can put the datafile offline or proceed in a non-business hour.
  • Follow change procedures for Production, of course. Things may get wild.

And what if I don’t have a backup?
1. You may want to take it. It may not work, though, considering the original mismatch.
2. Export/Import logically:
– Export the data from the related tablespace (Datapump or Legacy Export, check for limitations and datatypes).
– Drop the tablespace and recreate it.
– Import the data back.

As usual, test it in a non-production environment to validate your plan and commands.

I hope it helps!

Weekly Events #11

 

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

 

MAY 24

 

Emerging Women in Tech Panel Discussion

Join us for an ODTUG WIT discussion about growing your career in tech and building your own brand. How do you find your space in the community, continue to learn and develop, and find a technology you are passionate about? Panel led by: Steisi Manco and Oracle ACE Kate Helmer, Huron, Ghaida Khader, Azdan Business Analytics, and Jennifer Nicholson, Oracle Corporation.

READ MORE

 

Oracle Cloud-Native Journey Session 5: Keep an eye on your OIC services

Oracle Cloud-Native Journey Session 5: Keep an eye on your OIC services

Session Abstract: In this session, you will learn.

– The different mechanisms for monitoring, alerting and notifying your applications and infrastructure in OCI
– The concepts of infrastructure as a Code with the usage of the Terraform OCI provider
– How to automate the provisioning of services using the terraform provider
– How to enable alerts

READ MORE

 

   MAY 25

 

Oracle Enterprise Planning Cloud Certification Readiness Workshop
Note that seats are limited and priority will be given to EMEA Partners focusing to Oracle EPM Enterprise Cloud Service Track Expertise. Registrations will be closed as soon as the Event is full.
Oracle is pleased to invite you to attend an Oracle Enterprise Planning Cloud Certification Readiness Training Course. Gain an in-depth understanding of the Oracle Enterprise Planning Cloud 2020 Implementation Specialist certification process and the various areas of the system that will be tested as part of the Implementation Essentials Certification Exam (1Z0-1080-20)

READ MORE

 

Database 12c to 21c, Journey of key feature sets

This presentation will look at 12c to 21c new features that should be investigated for use which include Multitenant, IN-Memory and Oracle 19c Automatic Indexing and many more. I will discuss the 12c to 21c Journey for these new features with examples and sample code. Attendees can expect brief introduction of all the new features with deep dive into Multitenant, IN-Memory and Automatic Indexing.

READ MORE

 

Meetup: Gebruik van Machine Learning bij Autonomous Data Warehouse (ADW)

De sessie bestaat uit twee delen:

1) Introductie Data Science en Machine Learning.
2) Praktische Hands On met Machine Learning.

In deze nlOUG sessie praten we u bij over ontwikkelingen op het gebied van Data Science & Machine Learning (ML) bij Oracle.

Daarna kunt u zelf aan de slag met de  mogelijkheden van ML in de Autonomous Database aan de hand van een hands-on workshop.

READ MORE

   MAY 26

 

Smart Scan: Live and Uncensored!

Come and learn how to play with the Smart Scan. We’ll go with a lot of examples to explain and demonstrate how Smart Scan works on Exadata. Understand the scenarios Smart Scan will be used and the ones it won’t and why it was not used.

Column projection, predicate filtering, storage index, SQL offloading… understand all of this and how they make Exadata what it is.

About the Speaker
Franky Faust works for Pythian as Senior Oracle Database Consultant. He has extensive knowledge in Oracle Exadata and High Availability technologies and in other databases like SnowflakeDB, MySQL, Cassandra and SQL Server.

READ MORE

 

CAREER CHANGES: TAKING THE LEAP

Changing careers can be a daunting challenge. How do you shift your skills and experiences into a new field? How do you know if the new career is the right fit? And how do you catch up in an industry that is less familiar? For people that have made the leap later in their careers to a job in the technology and applications space, it’s important to find resources, support, and the knowledge to adapt quickly.

In this session, Lee will share his own experience and decisions to move into the technology space, and his challenges and lessons learned along the way. This is a great session for young professionals or people new to their careers, as well as supervisors and leaders that want to provide support to their teams.

READ MORE

 

Oracle Cloud-Native Journey Session 6: Digital Assistants and Chatbots

Oracle Cloud-Native Journey Session 6: Digital Assistants and Chatbots

Session Abstract: In this session, you will learn.

– Basics of Oracle Digital Assistant
– How to create a small conversational bot
– Basics of a chatbot: intents, entities, utterances
– Testing your own bot

Speaker BIO : ROLANDO CARRASCO
CTO, Services and Processes Solutions S.A de C.V

READ MORE

 

JWT: tudo o que não falaram para você sobre…

Javascript Object Signing and Encryption (JOSE) é um framework. É nessa família que encontramos o JWT (JSON Web Token) e seus componentes.

Neste evento ONLINE e GRATUITO no Canal .NET iremos abordar todos os componentes da família JOSE: JWA, JWK, JWE, JWKS. E como esse framework é o coração da segurança do OAuth2 & OpenId Connect. Além disso serão discutidos outros cenários de uso, como integrações de APIs!

Palestrante: Bruno Brito (Microsoft MVP)

READ MORE

 

   MAY 27

 

 

HOW TO MOVE ORACLE EBS TO THE CLOUD AND EFFECTIVELY ADAPT OPERATIONAL BENEFITS

Did you know there is a way to take advantage of the Cloud while keeping your EBS customizations? Backups as a Service, flexible hardware that can scale, cloning of environments, paying for what you use and only what you use. Move and improve your existing EBS environment to a modern, flexible Infrastructure as a Service (IaaS), and upgrade your environment. We will show you case studies that demonstrate how to keep control as well as control your costs.

READ MORE

 

DB-Oracle 19c Hands-On Experience: Pluggable Databases are Risen from the Dead

Join ODTUG and Viscosity for a hands-on virtual class on Oracle Database 19c.

We have a limited number of user IDs available for the hands-on lab, so be sure to register quickly as a “Hands-On Participant” or for the HOL Waiting List.

Registration is unlimited for those interested in View and Listen only mode.

In this two hour class, students will learn the fundamentals to managing the new frontier of pluggable databases. Each student will be assigned 2 VMs to configure PDBs and work labs.

READ MORE

 

Meetup: Ervaringen met het beheer van ODA-systemen

Meetup: Ervaringen met het beheer van ODA-systemen

Sprekers: Ian Hoogeboom en Marc Kelle van Transfer Solutions.

Aanvang: 15.00 uur.

Meer informatie volgt binnenkort.

READ MORE

 

   MAY 28

 

 

Migrate Your Oracle Forms Apps to Oracle APEX by Monica Godoy
Oracle Forms is an established technology that has been popular for building data applications for decades. Today, there are several approaches for building such applications.
In this session, you will learn:
• How to use Oracle APEX to modernize your Oracle Forms-based applications.
• When it’s a good moment to modernize
• What you should do before starting this type of projects
• Demonstration from Forms to APEX

READ MORE

 

Cloud Native Java by Josh Long

“It is not necessary to change. Survival is not mandatory.” -W. Edwards Deming

Work takes time to flow through an organization and ultimately be deployed to production where it captures value. It’s critical to reduce time-to-production. Software – for many organizations and industries – is a competitive advantage. Organizations break their larger software ambitions into smaller, independently deployable, feature -centric batches of work – microservices. In order to reduce the round-trip between stations of work, organizations collapse or consolidate as much of them as possible and automate the rest; developers and operations beget “devops,” cloud-based services and platforms automate operations work and break down the need for ITIL tickets and change management boards. But velocity, for velocity’s sake, is dangerous. Microservices invite architectural complexity that few are prepared to address. In this talk, we’ll look at how high-performance organizations like Ticketmaster, Alibaba, and Netflix make short work of that complexity with Spring Boot and Spring Cloud.

READ MORE

 

Fireside Chat with Security Gurus

Session Title: Fireside Chat with Security Gurus

Session Abstract: Join our interactive session where Manish, Angeline, Russ Lowenthal will answer your questions live. In this session, get the unique opportunity to engage with your peers on relevant issues on Oracle Security. You can pre-submit these questions by tweeting @AIOUG #aiougFC or ask live in the chat.

Speaker Bio: Manish Choudhary
Product Manager – Oracle Data Safe, Sensitive Data Discovery, Data Masking, and Subsetting, Oracle

Manish Choudhary is a product manager for Oracle Database Security, focusing on sensitive data discovery and masking technologies. He has experience in database firewall, activity monitoring, and security analytics areas also. Manish has nine years of experience in the security domain. Prior to joining the Oracle Database Security team, he worked with the Oracle Solaris group as the security and compliance product manager. During his time at McAfee Labs, he worked on Host Intrusion Prevention System and Database Activity Monitoring.
Manish has an MS in Security from Georgia Institute of Technology, Atlanta. His interest areas are data security and privacy, cryptography, cloud security, cyber-physical systems (IoT), and machine learning in security.

READ MORE

 

   MAY 29

 

 

Becas internacionales 📢 Big Data Certified Associate

“📢 Big Data Certified Associate
💻 6 meses de activación de plataforma 24/7
🎓 Obtenga una beca del 100% en el curso, solo paga el examen con el 70% de descuento.meetup

READ MORE

Automating APEX Applications Backup

Hi all,

As you might be aware and already posted by me here, o export APEX Applications the APEXExport Tool should be used.
Here we’ll also see some alternatives to accomplish that.

Plan A) Using same as discussed in the previous post for exporting all Applications in an instance:

As being, for any backup script, 3 parts need to be backed up

1. With database Export utilities (Datapump or Legacy Export, be aware of the limitations of each) dump your APEX applications need to run:

expdp matheusdba schemas=MY_APP_SCHEMA directory=DIR_BKP dumpfile=APEX_APP_SCHEMA.dmp logfile=APEX_APP_SCHEMA.log

2. Run the APEXExport using “-expWorkspace” to export all workspaces (This will generate a w*.sql script for each workspace)

java oracle.apex.APEXExport -db localhost:1521:MYDB -user system -password systems_password -expWorkspace

3. Run the APEXExport using “-instance” which will generate a f*.sql script for every application and shared component.

java oracle.apex.APEXExport -db localhost:1521:MYDB -user system -password systems_password -instance

Plan B) Take separate Backups for each Application or Workspace

Here is the interesting part: You can take also backups by applicationid or workspace id, with the following:

1. Exporting by ApplicationID:

APEXExport -db hostname:listenerport:dbservicename -user -password -applicationid 31500

2. Exporting by WorkspaceID:

APEXExport -db hostname:listenerport:dbservicename -user -password -workspaceid 9999

But how take all the workspace IDs? You can use the following SQL statement in SQLWORKSHOP:

select wwv_flow_api.get_security_group_id from dual;

Now you have all the basic exporting steps, it’s up to you to build the script as it fits better for you.

I hope it helps!

Additional notes:

  • The workspace export should export all of the shared components from the workspaces.
  • This does not mention RESTful services but if using the APEXExport from 4.2.4 or higher, they will be included.

Additional Reference:

  • APEXExport Gives: Java.lang.NoClassDefFoundError: Oracle/apex/APEXExport (Doc ID 2265534.1)

Weekly Events #10

 

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

 

MAY 17

 

DOAG 2021 DATENBANK ONLINE

Die DOAG 2021 Datenbank begrüßt Sie am 17. und 18. Mai zum virtuellen Wiedersehen der Community! Freut euch auf ein breitgefächertes Online-Konferenzprogramm mit den Streams Datenbank und Exadata!

READ MORE

 

   MAY 18

 

2021 PeopleSoft Oracle Northwest Summit Day1

Attend the all-virtual 2021Northwest Summit, a collaborative educational and networking effort co-hosted by the Northwest Oracle Users Group and PeopleSoft Northwest Regional Users Group.

Northwest Oracle Users Group serves the Pacific Northwest community who use Oracle Corporation products. Our goal is to provide education, facilitate networking and technical resources, and relay Oracle Corporation’s strategy and direction to application and database users. Example Product coverage includes EBS, OBIEE, Hyperion, Oracle SaaS, Database, Golden Gate, Edge solutions and all things Cloud.

READ MORE

   MAY 19

 

Oracle Account Reconciliation Cloud Certification Readiness Workshop
Note that seats are limited and priority will be given to EMEA Partners focusing to Oracle EPM Enterprise Cloud Service Track Expertise. Registrations will be closed as soon as the Event is full.
Oracle is pleased to invite you to attend an Oracle Account Reconciliation Cloud (ARCS) Certification Readiness Workshop. Gain an in-depth understanding of the Oracle Account Reconciliation Cloud 2020 Implementation Specialist certification process and the various areas of the system that will be tested as part of the Implementation Essentials Certification Exam (1Z0-1087-20). Explore key system functionality and terminology required to become a certified implementation specialist and evaluate the ways in which knowledge is tested in the exam. This course will equip attendees with all the necessary tools to prepare themselves for the Implementation Essentials Certification Exam.

READ MORE

 

RMOUG May Annual Membership Meeting and Workshop

Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so. Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals. Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.

READ MORE

 

Running Oracle Databases on Containers and Kubernetes with Pure Storage by Chris Bannayan

Gartner predicts that by 2022, more than 75% of global organisations will be running containerised applications in production, up from less that 30% today. Businesses now, more than ever should be putting together a strategy of how they will embrace this world of containers and Kubernetes to optimise their workloads in the transforming world. See how Pure integration with Containers and Kubernetes, coupled with its simplicity, efficiency and performance will modernise your data centre, reduce your complexity and increase your agility, so that your business can focus more on innovating and less on managing.

READ MORE

 

DOAG DAC WebSession: Oracle Machine Learning: Overview, What’s New? Customers and ML Apps

Oracle Machine Learning is now no license required feature in Oracle Databases (on-premises, Cloud and Autonomous). As part of Oracle’s Converged Database strategy, OML “moves the algorithms; not data” processing data where it resides. Oracle Machine Learning extends Oracle Database(s) delivering 30+ ML algorithms and AutoML functionality via SQL (OML4SQL) and integration with open source languages: Python, OML4Py and R, OML4R.

READ MORE

 

Gerando código com C# Source Generators

No C# 9 tivemos o lançamento dos source generators, que permitem uma espécie de metaprogramação na linguagem e gerando código adicional com base na implementação que você já possui.

Acompanhe neste evento ONLINE e GRATUITO no Canal .NET o que é possível fazer com source generators em C# e onde você os usaria.

READ MORE

 

   MAY 20

 

 

MOTU: Planejamento de Recursos com OptaPlanner

É chegada a hora de conversarmos sobre o como soluções com algoritmos complexos conseguem trazem lucro de, literalmente, bilhões de dólares a empresas críticas ao redor do mundo com uma simples tarefa: otimizar o planejamento de recursos. Vamos entender como resolver problemas complexos do mundo real de planejamento como o VRP (Problema de Roteamento de Veículos), criação de escalas de funcionários, atribuição de tarefas, agendamento de talks em conferências e muito, muito mais. Aos curiosos, um exemplo conhecido é o problema das n-rainhas, problema este que é rapidamente e facilmente resolvido pela IA do OptaPlanner.

READ MORE

 

EBS UPGRADES ARE NOT OUT OF FASHION: MAINTAIN COMPLIANCE UNTIL 2032

With Oracle Cloud taking center stage, many think that the Oracle E-Business Suite upgrades are no longer in fashion. But for many companies, Oracle EBS upgrades are the way to go. Companies that cannot move to the Oracle Cloud still need to have the latest security, better performance, a new look and feel, new features, and compliance with Oracle Support policies.

EBS R12.2.10+ offers all the benefits with enhanced security to eliminate many vulnerabilities, protecting against increasing cyber-attacks. EBS R12.2.X+ also gives us the ability to do online patching and eliminates the central pain point of production downtimes.

READ MORE

 

   MAY 21

 

 

OATUG TECH SIG TALK – CLONING PANEL

This panel will discuss the differences between available release R12.1 and R12.2 cloning methods. The advantages and disadvantages of each cloning method will be discussed in depth. This panel of experienced database administrators will lead a discussion focusing on the questions, such as “which cloning method is best to use in your particular environment”.

You can submit your questions before the panel here: Cloning Panel Questions.

Attendees will gain practical knowledge and tips and tricks to assist with cloning of Oracle E-Business Suite release R12.1 and R12.2 environments. We will also discuss cloning EBS version 12.2 with a Multitenant database using Rapid Clone.

READ MORE

Weekly Events #9

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

 

MAY 09

 

Before Disaster Strikes Architect Seminar Series

ACHIEVING RESILIENCY IN YOUR BUSINESS CONTINUITY STRATEGY.

Oracle invites you to a virtual seminar and panel discussion focused on mitigating risks in the uncertain times we live in today.

Natural disasters, system failures, operator error, and malicious hackers are causing serious damage to organizations without a well-planned high availability and disaster recovery strategy. Those consequences include lost revenue, diminished customer satisfaction, regulatory fines, lost data, and ransomware payments to name a few. Learn how BIAS, a leading IT solutions provider and award-winning Oracle partner, has designed and implemented high availability, disaster recovery and security strategies for some of the world’s leading companies leveraging Oracle technologies.

READ MORE

 

   MAY 11

 

Berliner Expertenseminar: Die Exadata, eine äußerst effiziente Hardware

Die Exadata ist ein komplexes Gebilde aus vielen kommunizierenden Einzelkomponenten, die man im Zusammenhang verstehen muss. So kann man zum Beispiel den Smart Scan nicht unabhängig von den Storage-Zellen verstehen. Auf den ersten Blick kann dies recht verwirrend wirken. Erst wenn man die historische Entwicklung und die Konstruktionsprinzipien kennt, wird es einfacher, alle Elemente in ihrem Zusammenspiel zu begreifen.
Mit dem Verständnis der Exadata als harmonisches, technisches Konzept wächst auch die Freude und der Spaß an der Arbeit mit dieser gut konstruierten Hardware.

READ MORE

 

Meetup: Ervaringen met Oracle Database Migraties naar de cloud

Oorspronkelijk zou deze Meetup plaatshebben op 18 maart. De Meetup is verplaatst naar 11 mei 2021!

Presentatie door team van The DOC.

READ MORE

ODTUG EPM Webinar Configuring Oracle Projects

Presented by Jesse Martin, Alithya. Deploying the Projects module provides the ability to plan upcoming projects with the additional detail that’s often required but not always available. Whether planning revenue or expense projects, this module includes several project types and planning methods to support individual, project-level detail. In this webcast, we’ll take a look at some features and processes within the out-of-the-box Projects module, review the configurable artifacts, and demonstrate a simple application build.

READ MORE

 

Data Management Strategy Evolution

Data Management Strategy Evolution
Data management strategies are evolving faster with the increased pressure for organizations to leverage the business benefits of digital transformation. Topics for this discussion include analytics across polyglot data stores, reducing the analytics cycle time to business value, evolving a logical warehouse across data tiers and delivering database solutions for DevOps. This presentation focuses on the benefits and the challenges of maturing a data management strategy to the next level to accelerate business transformation.

READ MORE

 

Oracle MySQL Database Service Hands-on Workshop

MySQL Database Service (MDS), a fully managed database service is:

  • 100% developed and managed by the MySQL team
  • 100% built on MySQL Enterprise Edition
  • 100% compatible with Oracle technologies
  • 100% supported by the MySQL team

As a result, MySQL Database Service is 100% compatible with on premise MySQL, allowing for a seamless transition to the public cloud or a hybrid cloud model.

READ MORE

 

RoOUG TechSession #45

Pe 11 Mai 2021, Romanian Oracle User Group a pregătit un nou eveniment dedicat utilizatorilor de produse Oracle.

READ MORE

 

Segurança e Infra no Azure: novidades do Ignite 2021

No mês de Março/2021 aconteceu mais uma edição do Microsoft Ignite, com diversos anúncios relacionados principalmente a infraestrutura na nuvem e um uso mais seguro de recursos.

Para ficar por dentro desses destaques acompanhe esta apresentação ONLINE e GRATUITA do Azure na Prática (live #20), em que serão abordadas novidades do Ignite envolvendo a utilização de tecnologias como Windows Server 2022, Windows Server Azure Edition, discos, networking, Azure Migrate, Azure Security Center, Azure Defender, Azure Sentinel, Azure Active Directory.

READ MORE

   MAY 12

 

AWS Summit Online – Américas

O AWS Summit Online foi projetado para desenvolvedores e profissionais de TI que desejam aprender como construir e inovar em grande escala usando a Nuvem AWS. Fique sabendo das novidades trazidas diretamente pelos executivos da AWS, participe de sessões paralelas com histórias de clientes e converse com especialistas da AWS para obter respostas às suas perguntas. Melhore suas habilidades com laboratórios práticos, aprenda com demonstrações inspiradoras e descubra o que a AWS e as soluções de parceiros podem fazer para o seu negócio.

READ MORE

 

Oracle Enterprise Data Management Certification Readiness Workshop
Note that seats are limited and priority will be given to EMEA Partners focusing to Oracle Enterprise Data Management Cloud Service Track Expertise. Registrations will be closed as soon as the Event is full.
Oracle is pleased to invite you to attend an Oracle Enterprise Data Management Cloud (EDMCS) Certification Readiness Workshop. Gain an in-depth understanding of the Oracle Enterprise Data Management Cloud 2020 Implementation Specialist certification process and the various areas of the system that will be tested as part of the Implementation Essentials Certification Exam (1Z0-1086-20). Explore key system functionality and terminology required to become a certified implementation specialist and evaluate the ways in which knowledge is tested in the exam. This course will equip attendees with all the necessary tools to prepare themselves for the Implementation Essentials Certification Exam.

READ MORE

 

Modals and Popups and Dialogs, Oh My! …Which to Use When, How and Why by Karen Cannell

Learn the subtle and not-so-subtle distinctions between APEX modals, popups and inline dialogs: Which to use when, why to choose one over the other, and how to use them appropriately in your APEX applications. We will cover modal and non-modal dialog pages, inline dialog and inline popup region types, when to use a dialog page vs an inline dialog or popup, and caveats and challenges to be aware of with each element type. Emphasis is on use of declarative APEX elements and documented JavaScript APIs whenever possible, and best practices for employing these various elements in your APEX pages, including specifics for launching from interactive grids.

READ MORE

 

E-BUSINESS SUITE UPGRADE PANEL

Please join us for an EBS Upgrade Panel in which we will review the latest EBS and database certified versions, support date details and EBS Upgrade news. We will also answer your EBS Upgrade questions during the Q&A with our Panelists.

READ MORE

   MAY 13

 

 

Cloud Lunch and Learn Marathon: mais de 170 palestras sobre Azure!

Gostaríamos de convidá-los para um super evento global de tecnologias em nuvem, focado principalmente em Azure, patrocinado pela Microsoft e Redgate e que acontecerá em Maio/2021: o Cloud Lunch and Learn Marathon.

Mais de 170 palestrantes de vários países e em várias línguas, incluindo diversas sessões em português! Alto conteúdo técnico e totalmente gratuito sobre Azure e diversas outras tecnologias Microsoft.

READ MORE

 

MOTU Deep Dive: Arquitetura de frameworks Java

Se você já participou da criação de um framework Java, você deve ter enfrentado diversas complexidades que não são encontradas no decorrer do dia a dia do desenvolvimento de uma aplicação tradicional – por exemplo, web. Vamos mergulhar nos desafios da criação de frameworks Java críticos, open-source e que adotados globalmente por arquitetos em busca de solução resiliente para suas aplicações!

READ MORE

 

MOTU Deep Dive: JNoSQL

Jakarta NoSQL é a primeira especificação do Jakarta EE cujo o objetivo é simplificar a integração entre uma aplicação Java e os bancos de dados NoSQL.

READ MORE

 

GUSAP – O digital como norma e o S4HANA como um habilitador da jornada de inovação

Em momentos desafiadores como o que vivemos, a demanda é por simplificação, interconexão, colaboração e velocidade, exatamente o que o SAP S/4HANA se propõe a entregar, principalmente quando combinada com soluções de Analytics e Inteligência Artificial, tendências que permitem otimização de custos e processos, de toda a cadeia de valor, além de agilidade na tomada de decisões.

READ MORE

 

APEX Em Português

O Oracle Application Express (APEX) é uma plataforma de desenvolvimento de baixo código que permite criar aplicativos escalonáveis ​​profissionais e seguros que podem ser implantados em qualquer lugar.

READ MORE

 

   MAY 14

 

 

DOAG database online event: A guide to migrating from Oracle to PostgreSQL

Speaker: Nabil Rütten, ORDIX AG

READ MORE

Moving APEX Applications Repository

Hello,
Most likely you land here because you need to migrate APEX Applications/Workspaces from one database to another, correct? You are in the right place!

We’ll use the APEXExport for this end.

Here you have a quick summary of the steps to use the tool, assuming:

  • The source APEX instance is at least 4.2.4.
  • The target instance must be 4.2.4 or higher.

Also, be aware that the APEX installation (the APEX and FLOWS_FILES schemas) cannot be exported in this manner or in any other manner.
So the APEX itself must pre-exist, what we’ll do is migrate the workspaces from one installation to another.

To Export:

1. Use database Export utilities (Datapump or Legacy Export, be aware of the limitations of each) to generate a dumpfile with all DB objects and data that your APEX applications need to run.
This will normally be the objects in the schemas that your APEX workspaces are dependent upon.

2. Run the APEXExport twice as follows:

2.1 First run it using “-expWorkspace” to export all workspaces (This will generate a w*.sql script for each workspace)

java oracle.apex.APEXExport -db localhost:1521:MYDB -user system -password systems_password -expWorkspace

2.2 Now run it using “-instance” which will generate a f*.sql script for every application and shared component.

java oracle.apex.APEXExport -db localhost:1521:MYDB -user system -password systems_password -instance

Note that that workspace export should export all of the shared components from the workspaces.
Note that this does not mention RESTful services but if using the APEXExport from 4.2.4 or higher, they will be included.

To Import:

1. Import the dumpfile generated for the regular database schemas your APEX Application use.
2. Import the workspaces via sqlplus as per:
2.1 connect sys / as sysdba
2.2 alter session set current_schema = APEX_040200;
2.3 run the scripts to create the workspaces

@<script_generated>.sql

This will create the workspaces with the same workspace IDs as the source DB.
This also prevents the need to modify the workspace ID contained in each of the application exports.

3. From the same session as above, accomplish the import of each of the application exports.

SQL> @.sql 
SQL> @.sql [...] 
SQL> @.sql

I hope it helps!

Weekly Events #8

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

 

MAY 02

 

Before Disaster Strikes Architect Seminar Series

ACHIEVING RESILIENCY IN YOUR BUSINESS CONTINUITY STRATEGY.

Natural disasters, system failures, operator error, and malicious hackers are causing serious damage to organizations without a well-planned high availability and disaster recovery strategy. Those consequences include lost revenue, diminished customer satisfaction, regulatory fines, lost data, and ransomware payments to name a few. Learn how BIAS, a leading IT solutions provider and award-winning Oracle partner, has designed and implemented high availability, disaster recovery and security strategies for some of the world’s leading companies leveraging Oracle technologies.

READ MORE

 

   MAY 04

 

APEX CONNECT 2021 [ONLINE]

Die APEX connect 2021 [online] heißt euch am 4. und 5. Mai zum großen Wiedersehen der Community willkommen – bequem und sicher von Zuhause oder dem Büro aus. Freut euch auf zahlreiche Vorträge und Workshops zu den Themen APEX, JavaScript und PL/SQL! Wir bieten euch ein einzigartiges Online-Konferenzerlebnis mit jeder Menge Wissensaustausch, Networking und einem unterhaltsamen Abendprogramm.

READ MORE

 

Oracle Communications SD-WAN Boot Camp

This course introduces the key technical concepts of Oracle’s SD-WAN offering and equips attendees with the skills to configure and troubleshoot an Oracle SD-WAN global network. Essential elements of network, site, and quality of service configuration are demonstrated in detail alongside related monitoring and troubleshooting activities enabled by the SD-WAN appliance GUI. This course also provides best practice recommendations for efficient provisioning and maintenance of the SD-WAN configuration and network.

READ MORE

Developer Live! App Dev with Oracle Database

BUILD APPLICATIONS WITH ORACLE DATABASE NOW.

Oracle’s market-leading database enables you to develop applications by supporting the data models and access methods your team wants—without unneeded functionality getting in the way. Learn how Oracle Database is optimized for developer productivity. This event will show you how Oracle Database gives developers simple API-driven access and model-specific languages together with powerful SQL capabilities. Each track will feature a hands-on lab so you can get started building applications on Oracle Database now.

READ MORE

 

Criando sua Infraestrutura no Azure com Código

Neste live evento ONLINE e GRATUITO do Azure na Prática (live #21) veremos como podemos criar nossa estrutura cloud no Azure, utilizando para isto o conceito de IaC (Infrastructure as Code).

Palestrante: Juliano Custódio (Microsoft MVP)

READ MORE

   MAY 05

 

UKOUG – License Management Event

The UKOUG License Management Event will be back in 2021. This event aims to bring together Oracle license owners to share their knowledge in a collaborative space.

We are currently looking for volunteers to help shape the content and structure of this event.

READ MORE

 

Evento RSJUG Maio

RSJUG promove evento sobre qualidade de código e melhoria de código a partir do entendimento de smells e técnicas de refactoring.

Analisando a saúde do seu código com DR-Tools Suite

READ MORE

 

   MAY 08

 

 

Bootcamp – Machine Learning: Funcionamiento y Aplicabilidad

📢 Machine Learning: Funcionamiento y Aplicabilidad.
🎓 Obtenga una beca del 100% en el curso y hasta el 50% de descuento sobre examen

READ MORE

OEM: Metric “Tablespace Allocation Metric” not Collected – Agent is Running but Not Ready

Hi all,

That’s an interesting case with OEM. A client reported the metric “Tablespace Allocation Metric” is not being updated on OEM for a specific database. In this case, the last gathering was in Nov/2020, as you’ll see.

When checking for it, the first try as usual was checking on the OEM agent status, and here is what I got:

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, that’s interesting.
Trying then to clear the agent state as this has 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

Now running 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

Ok, trying to just 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

Maybe something is stuck, so let’s 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.

Making sure we have no agent process running:

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

Also adjusting the threshod 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 starting 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.

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), a few changes were made:

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

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 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 is 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

On 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

Ok, so in summary: After fixing all issues on OEM side, everything running fine, still the database metrics are not being updated.

Long story short: After some investigation, bumped in MOS Database Hangs With Simple Queries like on view dba_data_files & dba_free_space (Doc ID 2665935.1)
Turns out this seemed to be a match. So proceeding with the recommendation:

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.

Once done, all issues solved and metric being collected again:

Some additional reference:

  • 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 it helps!