Buenas!!, hace rato no escribo. En esta oportunidad les
quiero mostrar como utilizar RDA, si bien es una herramienta que existe hace
tiempo, no todos la conocen ni saben para que la podrían utilizar.
RDA es “Remote
Diagnostic Agent”, es una tool de Oracle gratuita (Cuando nos referimos a
gratuita que se necesita una cuenta de support con cualquier licencia, no se
abona nada extra).
Nota de referencia de RDA:
Oracle Support Document 314422.1 (Remote Diagnostic Agent (RDA) - Getting
Started) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=314422.1
Poque usar RDA?
Por lo gral el RDA lo pide support para tener un panorama general del ambiente frente un issue en algún ticket de support, pero también lo podemos usar nosotros para validar nuesto ambiente ya que recompila info de todos los servicios y productos de la instalación.
Productos Soportados
Esta es la lista de productos soportados en la última versión de RDA que existe a la fecha:
- OLAP Products (Express Server,
Financial Analyzer, and Demand Planning Server)
- Oracle Application Server (iAS
1.0.2.x/9.0.x/10.1.2.x/10.1.3.x,10.1.4.x,WebLogic Server (WLS) Release
9.x, 10.x, 11g and 12c (WLS), HTTP Server,WebCache,J2EE/OC4J)
- Oracle Billing and Revenue
Management products
- Oracle
BPEL Process Manager
- Oracle Collaboration Suite
(Email Server,Calendar,Discussions,Content
Services,Workspaces,WebClient,and Wireless)
- Oracle
Data Integrator
- Oracle Developer (Forms and
Reports)
- Oracle Ebusiness Suite 11i and
12
- Oracle
Enterprise Content
- Oracle
Enterprise Single Sign-on
- Oracle Enterprise performance
management (Hyperion) products
- Oracle
Guardian
- Oracle
Identity Management products
- Oracle JDBC/PRO *C/ODBC and
other development client related information
- Oracle Management Server and
Intelligent Agent (Grid Server, Agent Server, DB Control)
- Oracle
Networking products
- Oracle RAC Cluster
(Single/Multiple Nodes, Automatic Storage Management, Oracle Cluster File
System, Data Guard)
- Oracle RDBMS Server (Standard
and Enterprise Editions)
- Oracle
Retail (Retek)
- Oracle
SQL*Plus/iSQL*Plus
- Oracle
TimesTen In-Memory Database
- Oracle
Universal Archive (11g)
- PeopleSoft
- Siebel
Y para este caso en particular tenemos justo una nota:
Oracle Support Document 359395.1 (Remote Diagnostic Agent (RDA) - RAC Cluster Guide) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=359395.1
1. Descargar RDA según plataforma: (en mi caso Oracle Linux 7)
Verán que es compatible con muchas plataformas!
Cuando lo descarguen, presten atención a la versión y año,
ya que no lo muestra ordenado.
2.
Próximo paso lo descargo y lo pego por lo gral
en el home del usuario grid.
|
sftp> put p21769913_204201020_LINUX.zip Uploading p21769913_204201020_LINUX.zip to /home/oracle/p21769913_204201020_LINUX.zip 100% 20637KB 322KB/s 00:01:04 |
Hay que tomar en cuenta que como vamos a
validar un RAC, el script lo debemos ejecutar como grid. No viene de más
validar que el .zip que descargamos no tenga ningún problema, para eso se
realiza una rápida validación:
|
[grid@]$ ./rda.sh -cv Loading the file list ... Checking the directory [D_RDA] . ... Checking the directory [D_RDA] engine ... Checking the directory [D_RDA_ADM] model ... Checking the directory [D_RDA_CHK] APPS ... Checking the directory [D_RDA_CHK] BI ... Checking the directory [D_RDA_CHK] CGBU ... Checking the directory [D_RDA_CHK] DB ... Checking the directory [D_RDA_CHK] EM ... Checking the directory [D_RDA_CHK] OFM ... Checking the directory [D_RDA_CHK] TEST ... Checking the directory [D_RDA_COL] APPS ... Checking the directory [D_RDA_COL] BI ... Checking the directory [D_RDA_COL] CGBU ... Checking the directory [D_RDA_COL] CLOUD ... Checking the directory [D_RDA_COL] DA ... Checking the directory [D_RDA_COL] DB ... Checking the directory [D_RDA_COL] EM ... Checking the directory [D_RDA_COL] EXPLORER ... Checking the directory [D_RDA_COL] OFM ... Checking the directory [D_RDA_COL] OS ... Checking the directory [D_RDA_COL] PGBU ... Checking the directory [D_RDA_COL] RDA ... Checking the directory [D_RDA_COL] SAMPLE ... Checking the directory [D_RDA_COL] TOOL ... Checking the directory [D_RDA_CSS] . ... Checking the directory [D_RDA_DAT] . ... Checking the directory [D_RDA_DFW] cv0200 ... Checking the directory [D_RDA_INC] Convert/Common ... Checking the directory [D_RDA_INC] Convert/DB/LOG ... Checking the directory [D_RDA_INC] Convert/OFM/OIM ... Checking the directory [D_RDA_INC] Convert/OS/INST ... Checking the directory [D_RDA_INC] Convert/OS/OS ... Checking the directory [D_RDA_INC] Convert/RDA/CONFIG ... Checking the directory [D_RDA_INC] Convert/TOOL/ALERT ... Checking the directory [D_RDA_INC] Convert/TOOL/COMPLY ... Checking the directory [D_RDA_INC] IRDA ... Checking the directory [D_RDA_INC] IRDA/CV0200 ... Checking the directory [D_RDA_INC] RDA ... Checking the directory [D_RDA_INC] RDA/Agent ... Checking the directory [D_RDA_INC] RDA/Driver ... Checking the directory [D_RDA_INC] RDA/Handle ... Checking the directory [D_RDA_INC] RDA/Library ... Checking the directory [D_RDA_INC] RDA/Limit ... Checking the directory [D_RDA_INC] RDA/Local ... Checking the directory [D_RDA_INC] RDA/Object ... Checking the directory [D_RDA_INC] RDA/Operator ... Checking the directory [D_RDA_INC] RDA/Request ... Checking the directory [D_RDA_INC] RDA/SDCL ... Checking the directory [D_RDA_INC] RDA/SDSL ... Checking the directory [D_RDA_INC] RDA/Target ... Checking the directory [D_RDA_INC] RDA/Token ... Checking the directory [D_RDA_INC] RDA/UI ... Checking the directory [D_RDA_INC] RDA/Value ... Checking the directory [D_RDA_INC] RDA/Web ... Checking the directory [D_RDA_MSG] charset ... Checking the directory [D_RDA_MSG] desc ... Checking the directory [D_RDA_MSG] en ... Checking the directory [D_RDA_MSG] fr ... Checking the directory [D_RDA_POD] en ... No issues found |
4.
Chequear Nodos y conectividad:
|
[grid@nodo01 rda]$ olsnodes nodo01 nodo01 [grid@nodo01 rda]$ ssh nodo01 Last login: Sat Aug 21
16:08:38 2021 [grid@nodo02 ~]$ exit |
5.
Para poder iniciar una recolección de
información sobre el RAC, RDA necesita realizar una configuración inicial. Voy
a mostrar el comando para la última versión RDA 8.X.
Recomiendo tener las variables de ambiente
seteadas previamente, para que el RDA las reconozca automáticamente.
|
[grid@nodo1rda]$ ./rda.sh -vXRda start CLOUD -p
Rac_Assessment Creating collection "output" ... -
Trying to identify the domain ... (can take time) Inside DFT
scenario, define the input and profile targets Inside DFT
scenario, check Oracle home or Middleware presence -
RDA:DCbegin ... ------------------------------------------------------------------------------ RDA.BEGIN: Initializes the Data Collection ------------------------------------------------------------------------------ Enter the Oracle home to be used for data analysis Press Return to accept the default
(/u01/app/grid/18c) > [ENTER] -
RDA:DCconfig ... ------------------------------------------------------------------------------ RDA.CONFIG: Collects Key Configuration Information ------------------------------------------------------------------------------ -
RDA:DCocm ... ------------------------------------------------------------------------------ RDA.OCM: Set up the Configuration Manager Interface ------------------------------------------------------------------------------ -
RDA:DCstatus ... ------------------------------------------------------------------------------ RDA.STATUS: Produces the Remote Data Collection
Reports ------------------------------------------------------------------------------ -
RDA:DCload ... ------------------------------------------------------------------------------ RDA.LOAD: Produces the External Collection Reports ------------------------------------------------------------------------------ -
RDA:DCfilter ... ------------------------------------------------------------------------------ RDA.FILTER: Controls Report Content Filtering ------------------------------------------------------------------------------ -
RDA:DCend ... ------------------------------------------------------------------------------ RDA.END: Finalizes the Data Collection ------------------------------------------------------------------------------ In CRS start scenario, getting nodes using
/u01/app/grid/18c/bin/olsnodes 2>/dev/null ------------------------------------------------------------------------------ Requesting common cluster information ------------------------------------------------------------------------------ Enter the absolute path of the directory where RDA
will be installed on the remote nodes. Press Return to accept the default (/home/grid/rda) >[ENTER] Do you want RDA to use an alternative login to
execute remote requests (Y/N)? Press Return to accept the default (N) > [ENTER] In CRS start scenario, getting local node
information In CRS start scenario, pinging node prorasf02 ------------------------------------------------------------------------------ Requesting information for node prorasf01 ------------------------------------------------------------------------------ Enter the Oracle home to be analyzed on the node
prorasf01 Press Return to accept the default
(/u01/app/grid/18c) > [ENTER] Enter the Oracle SID to be analyzed on the node
prorasf01 > +ASM1 ------------------------------------------------------------------------------ Requesting information for node prorasf02 ------------------------------------------------------------------------------ Enter the Oracle home to be analyzed on the node
prorasf02 Press Return to accept the default
(/u01/app/grid/18c) > [ENTER] Enter the Oracle SID to be analyzed on the node
prorasf02 > +ASM2 -
RDA:DCremote ... ------------------------------------------------------------------------------ RAC Setup Summary ------------------------------------------------------------------------------ Nodes: . NOD001
host01/+ASM1 . NOD002
host02/+ASM2 2 nodes found [grid@ rda]$ |
6.
Ejecución Validar conectividad de los nodos
configurados en el RDA (este comando también recolecta información) (Este paso
demora según los recursos del servidor unos 20 a 30m)
|
[grid@host1]$ ./rda.sh -vC RDA.REMOTE list Collecting diagnostic data ... ------------------------------------------------------------------------------ RDA Data Collection Started 21-Aug-2021 16:47:32 ------------------------------------------------------------------------------ Processing RDA.BEGIN module ... Inside BEGIN
module, testing the RDA engine code build Inside BEGIN
module, testing the report directory Inside BEGIN
module, testing the module targets Inside BEGIN
module, launching parallel executions Processing RDA.CONFIG module ... Inside CONFIG
module, listing Oracle homes Inside CONFIG
module, getting Oracle home inventory (can take time) Processing RDA.REMOTE module ... NOD001: Detecting storage type NOD001: Running RDA command NOD002: Detecting storage type NOD002: Installing RDA software NOD002: Running RDA command NOD001: Transfering report package NOD002: Transfering report package Processing RDA.END module ... Inside END
module, gathering system information Inside END
module, getting CPU information (linux) Inside END
module, getting memory information (linux) Inside END
module, producing the file catalog Inside END
module, producing target overview Inside END
module, waiting for parallel execution completion Inside END
module, producing setting overview ------------------------------------------------------------------------------ RDA Data Collection Ended 21-Aug-2021 16:57:05 ------------------------------------------------------------------------------ |
7.
Ver Reporte
El RDa, genera 2 .zip con la información de cada nodo que
nos deberíamos descargar y visualidar en un explorador.
Tomar en cuenta el espacio al descomprimirlos que pueden ser
pesados. (1G por nodo)
|
[grid@host1rda]$ ll output/remote/* -rw-r-----. 1 grid oinstall 135000000 ago 21 16:55
output/remote/RDA_nod001_output.zip -rw-r--r--. 1 grid oinstall 141063911 ago 21 16:56
output/remote/RDA_nod002_output.zip |
Una vez que lo descomprimimos para visualizar el reporte
abrimos el htm RDA_start.htm
Opción B.
También es posible ejecutar los paquetes disponibles aunque
no del todo actualizados en el mismo RDA
|
[grid@host1 rda]$ ./rda.sh -T hcve Processing HCVE tests ... Available Pre-Installation Rule Sets: 1.Oracle Database 10g R1 (10.1.0) Preinstall (Linux) Enter the HCVE rule set number or 0 to cancel the test Press Return to accept the default (0) > 26 Performing HCVE checks ... Test "RAC 10G DB and OS Best Practices
(Linux)" executed at 21-Aug-2021 17:36:22 Test Results ~~~~~~~~~~~~ ID
NAME RESULT VALUE ====== ====================
======= ========================================== P00010 ORA_CRS_HOME RECORD P00100 Database Name RECORD P00102 Database Version RECORD
P00104 Interconnect Network RECORD P00106 DB Block Size RECORD P00108 DB File Multiblock R RECORD P00120 Max Commit Propagati FAILED P00130 SYS.AUDSES$ Cache Si FAILED P00132 SYS.IDGEN1$ Cache Si FAILED P00140 Parallel Execution M FAILED P00150 Min Parallel Servers RECORD 0 P00152 parallel_min_servers FAILED P00200 $ORA_CRS_HOME Define FAILED Missing P00210 RemoteNodeInfo PASSED
All loaded P00220 _USR_ORA_DEBUG / CRS FAILED host01:Unknown host01:Unknown P00230 _USR_ORA_DEBUG / ORA FAILED hosts02:? hosts02:? P00240 rmem_max PASSED OK P00250 UDP Buffer Size PASSED
OK P00260 wmem_max PASSED OK P00270 rmem_default PASSED OK P00280 wmem_default PASSED OK P00290 SysRq Magic Keys FAILED
host01:16 host02:16 P00300 Oracle Executable Li PASSED linked P00310 hangcheck-timer FAILED
host01:Unknown host02:Unknown P00320 aio-max-size Setting FAILED hosts01:Unknown host02:Unknown P00330 Memory (32-bit) PASSED
OK P00340 Swap (32-bit) PASSED
OK P00350 Swap (64-bit) PASSED OK P00360 Patch List PASSED Complete Result file:
output/collect/DB_HCVE_P_RAC_lin_res.htm |
