Moving APEX Applications Repository

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

We’ll use the APEXExport for this end.

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

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

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

To Export:

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

2. Run the APEXExport twice as follows:

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

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

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

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

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

To Import:

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

@<script_generated>.sql

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

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

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

I hope it helps!

Weekly Events #8

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

 

MAY 02

 

Before Disaster Strikes Architect Seminar Series

ACHIEVING RESILIENCY IN YOUR BUSINESS CONTINUITY STRATEGY.

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

READ MORE

 

   MAY 04

 

APEX CONNECT 2021 [ONLINE]

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

READ MORE

 

Oracle Communications SD-WAN Boot Camp

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

READ MORE

Developer Live! App Dev with Oracle Database

BUILD APPLICATIONS WITH ORACLE DATABASE NOW.

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

READ MORE

 

Criando sua Infraestrutura no Azure com Código

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

Palestrante: Juliano Custódio (Microsoft MVP)

READ MORE

   MAY 05

 

UKOUG – License Management Event

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

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

READ MORE

 

Evento RSJUG Maio

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

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

READ MORE

 

   MAY 08

 

 

Bootcamp – Machine Learning: Funcionamiento y Aplicabilidad

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

READ MORE

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

Hi all,

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

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

oracle:dbserver@mydb02 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 12.1.0.5.0
OMS Version            : (unknown)
Protocol Version       : 12.1.0.1.0
Agent Home             : /u01/app/oracle/product/agent12c/agent_inst
Agent Log Directory    : /u01/app/oracle/product/agent12c/agent_inst/sysman/log
Agent Binaries         : /u01/app/oracle/product/agent12c/core/12.1.0.5.0
Agent Process ID       : 61641
Parent Process ID      : 61394
Currently initializing component             : Target Manager (2) (54 of 70)
Receivelet Interaction Manager Current Activity: Outstanding receivelet event tasks
----------------------------------
        TargetID = oracle_pdb.c4test_PDB1 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29 
        TargetID = oracle_pdb.c3test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29 
        TargetID = oracle_pdb.c3test_PDB2 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30 
        TargetID = oracle_pdb.c4test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29 
        TargetID = oracle_pdb.c6test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29 
        TargetID = oracle_pdb.c3test_PDB3 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30 
        TargetID = rac_database.c1prod - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30 


Target Manager Current Activity              : Compute Dynamic Properties (total operations: 37, active: 7, finished: 28)


Current target operations in progress
-------------------------------------
        oracle_pdb.c6test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c4test_PDB1 - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c3test_PDB2 - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c3test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c4test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c3test_PDB3 - LOAD_TARGET_DYNAMIC running for 120 seconds
        rac_database.c1test - LOAD_TARGET_DYNAMIC running for 120 seconds


Dynamic property executor tasks running
------------------------------


---------------------------------------------------------------
Agent is Running but Not Ready

Agent not ready, that’s interesting.
Trying then to clear the agent state as this has solved some previous similar cases:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl clearstate agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
EMD clearstate completed successfully

Now running the problematic metric manually:

oracle:dbserver02@c1test2 /u01/app/oracle: runCollection c1test_DW:oracle_pdb tbspAllocation                                                                <
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD runCollection error:The agent is running but is currently not ready to accept client requests

Ok, trying to just upload the case:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl upload
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload error:The agent is running but is currently not ready to accept client requests

Maybe something is stuck, so let’s kill the process and start all over again:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Stopping agent ...

 stopped.

Making sure we have no agent process running:

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

Also adjusting the threshod for metric running:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl  setproperty agent -a
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
EMD setproperty succeeded
oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl setproperty agent -allow_new -name _cancelThread  -value 210
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
EMD setproperty succeeded

And starting the agent:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl start agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Starting agent ........................................................................................................................... started but not ready.

On the Agent log:

