Files
notes/tiddlywiki/CRS resources check examples.txt
2026-03-12 22:01:38 +01:00

9 lines
485 B
Plaintext
Executable File

# not started databases
crsctl status resource -w "((TYPE = ora.database.type) AND (LAST_SERVER = $(hostname -s)) AND (STATE != ONLINE))"
# not started services
crsctl status resource -w "((TYPE = ora.service.type) AND (LAST_SERVER = $(hostname -s)) AND (STATE != ONLINE))"
# list in tabular mode services not started but having a target=ONLINE
crsctl status resource -t -w "((TYPE = ora.service.type) AND (LAST_SERVER = $(hostname -s)) AND (TARGET = ONLINE) AND (STATE != ONLINE))"