Category Archives: RAC

Oracle Tools for RAC / Cluster systems

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

Service Tools Bundle

DCLI    Doc

ED360

eAdam

doc for eAdam

Tanel Poder Scripts

SQL Developer

SQL Developer Data Modeler

Oracle RAC Instances

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
/

SVRCTL Commands Cluster Health

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 ;

login as dbaroot

crsctl stop crs