RAC

--Display cluster status
crs_stat –t

--Start all offline services
crs_start –all

--See the crs configuration
crs_start –p

--Start nodeapps (listener, VIP, ONS and GSD)
srvctl start nodeapps -n

--Stop nodeapps (listener, VIP, ONS and GSD)
srvctl stop nodeapps -n

--Start ASM
srvctl start asm -n

--Stop ASM
srvctl stop asm -n

--Start instance
srvctl start instance -d-i

--Stop instance
srvctl stop instance -d-i >

--Start the cluster on a node
sudo su -
/etc/init.crs start 

--Stop the cluster on a node
sudo su -
/etc/init.crs stop 

--Disable the cluster from starting after reboot
sudo su -
/etc/init.crs disable

--Enable the cluster to automatically start after reboot
sudo su -
/etc/init.crs enable

--Get session details from SID
set linesize 130
set pages 1000
col sid format 999999
col username format a20
col osuser format a15
select a.sid, a.serial#,a.username, a.inst_id, a.osuser, b.spid
from gv$session a, gv$process b
where a.paddr= b.addr
and a.sid='&sid'
order by a.inst_id;

--Get session details from OS process id
set linesize 130
set pages 1000
col sid format 999999
col username format a20
col osuser format a15
select a.sid, a.serial#,a.username, a.inst_id, a.osuser, b.spid
from gv$session a, gv$process b
where a.paddr= b.addr
and b.spid='&spid'
order by a.inst_id;

--Check session status and count in all nodes in RAC
set linesize 130
set pages 1000
select gvinst.INSTANCE_NAME,gvsess.TYPE,gvsess.STATUS,COUNT(*) from gv$session gvsess,gv$instance gvinst where gvsess.INST_ID=gvinst.INSTANCE_NUMBER group by gvinst.INSTANCE_NAME,gvsess.TYPE,gvsess.STATUS order by gvinst.INSTANCE_NAME;