Oracle Developer Community LAD TOUR 2018: OUGPY (Paraguay)

Hey all!
You may have seen my post abou LAOUC and the Tour last week. If not, have a look. Now let’s cover Paraguay Edition, organized by OUGPY – Oracle Users Group Paraguay.

I’ll be speaking in Assunción/Paraguay about “Oracle Database Backup Service: Backup of On-Premise Databases to Cloud“.

Where?
Central Bank of Paraguay
Federación Rusa y Augusto Roa Bastos, Asunción 1767

How much?
FREE! Click here!

What does my session cover?
In this session, I’ll be speaking about a study case one of the most fundamental Disaster Recovery tool for any business or technology: The Backup.  But, what happens if your backup don’t work, or you lose your backup with your Data Center?

The session covers the Oracle Backup Service available in Oracle Public Cloud, specially focusing on offsite backups for On-Premise Databases. It is the less disruptive and easy implementable alternative to have an offsite backup, a common need in several business due the Sarbanes-Oxley Act (SOX-2002). This is also the first step to put Database environments into Oracle Cloud.

The session has a hands-on lab covering installing, configuring, backing up and restoring a corrupted file from Public Cloud.

OUGPY-OTN-promos-01 (1).png

Wait you there!

Oracle 12.2.0.1 Trace Facility Problems

Hey!
Quick one today… Not sure if you noticed, but 12.2.0.1 has some problems with the trace facility. Some components/processes generate huge amount of trace files.

MOS notes:
– RMAN BACKUP Command Always Generates Trace File Having “kcbtse_print_kod” Message (Doc ID 2311975.1)
– MMON trace file grows and is flooded with: kmgs_parameter_update_timeout Gen0 messages (Doc ID 2319931.1)

Both have their patches already…

Additionally, Mike Dietrich’s blog posts about above notes:

https://mikedietrichde.com/2018/05/24/rman-backup-generates-traces-in-oracle-12-2-0-1/
https://mikedietrichde.com/2018/05/23/mmon-unconditional-traces-in-oracle-12-2-0-1/

 

Oracle Developer Community LAD TOUR 2018: GOUB Tech Day (Brazil)

Hey all!
You may have seen my post abou LAOUC and the Tour, right? If not, have a look!
Now let’s cover Brazilian Edition, organized by GUOB – Grupo de Usuários de Tecnologia Oracle do Brasil.

I’ll be speaking in São Paulo/Brazil with the session “Amazing Free Tools for Oracle DBAs“, in room 5 at 3:30 PM local time.

Where?
UNINOVE – Universidade Nove de Julho – Campus Memorial
Av. Francisco Matarazzo, 364
Bairro Barra Funda
São Paulo – SP

How much do I invest for this?

Public/Date up to June 30th Up to July 27th Up to August 3rd
General Public R$ 220,00 R$ 314,00 R$ 420,00
Student R$ 110,00 R$ 157,00 R$ 210,00
Student or Teacher UNINOVE Free Free Free

Confirm your presence!

bannerguob

What does my sessions cover?

> Amazing Free Tools for Oracle DBAs

Your scripts utility belt don’t need to cover it all! Know some outstanding free tools to manage and monitor your Oracle Database environment.

In this session we’ll get in touch with some amazing free tools to check on the database performance, ongoing issues, tracing, dashboarding and graphing things from your database and server perspectives.

 

Here for more info about:
All the Speakers
All the Sessions

Wait you there!

goub_tech_day

GRID upgrade FREEZES – 11g to 12c

Hey guys,
Upgrading is always something critical and a delicate operation but when you have no feedback on in the screen even harder.

I was working on an upgrade and using the GUI to upgrade the GRID from 11g to 12c. The 11gr2 11.2.0.4 was working without issue and ASM was as well (note this point, we will come back here later on).

When it was time to run the rootupgrade.sh, it just got stuck. No matter what, the GRID upgrade to 12c just FROZE. Checking the logs the last message was only this:

CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.

Looking the other logs (/u01/app/12.1.0/grid/cfgtoollogs/crsconfig) there were messages related to OCR, pointing it cannot get OCR key with CLUUTIL, try using OCRDUMP. I checked ORC with ocrdump and ocrcheck. No issues there as well. Also, as I said before, the cluster was working without any issues.

