Weekly Events #16

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

 

JUNE 27

 

ODTUG Kscope21 Virtual Event

The ODTUG Kscope21 Virtual Event is the premier Oracle developer conference, attracting Oracle experts from all over the world. With cutting-edge technical sessions and opportunities to connect to the global ODTUG community, this event is perfect for Oracle developers who want to boost their skills at any stage of their career.

The ODTUG Kscope21 Virtual Event features presentations across a variety of technical content topics, including Oracle Database, Oracle Application Express, Oracle EPM-Hyperion, and Oracle Analytics, just to name a few.

READ MORE

 

   JUNE 28

 

Data Analytics Summer Campus – 18 ponentes y más de 30 h de talleres y charlas

Llega el Data Analytics Summer Campus!

4 SEMANAS, 18 PONENTES Y MÁS DE 30 HORAS DE TALLERES Y CHARLAS ESPECIALIZADAS, TODO ONLINE.

Llega el Summer Campus, un mes de charlas especializadas donde podrás adquirir conocimientos de Big Data junto a grandes profesionales del sector.

READ MORE

 

 

   JUNE 29
Oracle Integration Partner Bootcamp Brazil

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

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

Oracle Product Management is pleased to invite Oracle Partners to attend the 3-day hands-on workshop on how to integrate with ERP & HCM applications using Oracle Integration Cloud. This Invite-Only hands-on workshop will be delivered at No-Fee to Partners. It will consist of presentations, demos, and hands-on labs.

READ MORE

 

Oracle Visual Builder What’s New

Learn how you can leverage the Visual Builder Platform – used by Oracle to develop the next generation of Oracle Cloud Apps – to develop your own solutions and to extend Oracle’s Apps too. In this session we’ll explain the new platform architecture, show a full development lifecycle demo, and discuss the new features added in the latest release. See the platform that Oracle relies on for our own business and learn how it can benefit your business.

READ MORE

 

Revolución en Cloud: experiencias de usuarios en Banca y Retail

Inteligencia Artificial, Machine Learning, gestión segura de datos críticos en la nube, e innovación son algunos de los ingredientes esenciales de las soluciones de Strands (startup Fintech) y JogoTech (empresa experta en Retail) que despliegan sus negocios en la nube de segunda generación de Oracle, garantizando los niveles de rendimiento, seguridad, disponibilidad de los grandes volúmenes de datos e innovación que es necesario gestionar en las organizaciones financieras y en el e-commerce.

Para conocer de primera mano cómo a partir de soluciones creadas en la Cloud de Oracle, STRANDS ayuda a más de 700 entidades financieras en todo el mundo, y cómo JogoTech continúa innovando en la industria del Retail a través de la plataforoma phygital, siendo pioneros en el “e-xtended retail” te invitamos a participar en un exclusivo evento virtual que tendrá lugar el próximo 29 de junio.

READ MORE

 

THE LAYERS OF YOUR IT INFRASTRUCTURE: CAN YOU SUPPORT YOUR EOL SYSTEMS & HOW?

Customized and often proprietary applications serve as a mission-critical function in an organization’s IT infrastructure. However, these applications present unique challenges. They are often written to run on specific operating systems (OS) and hardware platforms and are difficult to port and migrate.

As the underlying OS and host hardware ages, IT Departments face an increased risk of downtime as spare parts become difficult to source and their in-house technical support staff either retire or move on to other employment.

As the sun sets on Solaris and SPARC, the Unix OS and RISC processor, IT Directors and Managers are tasked with (a) ensuring their application’s underlying OS is properly supported, and (b) any risks associated with aging hardware that lead to unplanned downtime are mitigated.

READ MORE

 

INTEGRATE APPLICATIONS WITHOUT ANY CODING USING ORACLE INTEGRATION CLOUD

With the increasing footprint of Oracle Cloud applications comes the challenge of integrating those with other Cloud and on-prem applications. Organizations desire a single platform to achieve all the integration needs, including B2B and B2C integrations like EDI and XML. Oracle Integration Cloud provides an innovative and powerful cloud platform to extend, analyze, and integrate applications with the rest of your enterprise resources.

READ MORE

 

Capturing the true value of your Oracle Exadata investments — from the Customer’s Viewpoint

On Tuesday, 29th June 2021 at 3pm BST, join our live customer roundtable and hear directly from Tesco Stores and other leading companies that have realised benefits from passing the baton of Exadata management to Oracle Exadata experts and Managed Service Provider, Data Intensity.​

