Oracle RAC Instance Start/Stop steps



Status Check :

$ srvctl status database -d QARAC11G
Instance QARAC11G1 is running on node inqarc01
Instance QARAC11G2 is running on node inqarc02
Instance QARAC11G3 is running on node inqarc03

configuration check :

$ srvctl config database -d QARAC11G
inqarc01 QARAC11G1 /u01/app/oracle/product/db/11.1.0
inqarc02 QARAC11G2 /u01/app/oracle/product/db/11.1.0
inqarc03 QARAC11G3 /u01/app/oracle/product/db/11.1.0

Stop Databases :

$ srvctl stop database -d QARAC11G

Start Databases :

$ srvctl start database -d QARAC11G

 Stop/Start Listener in node:

$ srvctl stop listener -n inqarc01
$ srvctl start listener -n inqarc01
 

Oracle ASM Disks Space Utilization:


SELECT
name                                     group_name
, sector_size                              sector_size
, block_size                               block_size
, allocation_unit_size                     allocation_unit_size
, state                                    state
, type                                     type
, total_mb                                 total_mb
, (total_mb - free_mb)                     used_mb
, ROUND((1- (free_mb / total_mb))*100, 2)  pct_used
FROM
v$asm_diskgroup
ORDER BY
name
/

SQL Query to find Session Locks and Table Locks in Oracle Database.!


set serveroutput on
BEGIN
dbms_output.enable(1000000);
for do_loop in (select session_id, a.object_id, xidsqn, oracle_username, b.owner owner,
b.object_name object_name, b.object_type object_type
FROM v$locked_object a, dba_objects b
WHERE xidsqn != 0
and b.object_id = a.object_id)
loop
dbms_output.put_line('.');
dbms_output.put_line('Blocking Session : '||do_loop.session_id);
dbms_output.put_line('Object (Owner/Name): '||do_loop.owner||'.'||do_loop.object_name);
dbms_output.put_line('Object Type : '||do_loop.object_type);
for next_loop in (select sid from v$lock
where id2 = do_loop.xidsqn
and sid != do_loop.session_id)
LOOP
dbms_output.put_line('Sessions being blocked : '||next_loop.sid);
end loop;
end loop;
END;
/

=============================================================