Weekly Events #7

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

 

APRIL 25

 

Before Disaster Strikes Architect Seminar Series

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

 

   APRIL 26

 

SAVE THE DATE: BERLINER EXPERTENSEMINAR MIT CHRISTIAN PFUNDTNER

Dieser Workshop richtet sich speziell an Oracle DBAs, die zusätzlich auch PostgreSQL Datenbanken betreuen sollen. Die Voraussetzung ist ein fundiertes Wissen über die Oracle Datenbanken – von Begriffen wie Tablespace, Schema, Instanz bis hin zu Backup und Recovery. Bei vielen Erklärungen werden Vergleiche mir den entsprechenden Funktionen/Strukuren von Oracle genutzt, was einem Oracle DBA das verstehen deutlich erleichtern sollte.

READ MORE

   APRIL 27

 

Building a cloud-friendly application – Jakarta Tech Talks

The days of hand-crafted artisanal servers are long over. Modern web applications need to be able to run on many different servers without code changes. Not just different hosting providers, but different environments on the same hosting provider. Whether you’re using a legacy dev/stage/prod setup or a modern branch-is-environment host, modern hosting imposes some requirements on your application design but also offers a huge potential for new and powerful tools.

READ MORE

 

Microsserviços + Azure Event Hubs

Vivemos em uma época em que dados são extremamente importantes para qualquer negócio… Mas não adianta nada termos os dados, se não conseguimos entendê-los. Venha então conosco neste evento ONLINE e GRATUITO do Azure na Prática (live #19) e conheça uma maneira super prática de utilizar o Event Hub no Azure na manipulação de dados em uma arquitetura de microsserviços!

READ MORE

 

   APRIL 28

 

Oracle Narrative Reporting Cloud 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 Narrative Reporting (EPRCS) Certification Readiness Workshop. Gain an in-depth understanding of the Oracle Narrative Reporting 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-1083-20). Explore key system functionality and terminology that you will need to know 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

 

ACCELERATE ORACLE SAAS MIGRATION & REDUCE TCO WITH TRIADIC
Hexaware leverages its proprietary Triadic framework to carry out transformation assessments for its customers. It evaluates the client environment from three dimensions: business model, landscape complexity, and appetite to move to the cloud. The various automation tools & accelerators aligned with the framework will bring in a significant reduction in effort and cost during implementation as well as post-implementation. One of the elements in the Triadic framework is data migration; customers face multiple challenges during migration, consolidation, and reconciliation of data from multiple source systems like PeopleSoft, Oracle EBS, and other legacy applications to Oracle HCM, ERP, and CX Cloud applications.

 

Make it faster – Myths about SQL Performance

Many developers don’t pay attention to database performance when implementing new applications. The functionality of the application is important, but the efficiency of the SQL queries is often ignored. The DBA (or the query optimizer) does this job later. If necessary, we can still create some indexes, add hints or adjust some database parameters. And in the Cloud, the Oracle database does everything automatically and autonomously, anyway.

Make it faster - Myths about SQL Performance

READ MORE

 

Automatizando testes de integração com Azure DevOps e GitHub Actions

Implementar testes de integração nem sempre é uma tarefa fácil, chegando até mesmo a ser postergada em muitos casos ao se considerar os serviços dos quais uma aplicação pode depender. E as dificuldades só tendem a aumentar quando decidimos executar tais testes de maneira automatizada.

Embora muitos profissionais desconheçam, soluções de automação como Azure DevOps e GitHub Actions contam com ambientes em que inúmeros recursos e ferramentas foram pré-instalados. Podemos ir além nos valendo de containers criados sob medida, emulando sem complicações baseadas de bancos de dados e até mesmo serviços de mensageria. O resultado disso será validações simulando as hipóteses mais próximas daquelas que encontraríamos em produção.

READ MORE

   APRIL 29

 

SAVE THE DATE: BERLINER EXPERTENSEMINAR MIT MARCO PATZWAHL

Der Kurs erklärt die Methoden um in seiner Oracle Datenbank in Version von 11.2 bis 21.2 aufzuräumen und Objekte zu reorganisieren. Wie kann man unnötigen Speicherplatz durch Statistiken, Jobs Logs, Audits, Trace Dateien u. v. w wieder freigeben? Wie können partitionierte oder normale Tabellen, Indizes, Lobs und Sonderobjekte wie AQ Tabellen, Tabellen mit Long oder der gesamte Tablespace reorganisiert werden?

READ MORE

 

Berliner Expertenseminar: Oracle Datenbank Reorg und Wartung in Version 11.2 bis 21.1

Oracle Datenbank Reorg und Wartung für Experten in Version 11.2 bis 21.1, ein Berliner Expertenseminar (Online) mit Marco Patzwahl für DBA und Entwickler.

Der Kurs erklärt die Methoden um in seiner Oracle Datenbank in Version von 11.2 bis 21.2 aufzuräumen und Objekte zu reorganisieren. Wie kann man unnötigen Speicherplatz durch Statistiken, Jobs Logs, Audits, Trace Dateien u. v. w wieder freigeben? Wie können partitionierte oder normale Tabellen, Indizes, Lobs und Sonderobjekte wie AQ Tabellen, Tabellen mit Long oder der gesamte Tablespace reorganisiert werden?

READ MORE

 

MOTU: Monitoramento e solução de problemas com New Relic

MOTU: Monitoramento e solução de problemas com New Relic.

READ MORE

 

O SQL Server é extremamente rápido. Você que não sabe usar!

Atendendo a pedidos e ao excelente feedback da comunidade, vamos agora para a parte 6!

Confira esta apresentação ONLINE e GRATUITA no Canal .NET em que serão mostradas mais dicas e técnicas de como otimizar o desempenho de bancos SQL Server, obtendo assim o máximo desse excelente SGBD! Falaremos novamente de muita coisa legal… e muito além de NOLOCK e Missing Index!

READ MORE

 

   APRIL 30

 

OATUG TECH SIG TALK – EBS SECURITY: REMEDIES FOR YOUR VULNERABLE-ATTACK-SURFACES

In 2019/2020/2021, hundreds of Fortune-Five-Hundred companies and Federal Agencies were Hacked. Personally Identifiable Information (PII) and Sensitive Personal Information (SPI) was stolen. In 2018, Equifax’s security was breached and 145 Million accounts (user-ids, passwords, SSN, Addresses, etc.) were stolen. Most of these CIO and IT-Leaders and Technology-Leaders lost their jobs.

READ MORE

Dataguard Broker: ORA-16714: the value of property LogFileNameConvert is inconsistent with the database setting

This seems like a simple message to be fixed, right?

The parameter is different between the broker configuration and the database parameters, most likely changed directly on the database after the DGBroker configuration be created or the database added. However, there is an interesting thing in this case.

Let’s check on the error first. On the primary database side of the broker configuration:

DGMGRL> show database myprodDB;

Database - myprodDB

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
rmprdb01
Warning: ORA-16714: the value of property LogFileNameConvert is inconsistent with the database setting

Database Warning(s):
ORA-16707: the value of the property LogFileNameConvert is invalid, valid values are pairs of file specifications

Database Status:
WARNING

DGMGRL> show database verbose myprodDB;

Database - myprodDB

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
rmprdb01
Warning: ORA-16714: the value of property LogFileNameConvert is inconsistent with the database setting

Database Warning(s):
ORA-16707: the value of the property LogFileNameConvert is invalid, valid values are pairs of file specifications

