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.

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!


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!


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 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, 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/*: 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
The authenticity of host ' (' 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 '' (RSA) to the list of known hosts.

Oracle(R) Integrated Lights Out Manager

Version 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


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


-> cd /SP/network/test

-> show


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


-> set ping=       -- DBNode1
Ping of succeeded

-> set ping=       -- DBNode2
Ping of 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

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.


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:




“TNS-12531: TNS:cannot allocate memory error” – Are you sure, Oracle?

Hey guys!
So, I was working on a server build and everything was running fine until I tried to start the listerner. The process hang on “Starting /u01/app/grid/product/12.1.0/grid/bin/tnslsnr: please wait…” and then raised TNS-12531: TNS:cannot allocate memory error.

Well 1st thing, looked the error up using orerr:

TNS-12531: TNS: cannot allocate memory
Cause: Sufficient memory could not be allocated to perform the desired activity.
Action: Either free some resource for TNS, or add more memory to the machine. For further details, turn on tracing and re-execute the operation.

Should be simple right? Well, not in this case. The server had plenty of resources and not even the database was up yet so over 90% of the server memory was free.

Checked all sort of things when I started to check the server network configuration.
Looking up found that the server will through this error also when the hostname definition is different from what is resolved by the /etc/hosts file.

Once those matched, volià, listener started successfully.

Not the memory right? Oracle and its tricks…

That kept me bugging so I found this article, which shows a trace of the listener with a bit more information.

Hope this can save you some minutes on troubleshooting.

Until next time!

Oracle SecureFiles | In 11.2 extended to Oracle Database File System – DBFS

Hi All!
I was reviewing some features in Oracle and, basically, every single time I review them I find something new. Seems Oracle Databases’ features are near to infinite and we frequently find some that can really add value to our solutions.

So I decided to make a serie of posts with really quick notes about each one of them.
You can see all posts in this serie in my page of posts and some others more.

Ready? Here it goes:

Oracle SecureFiles | In 11.2 extended to Oracle Database File System – DBFS

In version 11g Oracle introduced SecureFiles, a new LOB storage architecture as replacement for BASICFILES LOBs’storage, being faster than Unix files to read/write. Lots of potential benefits for OLAP analytic workspaces are expected, as the LOBs used to hold AWs have historically been very slow to write. In addition, this object type is compliant to other mechanisms like deduplication, compression and encryption. Besides that, lock and concurrency model has been improved to manage those kind of objects. Other improvements like space management, reduced fragmentation, intelligent pre-fetching, new network layer, no LOB index contention, no high water mark contention and being easier to manage are important to mention.

Continue reading