oracle:dbserver02@c1test2 /u01/app/oracle: tail /u01/app/oracle/product/agent12c/agent_inst/sysman/log/gcagent.log
oracle:dbserver02@c1test2 /u01/app/oracle:
2020-12-20 13:15:03,457 [35:686116F5] DEBUG - StatusAgentAction: satisfyRequest Begin
2020-12-20 13:15:03,457 [35:686116F5] DEBUG - Agent Overall Health: 0
2020-12-20 13:15:03,457 [35:686116F5] DEBUG - StatusAgentAction: satisfyRequest End
Response:
initializing
2020-12-20 13:15:03,457 [35:686116F5] INFO - >>> Reporting response: StatusAgentResponse (initializing) (request id 1) <<< 2020-12-20 13:15:03,457 [35:686116F5] DEBUG - closing request input stream for "StatusAgentRequest (AGENT timeout:300)" 2020-12-20 13:15:03,457 [35:686116F5] DEBUG - overriding the buffer with a thread local copy (size: 8192b) 2020-12-20 13:15:03,458 [35:686116F5] DEBUG - closing request output stream for "StatusAgentRequest (AGENT timeout:300)" 2020-12-20 13:15:03,458 [35:686116F5] DEBUG - StatusAgentAction.call() is complete. 2020-12-20 13:15:03,458 [35:B5326F3F:HTTP Listener-35 - /emd/lifecycle/main/] DEBUG - removing entry for emdctl@18081@dbserver02=>[160849530330001] completely
2020-12-20 13:15:03,458 [35:B5326F3F] DEBUG - requests executed.
2020-12-20 13:15:03,458 [35:B5326F3F] DEBUG - HTTPListener Threads deallocated resource back to LifecycleRequestHandler partition
2020-12-20 13:15:03,458 [35:3C0B0663:HTTP Listener-35] DEBUG - using connection SCEP@1197017148 [d=true,io=1,w=true,b=false|false],NOT_HANDSHAKING, in/out=0/0 Status = OK HandshakeStatus = NOT_HANDSHAKING
bytesConsumed = 5 bytesProduced = 26
2020-12-20 13:15:03,780 [35:3C0B0663] DEBUG - using connection SCEP@1197017148  [d=true,io=1,w=true,b=false|false],NOT_HANDSHAKING, in/out=0/0 Status = OK HandshakeStatus = NOT_HANDSHAKING
bytesConsumed = 26 bytesProduced = 5
2020-12-20 13:15:06,986 [31:858161EB] DEBUG - Submitting task SchedulerHeartbeat for execution
2020-12-20 13:15:06,986 [395:1AE716D8] DEBUG - Begin task SchedulerHeartbeat on Thread: GC.SysExecutor.8
2020-12-20 13:15:06,986 [395:F944F4C8:GC.SysExecutor.8 (SchedulerHeartbeat)] DEBUG - Scheduler heartbeat
2020-12-20 13:15:06,988 [395:F944F4C8] DEBUG - Scheduling next SchedulerHeartbeat after delay 29998 including periodShift of 0 milliseconds
2020-12-20 13:15:06,988 [395:1AE716D8:GC.SysExecutor.8] DEBUG - End task SchedulerHeartbeat
2020-12-20 13:15:07,016 [31:858161EB] DEBUG - Submitting task HeapMonitorTask for execution
2020-12-20 13:15:07,017 [396:1AE716D9] DEBUG - Begin task HeapMonitorTask on Thread: GC.SysExecutor.9
2020-12-20 13:15:07,017 [396:391F60D7:GC.SysExecutor.9 (HeapMonitorTask)] DEBUG - Scheduling next HeapMonitorTask after delay 5000 including periodShift of 0 milliseconds
2020-12-20 13:15:07,017 [396:1AE716D9:GC.SysExecutor.9] DEBUG - End task HeapMonitorTask
2020-12-20 13:15:12,017 [31:858161EB] DEBUG - Submitting task HeapMonitorTask for execution
2020-12-20 13:15:12,017 [37:1AE716D0] DEBUG - Begin task HeapMonitorTask on Thread: GC.SysExecutor.0
2020-12-20 13:15:12,017 [37:FE21F10E:GC.SysExecutor.0 (HeapMonitorTask)] DEBUG - Scheduling next HeapMonitorTask after delay 5000 including periodShift of 0 milliseconds
2020-12-20 13:15:12,017 [37:1AE716D0:GC.SysExecutor.0] DEBUG - End task HeapMonitorTask
2020-12-20 13:15:12,189 [33:6D553CF6] DEBUG - HTTPListener Threads deallocated resource back to LifecycleRequestHandler partition
2020-12-20 13:15:12,190 [35:3C0B0663] DEBUG - using connection SCEP@1611645943  [d=true,io=1,w=true,b=false|false],NOT_HANDSHAKING, in/out=0/0 Status = OK HandshakeStatus = NOT_HANDSHAKING
bytesConsumed = 100 bytesProduced = 121
2020-12-20 13:15:12,191 [35:7107E334:HTTP Listener-35 - /emd/persistence/main/] DEBUG - HTTPListener Threads allocated resource from LifecycleRequestHandler partition
2020-12-20 13:15:17,017 [31:858161EB] DEBUG - Submitting task HeapMonitorTask for execution
2020-12-20 13:15:17,018 [45:1AE716D1] DEBUG - Begin task HeapMonitorTask on Thread: GC.SysExecutor.1
2020-12-20 13:15:17,018 [45:CBCC52CF:GC.SysExecutor.1 (HeapMonitorTask)] DEBUG - Scheduling next HeapMonitorTask after delay 5000 including periodShift of 0 milliseconds
2020-12-20 13:15:17,018 [45:1AE716D1:GC.SysExecutor.1] DEBUG - End task HeapMonitorTask