Properties:
DGConnectIdentifier = 'myprodDB'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
RedoRoutes = ''
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '1800'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '+DATA/MYDATABASE/DATAFILE/, +DATA/myprodDB/DATAFILE'
LogFileNameConvert = '+DATA/MYDATABASE/ONLINELOG/, +DATADG/myprodDB/ONLINELOG/, +DATA2/MYDATABASE/ONLINELOG/, +DATADG2/myprodDB/ONLINELOG/, +DATA3/MYDATABASE/ONLINELOG/', +DATADG3/myprodDB/ONLINELOG/'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.100)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=myprodDB_DGMGRL)(INSTANCE_NAME=MYDATABASE)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'MYDATABASE_%t_%s_%r.arc'
TopWaitEvents = '(monitor)'

Database Status:
WARNING

And checking for the status in the standby database server:

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.
DGMGRL> show configuration;

Configuration - my_dg_configuration

Protection Mode: MaxPerformance
Members:
myprodDB - Primary database
Warning: ORA-16809: multiple warnings detected for the database

mySTDB - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
WARNING (status updated 12 seconds ago)

DGMGRL> show database myprodDB;

Database - myprodDB

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
MYDATABASE
Warning: ORA-16714: the value of property LogFileNameConvert is inconsistent with the database setting

Database Warning(s):
ORA-16707: the value of the property LogFileNameConvert is invalid, valid values are pairs of file specifications

Database Status:
WARNING

Ok, let’s check now for the database parameters perspective on the Primary:

SQL> show parameter convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string +DATA/MYDATABASE/DATAFILE/, +
DATADG/myprodDB/DATAFILE
log_file_name_convert string +DATA/MYDATABASE/ONLINELOG/,+DATADG/myprodDB/ONLINELOG/, +DATA2/MYDATABASE/ONLINELOG/, 
                             +DATADG2/myprodDB/ONLINELOG/, +DATA3/MYDATABASE/ONLINELOG/, +DATADG3/myprodDB/ONLINELOG/
pdb_file_name_convert string

Comparing the settings:

  • LogFileNameConvert=’+DATA/MYDATABASE/ONLINELOG/, +DATA/myprodDB/ONLINELOG/, +DATA2/MYDATABASE/ONLINELOG/, +DATADG2/myprodDB/ONLINELOG/,+DATA3/MYDATABASE/ONLINELOG/’, +DATADG3/myprodDB/ONLINELOG/’
  • log_file_name_convert=+DATA/MYDATABASE/ONLINELOG/,+DATA/myprodDB/ONLINELOG/,+DATA/MYDATABASE/ONLINELOG/, +DATADG2/myprodDB/ONLINELOG/,+DATA/MYDATABASE/ONLINELOG/, +DATADG3/myprodDB/ONLINELOG/

It seems all right!

What is the problem then?

That’s the interesting part. Checking on MOS Usage and Limitation of db_file_name_convert and log_file_name_convert (Doc ID 1367014.1):

When using the Data Guard Broker the Values for these Parameters are limited to 512 Bytes (Characters) due to the Limit of the corresponding Data Guard Broker Properties ‘DbFileNameConvert’ and ‘LogFileNameConvert’.

That’s new to me! So, possible alternatives are:

  • Use OMF (Oracle Managed Files)
  • Use the same File Structure on both Sites
  • Rename and create Datafiles/RedoLog Files manually

What I did in my case?

We checked and confirmed with the client the only places for the logfiles are DATA and DATA2 (multiplexed). So the fix was easy:

edit database 'myprodDB' set property 'LogFileNameConvert' = "+DATA/MYDATABASE/ONLINELOG/,+DATADG/myprodDB/ONLINELOG/,+DATA/MYDATABASE/ONLINELOG/, +DATADG2/myprodDB/ONLINELOG/";

Once done:

DGMGRL> show configuration;

Configuration - my_dg_configuration

Protection Mode: MaxPerformance
Members:
myprodDB - Primary database
mySTDB - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 3 seconds ago)

DGMGRL> show database myprodDB;

Database - myprodDB

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
MYDATABASE

Database Status:
SUCCESS

DGMGRL> show database mySTDB;

Database - mySTDB

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 325.00 KByte/s
Real Time Query: OFF
Instance(s):
mySTDB

Database Status:
SUCCESS

DGMGRL> show database verbose myprodDB;

Database - myprodDB

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
MYDATABASE

Properties:
DGConnectIdentifier = 'myprodDB.'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
RedoRoutes = ''
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '1800'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '+DATA/MYDATABASE/DATAFILE/, +DATA/myprodDB/DATAFILE'
LogFileNameConvert = '+DATA/MYDATABASE/ONLINELOG/,+DATADG/myprodDB/ONLINELOG/,+DATA/2MYDATABASE/ONLINELOG/,+DATADG2/myprodDB/ONLINELOG/'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.100)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=myprodDB_DGMGRL)(INSTANCE_NAME=MYDATABASE)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'MYDATABASE_%t_%s_%r.arc'
TopWaitEvents = '(monitor)'

Database Status:
SUCCESS

Did you know that?
I hope it helps!

Weekly Events #6

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

 

APRIL 18

 

Before Disaster Strikes Architect Seminar Series

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

 

DB Viscosity Training: Upgrading to Oracle 19c

Join ODTUG and Viscosity for a hands-on virtual class that introduces upgrading to Oracle 19c. In this two hourclass, students will get hands-on experience with on how to upgrade databases to Oracle Database 19c.</span>

A virtual presentation will be followed by the hands-on practicum on performing an actual database upgrade. Attendees will have access to a virtual machine with Oracle database versions 11.2.0.4 and 12.1.0.2 pre-installed with the latest PSU.  Attendee can perform database upgrades from Oracle versions 11.2.0.4 or 12.1.0.2 to OracleDatabase 19c (19.7 or higher).

READ MORE

 

   APRIL 19

 

Oracle Communications Session Border Controller Troubleshooting Boot Camp

This training will prepare participants to take and pass the Oracle Communications Session Border Controller Troubleshooting 2017 Implementation Essentials Exam (1Z1-954).

This Boot Camp is designed for Tier-1 and Tier-2 technical support professionals. You will learn how to effectively troubleshoot problems with SIP call flows through the Oracle Communication SBCs series.

By enrolling in this boot camp, you’ll get a chance to deep dive into call flows through the Oracle Communication Session border Controller (SBC) series configuration. By learning through a combination of interactive instruction, discussion and hands-on labs, you’ll solidify your learning so you can apply it to your daily job.

READ MORE

 

Certification Training for Oracle Cloud Infrastructure 2020 Architect Professional: 1Z0-997-20

In conjunction with Arrow Switzerland please join us for this workshop where we will focus on providing Oracle partners with deeper knowledge on OCI and help you to prepare for the Oracle Cloud Infrastructure 2020 Architect Professional: 1Z0-997-20 exam.

Through a series of 4 separate lessons, we will cover topics and activities that are closely aligned with the exam. All lessons will include lecture, demo and whiteboarding sessions. We will finish the training with some practice questions.

READ MORE

   APRIL 20

 

Spring Tech Summit

In 2020 our first Technology Summit paved the way for UKOUG’s virtual event programme. This spring we will be back giving you high level Oracle content from across the globe. Stay connected no matter where in the world you are.

READ MORE

 

Oracle Enterprise Planning Cloud Implementation 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 Implementation workshop. In this workshop, you will gain a broad understanding and learn to demonstrate and implement the most common business flows and best practices of Oracle Enterprise Planning Cloud. This introductory hands-on, expert-led workshop is intended for consultants who are familiar with the key concepts associated with deploying enterprise class software. This workshop is taught in an accelerated fashion to teach you the most critical tasks in the shortest period of time. Live lab environments are included to reinforce your learning.

READ MORE

 

