Alternatives to Telnet for Testing Open Ports

In the world of networking, testing the availability and responsiveness of open ports is a crucial task. Traditionally, Telnet has been a go-to tool for such purposes, allowing users to connect to remote devices or servers. However, there are situations where Telnet might not be available or suitable for use. In those cases, several alternatives[…]

Exadata Cloud at Customer VM Cluster update failed using the OCI console: how to troubleshoot and resolve it

Hi people, It’s been 3 weeks since I updated the OS of the VMs of one of our client’s Exadata Cloud at Customer (ExaCC) in their DR site. The update was performed from Exadata image 19.2.x to 22.1.10.230422 using the OCI console without any issues. There was a huge leap in the image version because[…]

Oracle Autonomous Data Warehouse vs Snowflake Data Cloud: A brief overview

Introduction In today’s data-driven world, businesses need robust and scalable data warehousing solutions to stay ahead of the competition. Two key players in this domain are Oracle Autonomous Data Warehouse (ADW) and Snowflake Data Cloud. Both platforms offer unique features and capabilities for businesses looking to leverage the power of their data. In this blog[…]

Rolling forward an Oracle standby database in a DataGuard configuration with RMAN “recover from service”

Setup for this case: Two Gen2 Exadata Cloud At Customer X8 quarter rack (2 dbnodes + 3 cells): One ExaCC in NYC being the primary PRODDB is the primary RAC database running in 2 nodes in the NYC cluster. One ExaCC in SLC being the standby PRODDBB is the standby RAC database running in 2[…]

Sequences não garantem valores sequenciais no Oracle Database

Olá pessoal, hoje trago um conteúdo bastante fundamental e simples, mas que por muitas vezes é esquecido. Vez ou outra preciso discutir com desenvolvedores sobre a geração de valores sequenciais para os registros de uma tabela. Essa é uma discussão um tanto quanto cansativa, pois os desenvolvedores muitas das vezes optam por gerar esse número[…]

Ensuring Reliable Database Backups with Oracle Zero Data Loss Recovery Appliance

Organizations rely on their databases to store critical business data, making it essential to have a reliable backup solution in place. However, as databases grow larger and more complex, ensuring the recoverability of data becomes increasingly challenging. In this blog post, we’ll explore how large corporations overcame these challenges by implementing Oracle Zero Data Loss[…]

Exadata

OGB Appreciation Day: Exadata Smart Scan

Hello folks, Let’s see how Smart Scan works. It has been a while I don’t write anything in the blog, but is always good to come back here and also participate on the OGB Appreciation Day, organized every year by Tim Hall from the Oracle Base. This year I decided to quickly write about Exadata[…]

certification

Changes in Oracle Certification Program for DBAs

Hello folks, it has been a while I don’t post anything and this will be a quick one, but useful. Recently, Oracle announced some changes in their certification program for DBAs. There is no more OCA for DBA, only OCP. There is no SQL exam as a pre-requisite, SQL questions are included in the ADM[…]

Exadata

Treinamento Oracle Exadata Advanced Experience

Olá pessoal, é com grande prazer que trago para vocês um treinamento inédito no Brasil focado totalmente na tecnologia do Oracle Exadata Database Machine. O treinamento é inédito porque fui eu que criei e não tem outro igual. 🙂 O treinamento visa embasar a teoria que envolve essa tecnologia e também demonstrar de maneira prática[…]