Following MOS Enterprise Manager12c: Oracle Database Tablespace Monthly Space Usage shows no data (Doc ID 1536654.1), a few changes were made:

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

The status before the change:

oracle:dbserver02@c1test2 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 12.1.0.5.0
OMS Version            : (unknown)
Protocol Version       : 12.1.0.1.0
Agent Home             : /u01/app/oracle/product/agent12c/agent_inst
Agent Log Directory    : /u01/app/oracle/product/agent12c/agent_inst/sysman/log
Agent Binaries         : /u01/app/oracle/product/agent12c/core/12.1.0.5.0
Agent Process ID       : 61641
Parent Process ID      : 61394
Currently initializing component             : Target Manager (2) (54 of 70)
Receivelet Interaction Manager Current Activity: Outstanding receivelet event tasks
----------------------------------
        TargetID = oracle_pdb.c4test_PDB1 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29 
        TargetID = oracle_pdb.c3test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29 
        TargetID = oracle_pdb.c3test_PDB2 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30 
        TargetID = oracle_pdb.c4test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29 
        TargetID = oracle_pdb.c6test_CDBROOT - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:29 
        TargetID = oracle_pdb.c3test_PDB3 - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30 
        TargetID = rac_database.c1test - EventType - TARGET_EVENT for operation LOAD_TARGET submitted at 2020-12-20 12:54:30 

Target Manager Current Activity              : Compute Dynamic Properties (total operations: 37, active: 7, finished: 28)

Current target operations in progress
-------------------------------------
        oracle_pdb.c6test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c4test_PDB1 - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c3test_PDB2 - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c3test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c4test_CDBROOT - LOAD_TARGET_DYNAMIC running for 120 seconds
        oracle_pdb.c3test_PDB3 - LOAD_TARGET_DYNAMIC running for 120 seconds
        rac_database.c1test - LOAD_TARGET_DYNAMIC running for 120 seconds

Dynamic property executor tasks running
------------------------------


---------------------------------------------------------------
Agent is Running but Not Ready

And the status after the change:

oracle:dbserver02@c1test2 /u01/app/oracle:  /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 12.1.0.5.0
OMS Version            : 12.1.0.5.0
Protocol Version       : 12.1.0.1.0
Agent Home             : /u01/app/oracle/product/agent12c/agent_inst
Agent Log Directory    : /u01/app/oracle/product/agent12c/agent_inst/sysman/log
Agent Binaries         : /u01/app/oracle/product/agent12c/core/12.1.0.5.0
Agent Process ID       : 56994
Parent Process ID      : 56654
Agent URL              : https://dbserver02:3872/emd/main/
Local Agent URL in NAT : https://dbserver02:3872/emd/main/
Repository URL         : https://omsweb:4903/empbs/upload
Started at             : 2020-12-20 13:08:35
Started by user        : oracle
Operating System       : Linux version 3.10.0-957.27.2.el7.x86_64 (amd64)
Last Reload            : (none)
Last successful upload                       : 2020-12-20 13:40:41
Last attempted upload                        : 2020-12-20 13:40:41
Total Megabytes of XML files uploaded so far : 1.02
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 10.85%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2020-12-20 13:40:40
Last successful heartbeat to OMS             : 2020-12-20 13:40:40
Next scheduled heartbeat to OMS              : 2020-12-20 13:41:40

---------------------------------------------------------------
Agent is Running and Ready

Great! Agent issue resolved.
However, the metric is not being gathered not even after running it manually:

oracle:dbserver01@c1test1 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl control agent runCollection c1test_CDBROOT:oracle_pdb tbspAllocation
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD runCollection completed successfully