As I had no error code or any thing that would give me a more specific cause. I went to a broad search on google and MOS. Saw all kind of things until I found the MOS: Wrong DiscoveryString /dev/*: rootupgrade.sh/root.sh hangs: Check OCR key using ocrdump (Doc ID 1916106.1)

I checked any my ASM disk discovery string was set to /dev/* which did not strike me as an issue as I mentioned it was working… BUT when I changed the script in ASM to /dev/asm-* the upgrade worked like a charm.

Also as note there is this note, with some best practices for upgrading: How to Upgrade to/Downgrade from Grid Infrastructure 12.1 and Known Issues (Doc ID 1579762.1).

Hope this helps and save some time in your troubleshooting.

Élisson Almeida

OEM: The ILOM server is currently offline or unreachable on the network.

Hi all!
Just got an alarm from OEM with this message. How to check it?
– First thing is to be able to connect on ILOM from DBNode.
– From there we can test the IPv4 and/or IPv6 interfaces through ping, as pe shown below.

This is also documented as per this Doc: Oracle Integrated Lights Out Manager (ILOM) 3.0 HTML Documentation Collection – Test IPv4 or IPv6 Network Configuration (CLI)

In my case, it was only a false alarm, as I was able to connect to other DBNodes from this ILOM:

[root@greporasrv01db01 ~]# ssh greporasrv01-ilom.jcrew.com
The authenticity of host 'greporasrv01-ilom.grepora.com (10.48.18.64)' can't be established.
RSA key fingerprint is 59:c5:9f:b1:60:59:15:16:94:c8:94:88:7b:4e:52:57.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'greporasrv01-ilom.grepora.com' (RSA) to the list of known hosts.
Password: 

Oracle(R) Integrated Lights Out Manager

Version 3.2.9.23 r116695

Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.

Warning: HTTPS certificate is set to factory default.

Hostname: greporasrv01-ilom

-> show /SP/network

 /SP/network
    Targets:
        interconnect
        ipv6
        test

    Properties:
        commitpending = (Cannot show property)
        dhcp_clientid = none
        dhcp_server_ip = none
        ipaddress = 10.50.12.64
        ipdiscovery = static
        ipgateway = 10.50.12.1
        ipnetmask = 255.255.255.0
        macaddress = 00:10:E0:95:73:E6
        managementport = MGMT
        outofbandmacaddress = 00:10:E0:95:73:E6
        pendingipaddress = 10.50.12.64
        pendingipdiscovery = static
        pendingipgateway = 10.50.12.1
        pendingipnetmask = 255.255.255.0
        pendingmanagementport = MGMT
        pendingvlan_id = (none)
        sidebandmacaddress = 00:10:E0:95:73:E7
        state = ipv4-only
        vlan_id = (none)

    Commands:
        cd
        set
        show

-> cd /SP/network/test
/SP/network/test

-> show

 /SP/network/test
    Targets:

    Properties:
        ping = (Cannot show property)
        ping6 = (Cannot show property)

    Commands:
        cd
        set
        show

-> set ping=10.50.12.51       -- DBNode1
Ping of 10.50.12.51 succeeded

-> set ping=10.50.12.52       -- DBNode2
Ping of 10.50.12.52 succeeded

 

Oracle Developer Community LAD TOUR 2018: CLOUG (Chile)

Hey all!
You may have seen my post abou LAOUC and the Tour, right? If not, have a look!
Now let’s cover Chile Edition, organized by CLOUG – Chilean Oracle Users Group.

I’ll be speaking in Santiago/Chile with three sessions:
Oracle Database Backup Service: Backup of On-Premise Databases to Cloud
Amazing Free Tools for Oracle DBAs
Oracle Database Migration and Consolidation Techniques

Where?
UNIVERSIDAD SAN SEBASTIAN
Av Belavista 7, Recoleta, Santiago
Salon de exposiciones

How much?
Early Bird: (June 30th 2018): 10.000 CLP (around $15.00)
Preferencial (July 1st to July 15th): 15.000 CLP (around $24.00)
Normal: (July 16th to Aug 1st): 20.000 CLP (around $30.00)
Dia del Evento: (August 2nd): 25.000 CLP (around $40.00)

Confirm your presence!


What does my sessions cover?

Continue reading

Oracle Developer Community LAD TOUR 2018

Hello all!
I’m pretty sure you know what I’m talking about. Don’t know?
Perhaps the term OTN Tour LAD rings a bell?

Not yet?
Well, this is an Oracle Users Groups Tour around the Latin America where local communities engage their Oracle Professionals for a meeting discussion about experiences and technology. This is all organized by the LAOUC – Latin American Oracle Users Group Community (logo below) with the local users groups.

In general, we have people from other countries and continents doing a crossover to increase the value of any discussions. This year I’ll be speaking in Paraguay, Chile and Brazil. Check below my agenda:

# Paraguay (Assunción) – OUGPY – July 31th:
Oracle Database Backup Service: Backup of On-Premise Databases to Cloud

# Chile (Santiago) – CLOUG – August 2nd:
Oracle Database Backup Service: Backup of On-Premise Databases to Cloud
Amazing Free Tools for Oracle DBAs
Oracle Database Migration and Consolidation Techniques

# Brazil (São Paulo) – GUOB – August 4th:
Amazing Free Tools for Oracle DBAs

I’ll be doing a post with more info about each event (date/time, location, subscription info, etc) soon.

LOGO-LAOUC

The complete agenda for the LAD tour is:

Asuncion, Paraguay — Tuesday 31-Jul-2018
Santiago, Chile — Thursday 2-Aug-2018
Sao Paulo, Brasil — Saturday 4-Aug-2018
Montevideo, Uruguay — Monday 6-Aug-2018 & Tuesday 7-Aug-2018
Buenos Aires, Argentina — Thursday 9-Aug-2018
Lima, Peru — Saturday 11-Aug-2018
Quito, Ecuador — Tuesday 14-Aug-2018
Barranquilla, Colombia — Thursday 16-Aug-2018 & Friday 17-Aug-2018
San Jose, Costa Rica — Monday 20-Aug-2018
Panamá, Panamá — Wednesday 22-Aug-2018
Mexico DF, Mexico — Friday 24-Aug-2018
Guatemala, Guatemala — Tuesday 28-Aug-2018

For more info, please access:

LAOUC
OUGPY
CLOUG
GUOB

Cheers!