Compare RAC Database Instance Parameters

SELECT p1.name, p1.value val_inst1, p2.value val_inst2
FROM gv$parameter p1
JOIN gv$parameter p2 ON p1.name = p2.name
WHERE p1.inst_id = 1
AND p2.inst_id = 2
AND p1.value != p2.value
AND p1.name NOT IN ('instance_number', 'instance_name',
'local_listener','thread','undo_tablespace','core_dump_dest');

Compare Database Parameters

    set lines 300 
    col name form a30 
    col cdblab01 form a60 
    col cdblab02 form a60 
    select a.name, a.value "CDBLAB01", b.value "CDBLAB02" 
    from v$parameter a, v$parameter@cdblab02 b 
    where a.name = b.name 
    and a.value <> b.value 
    and a.name not in ('control_files','background_dump_dest','user_dump_dest','core_dump_dest','audit_file_dest','db_name', 
                       'db_unique_name','dg_broker_config_file1','dg_broker_config_file2','instance_name', 'service_names','dispatchers','spfile');