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!

Weekly Events #12

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

 

JUNE 01

 

Berliner Expertenseminar: Postgres Backup & Recovery, Migration und Replikation

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

Tag 1.

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

Tag 2:

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

READ MORE

 

Workshop Gratuito – SP: Cloud Solutions com Microsoft Azure

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

READ MORE

 

Microsserviços no Azure

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

READ MORE

 

   JUNE 02

 

APEX World 2021

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

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

READ MORE

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

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

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

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

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

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

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

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

How to resolve it?

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

This resolved my case, fixing the views.

BE CAREFUL:

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

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

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

I hope it helps!

Weekly Events #11

 

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

 

MAY 24

 

Emerging Women in Tech Panel Discussion

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

READ MORE

 

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

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

Session Abstract: In this session, you will learn.

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

READ MORE

 

   MAY 25

 

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

READ MORE

 

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

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

READ MORE

 

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

De sessie bestaat uit twee delen:

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

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

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

READ MORE

   MAY 26

 

Smart Scan: Live and Uncensored!

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

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

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

READ MORE

 

CAREER CHANGES: TAKING THE LEAP

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

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

READ MORE

 

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

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

Session Abstract: In this session, you will learn.

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

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

READ MORE

 

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

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

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

Palestrante: Bruno Brito (Microsoft MVP)

READ MORE

 

   MAY 27

 

 

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

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

READ MORE

 

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

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

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

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

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

READ MORE

 

Meetup: Ervaringen met het beheer van ODA-systemen

Meetup: Ervaringen met het beheer van ODA-systemen

Sprekers: Ian Hoogeboom en Marc Kelle van Transfer Solutions.

Aanvang: 15.00 uur.

Meer informatie volgt binnenkort.

READ MORE

 

   MAY 28

 

 

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

READ MORE

 

Cloud Native Java by Josh Long

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

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

READ MORE

 

Fireside Chat with Security Gurus

Session Title: Fireside Chat with Security Gurus

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

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

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

READ MORE

 

   MAY 29

 

 

Becas internacionales 📢 Big Data Certified Associate

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

READ MORE

Automating APEX Applications Backup

Hi all,

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

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

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

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

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

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

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

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

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

Plan B) Take separate Backups for each Application or Workspace

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

1. Exporting by ApplicationID:

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

2. Exporting by WorkspaceID:

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

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

select wwv_flow_api.get_security_group_id from dual;

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

I hope it helps!

Additional notes:

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

Additional Reference:

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

Weekly Events #10

 

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

 

MAY 17

 

DOAG 2021 DATENBANK ONLINE

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

READ MORE

 

   MAY 18

 

2021 PeopleSoft Oracle Northwest Summit Day1

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

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

READ MORE

   MAY 19

 

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

READ MORE

 

RMOUG May Annual Membership Meeting and Workshop

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

READ MORE

 

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

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

READ MORE

 

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

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

READ MORE

 

Gerando código com C# Source Generators

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

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

READ MORE

 

   MAY 20

 

 

MOTU: Planejamento de Recursos com OptaPlanner

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

READ MORE

 

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

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

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

READ MORE

 

   MAY 21

 

 

OATUG TECH SIG TALK – CLONING PANEL

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

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

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

READ MORE

Weekly Events #9

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

 

MAY 09

 

Before Disaster Strikes Architect Seminar Series

ACHIEVING RESILIENCY IN YOUR BUSINESS CONTINUITY STRATEGY.

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

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

READ MORE

 

   MAY 11

 

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

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

READ MORE

 

Meetup: Ervaringen met Oracle Database Migraties naar de cloud

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

Presentatie door team van The DOC.

READ MORE

ODTUG EPM Webinar Configuring Oracle Projects

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

READ MORE

 

Data Management Strategy Evolution

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

READ MORE

 

Oracle MySQL Database Service Hands-on Workshop

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

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

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

READ MORE

 

RoOUG TechSession #45

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

READ MORE

 

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

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

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

READ MORE

   MAY 12

 

AWS Summit Online – Américas

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

READ MORE

 

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

READ MORE

 

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

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

READ MORE

 

E-BUSINESS SUITE UPGRADE PANEL

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

READ MORE

   MAY 13

 

 

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

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

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

READ MORE

 

MOTU Deep Dive: Arquitetura de frameworks Java

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

READ MORE

 

MOTU Deep Dive: JNoSQL

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

READ MORE

 

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

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

READ MORE

 

APEX Em Português

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

READ MORE

 

   MAY 14

 

 

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

Speaker: Nabil Rütten, ORDIX AG

READ MORE

Moving APEX Applications Repository

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

We’ll use the APEXExport for this end.

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

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

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

To Export:

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

2. Run the APEXExport twice as follows:

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

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

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

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

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

To Import:

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

@<script_generated>.sql

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

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

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

I hope it helps!

Weekly Events #8

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

 

MAY 02

 

Before Disaster Strikes Architect Seminar Series

ACHIEVING RESILIENCY IN YOUR BUSINESS CONTINUITY STRATEGY.

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

READ MORE

 

   MAY 04

 

APEX CONNECT 2021 [ONLINE]

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

READ MORE

 

Oracle Communications SD-WAN Boot Camp

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

READ MORE

Developer Live! App Dev with Oracle Database

BUILD APPLICATIONS WITH ORACLE DATABASE NOW.

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

READ MORE

 

Criando sua Infraestrutura no Azure com Código

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

Palestrante: Juliano Custódio (Microsoft MVP)

READ MORE

   MAY 05

 

UKOUG – License Management Event

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

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

READ MORE

 

Evento RSJUG Maio

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

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

READ MORE

 

   MAY 08

 

 

Bootcamp – Machine Learning: Funcionamiento y Aplicabilidad

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

READ MORE