Join infrastructure experts in this interactive session to:

  • Understand the key drivers and decision points that led the companies to outsource management and support of their Exadata platforms.​
  • From the decision to invest in Exadata through to the current day, hear customer stories and understand the detail of having your Exadata estate managed by Data Intensity
  • Discover how your organisation can realise enhanced stability and improved security, and how to replicate this success.​
  • Obtain insight from leading organisation to inform your thinking and determine the next steps for your Exadata strategy.

READ MORE

 

   JUNE 30

 

Oracle Cloud Infrastructure Community Summit

THE 1ST ORACLE CLOUD INFRASTRUCTURE COMMUNITY SUMMIT

LEARN FROM AND INTERACT WITH OTHER CUSTOMERS TO SHARE EXPERIENCES AND BEST PRACTICES

A unique and interactive event exclusively for EMEA Customers of Oracle Cloud Infrastructure (OCI) to share the details of their success, illustrate new and planned ideas as well as inspire innovative applications and powerful use-cases. 

  • Customers explaining their use of and plans for OCI
  • Interactive Q&A for each session
  • Fireside chat / Panel session to discuss customer cases

READ MORE

 

What’s new @ Oracle Cloud – This month’s dedicated product updates

In this weeks session, find out whats the latest updates on Oracle Cloud. We try to pick some of the lesser advertised functions and features you might not have heard about. We also let the technical architects and presenters add new changes that they have identified during the month. We cover approximately 5-6 new topics each month. This is always a popular event.

READ MORE

 

Location matters: The new Map Region Type in APEX 21.1 by Carsten Czarski

This presentation introduces the new Map Region Type, which was introduced the latest APEX release 21.1. Attendees will learn, how to easily visualize location data from a SQL query or a REST Data Source on a map – all declarative, without manual coding and without external Plug-Ins.

The session will also cover how to integrate a Map region with other APEX region types like Charts, Reports or Faceted Search. Tips and tricks about visualizing larger amounts of data and how to leverage Oracle Spatial functionality will wrap the session.

READ MORE

 

How to cheat for extreme Database Performance

– Learn some simple techniques to optimize the performance of your Oracle, RAC, and Exadata databases.
– Learn how you can lower latency and reduce your DB IO.
– Learn how these techniques can work on bare metal, VMs, and Kubernetes.
– Warning, SQL explain plans and indexes may be involved.

Speaker BIO: Douglas Hood
Consulting Member of Technical Staff, Oracle

READ MORE

 

   JULY 01

 

Oracle Cloud Infrastructure Advanced Workshop 200
Oracle Cloud Infrastructure (OCI) is an IaaS that delivers on-premises, high-performance computing power to run cloud native and enterprise company’s IT workloads. OCI provides real-time elasticity for enterprise applications by combining Oracle’s autonomous services, integrated security, and serverless compute. Available for public cloud.
In this workshop, you will have chance to dive deep in Oracle Cloud Infrastructure technologies, explore details of core infrastructure connections, and understand HA and DR solutions, create skills for database capacity planning and migrations.
Duration: 2 Days
Audience:
  • Architect, Cloud Architect, Presales, Solution Engineers, Developer, System Integrator
Oracle Products:
  • Oracle IaaS, Oracle PaaS

READ MORE

 

DOAG DEV TALK ZUM THEMA “PL/SQL VS. JAVASCRIPT”

NEU: “DOAG Dev Talk”-Reihe – Thema: PL/SQL vs. JavaScript

Referenten: Kai Donato & Moritz Klein

Moderation: Niels de Bruijn, Leiter der Dev-Community

Einen Link zur Anmeldung stellen wir zeitnah zur Verfügung!

READ MORE

Weekly Events #15

 

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

 

JUNE 21

 

ODTUG Kscope21 Virtual Event

The ODTUG Kscope21 Virtual Event is the premier Oracle developer conference, attracting Oracle experts from all over the world. With cutting-edge technical sessions and opportunities to connect to the global ODTUG community, this event is perfect for Oracle developers who want to boost their skills at any stage of their career.

The ODTUG Kscope21 Virtual Event features presentations across a variety of technical content topics, including Oracle Database, Oracle Application Express, Oracle EPM-Hyperion, and Oracle Analytics, just to name a few.

READ MORE

 

   JUNE 22

 

Oracle Integration Partner Bootcamp India

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

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

READ MORE

 

Oracle PartnerCast: Oracle Cloud Infrastructure Console – From idea to live environment in less than a minute

Work is not a place; the Cloud is where you work. Oracle Cloud Infrastructure (OCI) is revamping its console experience with a series of new improvements.

JOIN US AND LEARN HOW TO:

  • Keep improving your developers’ productivity
  • Access your business insights and optimize your cloud usage
  • Empower non-technical stakeholders to get the information they need

