lucaslellis

define degree=4

purge dba_recyclebin;

exec dbms_stats.gather_dictionary_stats(degree=>&&degree);

exec dbms_stats.gather_table_stats('SYS','X$KTFBUE', degree=>&&degree);

lucaslellis

Grid Infrastructure Deconfig - Node 1

Run as root user:

/u01/app/19.21/grid/crs/install/roothas.sh -deconfig -force

Grid Infrastructure Detach - Node 1

lucaslellis

Para quem roda labs em ambientes de cloud, como é o meu caso, pode encontrar em algumas versões do Oracle restrições como as listadas abaixo:

• Rejecting connection from node 2 as MultiNode RAC is not supported in this Configuration
• ORA-65010 When Oracle Database Hosted on AWS Cloud (Doc ID 2328600.1)

A solução de contorno nestes casos é bloquear o IP 169.254.169.254, que é usado pelos provedores de cloud como endpoint da API de metadata.

Para fazer isso de maneira temporária, basta apenas o comando abaixo:

lucaslellis

#!/bin/bash

# Interpretting the listener log entries for incoming connections (Doc ID 2322110.1)
# https://support.oracle.com/epmos/faces/DocContentDisplay?id=2322110.1

tail -600000 listener.log | grep -E '22-FEB-2023 04:3' | grep -i -c estab

tail -100000 listener.log | grep -E '23-FEB-2023 04:4[6789]' | grep -i estab

# https://pankajx.wordpress.com/2020/06/10/listener-connection-storm/

lucaslellis

#!/bin/ksh
#based on explanations of pmap in http://www.makelinux.co.il/books/lkd2/ch14lev1sec2
# Author: Marc Billette
# Ref: http://www.pythian.com/blog/oracle-instance-memory-usage/
# Description: Calculates RAM memory used by an Oracle Instance
# Changes
# Austin Hackett - 06/06/2012 - Extra greps to exclude POSIX Shared Memory
# Lucas Lellis - 11/16/2013 - Error treatment when there are no connections
#                           - Average memory for background processes
#                           - Treating job queue processes as user process, as in v$session