Oracle Account Reconciliation Implementation 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 introductory hands-on workshop for Oracle Account Reconciliation Cloud (ARCS). In this workshop, you will discover how to use Account Reconciliation Cloud to help streamline close processes and deliver insight about the real-time status of account reconciliations.

READ MORE

 

Hands-on Workshop: Oracle Key Vault

Get a risk-free trial of key vault based on typical use cases from peer customers.

Attendees will receive $500 in free oracle cloud infrastructure (oci) credit.

The environment comes pre-configured, is deployed in minutes, and requires zero system resources (storage, CPU, memory) from attendees’ PCs.

READ MORE

 

Chatbot hands-on workshop series with Oracle Digital Assistant

Bots are the future: Innovate & Extend Oracle SaaS!
In fact, if you’re wondering whether your business should create a bot, you’re asking the wrong question. Bot-powered commerce is the future. This technology is still in its infancy, so most bots follow a set of rules programmed by a human via a bot-building platform, and one of them is Oracle Digital Assistant.

READ MORE

 

Data Modeling with Paul Turley

Paul Turley is a Principal Consultant for 3Cloud Solutions (formerly Pragmatic Works), a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisi.

READ MORE

 

   APRIL 21

 

Oracle Integration Cloud Workshop

Il rapido passaggio da applicazioni on-premise a un mix ibrido di Software as a Service (SaaS), Platform as a Service (Paas) e applicazioni on-premise ha introdotto grandi sfide per le aziende che tentano di semplificare l’integrazione di applicazioni aziendali.

Una volta che le aziende iniziano a utilizzare applicazioni sia su cloud che on premise, spesso risulta necessario integrarsi con le applicazioni esistenti. Prima di Oracle Cloud Integration Service, le piattaforme di integrazione erano troppo complicate per includere facilmente tutti gli utenti di applicazioni della linea di business, risultando un tentativo di integrazione costoso, dispendioso in termini di tempo e soggetto ad errori.

READ MORE

 

How to Simplify and Automate Data Protection of Oracle Environments

It is paramount to protect and secure your companies most valuable asset: your Oracle databases! Oracle Database Administrators often spend most of their time and resources dealing with multiple products, features—not to mention—complexity.

READ MORE

 

Oracle 21c: New Features and Enhancements of Data Pump / TTS

At the end of the year 2020, Oracle released 21c on its Cloud infrastructure. The on-premises version will follow later this year. As with every new Oracle version, the Data Pump utility gets new features or enhancements for existing features.

READ MORE

 

DOAG DAC Online-Event: Oracle Analytics Cloud – von Self-Service Datenvisualisierung bis Machine Learning

In der Session wird gezeigt welche Funktionen das aktuelle Release der Oracle Analytics Cloud im Bereich Self-Service Datenvisualisierung, Datenaufbereitung und Machine Learning bietet. Anhand eines Demo-Beispiels wird Schritt für Schritt erklärt wie die Datenaufbereitung von der Quelle bis zum Dashboard erfolgt, welche Visualisierungsmöglichkeiten bestehen und wie leicht Machine Learning Modelle aus der Oracle Autonomous Database ohne Programmierung in die Analyse integriert werden können.

READ MORE

   APRIL 22

 

Oracle PartnerCast: OCI fundamentals and how they are mapped to Google Cloud Platform

Oracle Cloud Infrastructure has ~100 services and it can be difficult for architects to identify how services map between OCI and other cloud vendors. In this session, you will learn Oracle Cloud Infrastructure (OCI) fundamentals and its mapping to Google Cloud Platform services. We’ll cover key concepts, core service comparisons including identity, compute, storage, networking and databases and OCI differentiators. After this session, you will get a good understanding of OCI services and how to map architectures from GCP to OCI.

READ MORE

 

MOTU: Reactive Applications

MOTU: Reactive Applications
🕛 Quando: 12h do dia 22 de Abril, Quinta Feira! 🕛
✓ Tema: Aplicações reativas no Java: quando, como e porquê!

READ MORE

   APRIL 23

 

DOAG DAC Online-Event: HOL – Oracle Machine Learning

Referent: Charlie Berger, ORACLE Deutschland B.V. & Co.

READ MORE

Weekly Events #5

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

 

APRIL 11

 

Oracle Systems Advantage Forum

DATA DRIVEN INFRASTRUCTURE FOR THE FUTURE ENTERPRISE

Is your it infrastructure built to enable a data-driven future enterprise?

We invite you to join us and experience this on 8th April as Oracle Systems Advantage Forum goes live virtually in association with Intel.

READ MORE

 

   APRIL 12

 

JD Edwards INFOCUS Envision 2021
Plan ahead: roadmaps, product updates, enhancements, cloud adoption and more.
   APRIL 13

 

Oracle Cloud Infrastructure (OCI) Advanced Workshop

Certification Readiness Training for Oracle Cloud Infrastructure 2020 Architect Professional

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 server less and container-based architectures.

READ MORE

 

Oracle Cloud Infrastructure Professional Certification Training Class

Join us at our Oracle Cloud Infrastructure (OCI) Partner Certified Architect Professional Training event to learn the latest in OCI technical features. This event will not only help you enrich your knowledge in deep technical features of OCI, but will also allow a unique chance to hear from the OCI Product Management & Engineering staff that’s pioneering the next generation of cloud at Oracle.

READ MORE

 

Oracle Cloud Infrastructure Advanced 200 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 server less and container-based architectures.

READ MORE

 

Protect Yourself Against Database Downtime with Oracle

Emerging cloud technologies are transforming businesses today. Join us at our webinar on Tuesday, 13 April 2021 @ 10:00 a.m. GMT+2, where you will hear how the Oracle Database Appliance saves time and money by simplifying deployment, maintenance, and support of database solutions for organizations of every size.

Optimized for the world’s most popular database–Oracle Database–it integrates software, compute, storage, and network resources to deliver database services for a wide range of custom and packaged online transaction processing (OLTP), in-memory database, and data warehousing applications.

READ MORE

 

GitOps keeps focus on product, not on infrastructure – Jakarta Tech Talks

Development teams spend time on a lot of things other than their product. They manage infrastructure, DevOps and integrations, and even create staging servers so that an external agency can test out your sweet new redesign. Maybe it’s not even just one site to worry about, but a whole fleet of applications that need to be kept in-sync, secure, and up-to-date, all while sticking to a release schedule.

No one has that much attention or experience to manage it all, and it’s a lot to ask of them to keep up with.

READ MORE

 

How Oracle Builds Internet Scale Applications with Oracle Database on Oracle Cloud Infrastructure

Learn how Oracle uses sharding in Oracle Cloud Infrastructure to achieve extreme scalability, availability, and performance benefits.

  • Extreme scalability with petabytes of data with no impact on latency;
  • Performance improvements when compared to other key value stores;
  • Improved latency over NoSQL implementation.

READ MORE

 

Optimize Cost & Increase Value with Database Cloud Services

Oracle has created a second generation cloud platform with security, performance and reliability at its core. Oracle Cloud Infrastructure is built for enterprises looking for higher performance, lower costs and easier cloud migration from their on-premise applications. Customers who are using OCI get exclusive access to Oracle Autonomous Database and a whole range of Database Services that can be adapted to any use cases and any modern workload that exists today.

READ MORE

 

GUOB Webinar: PLSQL Development Best Practices for DBAs

Dev PL/SQL? Nesta sessão veremos alguns truques e ferramentas que podem mudar a sua vida. Pra melhor! 🙂

Onde: https://www.youtube.com/c/GUOBOficial
Realização: GUOB
Palestrante: Matheus Boesing

READ MORE

   APRIL 14

 

Oracle Exadata/ExaCC Nordic User Group Meeting

Join us at our virtual oracle exadata/exacc user group meeting on 14th april 2021.