READ MORE

 

Getting Started with Oracle Cloud

In this live demo, we will get you started on your journey with OCI.
We will show the scalability and flexibility of Oracle Cloud Services, how to access & navigate the console, find the many benefits of the large suite of services and the best way to deploy them.

READ MORE

 

 

   JUNE 23
SAVE THE DATE: BERLINER EXPERTENSEMINAR MIT RANDOLF EBERLE-GEIST

Um große Datenmengen so schnell wie möglich zu verarbeiten und die Fähigkeiten moderner Hardware entsprechend einzusetzen bietet Oracle als Teil der Enterprise Edition das “Parallel Execution” Feature an. Allerdings, wie bei den meisten Features gibt es keinen einfachen “go_faster = true”-Schalter, und “Parallel Execution” ist hier keine Ausnahme. Es gibt viele Fälle, in denen ein einfaches Hinzufügen von Parallelverarbeitung nicht die erwartete Verringerung der Laufzeit ergibt. Es ist daher wichtig zu verstehen, wie Oracle “Parallel Execution” funktioniert, was seine Bestandteile sind, welche Diagnosemöglichkeiten für eine systematische Performance Analyse geboten werden und wie entsprechende Maßnahmen basierend auf einer solchen Analyse aussehen können.

Sie sind generell interessiert, das Oracle Parallel Execution Feature für SQL einzusetzen und möchten deshalb mehr davon verstehen? Oder Sie verwenden es bereits regelmäßig, zum Beispiel im Data Warehouse Umfeld, oder im Rahmen von Batch-Prozessen?

READ MORE

 

 

Oracle Converged DB from REST to Relational

In this weeks session, find out How an Oracle DB supports Machine Learning, Blockchain, Graph, Spatial, JSON, REST among others. There will be a live demo showing examples of the above.

READ MORE

 

 

Webinar – Realising the benefits of Scottish Government’s Investment in Oracle Cloud

Organisations worldwide are adopting Oracle Cloud Infrastructure (OCI) as part of their cloud strategy, including UK Cabinet Office (Government Shared Services) and University of Oxford. OCI is the world’s only Gen2 hyperscale cloud platform. It is enabling organisations to reduce IT costs, improve security and deliver greater flexibility, as well as allowing employees to innovate more effectively across large parts of the UK public sector.

READ MORE

 

EMERGING LEADERS: ORACLE CERTIFICATIONS PANEL DISCUSSION

As a young/new professional in the technology field, it can be challenging to determine which Oracle certifications will provide the best training to excel in your career. Julio Lois and Amod Joshi will share their own experiences with Oracle Certifications, Oracle Learning Explorer, and the Learning Paths offered for Oracle Cloud Applications. This session will include suggestions for where to get started in your education, training opportunities, and an overview of the certification process. They will also discuss ways to access free support and real-world application for your knowledge.

READ MORE

 

Deploy Oracle Databases Anywhere, Manage from Everywhere

In this session, learn about the new capabilities in the just-released Oracle Enterprise Manager 13c Release 5 that allows Oracle Databases to be deployed in the cloud or on-premises and stop worrying about the operational risks and management of these databases.

This session covers the exciting features of Oracle Enterprise Manager 13c Release 5 in the following key areas:

– Hybrid Cloud Management: Fleet monitoring, management and data movement across the entire IT estate – on-premises and in the cloud including Exadata Cloud@Customer, Exadata Cloud Service, Oracle Dedicated Region Cloud@Customer, Autonomous Database, and Oracle Databases deployed elsewhere
– Ops Automation: Enhanced automation and modernization with smart performance analytics, dynamic run books, database provisioning, patching, security, and compliance
– Extensibility: Open standards-based extensions for interoperability with 3rd party ecosystems with REST APIs, custom dashboards, and mobile app

READ MORE

 

   JUNE 24

 

Oracle Cloud Infrastructure in Pocket

OCI IN POCKET – UM MUNDO DE TECNOLOGIA EM APENAS 30 MINUTOS

OCI in Pocket traz toda quinta-feira um assunto relevante e atual sobre tecnologia em nuvem, de forma prática e direta!Acompanhe os eventos do mês de Junho de 2021.

READ MORE

 

Oracle PartnerCast: Demo Services Office Hours for Partners – June 2021

Join this online webinar to learn about Oracle Demo Services and understand what new features and Data are coming with the latest Demo Platform release for Fusion Applications 21B D02 and EPM latest release.

READ MORE

 

Is your business PoPIA Ready?

