Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

SAP / Oracle on Linux Cheat Sheet (DRAFT) by

Baic commands to administrate SAP / Oracle on Linux

This is a draft cheat sheet. It is a work in progress and is not finished yet.

SAP

 
Make sure to run these commands as <si­­d>adm user

Monitoring SAP instances

sapcontrol -nr <nr> -function GetSys­tem­Ins­tan­ceList
Shows all configured instances and their respective status

Starting and stopping SAP instances

sapcontrol -nr <nr> -function Start
Starts the given SAP instance
sapcontrol -nr <nr> -function Stop
Stops the given SAP instance

SAP log file locations

/usr/s­ap/­<SI­D>/­<IN­STA­NCE­>/work/

Workprocess and other log files
 
/home/­<si­d>a­dm/­[st­art­|st­op]­sap­_<I­NST­ANC­E>.log

Startup and shutdown trace

Oracle

 
Make sure to run these commands as ora<si­­d> user

Monitoring Oracle instances

lsnrctl status
Displays the status or the Oracle listener

Starting the Oracle listener

lsnrctl start
Starts the Oracle listener

Oracle log file locations

/oracl­e/<­SID­>/s­apt­rac­e/d­iag­/rd­bms­/<s­id>/
<SI­D>/­tra­ce/­alt­ert­_<S­ID>.log

Oralce instance log
 

Cluster

 
Make sure to run these commands as root user

Monitoring the Cluster status

crm_mon -1Arfj
Displays the configured Cluster resources and their respective status

Manging cluster resources

crm resource start <na­me>
Starts the given resource
crm resource stop <na­me>
Stops the given resource
crm resource cleanup <na­me>
Removes a given resources failure state (and does a recheck)

Migrating Cluster resources

crm resource migrate <re­sou­rce> PT<­N>M
Forces a resource away from the current node for N minutes