Exadata DNS Change – Pitfalls to be avoided

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

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

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

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

Here is a summary of the steps.

Infiniband switches

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

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

 

Database nodes

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

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

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


Cell nodes – Here things start to get interesting

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

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

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

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

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


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

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

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

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

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

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

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

 

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

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

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

# Restart cellwall service
service cellwall restart
service cellwall status

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

 

I hope it helps!

Elisson Almeida

Weekly Events #3

 

MARCH 29

 

HOW TO SETUP, TRANSACT AND USE OUTSIDE PROCESSING

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

READ MORE

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

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

READ MORE

 

   MARCH 30

 

 

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

Introducing INSYNC 21​

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

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

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

READ MORE

 

Cloud Native Computing Linz Meetup

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

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

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

READ MORE

 

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

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

READ MORE

Opatchauto Failing on “CheckActiveFilesAndExecutables” during Prerequisite Check

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

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

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

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

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

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


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


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


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


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


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


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


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


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

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

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

After fixing the cause of failure Run opatchauto resume

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

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

opatchauto failed with error code 42

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

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


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


Following active executables are not used by opatch process :


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

This is an interesting situation.

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

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

So, no matches at all.

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

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

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

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

Check the output:

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

And now resuming the Opatchauto:

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

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

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


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

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


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


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


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

OPatchAuto successful.

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

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

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

==Following patches were SKIPPED:

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

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

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


==Following patches were SUCCESSFULLY applied:

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

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


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

==Following patches were SUCCESSFULLY applied:

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

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

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

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

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

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

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

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

I hope it helps you as well!

Weekly Events #2

 

MARCH 23

 

Oracle Developer Live – Java Innovations

ADVANCE YOUR APPLICATION INNOVATION WITH ORACLE’S JAVA TECHNOLOGIES

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

READ MORE

Modern Data Platform: Next Generation Data Management

SIMPLIFY, SECURE AND MODERNISE YOUR DATA PLATFORM.

NEXT GENERATION DATA MANAGEMENT.

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

READ MORE

   MARCH 24

 

 

New Integration Tools for Oracle Modern Data Warehousing

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

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

READ MORE

 

MySQL Webinar – Query Acceleration for MySQL

400X QUERY ACCELERATION FOR MYSQL WITH HEATWAVE.

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

READ MORE

 

Workshop: Cassandra Data Modeling Methodology, with samples!

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

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

 

READ MORE

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

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

READ MORE

 

   MARCH 25

 

 

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

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

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

READ MORE

 

Oracle/IDC France Webinar

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

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

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

READ MORE

 

Primeiros passos na Oracle Cloud Infrastructure

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

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

READ MORE

 

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

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

READ MORE

 

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

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

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

READ MORE

 

   MARCH 26

 

Authentication options for the Oracle Database

Authentication options for the Oracle Database

Session Abstract: Oracle Database accepts several different authentication methods – each with its own advantages and disadvantages. Join us to review database authentication, appropriate use cases, and how you can use authentication methods to reduce risk and improve security

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

READ MORE

5 Best Practices for Setting Dispatchers for Shared Connections

Hi all,

Here are 5 Best Practices / Tips for when setting dispatches with Shared Connections:

1. Set local_listener on both instances on the database

alter system set LOCAL_LISTENER=”(address=(protocol=tcp)(port=1521)(host=yourhost))” scope=both sid=’instance_name’;
Ref: Shared Server: Dispatchers Are Not Registered With Listener (Doc ID 465881.1)

2. Dispatchers parameter should be set to utilize the VIP name of the host

alter system set dispatchers='(address=(protocol=tcp)(host=node1-vip))(dispatchers=2)’ scope=both sid=’instance_name’;
Ref: How To Configure Shared Server Dispatchers For RAC Environment (Doc ID 578524.1)

3. Dispatchers count should be set appropriately considering the number of sessions expected to connect to the database

A general rule of thumb is that 1 dispatcher can handle 50 shared server connections with minimal performance impact.
Ref: Shared Server Only: TNS-12518, TNS-12564 and TNS-12602 Errors at Connect Time (Doc ID 1539104.1)

4. Arguments can be used with the dispatchers parameter for closer control of how the shared server sessions are used

SESSIONS – Determines the max sessions allowed for each dispatcher.
CONNECTIONS – The maximum number of network connections to allow for each dispatcher.
Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DISPATCHERS.html#GUID-DCBCCF94-8A73-4805-9138-412DA413FC7C

5. Shared_servers parameter can be set to control total number of shared servers spawned by the database