Compliance with #POPIA will be mandatory for all sectors in South Africa from 1 July 2021. As this date is fast approaching be sure to check if your business is ready to comply with the requirements. When you’re prepared, data regulation doesn’t mean disruption…

MODERNISE YOUR DATA SECURITY, STAY COMPLIANT AND GET AHEAD OF POPIA REQUIREMENTS.

IS YOUR BUSINESS POPIA READY?

READ MORE

 

6. Oracle DBA Stammtisch

Liebe Oracle DBAs,

für den 6.Oracle DBA Stammtisch habe ich wie gewünscht das Thema Datenbank Cloud Services vorbereitet. Immer mehr Unternehmen überlegen, die ersten Datenbanken und Anwendungen sicher in die Cloud zu verlegen. Damit wollen Sie Datenbanken flexibler für die Entwicklung von bestehenden und neuen Anwendungen betreiben. Die entwickelten Anwendungen sollen dann nach Bedarf ausgerollt, betrieben und skaliert werden. Und all dies unter der Prämisse – „Pay as you go“ – also verbrauchsbasierte Abrechnung der Nutzung.
Wie geht das, was ist zur Vorbereitung notwendig, was gilt es bei der Durchführung zu beachten? Ingrid Niedermayer, verantwortlich für Applikations- und Datenbankbetrieb in der Agrarmarkt Austria, wird über die Erfahrungen der AMA mit Oracle Cloud Services im Bereich der Anwendungsentwicklung berichten.

READ MORE

 

   JUNE 25

 

Database Auditing: Best Practices for improving performance and security

Oracle Database provides the industry’s most comprehensive and flexible auditing capability. Effective audit policies let you monitor database activity with a negligible performance impact. In this session, you’ll learn how to create audit policies that are selective and targeted to your needs, avoiding the common pitfall of collecting unnecessary audit information that, in turn, impacts database performance, increases storage costs, and may make it more difficult to spot malicious activity. Angeline Dhanarani, Principal Product Manager for Database Auditing, will share key tips to capture relevant audit events, reduce false positives, and support quick and reliable threat detection – all without compromising database performance!

READ MORE

 

OATUG TECH SIG TALK – TIME TO UPGRADE: TAKING YOUR EBS DATABASE TO 19C

Oracle Database 19c was certified for the E-Business Suite in late summer 2019. This means that companies have until the end of 2020 to complete their upgrade to 19c in order to avoid paying extended support fees. This presentation will review the process of upgrading from 12.1.0.2 to 19c in an E-Business Suite 12.2 environment. It will discuss the architectural changes done as part of the database upgrade including moving from a CDB with a single PDB.

READ MORE

 

Creating a Read-Only Account on Database with VPD or Label Security

Hi all,

This is an interesting case, specific to be understood by easy to be resolved.

The whole story started when a client asked for a Read-Only account (let’s call it RO_USER) with access to objects under another schema (let’s call it SCHEMA_OWNER). Easy going, right?

  • Create user
  • Grant select on SCHEMA_OWNER tables
  • Possibly grant execute on SCHEMA_OWNER procedures/packages/functions
  • Possibly private synonyms on RO_USER for SCHEMA_OWNER objects

However, when connecting with RO_USER and executing a query on a table, that’s what happened:

select count(*) from SCHEMA_OWNER.TABLE_EXAMPLE;

COUNT(*)
----------
0

When connecting with SCHEMA_OWNER and executing the same query:

select count(*) from SCHEMA_OWNER.TABLE_EXAMPLE;

COUNT(*)
----------
9255013

Hm, in general, the known limitations for this approach are:

  • Private database links: In case this is the issue, the only alternative is using Proxy Connection. Trying this:
SQL> alter user SCHEMA_OWNER grant connect through RO_USER;

User altered.