oracle:dbserver01@c1test1 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl status agent scheduler | grep tbspAllocation
2020-12-28 23:05:14.562 : rac_database:c1test:tbspAllocation_cdb
2020-12-29 03:07:21.988 : rac_database:c4prod:tbspAllocation_cdb
2020-12-29 03:08:11.888 : rac_database:c6prod:tbspAllocation_cdb
2020-12-29 03:09:39.103 : rac_database:c2prod:tbspAllocation_cdb
2020-12-29 03:09:55.372 : rac_database:c3prod:tbspAllocation_cdb

oracle:dbserver01@c1test1 /u01/app/oracle: /u01/app/oracle/product/agent12c/core/12.1.0.5.0/bin/emctl control agent runCollection c1test_DW:oracle_pdb tbspAllocation
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD runCollection completed successfully

On OEM Repository database:

SQL> select TARGET_NAME,TARGET_TYPE,TARGET_GUID,max(ROLLUP_TIMESTAMP )
from mgmt$metric_daily where TARGET_NAME like '%c1test%'
and TARGET_TYPE='oracle_pdb'
and METRIC_NAME='tbspAllocation'
group by TARGET_NAME,TARGET_TYPE,TARGET_GUID;  2    3    4    5

TARGET_NAME                    TARGET_TYPE          TARGET_GUID                      MAX(ROLLUP_TIMESTAM
------------------------------ -------------------- -------------------------------- -------------------
c1test_DW         oracle_pdb           7B1DF5DD4555EB978330A6D522004D44 2020-11-12 00:00:00
c1test_CDBROOT    oracle_pdb           4CE72911295C0287E053837F649B7D0E 2020-11-12 00:00:00


SQL> select TARGET_NAME,TARGET_TYPE,TARGET_GUID,ROLLUP_TIMESTAMP from mgmt$metric_daily where TARGET_NAME like '%c1test%' and TARGET_TYPE='oracle_pdb' and ROLLUP_TIMESTAMP>sysdate-3 order by 4

TARGET_NAME                    TARGET_TYPE          ROLLUP_TIMESTAMP       AVERAGE
------------------------------ -------------------- ------------------- ----------
c1test_DW         oracle_pdb           2020-11-06 00:00:00  1575.9375
c1test_DW         oracle_pdb           2020-11-07 00:00:00  1575.9375
c1test_DW         oracle_pdb           2020-11-08 00:00:00  1575.9375
c1test_DW         oracle_pdb           2020-11-09 00:00:00  1575.9375
c1test_DW         oracle_pdb           2020-11-10 00:00:00  1575.9375
c1test_DW         oracle_pdb           2020-11-11 00:00:00  1575.9375
c1test_DW         oracle_pdb           2020-11-12 00:00:00  1575.9375
c1test_CDBROOT    oracle_pdb           2020-11-05 00:00:00 37581.5625


TARGET_NAME                    TARGET_TYPE          ROLLUP_TIMESTAMP       AVERAGE
------------------------------ -------------------- ------------------- ----------
c1test_CDBROOT    oracle_pdb           2020-11-08 00:00:00  227138.75
c1test_CDBROOT    oracle_pdb           2020-11-09 00:00:00 455087.688
c1test_CDBROOT    oracle_pdb           2020-11-10 00:00:00 278230.875
c1test_CDBROOT    oracle_pdb           2020-11-11 00:00:00 208727.188
c1test_CDBROOT    oracle_pdb           2020-11-12 00:00:00 454964.063

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

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

SQL> alter session set container=DW;

Session altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 DW                             READ WRITE NO
SQL> select count(*) from dba_recyclebin;

  COUNT(*)
----------
     28522

SQL> purge recyclebin;

Recyclebin purged.

SQL> purge dba_recyclebin;

DBA Recyclebin purged.

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

Some additional reference:

  • Database Tablespace Metrics: Tablespace Allocation Is Not Collected (Metric tbspAllocation) (Doc ID 404692.1)
  • EM 12c : emctl start agent Fails With Error ‘Starting agent … started but not ready’ (Doc ID 1591477.1)
  • EM12c : emctl start / status agent ‘Agent Running but Not Ready’ ‘ERROR – The agent is overloaded [current requests: 30]’ Reported in gcagent.log (Doc ID 1546529.1)

I hope it helps!

Weekly Events #7

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

 

APRIL 25

 

Before Disaster Strikes Architect Seminar Series

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

READ MORE

 

   APRIL 26

 

SAVE THE DATE: BERLINER EXPERTENSEMINAR MIT CHRISTIAN PFUNDTNER

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

READ MORE

   APRIL 27

 

Building a cloud-friendly application – Jakarta Tech Talks

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

READ MORE

 

Microsserviços + Azure Event Hubs

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

READ MORE

 

   APRIL 28

 

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

READ MORE

 

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

 

Make it faster – Myths about SQL Performance

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

Make it faster - Myths about SQL Performance

READ MORE

 

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

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

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

READ MORE

   APRIL 29

 

SAVE THE DATE: BERLINER EXPERTENSEMINAR MIT MARCO PATZWAHL

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

READ MORE

 

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

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

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

READ MORE

 

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

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

READ MORE

 

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

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

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

READ MORE

 

   APRIL 30

 

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

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

READ MORE

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

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

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

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

DGMGRL> show database myprodDB;

Database - myprodDB

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

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

Database Status:
WARNING

DGMGRL> show database verbose myprodDB;

Database - myprodDB

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

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

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

Database Status:
WARNING

And checking for the status in the standby database server:

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

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

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

Configuration - my_dg_configuration

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

mySTDB - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
WARNING (status updated 12 seconds ago)

DGMGRL> show database myprodDB;

Database - myprodDB

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

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

Database Status:
WARNING

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

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

Comparing the settings:

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

It seems all right!

What is the problem then?

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

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

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

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

What I did in my case?

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

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

Once done:

DGMGRL> show configuration;

Configuration - my_dg_configuration

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

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 3 seconds ago)

