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?

More“Oracle Developer Community LAD TOUR 2018: CLOUG (Chile)”

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!

 

“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.

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

11g+ Features: Extended Statistics

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:

Extended Statistics

One of the most expected features of Oracle 11g is improvements to the dbms_stats package, specifically the ability to aid complex queries by providing extended statistics to the cost-based optimizer (CBO).

The 11g extended statistics are intended to improve the optimizers guesses for the cardinality of combined columns and columns that are modified by a built-in or user-defined function. In Oracle 10g dynamic sampling can be used to provide inter-table cardinality estimates, but dynamic sampling has important limitations. However, the 11g create_extended_stats in dbms_stats relieves much of the problem of sub-optimal table join orders allowing for extended statistics on correlated columns.

One of the expectation is to avoid using the ORDERED hint, one of the most popular SQL tuning hints, used to to specify that the tables be joined together in the same order that they appear in the FROM clause.

This feature can be controlled by hidden parameter:

_optimizer_enable_extended_stats in case of SQL Performance regression.

 

You can also see more detailed material here:
About improvements on 18c (yeah, lots of things on 12c and 18c).
Oracle 12c: Automatic Column Group Detection in Oracle Database 12c Release 1 (12.1)
Oracle Base: Extended Statistics on 11gR2.

Cheers!