shared_servers set to 1 –> This will enable shared server sessions on the database.
max_shared_server  –> Specifies the maximum number of shared servers that can run simultaneously.
shared_server_sessions  –> Specifies the total number of shared server user sessions that can run simultaneously. Setting this parameter enables to reserve user sessions for dedicated servers.
Ref: Automatic Shared Server Configuration (Doc ID 265931.1)

See you next post!

Weekly Events #1

 

MARCH 16

 

Oracle Cloud SaaS Awareness Session

Oracle SD-WAN – ensuring application performance and reliability for real-time and other critical applications.

Oracle SD-WAN helps enterprises connect their branches, HQ, data centers, multiple clouds but also vehicles and ships with an autonomous WAN providing greater network reliability and superior application quality of experience while reducing the cost of WAN.

READ MORE

Oracle User Group Get-Together: JDE-DevOps(Blue-Green deployment) and Pluggable DB for Data refreshes

This is a webinar associated with Oracle Benelux User Group and French Oracle Users Group.

Come and join us to see our success in Oracle’s JDE internal development operations with Blue-Green deployment for the JDE Tools updates process and simplification of data refresh process using pluggable databases(PDB) of containerized database(CDB). This session showcases the benefits of Blue-Green deployment strategy, Pluggable Databases and how much Time/Effort we have saved in our internal operations by adopting the latest innovations of DevOps strategies and Pluggable Databases.

READ MORE

Cloud Applications Implementation Best Practices Webinar

ORACLE CS connectx: implementation best practices.

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

READ MORE

Oracle Maximize Value with Oracle Database 19c

“The Time is Now” for database modernization removing technology debt.

The new normal has accelerated digitalization of many customers across industries. Customers are facing new challenges and need to develop new business models to increase efficiency, be more agile and highly resilient.

Addressing “technology debt” enables customers to move much more rapidly in this direction.Technology debt is not only linked to hardware and software obsolescence, but leaves organisations “lagging” – unable to leverage automation and integration capabilities, lacking superior scalability and availability to be able to handle demand and offer near-zero business service disruption. To add to this, there is an inability to get insights from data in real-time, and increased vulnerability as cyber-attacks grow exponentially and data breaches are commonplace, particularly, as systems remain out-of-date.

READ MORE

DAY ONE – Hyperion on Oracle Cloud Infrastructure – Hands On Lab

See Oracle Cloud Infrastructure (OCI) in action with your Hyperion application in a live hands-on virtual lab.

In this workshop, Oracle cloud engineers will demonstrate the setting up of Oracle Hyperion Financial Management (HFM), Oracle Hyperion Foundation Services, and Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) on OCI.

READ MORE

   MARCH 17

 

DAY TWO – Hyperion on Oracle Cloud Infrastructure – Hands On Lab

See Oracle Cloud Infrastructure (OCI) in action with your Hyperion application in a live hands-on virtual lab.

In this workshop, Oracle cloud engineers will demonstrate the setting up of Oracle Hyperion Financial Management (HFM), Oracle Hyperion Foundation Services, and Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) on OCI.

READ MORE

DAY ONE – UTOUG – Training Days 2021

We are going VIRTUAL this year.

UTOUG Training Days brings the best speakers in the country to your doorstep! Network with people who are part of your local community – no hotel required! Explore the session schedule when it becomes available then go ahead and invest in yourself by registering today.

UTOUG is committed to ensuring that all Oracle technologists in our area can learn and grow. Our available scholarships help further that commitment by helping UTOUG members and students attend Training Days.

READ MORE

Oracle Live Event – MySQL Accelerate Live Session: GAMING

Mysql for modern & secure high availability gaming applications.

This Accelerate Live Session is designed to get you on track with the latest DBA trends and technology with real life use cases.

READ MORE

New Autonomous Data Warehouse Innovations

Featuring andrew mendelsohn, evp, oracle database server technologies.

On Wednesday, March 17, Andrew Mendelsohn will announce Oracle’s latest cloud data warehouse innovations that put the full power of your data within the reach of your entire organization. New intuitive, integrated capabilities enable analysts, data scientists, and line-of-business developers to deliver even faster results, accelerating insights and time-to-market. Together with the existing zero-admin capabilities of Oracle Autonomous Data Warehouse, organizations of all sizes can lower TCO and increase ROI while more rapidly gaining maximum value from their data.

READ MORE

Live Webinar: Simplify and Modernize Your On-Premises Cloud using Oracle Private Cloud Appliance

Cloud native technology are rapidly gaining acceptance and is simplifying the building of complex applications, while at the same time enabling organizations to build and deploy these applications faster.