DGMGRL> show database myprodDB;

Database - myprodDB

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

Database Status:
SUCCESS

DGMGRL> show database mySTDB;

Database - mySTDB

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

Database Status:
SUCCESS

DGMGRL> show database verbose myprodDB;

Database - myprodDB

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

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

Database Status:
SUCCESS

Did you know that?
I hope it helps!

Weekly Events #6

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

 

APRIL 18

 

Before Disaster Strikes Architect Seminar Series

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

READ MORE

 

DB Viscosity Training: Upgrading to Oracle 19c

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

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

READ MORE

 

   APRIL 19

 

Oracle Communications Session Border Controller Troubleshooting Boot Camp

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

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

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

READ MORE

 

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

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

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

READ MORE

   APRIL 20

 

Spring Tech Summit

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

READ MORE

 

Oracle Enterprise Planning Cloud Implementation Workshop

Note that seats are limited and priority will be given to EMEA Partners focusing to Oracle EPM Enterprise Cloud Service Track Expertise. Registrations will be closed as soon as the Event is full.

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

READ MORE

 

Oracle Account Reconciliation Implementation Workshop

Note that seats are limited and priority will be given to EMEA Partners focusing to Oracle EPM Enterprise Cloud Service Track Expertise. Registrations will be closed as soon as the Event is full.

Oracle is pleased to invite you to attend an introductory hands-on workshop for Oracle Account Reconciliation Cloud (ARCS). In this workshop, you will discover how to use Account Reconciliation Cloud to help streamline close processes and deliver insight about the real-time status of account reconciliations.

READ MORE

 

Hands-on Workshop: Oracle Key Vault

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

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

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

READ MORE

 

Chatbot hands-on workshop series with Oracle Digital Assistant

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

READ MORE

 

Data Modeling with Paul Turley

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

READ MORE

 

   APRIL 21

 

Oracle Integration Cloud Workshop

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

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

READ MORE

 

How to Simplify and Automate Data Protection of Oracle Environments

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

READ MORE

 

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

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

READ MORE

 

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

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

READ MORE

   APRIL 22

 

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

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

READ MORE

 

MOTU: Reactive Applications

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

READ MORE

   APRIL 23

 

DOAG DAC Online-Event: HOL – Oracle Machine Learning

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

READ MORE

Weekly Events #5

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

 

APRIL 11

 

Oracle Systems Advantage Forum

DATA DRIVEN INFRASTRUCTURE FOR THE FUTURE ENTERPRISE

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

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

READ MORE

 

   APRIL 12

 

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

 

Oracle Cloud Infrastructure (OCI) Advanced Workshop

Certification Readiness Training for Oracle Cloud Infrastructure 2020 Architect Professional

Oracle set an ambitious goal in building its second-generation cloud infrastructure: to create an infrastructure that matches and surpasses the performance, control and governance of enterprise datacenters, while delivering the scale, elasticity, and cost-savings of public clouds. The result, Oracle Cloud Infrastructure, is built from the ground up to be an Enterprise Cloud, equally capable of running traditional multi-tiered enterprise applications, high-performance workloads, and modern server less and container-based architectures.

