Test Multicast on Private Interconnect (and get maximum MTU) There are several ways to test multicast communication using udp. I was debugging an oracle Clusterware installation – the clusterware on the second node would not…
Rename and compress listener.log file [grid@server]$ lsnrctl LSNRCTL> set current_listener listener LSNRCTL> set log_status off [grid@server]$ mv listener.log listener.log.temp [grid@server]$ lsnrctl LSNRCTL> set current_listener listener LSNRCTL> set log_status on — compress (or delete) [grid@server]$ gzip…
Installing and Configuring Oracle Clusterware The installation procedure for Oracle clusterware (Grid Infrastructure) is well documented in Oracle documentation. This post contains the titles of MOS documents that will be useful before, during, or after…
Scenario : Oracle Direct NFS, NFS on Windows Server you are using Oracle Direct NFS, and the NFS is running on Windows, there is a potential issue with permissions and ownership changes required. Example An…
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’)
— set ORACLE env first export ORACLE_SID=ORCL12 export ORACLE_HOME=/oracle/….. oracle@oravm:~/ [ORCL12] rman target / Recovery Manager: Release 12.1.0.1.0 – Production on Wed Dec 27 09:45:33 2017 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All…
— get list of file descriptors # lsof /dev/mapper/XYZ_* — example output oracle 31814 oracle 256u BLK 253,7 0t0 20968 /dev/mapper/../dm-7 — above, fd 256 is open for update (could also be w (write)) –…
cluvfy stage -post crsinst -n nserver-rac1,server-rac2