The aim of the conference is to foster open discussions and peer-to-peer knowledge sharing about best practices, tips & tricks to make private cloud deployments even simpler with Oracle Exadata Database platform and Exadata Cloud@Customer.

The program includes a keynote presentation by Dario Wiser, EMEA Business Development Director – Cloud Systems who will share the Exadata Roadmap and some exciting technology advances.

READ MORE

 

Oracle Cloud Infrastructure Advanced 200

Oracle Cloud Infrastructure est un ensemble de services cloud qui vous permettent de créer et d’exécuter une large gamme d’applications. Oracle Cloud Infrastructure combine la souplesse et l’utilité du Cloud public avec un fort niveau de contrôle, de sécurité, et une très haute disponibilité et prévisibilité de l’infrastructure on-premise, pour fournir des services d’infrastructure rentables et de hautes performances.

Oracle Cloud Infrastructure est la première plate-forme Cloud à mettre en œuvre la virtualisation de réseau off-box, qui sort la virtualisation du réseau et des ressources de la stack logicielle pour la placer dans la couche réseau.

READ MORE

 

Oracle Database Appliance High Availability and Disaster Recovery

Oracle Database Appliance è la soluzione semplice, ottimizzata e conveniente per tutti i tipi di carichi di lavoro del database. In ogni caso, la semplicità non ha bisogno di scendere a compromessi con l’affidabilità. Oracle Database Appliance semplifica le operazioni di distribuzione di tutte le funzionalità di alta affidabilità del database, inclusi Oracle Real Application Clusters e Oracle Active Data Guard, adattandosi alle best practice raccomandate da Oracle. Unisciti ad una sessione della durata di un’ora in cui potrai approfondire come Oracle Database Appliance può semplificare le tue soluzioni di alta affidabilità e disaster recovery.

READ MORE

 

Oracle State and Local Government Virtual Cloud Summit

MASTER YOUR CLOUD STRATEGY. LEARN FROM YOUR PEERS HOW TO BEGIN YOUR JOURNEY TO THE CLOUD

Many government agencies are seeking advice about how to begin their migration to cloud. Join a panel of your colleagues from across the country who have successfully moved to Oracle Cloud Infrastructure.

READ MORE

 

Oracle Converged Database

INNOVATOR’S DILEMMA: CONQUERING THE COMPLEXITY OF MODERN APPDEV

Developing modern, powerful, reliable applications without losing your mind.

Once upon a time, not so long ago, AppDev for business purposes was relatively simple. A small team of developers would use a single development tool and database to quickly develop a new app for the business. That time is gone. Modern AppDev has become dramatically more complicated with the increased adoption of state-of-the-art Data-Driven technologies such as Machine Learning, Graph Analytics, Spatial Processing, and Blockchain to help gain better insight into customer’s needs.

READ MORE

 

A Tour of the Oracle Database block

Session Abstract: A look inside an Oracle block, the fundamental unit of the Oracle Database. We’ll see how a block is constructed, and how the components inside the block are used by the database to provide performance and concurrency. Unlike a typical internals deep-dive, this session will be more focused on how this internals related back to real-world use cases, such as how queries work, storage optimization, and application locking.

READ MORE

 

   APRIL 15

 

Architectural Principles and Best Practices for Adopting Oracle Cloud
We would like to invite you to attend a webinar Advantage Moving Oracle Database to Oracle Cloud held on April 15 at 09:00-10:00 CET.
Data is considered the most valuable asset of a company. But it’s not just about storing it, you need to extract value out of it.
If your DBA team spends most of its time managing the infrastructure and less time on the data itself, you need a more agile Data Management solution.
Oracle Cloud has the most complete, secure and innovative Data Management Platform. Through automation, scalability and performance, Oracle Cloud takes care of your data, allowing you to focus on your business.

READ MORE

 

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

 

Diving into Oracle Cloud Infrastructure – Hands-on workshop

With an array of benefits Oracle Cloud Infrastructure is pushing boundaries and exceeding expectations in the Cloud world. Companies like Zoom, BotSupply and CERN have already moved key workloads to the Oracle Cloud.

Join the hands-on-workshop to hear and test first-hand how OCI leads to better performance, higher security while maintaining low costs – and the ease of cloud migration.

READ MORE

 

Live Developer Webcast

TRANSFORM YOUR WLS JAVA APPS TO MICROSERVICES ON ORACLE CLOUD INFRASTRUCTURE WITH VFUNCTION.

Legacy Java applications are difficult to modernize. Enterprises rely on these monolithic apps to power their businesses but face an urgent mandate to move to the cloud and adopt a cloud native architecture.

READ MORE

 

Cloud Computing SIG April Meeting

Join us for our monthly Cloud Computing SIG meeting!

READ MORE

 

   APRIL 16
Architectural Principles and Best Practices for Adopting Oracle Cloud
We would like to invite you to attend a webinar Advantage Moving Oracle Database to Oracle Cloud held on April 15 at 09:00-10:00 CET.
Data is considered the most valuable asset of a company. But it’s not just about storing it, you need to extract value out of it.
If your DBA team spends most of its time managing the infrastructure and less time on the data itself, you need a more agile Data Management solution.
Oracle Cloud has the most complete, secure and innovative Data Management Platform. Through automation, scalability and performance, Oracle Cloud takes care of your data, allowing you to focus on your business.

READ MORE

 

Before Disaster Strikes Architect Seminar Series

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

 

Getting started with Oracle Machine Learning – Hands-on Workshop

No experience with Oracle Analytics Cloud (OAC) yet? During this workshop you will get started with the integrated Machine Learning functionalities of Oracle’s most innovative Analytics Platform. Learn how to make use of Augmented Analytics and talk to your data in able to quickly gain insight and easily discover hidden patterns and trends. How do you train a ML model and how do you apply it to make a prediction. These are two examples of what you will find out during this Machine Learning hands-on workshop. You don’t need any Machine Learning prior knowledge!

READ MORE

 

OCI Database Management Cloud Service

Oracle delivers a new comprehensive cloud-native database management cloud service with rich features for monitoring and diagnosing performance problems and compute usage on both cloud and on-premises environments. This technical session will include screen watch demonstrations highlighting common use cases, extensibility, and how to use the tool. Learn how this product is positioned in the Oracle Manageability suite of native cloud-based services and licensed products. Don’t miss the following key takeaway.

READ MORE

Relying in Guaranteed Restore Points? Be careful!

Hi all,

Are you relying on Guaranteed Restore Points (GRP) as a fallback plan for your migration or upgrade strategy? Be careful!

When performing some non-Prod upgrade with the Autoupgrade tool,  after completing the upgrade, I wanted to roll it back and go through the process again,  This is what happened:

SQL> startup
ORA-29702: error occurred in Cluster Group Service operation

When looking for it found this blog post from Mike I missed the last year: https://mikedietrichde.com/2020/11/13/ora-29702-and-your-instance-does-not-startup-in-the-cluster-anymore/

This means my database is not starting anymore! Oh man, glad that I’m in the testing phase!

This caused by of Bug 31561819 – Incompatible maxmembers at CRSD Level Causing Database Instance Not Able to Start.

As per Mike’s post, “you don’t need to even restore or flashback a database to hit this error. A simple instance in NOMOUNT state leads to the same error. Without even any datafile.”

The bug is fixed on:

  • 19.9.0.0.201020 (Oct 2020) OCW RU
  • 18.12.0.0.201020 (Oct 2020) OCW RU
  • 12.2.0.1.201020 (Oct 2020) OCW RU

As being, you should include this patch BEFORE starting any move! Do it right away if you are on these versions!