SQL> conn RO_USER[SCHEMA_OWNER]/***********
Connected.
SQL> select count(*) from SCHEMA_OWNER.TABLE_EXAMPLE;

  COUNT(*)
----------
   9255013

WORKING!

However, when checking for the scenario, noticed this is a real table, not a synonym or view using a private database link. Why is that?

Also, this alternative creates some problems, as the RO user would now have access to DML on SCHEMA_OWNER tables, not Read-Only access anymore.

Well, the other option:

  • VPD or Label Security: Limit access to data depending on the current schema. That’s a match:
SQL> select object_owner,object_name,policy_name,function, PACKAGE from dba_policies where object_name='TABLE_EXAMPLE';

OBJECT_OWNER	     OBJECT_NAME		    POLICY_NAME 		   FUNCTION	         PACKAGE
-------------------- ------------------------------ ------------------------------ --------------------- ---------
SCHEMA_OWNER	     TABLE_EXAMPLE		     POLICY_EXAMPLE	           FCN_TABLE_EXAMPLE	 PKG_EXAMPLE

OK!

So what to do?

Here is the trick: https://docs.oracle.com/cd/B19306_01/network.102/b14266/apdvpoli.htm#i1006985

Using EXEMPT ACCESS POLICY. As per Oracle Document “[…] database users granted the EXEMPT ACCESS POLICY privilege, either directly or through a database role, are exempt from VPD enforcements.”

This is also valid for Datapump and Legacy Export as per MOS When Is Privilege “Exempt Access Policy” Needed For Export? (Doc ID 2339517.1).

Let’s check for it:

SQL> GRANT EXEMPT ACCESS POLICY TO RO_USER;
Grant succeeded.

SQL> select count(*) from SCHEMA_OWNER.TABLE_EXAMPLE;
COUNT(*)
----------
 9255015

And what about Label Security?

That was not my case, as you could see, but as per the same Oracle Document: ” They are also exempt from some Oracle Label Security policy enforcement controls, such as READ_CONTROL and CHECK_CONTROL, regardless of the export mode, application, or utility used to access the database or update its data.”

I hope it helps you!

Weekly Events #14

 

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

 

JUNE 14

 

SAVE THE DATE: BERLINER EXPERTENSEMINAR MIT JÜRGEN SIEBEN

Die Schulung erläutert, wie in APEX schnell und komfortabel entwickelt werden kann, ohne die Anforderungen an eine saubere Anwendungsstruktur zu verletzen.

Eigentlich weiß es jeder: Software wird in Modulen entwickelt, die eine Schnittstelle und eine Implementierung haben und aufeinander aufbauen. Oracle empfiehlt dies, Technical Papers wie zu SmartDB oder PinkDB schlagen entsprechende Lösungen vor. Dennoch sind die meisten APEX-Anwendungen weit von einer sauberen Struktur und der damit verbundenen Erweiterungsfähigkeit und Wartbarkeit entfernt. Warum?

READ MORE

 

Oracle Communications Session Border Controller Basic Boot Camp

The goal of this implementation boot camp is to educate and make Oracle Partners aware of Oracle Communications Session Border Controller basic installation and configuration concepts. After taking this course, Oracle Partners should be enabled to bid for SBC projects with a degree of confidence as far as the installation and configuration is concerned.

READ MORE

 

   JUNE 15

 

Oracle Workload Cloud-Strategy Innovation: A Customer Perspective

On Tuesday, June 15th, 2021 at 10am ET / 3pm BST, join our live customer roundtable and learn directly from leading companies about their prevailing challenges and positive experiences of migrating Oracle workloads to the ​public cloud.

Data Intensity owns a proprietary methodology for safely and effectively migrating Oracle workloads into the cloud. Safe-Switch was developed in conjunction with vendor-specific cloud-migration frameworks and a laser-sharp focus on determining the right licencing, cloud, and services to lower Oracle Total Cost of Ownership (TCO).

READ MORE

 

CHOOSING THE RIGHT CLOUD PLATFORM FOR THE NEXT STAGE ON YOUR ORACLE WORKLOAD JOURNEY

How can you reduce uncertainty when planning Oracle workload migrations to the cloud? Join our live customer roundtable and learn directly from leading companies about their challenges and experiences when migrating Oracle workloads to the cloud.

READ MORE

 

   JUNE 16
UKOUG Applications Summit

This summer we will be bringing a dedicated event for the Oracle Applications communities.

We are currently looking for volunteers to help shape this event.

READ MORE

 

Oracle Cloud Infrastructure 2 Day Deep Dive

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.

Following the delivery of the technical sessions, we will offer all attendees the opportunity to take the Oracle Cloud Infrastructure Architect Associate exam (1Z0-932) and earn your OCI Associate Certification.

READ MORE

 

Oracle Hands on Lab: E-Business Suite to OCI
JOIN OUR VIRTUAL HANDS ON LAB TO TRY ORACLE E-BUSINESS SUITE FOR YOURSELF.

Oracle cloud engineers will demonstrate E-Business Suite Cloud Manager graphical user interface to provision and clone environments on Oracle Cloud Infrastructure (OCI).You will learn how easily you can:

  • Setup EBS Cloud Manager on Oracle Cloud
  • Spin up an instance of EBS using one-click provisioning
  • Clone EBS using EBS Cloud Manager

READ MORE

 

How to secure your workloads in the Cloud using Oracle IDCS

In this weeks session, find out How to secure your workloads in the Cloud using Oracle Identity Cloud Service. We will show how easy it is for your users to access, develop and deploy their applications.

READ MORE

 

Query Rewrite: The Supreme League of Materialized Views

Materialized Views are very useful to increase the performance of frequently executed queries. In many database applications, Materialized Views are accessed directly using SQL. However, the use of Query Rewrite is much more elegant and flexible: The optimizer decides independently whether a suitable Materialized View can be used to accelerate the query. The goal is to be able to improve the performance of different queries with the smallest possible number of Materialized Views. Query Rewrite offers excellent possibilities for this.

READ MORE

 

   JUNE 17

 

 

Oracle PartnerCast: Oracle Compute – Fast, flexible, and affordable compute capabilities

Oracle has made significant, recent advances in delivering fast, flexible, and affordable compute capabilities that support any workload. This session will introduce a range of new compute shapes built to deliver exceptional price performance as well new compute features and services that provide flexibility to match resources to workload needs while helping optimize for lower, more predictable compute cost

READ MORE

 

Oracle Machine Learning with the Autonomous Database Hands-On Lab
If you have access to Oracle Database, then you probably already have access to Oracle Machine Learning (OML). In this hands-on workshop based on Autonomous Database, you will learn how to use OML to build a machine learning model and integrate it into an APEX application.

 

HIDDEN LIMITATIONS OF ORACLE SMART VIEW AND HOW TO OVERCOME THEM

Oracle Smart View is a popular choice for Oracle ERP Cloud users because it provides a more flexible environment for ad hoc analysis. Unfortunately, Smart View is not purpose-built for finance, so its drill-down capabilities, formatting options, and the ability to combine multiple charts of accounts into a single workbook are all limited. Which means, extracting near-real time financial data and analyzing them are not possible.

READ MORE

 

DOAG DEV TALK ZUM THEMA “JAVASCRIPT IN APEX?”

JavaScript in APEX?

Referenten: Kai Donato & Carolin Hagemann

Moderation: Niels de Bruijn, Leiter der Dev-Community

Einen Link zur Anmeldung stellen wir zeitnah zur Verfügung!

READ MORE

 

Summer Campus Open Day – Conoce el Data Analytics Summer Campus de datahack

Te vas a perder el 𝐎𝐩𝐞𝐧 𝐃𝐚𝐲 de nuestro 𝑫𝒂𝒕𝒂 𝑨𝒏𝒂𝒍𝒚𝒕𝒊𝒄𝒔 𝑺𝒖𝒎𝒎𝒆𝒓 𝑪𝒂𝒎𝒑𝒖𝒔? Es de asistencia gratuita y nos acompañarán:

– Lourdes Hernández, CEO de datahack.
– Ángel Niño, Concejal en Madrid del Área de Innovación y Emprendimiento.
– Marcelo Molina, Director de Big Data & Analytics en datahack.

READ MORE

 

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

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

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

   JUNE 18

 

 

Enterprise Application Migration to Oracle Cloud

Give your IT department the performance, price, and security advantages it needs to confidently support your organization’s goals. Experience performance that exceeds most on-premises computing environments when you move your applications and workloads to Oracle Cloud Infrastructure.

The migration of enterprise and mission critical applications to the Cloud represents a huge opportunity for companies, allowing the renewal of technologies and solving security and integration issues . Seizing this opportunity is also a challenge, as it is often necessary to review the architecture of the applications in order to adapt it to the technologies available in the Cloud.

READ MORE

 

Diagnosing Oracle RAC Performance Issues using AWR reports

This session will focus on using AWR reports to tune OLTP and DSS workloads running on Oracle Real Application Clusters (RAC) both on generic systems and Exadata. This includes hints and tips to focus on relevant sections of the AWR report to quickly understand the root cause of the problem. Further, we will review AWR reports of some interesting real-world performance issues reported by customers and the diagnostics involved in resolving them

Speaker BIO: Anil Nair
Sr Principal Product Manager (RAC), Oracle USA

READ MORE

 

   JUNE 19

 

 

Azure Weekend 2021 – 2a edição: online e totalmente gratuito!

Gostaria de conhecer mais sobre o Azure e os diversos serviços oferecidos pela plataforma de cloud computing da Microsoft? Não deixe então de acompanhar a segunda edição do Azure Weekend em 2021, um EVENTO ONLINE e GRATUITO do canal Coding Night e das comunidades .NET SP e Azure Talks!

READ MORE

The cluster upgrade state is [ROLLING PATCH] with correct Patch Level in all nodes

Hi all,
When performing a spot health check in a client environment, got this:

[oracle@dbserver1 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [12.1.0.2.0]
[oracle@dbserver1 ~]$ crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [26717470].

By checking over the applied patched on the 3 nodes, it’s matching:

+ASM1@dbserver1 > kfod op=patches
List of Patches
===============
20243804
20415006
20594149
20788771
20950328
21125181
21359749
21436941
21527488
21694919
21949015
22806133
23144544
24007012
24340679
24732088
24846605
25397136
25869760
26392164
26392192
26609798
26717470

+ASM2@dbserver2 > kfod op=patches
List of Patches
===============
20243804
20415006
20594149
20788771
20950328
21125181
21359749
21436941
21527488
21694919
21949015
22806133
23144544
24007012
24340679
24732088
24846605
25397136
25869760
26392164
26392192
26609798
26717470

+ASM3@dbserver3 > kfod op=patches
List of Patches
===============
20243804
20415006
20594149
20788771
20950328
21125181
21359749
21436941
21527488
21694919
21949015
22806133
23144544
24007012
24340679
24732088
24846605
25397136
25869760
26392164
26392192
26609798
26717470

So, it’s most likely some patch completed wrongly. Here is the quick fix:

$GI_HOME/bin/clscfg -patch
$GI_HOME/bin/crsctl stop rollingpatch

Once done, issue fixed!
I hope it helps!

Weekly Events #13

 

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

 

JUNE 07

 

TDWC21 – A Maior Conferência Online de Transformação Digital do Mundo!

Para construir o futuro não basta a adaptação. Você precisa subverter padrões e entender a nova visão do mundo.

Aprenda a colocar a transformação digital em prática em uma das experiências mais disputadas de 2021. O novo mundo é híbrido!

A pandemia desafiou as premissas da sociedade. Agora, os seres humanos querem voltar à socialização. A tecnologia nos ensinou que os encontros podem ser físicos e digitais. Não é mais preciso fazer uma escolha.

Na TDWC, você vai ver na prática a revolução das relações humanas através da tecnologia.

Seja bem-vindo à transformação digital!

READ MORE

 

 

   JUNE 08

 

 

Oracle RDBMS x NoSQL: 101 for DBAs

A partir da perspectica de um DBA: Quais as vantagens do NoSQL em comparação com os bancos de dados clássicos? E como integrar estruturas de dados tradicionais com as novas flexívies estruturas NoSQL?

READ MORE

Getting Started with Oracle Cloud

In this live demo, we will get you started on your journey with OCI.

We will show the scalability and flexibility of Oracle Cloud Services, how to access & navigate the console, find the many benefits of the large suite of services and the best way to deploy them.
Finally, we will also demonstrate how to add users and give them specific roles through policies, how to monitor usage and how to work with My Oracle Support.

READ MORE

 

Cloud Applications My Services Webinar

We invite you to attend a LIVE webinar to get started with your Oracle Cloud Applications. This is a perfect start to your Cloud journey where you will learn about:-

  • Overview of the New Admin console
  • Get started with your services
  • Know your dashboards
  • Understand various Self Service options

Invitation to this Webinar is through Registration only, click on Register Today button to confirm your Registration and receive Webinar joining details.

READ MORE

 

High Performance Computing Solutions on Oracle Cloud Infrastructure for the Oil & Gas Industry

The majority of high performance computing systems still run on-premises in customer managed data centers with high capital costs. Cloud-based options have historically been limited, as early cloud-based HPC services relied on extremely expensive flash memory and heavy cache architectures that supported narrow use cases.

By contrast, Oracle Cloud now delivers a commercially viable, cost-effective HPC platform that can be used across industries, enterprises, and governments. The platform delivers performance levels that rival on-premises solutions – but with cloud economics, on-demand availability, and scale that can support jobs running tens of thousands of cores simultaneously.

READ MORE

 

TDC CONNECTIONS BUILDING SOFTWARE IN THE CONNECTED WORLD

TDC is the most important event of IT professionals in Latin America. Over the past 12 yeras we connected communities, meetups, specialists and lots of content on a single plataform of open inovattion. Come with us and sign up!

READ MORE

 

Securing your mission critical systems running Oracle from cyber attacks by Trichy Premkumar

Until recently, organizations have focused on trying to prevent cyberattacks, which come primarily from hacking and malware. However, the likelihood that all malware will be discovered before harm is done is slim, particularly for slow-moving and sophisticated attacks. This difficulty of detecting malware early gives hackers time to orchestrate attacks ranging from extortion to outright destruction of mission-critical systems. Such cyberattacks can cripple an organization, leading to revenue loss, negative publicity, and lasting customer distrust. In this session we will review how Oracle data protection can be simplified, secured and enhanced to include comprehensive cyber recovery protection.

READ MORE

 

 

   JUNE 09

 

 

UKOUG Applications Summit

This summer we will be bringing a dedicated event for the Oracle Applications communities.

We are currently looking for volunteers to help shape this event. Submit your interest here.

READ MORE

 

Oracle Autonomous Database Cloud Service

Computer Gross e Oracle sono lieti di invitarvi a un esclusivo workshop su Autonomous Database Cloud Service, incentrato su come utilizzare l’innovativo tipo di database e la parte di data integration, insieme ad una panoramica introduttiva sui componenti infrastrutturali (OCI).

READ MORE

 

Leveraging free available content and templates using Oracle APEX

In this weeks session, find out how we can help you to deliver high quality, end user friendly, secure applications using free content and templates available in APEX.APEX is an easy to learn, low code alternative to answer all your needs.

READ MORE

 

   JUNE 10

 

 

Oracle PartnerCast: Modern OPN Office Hours

Join our team of subject matter experts for highly informative discussions and live Q & A about the Modern Oracle PartnerNetwork program. Don’t miss this opportunity to ask any questions you may have about Modern OPN.

READ MORE

 

Oracle Integration Update Webcast

WEBINAR

Participants will be provided with an update on the latest innovations on Oracle Integration released in May 2021. Our Oracle Integration Product Manager Team will give attendees exclusive access to our new features, product roadmaps, discuss upcoming innovations and provide guideline to help you adopt these quickly within your organization to drive business benefits.Prebuilt integration flows
Oracle jump-starts your ERP, HCM, and CX connectivity with embedded best-practice integrations, machine-learning recommendations, recipes, and business accelerators.Preintegrated with applications
Oracle Integration offers the world’s only Oracle application adapters built by Oracle app development experts. With our extensive library of best-in-class, third-party adapters, your apps are ready to get connected.

READ MORE

 

The journey of Stolt Nielsen: from HFM to Oracle Cloud EPM

Stolt Nielsen is the world’s largest operator of sophisticated chemical tankers, providing safe, high quality transportation services for bulk-liquid chemicals, edible oils, acids and clean petroleum products based in the Netherlands and Norway. Stolt Nielsen keeps it’s business near water, but they moved their Finance in the Clouds with a complete Finance Transformation in the Cloud.Join us and listen to Michel Bresser, Senior Global Business Process and Applications Leader, at Stolt Nielsen. Stolt Nielsen went from their beloved HFM to Oracle Cloud EPM.

READ MORE

 

The CityShark Project – How drones and Oracle Cloud aid cleaning up the oceans

How do we utilize tech for the environment and create a more sustainable future? The rapid development of environmental issues (climate change, air and water pollution etc.) create the need for innovative ideas that can match the gravity and fluidity of these problems. This webinar is dedicated to uncovering the motivations and technology behind the project codenamed CityShark by the Danish Ministry of Climate, Energy, and Utilities that enlists sailing and aerial drones to help identify and clean up liquid and solid waste from the Port of Aarhus.

Join this webinar and hear Martin Skjold Grøntved, Special Consultant at the “Danish Agency for Data Supply and Efficiency (SDFE) – Office for Data and Green Transition Technologies” present this exciting project in a live interview with Ingrid Mjøen, Country Manager at Oracle Danmark.

READ MORE

 

Oracle CS ConnectX : Tools Overview

You are invited for an exclusive Oracle CS ConnectX Tools Overview webinar. Success Hub has an excellent selection of cloud product related documents and articles that you can easily search through in our Knowledge-Base. Also enable yourself and leverage the best of MOS.
Join us in the Online Masterclass to start successful planning of your Cloud journey with Oracle Cloud Applications.

READ MORE

 

Oracle Analytics Virtual Workshop

JOIN OUR VIRTUAL WORKSHOP TO TRY ORACLE ANALYTICS CLOUD FOR YOURSELF

Experience how Oracle Analytics Cloud, is the fastest way to uncover meaningful insights in your data.Register now to join Oracle for our next virtual workshop event.

  • Instructor led labs on Oracle Analytics
  • Self-guided labs so you can try it out for yourself
  • Q&A with Oracle product experts

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.apex

Junte-se aos desenvolvedores da comunidade e gerentes de produto da APEX para obter o máximo desta ferramenta incrível!

READ MORE

 

 

   JUNE 11

 

 

DOAG Database Online Event: Compare Server Performance

Compare server performance: Compare the performance of servers with Oracle databases

Speaker: Marc Wagner, dbi services

READ MORE

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!