database:oracle:rac:commands
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
database:oracle:rac:commands [2018/12/03 12:14] – odefta | database:oracle:rac:commands [2018/12/03 12:43] – odefta | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Oracle RAC commands ====== | ====== Oracle RAC commands ====== | ||
- | ===== Check cluster | + | ===== Check one node status ===== |
+ | |||
+ | Execute as root: | ||
< | < | ||
Line 9: | Line 11: | ||
Normal output: | Normal output: | ||
+ | < | ||
+ | [root@lptxrac122n1 ~]# crsctl check crs | ||
+ | CRS-4638: Oracle High Availability Services is online | ||
+ | CRS-4537: Cluster Ready Services is online | ||
+ | CRS-4529: Cluster Synchronization Services is online | ||
+ | CRS-4533: Event Manager is online | ||
+ | </ | ||
+ | ===== Check all nodes status ===== | ||
+ | |||
+ | Execute as root: | ||
+ | |||
+ | < | ||
+ | crsctl check cluster -all | ||
+ | </ | ||
+ | |||
+ | Normal output: | ||
+ | |||
+ | < | ||
+ | |||
+ | [root@lptxrac122n1 ~]# crsctl check cluster -all | ||
+ | ************************************************************** | ||
+ | lptxrac122n1: | ||
+ | CRS-4537: Cluster Ready Services is online | ||
+ | CRS-4529: Cluster Synchronization Services is online | ||
+ | CRS-4533: Event Manager is online | ||
+ | ************************************************************** | ||
+ | lptxrac122n2: | ||
+ | CRS-4537: Cluster Ready Services is online | ||
+ | CRS-4529: Cluster Synchronization Services is online | ||
+ | CRS-4533: Event Manager is online | ||
+ | ************************************************************** | ||
+ | </ | ||
+ | |||
+ | ===== Verify DBCA requirements (before installing database instance) ===== | ||
+ | |||
+ | GRID_HOME: / | ||
+ | ORACLE_HOME: | ||
+ | |||
+ | < | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | This command will generate a script (/ | ||
+ | |||
+ | Possible output: | ||
+ | |||
+ | < | ||
+ | Verifying Physical Memory ...PASSED | ||
+ | Verifying Available Physical Memory ...PASSED | ||
+ | Verifying Swap Size ...PASSED | ||
+ | Verifying Free Space: lptxrac122n2:/ | ||
+ | Verifying Free Space: lptxrac122n1:/ | ||
+ | Verifying User Existence: oracle ... | ||
+ | Verifying Users With Same UID: 1100 ...PASSED | ||
+ | Verifying User Existence: oracle ...PASSED | ||
+ | Verifying Group Existence: asmdba ...PASSED | ||
+ | Verifying Group Existence: oper ...PASSED | ||
+ | Verifying Group Existence: oinstall ...PASSED | ||
+ | Verifying Group Membership: asmdba ...PASSED | ||
+ | Verifying Group Membership: oinstall(Primary) ...PASSED | ||
+ | Verifying Group Membership: oper ...PASSED | ||
+ | Verifying Run Level ...PASSED | ||
+ | Verifying Hard Limit: maximum open file descriptors ...FAILED (PRVG-0446) | ||
+ | Verifying Soft Limit: maximum open file descriptors ...PASSED | ||
+ | Verifying Hard Limit: maximum user processes ...PASSED | ||
+ | Verifying Soft Limit: maximum user processes ...PASSED | ||
+ | Verifying Soft Limit: maximum stack size ...PASSED | ||
+ | Verifying Architecture ...PASSED | ||
+ | Verifying OS Kernel Version ...PASSED | ||
+ | Verifying OS Kernel Parameter: semmsl ...PASSED | ||
+ | Verifying OS Kernel Parameter: semmns ...PASSED | ||
+ | Verifying OS Kernel Parameter: semopm ...PASSED | ||
+ | Verifying OS Kernel Parameter: semmni ...PASSED | ||
+ | Verifying OS Kernel Parameter: shmmax ...PASSED | ||
+ | Verifying OS Kernel Parameter: shmmni ...PASSED | ||
+ | Verifying OS Kernel Parameter: shmall ...PASSED | ||
+ | Verifying OS Kernel Parameter: file-max ...PASSED | ||
+ | Verifying OS Kernel Parameter: ip_local_port_range ...PASSED | ||
+ | Verifying OS Kernel Parameter: rmem_default ...PASSED | ||
+ | Verifying OS Kernel Parameter: rmem_max ...PASSED | ||
+ | Verifying OS Kernel Parameter: wmem_default ...PASSED | ||
+ | Verifying OS Kernel Parameter: wmem_max ...PASSED | ||
+ | Verifying OS Kernel Parameter: aio-max-nr ...PASSED | ||
+ | Verifying Package: binutils-2.23.52.0.1 ...PASSED | ||
+ | Verifying Package: compat-libcap1-1.10 ...PASSED | ||
+ | Verifying Package: libgcc-4.8.2 (x86_64) ...PASSED | ||
+ | Verifying Package: libstdc++-4.8.2 (x86_64) ...PASSED | ||
+ | Verifying Package: libstdc++-devel-4.8.2 (x86_64) ...PASSED | ||
+ | Verifying Package: sysstat-10.1.5 ...PASSED | ||
+ | Verifying Package: ksh ...PASSED | ||
+ | Verifying Package: make-3.82 ...PASSED | ||
+ | Verifying Package: glibc-2.17 (x86_64) ...PASSED | ||
+ | Verifying Package: glibc-devel-2.17 (x86_64) ...PASSED | ||
+ | Verifying Package: libaio-0.3.109 (x86_64) ...PASSED | ||
+ | Verifying Package: libaio-devel-0.3.109 (x86_64) ...PASSED | ||
+ | Verifying Package: smartmontools-6.2-4 ...PASSED | ||
+ | Verifying Package: net-tools-2.0-0.17 ...PASSED | ||
+ | Verifying Current Group ID ...PASSED | ||
+ | Verifying CRS Integrity ... | ||
+ | Verifying Clusterware Version Consistency ...PASSED | ||
+ | Verifying CRS Integrity ...PASSED | ||
+ | Verifying Node Application Existence ...PASSED | ||
+ | Verifying Time zone consistency ...PASSED | ||
+ | Verifying Single Client Access Name (SCAN) ... | ||
+ | Verifying DNS/NIS name service ' | ||
+ | Verifying Name Service Switch Configuration File Integrity ...PASSED | ||
+ | Verifying DNS/NIS name service ' | ||
+ | Verifying Single Client Access Name (SCAN) ...WARNING (PRVG-11368) | ||
+ | Verifying ASM Integrity ... | ||
+ | Verifying Node Connectivity ... | ||
+ | Verifying Hosts File ...PASSED | ||
+ | Verifying Check that maximum (MTU) size packet goes through subnet ...PASSED | ||
+ | Verifying subnet mask consistency for subnet " | ||
+ | Verifying subnet mask consistency for subnet " | ||
+ | Verifying Node Connectivity ...PASSED | ||
+ | Verifying ASM Integrity ...PASSED | ||
+ | Verifying Database Clusterware Version Compatibility ...PASSED | ||
+ | Verifying File system mount options for path ORACLE_HOME ...PASSED | ||
+ | Verifying /dev/shm mounted as temporary file system ...PASSED | ||
+ | |||
+ | Pre-check for database configuration was unsuccessful. | ||
+ | Checks did not pass for the following nodes: | ||
+ | lptxrac122n1 | ||
+ | |||
+ | |||
+ | Failures were encountered during execution of CVU verification request "stage -pre dbcfg" | ||
+ | |||
+ | Verifying Hard Limit: maximum open file descriptors ...FAILED | ||
+ | lptxrac122n1: | ||
+ | was not found on node " | ||
+ | = " | ||
+ | |||
+ | Verifying Single Client Access Name (SCAN) ...WARNING | ||
+ | lptxrac122n2: | ||
+ | addresses, but SCAN " | ||
+ | "/ | ||
+ | |||
+ | lptxrac122n1: | ||
+ | addresses, but SCAN " | ||
+ | "/ | ||
+ | |||
+ | |||
+ | CVU operation performed: | ||
+ | Date: Dec 3, 2018 11:29:37 AM | ||
+ | CVU home: / | ||
+ | User: | ||
+ | ****************************************************************************************** | ||
+ | Following is the list of fixable prerequisites selected to fix in this session | ||
+ | ****************************************************************************************** | ||
+ | -------------- | ||
+ | Check failed. | ||
+ | -------------- | ||
+ | Hard Limit: maximum open lptxrac122n1 | ||
+ | file descriptors | ||
+ | |||
+ | |||
+ | Execute "/ | ||
+ | |||
+ | Press ENTER key to continue after execution of "/ | ||
+ | |||
+ | Fix: Hard Limit: maximum open file descriptors | ||
+ | Result: | ||
+ | "Hard Limit: maximum open file descriptors" | ||
+ | </ | ||
database/oracle/rac/commands.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1