Also, be aware of the latest change regarding Restore Points propagation on 19c, as per MOS Automatic Propagate Restore Points from Primary to Standby site in 19C (Doc ID 2463082.1)

In my case, the usage is exactly for a 12.1->19c upgrade. So, the fix is not even available (no Extended Support in place). As being, we had to think on alternate fallback plans, like a physical standby. But this is a topic for another post.

So for YOU:

  • Apply this patch if you can!
  • If not, be very careful on the fallback plans and as usual: Test, Test and Test!

See you next post!

Weekly Events #4

Here is a summary of the EVENTS for this week!

 

APRIL 05
Azure App Service em Linux: é possível executar WebJobs?

Computação em nuvem é algo que está cada vez mais presente no nosso dia a dia como desenvolvedores, IT pros e mesmo usuários. E sendo o Microsoft Azure uma das plataformas líderes em cloud computing no cenário atual, o Canal .NET decidiu promover mais uma vez o Azure Tech Nights: um evento completamente ONLINE e GRATUITO com sessões durante Fev/2021 e Mar/2021 para levar mais conhecimento sobre nuvem para toda a comunidade.

READ MORE

   APRIL 06

 

Boot Camp Oracle Communications SD-WAN

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

 

Reduce system complexity in Java with Data-Oriented programming

Traditionally in Java, we mix data and code in objects. While being beneficial in some cases, data encapsulation has a tendency towards systems with complex class hierarchies. Moreover, we introduce complex synchronization mechanisms to protect the state of our objects from being mutated or corrupted by other threads, making our code harder to maintain. Over the years many design patterns have been invented to work around this complexity.

Data-Oriented programming is a programming paradigm that inherently reduces system complexity by drawing a clear separation between code and data, and representing data with generic immutable data structures.

READ MORE

   APRIL 07

 

Experience HPC for Research on Oracle Cloud Infrastructure
GET UP AND RUNNING IN YOUR CLOUD TENANCY
ORACLE HPC IS DESIGNED FOR THE MOST COMPUTATIONALLY INTENSIVE WORKLOADS

Register for this hands-on workshop delivering the experience of high performance computing on Oracle Cloud Infrastructure. You’ll learn how to:

  • Launch an HPC cluster through the OCI command line interface.
  • Apply best practices for provisioning an automated application stack through the “infrastructure-as-a-code” model and Terraform.
  • Easily and efficiently deploy an OpenFOAM-ready VM on OCI

READ MORE

 

Oracle Virtual Event: The Modern Data Warehouse
VIRTUAL EVENT

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

 

Running Oracle Database Upgrades on Docker

Organizations planning for an Oracle upgrade should consider Docker in their upgrade strategy. Docker is an ideal environment for evaluating and testing Oracle database features and upgrades are no exception. Creating an Oracle database in Docker is fast and easily repeated. Containers require little time or effort to create and are light enough to run on a laptop. This makes Docker the ideal platform for evaluating, practicing, and perfecting database upgrade procedures. In this session, I’ll demonstrate: – Approaches for installing, patching, and customizing Oracle database software on Docker – Modifications needed in Oracle’s default Docker image builds to support upgrades – Techniques for creating “upgrade containers with source and target Oracle database homes preinstalled – How to merge multiple database images into a single container – Methods for creating reference data for running instant databases

READ MORE

 

Oracle Database 19c Upgrade Workshop

Computer Gross, in collaborazione con Oracle, vi invita a partecipare a questo workshop gratuito, indirizzato a tutti coloro che intendono approfondire tutto ciò che riguarda la versione 19c ed avere la possibilità di assistere a come eseguire l’upgrade ad Oracle Database 19c.

Questo include un’introduzione alla 19c e un’osservazione più da vicino dei vari metodi di upgrade all’ultima versione.

READ MORE

 

Information Lifecycle Management: Manage Exponential Data Growth

Abstract:
Exponential increases in data volumes are putting enterprise IT infrastructures under severe pressure – from a cost, performance, scalability and manageability perspective. Regulatory requirements are also changing how and why data is being retained, as many organizations are now required to retain and control much more information
for much longer periods. Information Lifecycle Management (ILM) is the practice of applying policies for the
effective management of information throughout its useful life.

READ MORE

 

   APRIL 08

 

Oracle Exadata X8M – New Features for OLTP Applications. PMEM Cache & PMEM Log

The Oracle Exadata Database Machine is engineered to deliver dramatically better performance, cost effectiveness, and availability for Oracle databases. The newest Oracle Exadata X8M features a modern cloud-enabled architecture with scale-out high-performance database servers, scale-out intelligent storage servers with state-of-the-art PCI flash, leading-edge storage cache using persistent memory, and cloud scale RDMA over Converged Ethernet (RoCE) internal fabric that connects all servers and storage.

READ MORE

 

DB DATA GUARD: CONFIGURATION AND BEST PRACTICES

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.

READ MORE

 

GUORS: MongoDB for Oracle DBAs/Developers

Faz tanto tempo que os bancos de dados relacionais dominam o mercado que em certo momento a expressão banco de dados virou sinônimo de bancos de dados relacionais. Esse tipo de tecnologia ainda domina o mercado, mas vem crescendo rapidamente o uso de diversas novas tecnologias de armazenamento de dados. Estes novos bancos de dados são chamados, genericamente, de bancos NoSQL, abreviatura da expressão “Not Only SQL”, ou seja, não apenas SQL (sendo SQL a linguagem padrão usada por quase todos os bancos relacionais).

Para muitos administradores de banco de dados e desenvolvedores, o uso de um banco de dados NoSQL ainda é uma novidade e muitos ainda estão se adaptando e aprendendo sobre as vantagens na utilização deste tipo de banco de dados.

Este evento irá cobrir uma visão geral sobre os recursos de MongoDB e comparativo de features relacionadas entre as duas tecnologias MongoDB x Oracle para ambas as áreas DBAs e Desenvolvedores.

READ MORE

 

   APRIL 09

 

DOAG Datenbank Online-Event: PostgreSQL als Resource auf der ODA

Wem kommt das bekannt vor? Die Datenbank läuft auf der neuen ODA und alles ist prima aber auf der ODA ist noch Platz und die CPU-Auslastung ist auch nicht allzu hoch. Und dann kommt die Idee! Man könnte doch, .. ja genau!

Warum bringen wir unsere PostgreSQL Datenbank nicht auf die ODA? Die Datenbank soll nicht von PostgreSQL nach Oracle migriert werden, nein, sie soll nativ auf der ODA als Ressource laufen!

READ MORE

 

   APRIL 10

 

Becas certificaciones internacionales 📢 DevOPS Certified Associate

DevOPS Certified Associate.

Obtenga una beca del 100% en el curso! solo paga el examen hasta con el 60% de descuento

Fecha sesión online en vivo:

Relaciono enlace de descarga del contenido temático de la certificación.

READ MORE

 

Gratuito- Simulado AZ-900: teste seus conhecimentos em Azure

Durante o mês de Fevereiro/2021 aconteceu no canal Coding Night uma série de lives cobrindo conceitos básicos de cloud computing, uma visão geral do Microsoft Azure, além de dicas para você que pretende realizar o exame de certificação AZ-900 – Microsoft Azure Fundamentals.

E decidimos agora dar continuidade a este projeto voltado àqueles que pretendem se certificar no exame AZ-900: um simulado ao vivo, online, gratuito e com emissão de certificado para aqueles que participarem desta iniciativa!

READ MORE

Exadata DNS Change – Pitfalls to be avoided

Hi all, it’s been a while but here I am!

There were some changes in the infrastructure at the place I work and I was asked to do a DNS change on a bit old Exadata X5. I had never done one before this, so the idea of this post is to help others who might face the issues I had.

