RAC | IT Remote

ORAchk Health Checks For The Oracle Stack 1268927.1

ORAchk replaces the popular RACcheck tool, extending the coverage based on prioritization of top issues reported by users, to proactively scan for known problems.

Oracle Exadata Best Practices 757552.1

Trace File Analyzer Collector (aka TFA) 1513912.1

TFA Collector - Tool for Enhanced Diagnostic Gathering 1513912.1

OSWatcher 301137.1

Procwatcher 459694.1

ORATOP => 1500864.1

Oratop DOC

SQLT => 215187.1

Tutorial

RDA 314442.1 DA Diagnostic Assistant (GUI to the RDA) - both are covered by the doc id

DCLI Doc

SQL Developer Data Modeler

SET LINESIZE  145
SET PAGESIZE  9999
SET VERIFY    off

COLUMN instance_name          FORMAT a13         HEAD 'Instance|Name / Number'
COLUMN thread#                FORMAT 99999999    HEAD 'Thread #'
COLUMN host_name              FORMAT a13         HEAD 'Host|Name'
COLUMN status                 FORMAT a6          HEAD 'Status'
COLUMN startup_time           FORMAT a20         HEAD 'Startup|Time'
COLUMN database_status        FORMAT a8          HEAD 'Database|Status'
COLUMN archiver               FORMAT a8          HEAD 'Archiver'
COLUMN logins                 FORMAT a10         HEAD 'Logins?'
COLUMN shutdown_pending       FORMAT a8          HEAD 'Shutdown|Pending?'
COLUMN active_state           FORMAT a6          HEAD 'Active|State'
COLUMN version                                   HEAD 'Version'

SELECT
instance_name || ' (' || instance_number || ')' instance_name
, thread#
, host_name
, status
, TO_CHAR(startup_time, 'DD-MON-YYYY HH:MI:SS') startup_time
, database_status
, archiver
, logins
, shutdown_pending
, active_state
, version
 FROM
   gv\$instance
ORDER BY
   instance_number
/

SCAN Information
echo "Status SCAN-------------------------------------"
echo "================================================"
srvctl status scan

Status SCAN-------------------------------------
================================================
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node host121
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node host120
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node host120

echo
echo "Status listener---------------------------------"
echo "================================================"
srvctl status listener

echo
echo "Status config SCAN------------------------------"
echo "================================================"
srvctl config scan

echo
echo "Status config SCAN_LISTENER---------------------"
echo "================================================"
srvctl config scan_listener

echo
echo "Services config --------------------------------"
echo "================================================"
# srvctl status service -d TEST01
Service TEST01_SVC_01 is running on instance(s) TEST011,TEST012

srvctl config - will list databases configured in the cluster

once the databases are listed you can look at the config of each one via this command
srvctl config database -d ;

shutdown on one node

srvctl stop database -d -i ;

crsctl stop crs

ITRemote