Now, with Cloud native environments integrated with the latest PCA software release, organizations are further empowered to build and run scalable applications in modern, dynamic, highly available environments, which enable loosely coupled systems that are resilient, manageable, and observable.

READ MORE

ZDLRA and MAA integration to reach ZERO RPO everywhere

Zero Data Loss Recovery Appliance (ZDLRA) is an Oracle Engineering System that was it is part of the Oracle Maximum Availability Architecture (MAA) family. But it goes beyond just backup and recovery. In this webinar I will show how to integrate ZDLRA with all kinds of databases that you have, protecting from the simplest single instance to the huge multi-site DG+RAC database. Everything with ZERO Recovery Point Objective (RPO) and multi-site protection. Check in this webinar how you integrate ZDLRA features like Real-Time Redo transport, Multi ZDLRA Replication, and Tape backups with the Oracle MAA Reference Architecture. After the webinar, you will understand why you need to consider ZDLRA for your architecture design and how ZDLRA and MAA can work together to reach maximum protection for all kinds of databases.

READ MORE

   MARCH 18
DAY TWO – UTOUG – Training Days 2021

We are going VIRTUAL this year.

UTOUG Training Days brings the best speakers in the country to your doorstep! Network with people who are part of your local community – no hotel required! Explore the session schedule when it becomes available then go ahead and invest in yourself by registering today.

READ MORE

Cloud-Driven Transformation: Accelerating resiliency and business continuity with Oracle

Today’s organizations are undergoing massive transformation, ramping up digital initiatives across the enterprise. Further driven by the pandemic, according to IDC, at least 50% of organizations in Africa will launch new lines of business driven by DX investments in 2021.

READ MORE

Live Webcast: Optimizing value of your Oracle licenses – best practices for Software Asset Management

Optimizing value of your oracle licenses – best practices for software asset management.

Do you want to gain a better understanding of the various licensing and contract options that Oracle offers? Is the management of your Oracle licenses fixed in a solid and standardized Software Asset Management process? Are you wondering what methods and techniques you can use and what this means for your organization? Then join us for this upcoming webinar!

READ MORE

Meetup: Experiences with Oracle Database Migrations to the Cloud (Moved to April!)

Meetup: Experiences with Oracle Database Migrations to the cloud</strong>

Originally this Meetup was supposed to take place on March 18th. The Meetup will be postponed to a date yet to be determined in April. More information about this will follow as soon as possible.

READ MORE

APEX Office Hours
APEX + Server-side JavaScript = Awesome!
Welcome to the future! Starting with Oracle Database 21c, developers can now execute JavaScript within the database. This functionality is enabled by the Multilingual Engine (MLE), powered by GraalVM. And APEX 20.2 is the first (and only) low code framework on the planet which natively supports server-side JavaScript, out of the box!

READ MORE

   MARCH 19
A la découverte de la nouvelle machine virtuelle d’Oracle – GraalVM

Venez decouvrir graalvm lors de ce webinar.

Une toute nouvelle solution elaborée par “Oracle Lab” qui apporte une valeure ajoutee ultra rapide au Business que vous soyez une Multinational ou une PME.

READ MORE

AWS AQUA for Redshift

Hi all,

Quick one today. Did you see this new release? I’m a bit behind the schedule but trying to catch up with the news. It seems very interesting:

AQUA (Advanced Query Accelerator) for Amazon Redshift is available in preview. AQUA provides a new distributed and hardware-accelerated cache that brings compute to the storage layer for Amazon Redshift and delivers up to 10x faster query performance than other cloud data warehouses.

AQUA is a high-speed cache on top of Redshift Managed Storage that can scale out and process data in parallel across many AQUA nodes. AQUA uses AWS-designed analytics processors that dramatically accelerate data compression, encryption, and data processing on queries that scan, filter, and aggregate large data sets. With this new architecture, customers can run queries quicker than ever before, allowing them to query data directly, even at scale, and giving them more up-to-date dashboards, reducing development time, and making system maintenance easier.

It is available for preview in US East (Ohio), US East (N. Virginia), and US West (Oregon) regions at this point.

For more references:

  • There is a very tech detailed article about it HERE.
  • There is also a very nice TechTalk presenting it HERE.

Let’s keep up to date!

Microsoft Ignite 2021!

Hey Folks,
Better later than never… Yesterday was the first day of the Microsoft Ignite event, and again, like last year, you have a chance to earn a voucher to do a free certification exam.

Same as the last year, to receive the voucher all you have to do is complete at least one of the challenges.

Bellow, you have two links. One where you can see which Exams will be available and the other one will take you to the challenges page.