The first thing I did was to look up the documentation about it and see the steps, yes there are blogs about it but the doc can help to get at least the first glance of the situation.

Long story short: Exadata has lots of components and the new DNS should be changed on all of them.

Here is a summary of the steps.

Infiniband switches

Connect to the switches and sudo to ilom-admin and change the DNS

su - ilom-admin
show /SP/clients/dns
set /SP/clients/dns nameserver=192.168.16.1,192.168.16.2,192.168.16.3
show /SP/clients/dns

 

Database nodes

For my image I only needed to change the /etc/resolv.conf, if you have a newer one you will need to user ipconf – That´s why you need to go to the documentation, at least there we hope that they will put some mentions on the pitfalls (well keep reading and you will see that was not my case)

Also changed the DNS on wach database node ilom, runing the ipmtool from the each node

ipmitool sunoem cli 'show /SP/clients/dns'
ipmitool sunoem cli 'set /SP/clients/dns nameserver=192.168.16.1,192.168.16.2,192.168.16.3'
ipmitool sunoem cli 'show /SP/clients/dns'


Cell nodes – Here things start to get interesting

For the storage cell there are some points that need to be taken under consideration:

Increase the ASM disk_repair_time – the goal here is to avoid a full rebalance if you do this within its timeframe, if you don’t know this parameter,  ASM will wait for up to the interval specified for DISK_REPAIR_TIME for the disk(s) to come online. If the disk(s) come back online within this interval, a resync operation will occur, where only the extents that were modified while the disks were offline are written to the disks once back online. If the disk(s) do not come back within this interval, ASM will initiate a forced drop of the disk(s), which will trigger a rebalance.

On each cell node we need to make sure all disks are OK, stop all cell disks, stop all cell services and user ipconfig to change the DNS configuration

#Check that putting the grid disks offline will not cause a problem for Oracle ASM - it should all say YES on the 3rd column 
cellcli -e LIST GRIDDISK ATTRIBUTES name,asmmodestatus,asmdeactivationoutcome

#Inactivate all grid disks on the cell - may take a while to complete
cellcli -e ALTER GRIDDISK ALL INACTIVE


#Confirm the grid disks are offline, it should show asmmodestatus=OFFLINE or asmmodestatus=UNUSED, and asmdeactivationoutcome=Yes for all grid disks
cellcli -e LIST GRIDDISK ATTRIBUTES name, asmmodestatus,asmdeactivationoutcome

#Confirm that the disks are offline
cellcli -e LIST GRIDDISK

#Shut down the cell services and ocrvottargetd service
cellcli -e ALTER CELL SHUTDOWN SERVICES ALL
service ocrvottargetd stop #on some images this services does not exists

To execute the ipconf on the old way we only need to call it can follow the prompts, but if you have a newer image you will need to provide its parameters as is shown in the documentation.

The documentation says that after it we could start the cell services back up but I would recommend validating the DNS prior to doing that, why is that you might say because mine did not work and I could have a bigger issue with a cell node without DNS trying to start the services.

So, how to test, use nslookup, dig and curl

nslookup dns_domain.com
curl -v 192.168.16.1:53
dig another_server_in_the_network

 

My tests did not work, I was able to ping the DNS servers but not to resolve any name, I had an SR on MOS but did not help much either, looking up as this is a production system I tried to see if the firewall was up on the Linux site, and to my surprise it was.

I tried to manually add rules to iptables but it did not work and then I came across this note Exadata: New DNS server is not accessible after changing using IPCONF (Doc ID 1581417.1)

And there it was, I needed to restart the cellwall service to recreate the iptables rules.

# Restart cellwall service
service cellwall restart
service cellwall status

One final point, check if ASM started the rebalance or not, if it did, do not start to bring down another cell node until the rebalance is finish, otherwise you may run into deeper issues.

 

I hope it helps!

Elisson Almeida

Weekly Events #3

 

MARCH 29

 

HOW TO SETUP, TRANSACT AND USE OUTSIDE PROCESSING

For Discrete Costing learn about the Oracle EBS outside processing (OSP) techniques and other alternative approaches not found in an Oracle User Guide. Learn about the different ways you can use Outside Processing and how these transactions are viewed by Oracle Purchasing as opposed to Oracle Work in Process. Applicable to both Release 11i and 12.

READ MORE

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

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 e Azure Functions. Ao longo da apresentação será coberto o uso de diferentes frameworks, serviços na nuvem, mensageria, bancos de dados 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

 

   MARCH 30

 

 

Database & Technology INSYNC – 30/03 at 01-04

Introducing INSYNC 21​

Three jam-packed days of Oracle Database and Technology learning​

Quest Oracle Community is excited to introduce a <strong>BRAND NEW</strong> virtual conference exclusively for Database and Technology users!

INSYNC connects DBAs to product experts, industry innovators, technology leaders and Oracle product teams for 3 full days of online education and networking. Get hands-on with the experts, dive into demo’s and workshops, connect with other Oracle database users, and meet solutions providers – all from the comfort of your desk. ​

READ MORE

 

Cloud Native Computing Linz Meetup

WE ARE EXCITED TO HOST THE 6TH EDITION OF THE CLOUD NATIVE COMPUTING LINZ MEETUP!

 Matt Jarvis is a Senior Developer Advocate at Snyk. Matt has spent more than 15 years building products and services around open source software, on everything from embedded devices to large scale distributed systems. Most recently he has been focused on the open cloud infrastructure space, and in emerging patterns for cloud native applications. Matt is a regular speaker at conferences across the world, including Open Infrastructure Summit, FOSDEM and All Things Open.

– Rainer Stropek is co-founder and CEO of the company software architects and has been serving this role since 2008. At software architects Rainer and his team are developing the award-winning SaaS time tracking solution “time cockpit”. Previously, Rainer founded and led two IT consulting firms that worked in the area of developing software solution based on the Microsoft technology stack.

READ MORE

 

Boas Práticas em Aplicações na Nuvem: Twelve-Factor App

Computação em nuvem é algo que está cada vez mais presente no nosso dia a dia como desenvolvedores, IT pros e mesmo usuários. E sendo o Microsoft Azure uma das plataformas líderes em cloud computing no cenário atual, o Canal .NET decidiu promover mais uma vez o Azure Tech Nights: um evento completamente ONLINE e GRATUITO com sessões durante Fev/2021, Mar/2021 e Abr/2021 para levar mais conhecimento sobre nuvem para toda a comunidade.

READ MORE

Opatchauto Failing on “CheckActiveFilesAndExecutables” during Prerequisite Check

Hi all,
So, very recently when applying the 2021 January CPU in a client environment, the following happened:

[root@dbserver01 32226239]# $ORACLE_HOME/OPatch/opatchauto apply

OPatchauto session is initiated at Sun Mar 14 03:00:06 2021

System initialization log file is /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchautodb/systemconfig2021-03-14_03-00-08AM.log.

Session log file is /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/opatchauto2021-03-14_03-00-13AM.log
The id for this session is 1J89

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/db
Patch applicability verified successfully on home /u01/app/oracle/product/19c/db


Executing patch validation checks on home /u01/app/oracle/product/19c/db
Patch validation checks successfully completed on home /u01/app/oracle/product/19c/db


Verifying SQL patch applicability on home /u01/app/oracle/product/19c/db
SQL patch applicability verified successfully on home /u01/app/oracle/product/19c/db


Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19c/grid
Patch applicability verified successfully on home /u01/app/oracle/product/19c/grid


Executing patch validation checks on home /u01/app/oracle/product/19c/grid
Patch validation checks successfully completed on home /u01/app/oracle/product/19c/grid


Preparing to bring down database service on home /u01/app/oracle/product/19c/db
Successfully prepared home /u01/app/oracle/product/19c/db to bring down database service