READ MORE

 

Oracle Cloud Infrastructure Professional Certification Training Class

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

READ MORE

 

Oracle Cloud Infrastructure Advanced 200 Workshop

Oracle set an ambitious goal in building its second-generation cloud infrastructure: to create an infrastructure that matches and surpasses the performance, control and governance of enterprise datacenters, while delivering the scale, elasticity, and cost-savings of public clouds. The result, Oracle Cloud Infrastructure, is built from the ground up to be an Enterprise Cloud, equally capable of running traditional multi-tiered enterprise applications, high-performance workloads, and modern server less and container-based architectures.

READ MORE

 

Protect Yourself Against Database Downtime with Oracle

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

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

READ MORE

 

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

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

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

READ MORE

 

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

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

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

READ MORE

 

Optimize Cost & Increase Value with Database Cloud Services

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

READ MORE

 

GUOB Webinar: PLSQL Development Best Practices for DBAs

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

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

READ MORE

   APRIL 14

 

Oracle Exadata/ExaCC Nordic User Group Meeting

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

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

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

READ MORE

 

Oracle Cloud Infrastructure Advanced 200

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

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

READ MORE

 

Oracle Database Appliance High Availability and Disaster Recovery

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

READ MORE

 

Oracle State and Local Government Virtual Cloud Summit

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

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

READ MORE

 

Oracle Converged Database

INNOVATOR’S DILEMMA: CONQUERING THE COMPLEXITY OF MODERN APPDEV

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

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

READ MORE

 

A Tour of the Oracle Database block

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

READ MORE

 

   APRIL 15

 

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

READ MORE

 

Before Disaster Strikes Architect Seminar Series

Achieving resiliency in your business continuity strategy. 

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

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

READ MORE

 

Diving into Oracle Cloud Infrastructure – Hands-on workshop

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

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

READ MORE

 

Live Developer Webcast

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

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

READ MORE

 

Cloud Computing SIG April Meeting

Join us for our monthly Cloud Computing SIG meeting!

READ MORE

 

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

READ MORE

 

Before Disaster Strikes Architect Seminar Series

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

READ MORE

 

Getting started with Oracle Machine Learning – Hands-on Workshop

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

READ MORE

 

OCI Database Management Cloud Service

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

READ MORE

Relying in Guaranteed Restore Points? Be careful!

Hi all,

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

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

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

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

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

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

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

The bug is fixed on:

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

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

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

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

So for YOU:

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

See you next post!

Weekly Events #4

Here is a summary of the EVENTS for this week!

 

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

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

READ MORE

   APRIL 06

 

Boot Camp Oracle Communications SD-WAN

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

READ MORE

 

Reduce system complexity in Java with Data-Oriented programming

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

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

READ MORE

   APRIL 07

 

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

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

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

READ MORE

 

Oracle Virtual Event: The Modern Data Warehouse
VIRTUAL EVENT

Data is a critical resource for every organisation, and maximising its value requires a modern approach to data management. In this briefing, we will cover the challenges customers face when trying to ingest, consolidate, catalogue, secure and analyse large amounts of data from multiple sources. We will talk about new cloud capabilities, such as autonomous and data science services, that are making it easier for organisations to manage and extract value from their data.

READ MORE

 

Running Oracle Database Upgrades on Docker

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

READ MORE

 

Oracle Database 19c Upgrade Workshop

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

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

READ MORE

 

Information Lifecycle Management: Manage Exponential Data Growth

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

READ MORE

 

   APRIL 08

 

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

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

READ MORE

 

DB DATA GUARD: CONFIGURATION AND BEST PRACTICES

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

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

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

READ MORE

 

GUORS: MongoDB for Oracle DBAs/Developers

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

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

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

READ MORE

 

   APRIL 09

 

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

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

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

READ MORE

 

   APRIL 10

 

Becas certificaciones internacionales 📢 DevOPS Certified Associate

DevOPS Certified Associate.

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

Fecha sesión online en vivo:

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

READ MORE

 

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

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

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

READ MORE

Exadata DNS Change – Pitfalls to be avoided

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

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

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

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

Here is a summary of the steps.

Infiniband switches

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

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

 

Database nodes

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

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

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


Cell nodes – Here things start to get interesting

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

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

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

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

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


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

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

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

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

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

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

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

 

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

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

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

# Restart cellwall service
service cellwall restart
service cellwall status

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

 

I hope it helps!

Elisson Almeida