database:oracle:rac:commands
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
database:oracle:rac:commands [2018/12/03 11:24] – created odefta | database:oracle:rac:commands [2018/12/03 21:16] – odefta | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Oracle RAC commands ====== | ====== Oracle RAC commands ====== | ||
- | ===== Check cluster | + | ===== Check one node status ===== |
+ | |||
+ | Execute as root: | ||
+ | |||
+ | < | ||
+ | crsctl check crs | ||
+ | </ | ||
+ | |||
+ | 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 | 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: | ||
+ | Node1: lptxrac122n1 | ||
+ | Node2: lptxrac122n2 | ||
+ | |||
+ | < | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | 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" | ||
+ | </ | ||
+ | |||
+ | ===== Check if instances are running in RAC ===== | ||
+ | |||
+ | Suppose global SID name is SNT: | ||
+ | |||
+ | < | ||
+ | srvctl status database -db SNT | ||
+ | </ | ||
+ | |||
+ | Output should be: | ||
+ | |||
+ | < | ||
+ | Instance SNT1 is running on node lptxrac122n1 | ||
+ | Instance SNT2 is running on node lptxrac122n2 | ||
+ | </ | ||
+ | |||
+ | ===== Find server pool name ===== | ||
+ | |||
+ | < | ||
+ | srvctl status srvpool | ||
+ | </ | ||
+ | |||
+ | Possible output: | ||
+ | |||
+ | < | ||
+ | Server pool name: Free | ||
+ | Active servers count: 0 | ||
+ | Server pool name: Generic | ||
+ | Active servers count: 2 | ||
+ | </ | ||
+ | |||
+ | ===== Automate start / stop PDB ===== | ||
+ | |||
+ | Adding the service (for admin-managed database) with PDB name SNTL: | ||
+ | |||
+ | < | ||
+ | srvctl add service -db SNT -service plug -preferred SNT1 -available SNT2 -tafpolicy BASIC -policy AUTOMATIC -failovertype SELECT -failovermethod BASIC -failoverretry 5 -pdb SNTL -verbose | ||
+ | </ | ||
+ | |||
+ | Start the service: | ||
+ | |||
+ | < | ||
+ | srvctl start service -db SNT -s plug | ||
+ | </ | ||
+ | |||
+ | Check that the PDB is started: | ||
+ | |||
+ | < | ||
+ | sqlplus / as sysdba | ||
+ | SQL*Plus: Release 12.2.0.1.0 Production on Mon Dec 3 20:11:28 2018 | ||
+ | |||
+ | Copyright (c) 1982, 2016, Oracle. | ||
+ | |||
+ | |||
+ | Connected to: | ||
+ | Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production | ||
+ | |||
+ | SQL> COLUMN NAME FORMAT A15 | ||
+ | SQL> COLUMN RESTRICTED FORMAT A10 | ||
+ | SQL> COLUMN OPEN_TIME FORMAT A30 | ||
+ | SQL> SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS; | ||
+ | |||
+ | NAME OPEN_MODE | ||
+ | --------------- ---------- ---------- ------------------------------ | ||
+ | PDB$SEED | ||
+ | 00 | ||
+ | |||
+ | SNTL READ WRITE NO | ||
+ | 00 | ||
+ | |||
+ | |||
+ | SQL> exit | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
database/oracle/rac/commands.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1