Bringing down database service on home /u01/app/oracle/product/19c/db
Following database has been stopped and will be restarted later during the session: er1pprd,obiee
Database service successfully brought down on home /u01/app/oracle/product/19c/db


Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/oracle/product/19c/grid
Prepatch operation log file location: /u01/app/oracle/product/crsdata/dbserver01/crsconfig/hapatch_2021-03-14_03-06-15AM.log
CRS service brought down successfully on home /u01/app/oracle/product/19c/grid


Start applying binary patch on home /u01/app/oracle/product/19c/db
Failed while applying binary patches on home /u01/app/oracle/product/19c/db

Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : dbserver01->/u01/app/oracle/product/19c/db Type[sidb]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/oracle/product/19c/db, host: dbserver01.
Command failed: /u01/app/oracle/product/19c/db/OPatch/opatchauto apply /ora02/soft/jan21cpu/32126842/32226239 -oh /u01/app/oracle/product/19c/db -target_type oracle_database -binary -invPtrLoc /u01/app/oracle/product/19c/grid/oraInst.loc -jre /u01/app/oracle/product/19c/grid/OPatch/jre -persistresult /u01/app/oracle/product/19c/db/opatchautocfg/db/sessioninfo/sessionresult_dbserver01_sidb_2.ser -analyzedresult /u01/app/oracle/product/19c/db/opatchautocfg/db/sessioninfo/sessionresult_analyze_dbserver01_sidb_2.ser
Command failure output:
==Following patches FAILED in apply:

Patch: /ora02/soft/jan21cpu/32126842/32226239/32218454
Log: /u01/app/oracle/product/19c/db/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-14_03-17-58AM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Prerequisite check "CheckActiveFilesAndExecutables" failed.

After fixing the cause of failure Run opatchauto resume

]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.

OPatchauto session completed at Sun Mar 14 03:19:25 2021
Time taken to complete the session 19 minutes, 19 seconds

opatchauto failed with error code 42

OK, going by parts, let's see what we have on the refered log:

