Today, I will explain a little about this tool that helps us identify communication problems regarding networks in OCI. What is Network Path Analyzer? Network Path Analyzer is a network reachability analysis tool based on real-time network configuration. Its primary data input is the network routing and security configuration in a customer tenancy, augmented with key network runtime state data, such as the status of a load balancer backend set or the state of a FastConnect virtual circuit. Network Path Analyzer answers the following questions that are essential for the cloud network operations ..read more

The Object Storage is an internet-scale, high-performance storage platform that offers reliable and cost-efficient data durability. The Object Storage service can store an unlimited amount of unstructured data of any content type, including analytic data and rich content, like images and videos. Object Storage is a regional cloud service. Buckets are logical containers created in a tenancy inside a region in which customer data is stored as objects. You can store a copy of all objects from one bucket in another bucket located inside a different region for redundancy. This copy can help yo ..read more

The Oracle Database Security Assessment Tool (DBSAT), currently in version 3.1.0 (January 2024), is a command-line tool focused on detecting potential security vulnerabilities. Its greatest scope occurs within the database but it also inspects operating system and network components (listener) in search of failures. The tool provides insight into the current status of users, roles, permissions, and security control policies to promote successful approaches to mitigating potential security risks. What’s new in DBSAT 3.0 ? New checks added in DBSAT 3.0 include the newly introduced Oracle Databas ..read more

   I did this how-to with the purpose of you using it as a ” best practice” and having a regular backup of your Oracle Home in case you, or another guy on your team, accidentally remove part of or entire files and folders on it. I will reproduce the steps on Compute instance in OCI; I hope that is not your case on a production database server, but nobody knows when shit happens, and you may need this procedure to recover and put your database online after an accident.    As you can see, my database is up and running in my Oracle 19c home. The location of my ORACLE HOME is ..read more

Today, we will configure the email delivery service to send emails using Always Free resources. First, you need access to an OCI environment. When you have an environment, ensure your user has been assigned to a group with permission to manage the email-family resources. It would be best if you had a DNS domain to publish your domain keys identified mail (DKIM) and sender policy framework (SPF) records. 1. Generate SMTP credentials SMTP credentials are necessary to send email through Email Delivery.  Remember that each user is limited to a maximum of two SMTP credentials. Log i ..read more

My client asked me for help. He needs to update the DEV environment every month The current process (using export-import) takes a few days. To reduce the time, an alternative approach was implemented Replicate constantly all production changes to a standby database.   This is achieved using Data Guard For the refresh Stop synchronization Drop old DEV databases Create new DEV databases by cloning from the standby database Restart synchronization The new procedure should considerably reduce the refresh time considerably to a few hours. 1      &n ..read more

Estou com um problem em um compute instance no OCI, e o support me solicitou um OSWatcher para analisar o ambiente. Diante disso como eu não tinha nenhum documento facilitando uma busca rápida, resolvi escrever este post para pode ajudar outras pessoas que no momento de necessitarem de uma consulta rápida não precisem ficar se matando para achar as informações. Vamos lá para nossa instalação. Relatórios de desempenho do Oracle OSWatcher A ferramenta OSWatcher é uma ferramenta muito interessante que coleta e mantém dados estatísticos dos recursos do sistema operacional periodicamente e nos rep ..read more

Olá pessoal Hoje eu enfretei um problema one uma Compute instance ficou sem operação até eu forçar um reboot para entender o que estava ocorrendo. Recebi esta mensagem na console: Me fez lembrar do ORA-0600, mas vamos lá do que se trata este erro. A VM ou Compute Instance, envia uma solicitação de protocolo de resolução de endereço (ARP) para a placa de interface de rede virtual (VNIC) da instância. Se o ARP falhar, a máquina virtual (VM) será marcada como sem resposta e a mensagem de erro aparecerá. Diante disso qual seria as possiveis soluções para analisar e arrumar isso: Verifique as mét ..read more

Today, I tried to connect to my server on the Oracle Cloud Infrastructure instance, but either I lost my private key or, for some unknown reason, your opc user SSH key got corrupted or deleted. It might be scary at first, but the process of recovering an opc user SSH key on Oracle Cloud Infrastructure is easier than you think. Stop the instance that you can’t log in to.  Stop the instance that you can’t connect to. In the Oracle Cloud Infrastructure Console, go to the details page for the instance and click Stop. 2. Detach the boot volume. Detach the boot volume. In the Boot Volum ..read more

Fala pessoal !!!! Mais um artigo agora um pouco menos técnico, falando um pouco da carreira de DBA, como será daqui alguns anos. Bem venho conversando com diversas pessoas que sempre vem dizendo a carreira de DBA está acabando e será um caminho sem volta. Bem depende, como em toda evolução assim como foi na Revolução Industrial onde grandes transformações econômicas e sociais ocorreram, sugiram também diversas profissões que até então não existiam.  Com toda esta automação, IA entre outros o DBA está cada vez mais migrando para outras importantes carreiras. Minha resposta é depende como ..read more