[Mar 14, 2021 3:33:32 AM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19c/grid/bin/expdp at Sat Mar 14 03:33:32 PDT 2021
[Mar 14, 2021 3:33:32 AM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19c/grid/bin/expdp at Sat Mar 14 03:33:32 PDT 2021
[Mar 14, 2021 3:33:32 AM] [INFO] Following active executables are not used by opatch process :


Following active executables are used by opatch process :
/u01/app/oracle/product/19c/grid/lib/libclntsh.so.19.1
[Mar 14, 2021 3:33:32 AM] [INFO] Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:


Following active executables are not used by opatch process :


Following active executables are used by opatch process :
/u01/app/oracle/product/19c/grid/lib/libclntsh.so.19.1
[Mar 14, 2021 3:33:33 AM] [INFO] UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Mar 14, 2021 3:33:33 AM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Mar 14, 2021 3:33:33 AM] [INFO] Finishing UtilSession at Sat Mar 14 03:33:33 PDT 2021
[Mar 14, 2021 3:33:33 AM] [INFO] Log file location: /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/core/opatch/oapatch_2021-03-14_03-06-15AM.log

This is an interesting situation.

After some validations making sure no service is online, the path is writable, oracle and root have the required privilege and access, I found some relevant Oracle notes:

  • 19c Installation Fails with error “libclntsh.so: file format not recognized; treating as linker script” (Doc ID 2631283.1): Pointing to file corruption
  • While Applying a Weblogic Patch, opatch Fails with “Prerequisite check “CheckActiveFilesAndExecutables” failed” Error (Doc ID 2705809.1): Not a DB note and pointing to other processes using the files.
  • Opatch failure due to “CheckActiveFilesAndExecutables” as Remote registry service holding files (Doc ID 2462952.1): Remote registry holding the binaries.
  • Prerequisite Check “Checkactivefilesandexecutables” Failed (Doc ID 1281644.1): Patch requisite miss on 10g
  • Failed to apply PSU due to CheckActiveFilesAndExecutables check failure (Doc ID 2506432.1): SQLPlus holding the binaries.
  • [OCI]: Database System Patching Failed With Error “DCS-10001:Internal Error Encountered: Failure : Failed To Apply” And Opatch Log Shows “Prerequisite check “CheckActiveFilesAndExecutables” failed” (Doc ID 2687607.1): My case is not an OCI and not in RAC.

So, no matches at all.

However, this last note gave me the hints I needed. From Doc ID 2687607.1, for RAC environments:

/u01/app/19.0.0.0/grid/crs/install/rootcrs.sh -unlock
/u01/app/19.0.0.0/grid/crs/install/rootcrs.sh -init
/u01/app/19.0.0.0/grid/crs/install/rootcrs.sh -prepatch
/u01/app/19.0.0.0/grid/crs/install/rootcrs.sh -postpatch

So, in my case, a Standalone On-Premise Database (and GI):

/ora01/app/oracle/product/19c/grid/crs/install/roothas.sh -unlock
/ora01/app/oracle/product/19c/grid/crs/install/roothas.sh -init
/ora01/app/oracle/product/19c/grid/crs/install/roothas.sh -prepatch
[ Apply the patch! ]
/ora01/app/oracle/product/19c/grid/crs/install/roothas.sh -postpatch

Check the output:

[root@dbserver01 jan21cpu]# /u01/app/oracle/product/19c/grid/crs/install/roothas.sh -unlock
Using configuration parameter file: /u01/app/oracle/product/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/oracle/product/crsdata/dbserver01/crsconfig/haunlock__2021-03-14_04-00-35AM.log
2021/03/14 04:01:01 CLSRSC-347: Successfully unlock /u01/app/oracle/product/19c/grid
[root@dbserver01 jan21cpu]# /u01/app/oracle/product/19c/grid/crs/install/roothas.sh -init
Using configuration parameter file: /u01/app/oracle/product/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/oracle/product/crsdata/dbserver01/crsconfig/roothas_2021-03-14_04-01-09AM.log
[root@dbserver01 jan21cpu]# /u01/app/oracle/product/19c/grid/crs/install/roothas.sh -prepatch
Using configuration parameter file: /u01/app/oracle/product/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/oracle/product/crsdata/dbserver01/crsconfig/hapatch_2021-03-14_04-01-16AM.log
2021/03/14 04:01:27 CLSRSC-347: Successfully unlock /u01/app/oracle/product/19c/grid
2021/03/14 04:01:27 CLSRSC-671: Pre-patch steps for patching GI home successfully completed.

And now resuming the Opatchauto:

[root@dbserver01 jan21cpu]# cd 32126842/32226239/
[root@dbserver01 32226239]# $ORACLE_HOME/OPatch/opatchauto resume

OPatchauto session is initiated at Sun Mar 14 04:02:07 2021
Session log file is /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/opatchauto2021-03-14_04-02-10AM.log
Resuming existing session with id 1J89

Start applying binary patch on home /u01/app/oracle/product/19c/db
Binary patch applied successfully on home /u01/app/oracle/product/19c/db


Start applying binary patch on home /u01/app/oracle/product/19c/grid

Binary patch applied successfully on home /u01/app/oracle/product/19c/grid


Performing postpatch operations on CRS - starting CRS service on home /u01/app/oracle/product/19c/grid
Postpatch operation log file location: /u01/app/oracle/product/crsdata/dbserver01/crsconfig/hapatch_2021-03-14_04-27-58AM.log
CRS service started successfully on home /u01/app/oracle/product/19c/grid


Preparing home /u01/app/oracle/product/19c/db after database service restarted
No step execution required.........


Trying to apply SQL patch on home /u01/app/oracle/product/19c/db
SQL patch applied successfully on home /u01/app/oracle/product/19c/db

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:dbserver01
SIDB Home:/u01/app/oracle/product/19c/db
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /ora02/soft/jan21cpu/32126842/32226239/32218663
Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /ora02/soft/jan21cpu/32126842/32226239/29340594
Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /ora02/soft/jan21cpu/32126842/32226239/32240590
Reason: This patch is not applicable to this specified target type - "oracle_database"


==Following patches were SUCCESSFULLY applied:

Patch: /ora02/soft/jan21cpu/32126842/32226239/32218454
Log: /u01/app/oracle/product/19c/db/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-14_04-02-36AM_1.log

Patch: /ora02/soft/jan21cpu/32126842/32226239/32222571
Log: /u01/app/oracle/product/19c/db/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-14_04-02-36AM_1.log


Host:dbserver01
SIHA Home:/u01/app/oracle/product/19c/grid
Version:19.0.0.0.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /ora02/soft/jan21cpu/32126842/32226239/29340594
Log: /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-14_04-11-34AM_1.log

Patch: /ora02/soft/jan21cpu/32126842/32226239/32218454
Log: /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-14_04-11-34AM_1.log

Patch: /ora02/soft/jan21cpu/32126842/32226239/32218663
Log: /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-14_04-11-34AM_1.log

Patch: /ora02/soft/jan21cpu/32126842/32226239/32222571
Log: /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-14_04-11-34AM_1.log

Patch: /ora02/soft/jan21cpu/32126842/32226239/32240590
Log: /u01/app/oracle/product/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-14_04-11-34AM_1.log

OPatchauto session completed at Sun Mar 14 04:31:48 2021
Time taken to complete the session 29 minutes, 43 seconds

And here is the relevant point: This has been happening to me on several environments and servers across the recent weeks. Always for 2021 January CPU.
My guess is that this might have something to do with this CPU binaries set or, most likely, with the latest OPatch version:

[oracle@dbserver01 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.24

I hope it helps you as well!

Weekly Events #2

 

MARCH 23

 

Oracle Developer Live – Java Innovations

ADVANCE YOUR APPLICATION INNOVATION WITH ORACLE’S JAVA TECHNOLOGIES

Oracle’s ongoing technology leadership and ecosystem stewardship is advancing Java, strengthening its position as the premier programming language and platform for modern application development. At this event, you’ll enhance your developer skills by learning more about Java from Oracle and industry technical experts. See how Java can help you create the next generation of rich, scalable, secure, and modern applications for a variety of targeted deployment environments. Gain insight into innovations within the Java 16 release that improve the performance, stability, and security of application development.

READ MORE

Modern Data Platform: Next Generation Data Management

SIMPLIFY, SECURE AND MODERNISE YOUR DATA PLATFORM.

NEXT GENERATION DATA MANAGEMENT.

Embarking on the modernisation journey is more than just re-hosting the workloads in a lift and shift manner. It is as an opportunity to reinforce and optimise the underlying infrastructure.

READ MORE

   MARCH 24

 

 

New Integration Tools for Oracle Modern Data Warehousing

SEE THE NEW SERVICE BUILT TO MOVE YOUR DATA EASILY AND DERIVE VALUE FROM IT.

In this upcoming webcast, you’ll discover the benefits of the all-new Oracle Data Integrator Transforms. This service is an evolution of our classic, market-leading Oracle Data Integrator (ODI).

READ MORE

 

MySQL Webinar – Query Acceleration for MySQL

400X QUERY ACCELERATION FOR MYSQL WITH HEATWAVE.

HeatWave is a new, in-memory query accelerator for MySQL Database Service available in Oracle Cloud. HeatWave can accelerate performance on large multi-TB datasets, and scale across 1,000s cores. Benchmark results show that HeatWave accelerates MySQL queries by 400X and is 1/3 the cost of Amazon Redshift.

READ MORE

 

Workshop: Cassandra Data Modeling Methodology, with samples!

If you’re a developer that wants to succeed with Apache Cassandra™, understanding the art of Data Modeling is the single biggest factor to help you get there!

Join us for this BRAND NEW session to learn how Cassandra’s data modeling differs from traditional data modeling. You’ll leave knowing how to create data models that scale effectively as your system grows – meaning your users get the experience they deserve!

 

READ MORE

Oracle R12.2 Upgrade and Impacts on Legacy Reporting and Discoverer

Are you worried about how Oracle upgrades will affect your legacy reporting? Are you dreading the migration from a legacy reporting tool like Oracle Discoverer or OBIEE? Many users currently running Oracle Discoverer or OBIEE express concerns when it comes to finding a path forward now that these legacy tools have reached their end of life and are no longer being supported by Oracle. These concerns are well-founded as those who choose to
stay on board until the sustaining period ends will be left without critical support for existing Oracle and third-party products and necessary updates. While users who opt to upgrade to R12.2 will find that the advancements included in this upgrade, unfortunately, haven’t reached Oracle’s native reporting tools.

READ MORE

 

   MARCH 25

 

 

Oracle MySQL Cloud Day 2021 | ANZ, ASEAN, & HK

DON’T MISS OUT ON OUR UPCOMING MYSQL VIRTUAL EVENT!

Join us for our MySQL Cloud Day, and get a deep dive and interactive experience on how the world’s #1 open source database in Oracle Cloud, can help you with your cloud and database solutions.

READ MORE

 

Oracle/IDC France Webinar

TRANSFORMATION NUMÉRIQUE : DSI ET DAF, LE DUO GAGNANT

QUELLE COLLABORATION POUR L’OPTIMISATION DES RESSOURCES AU PROFIT DE LA CAPACITÉ D’INNOVATION ?

Oracle et le cabinet d’études IDC France vous donne rendez-vous le 25 mars 2021 à 9h pour un webinar sur le thème de la transformation numérique.

READ MORE

 

Primeiros passos na Oracle Cloud Infrastructure

Um Pequeno Passo Para Si, Um Passo Inteligente Para A Sua Empresa! Aprenda Nesta Sessão Especial De 2 Horas Alguns Benefícios Da Oci.

Conhece os benefícios práticos da Autonomous Database? Sabe como configurar Alta Disponibilidade e Disaster Recovery? E o que fazer para explorar Escalabilidade e Flexibilidade em OCI?

READ MORE

 

Oracle PartnerCast: OCI fundamentals and how they are mapped to Microsoft Azure

Oracle Cloud Infrastructure has ~100 services and it can be difficult for architects to identify how services map between OCI and other cloud vendors. In this session, you will learn Oracle Cloud Infrastructure (OCI) fundamentals and its mapping to Azure services. We’ll cover key concepts, core service comparisons including identity, compute, storage, networking and databases and OCI differentiators. After this session, you will get a good understanding of OCI services and how to map architectures from Azure to OCI.

READ MORE

 

DB Viscosity Training (RESCHEDULED): Upgrading to Database 19c

Join ODTUG and Viscosity for a hands-on virtual class that introduces upgrading to Oracle 19c. In this two-hour class, students will get hands-on experience on how to upgrade databases to Oracle Database 19c.

A virtual presentation will be followed by the hands-on practicum on performing an actual database upgrade. Attendees will have access to a virtual machine with Oracle database versions 11.2.0.4 and 12.1.0.2 pre-installed with the latest PSU. Attendees can perform database upgrades from Oracle versions 11.2.0.4 or 12.1.0.2 to Oracle Database 19c (19.7 or higher).

READ MORE

 

   MARCH 26

 

Authentication options for the Oracle Database

Authentication options for the Oracle Database

Session Abstract: 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

Speaker BIO: Russ Lowenthal
Senior Director of Product Management for Database Security, Oracle

READ MORE