Table of Contents

Oracle RAC commands

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

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-inst
ORACLE_HOME: /home/oracle/app/oracle/product/12.2.0/dbhome_1
Node1: lptxrac122n1 Node2: lptxrac122n2

/oracle-inst/bin/cluvfy stage -pre dbcfg -fixup -n lptxrac122n1,lptxrac122n2 -d /home/oracle/app/oracle/product/12.2.0/dbhome_1

This command will generate a script (/tmp/CVU_12.2.0.1.0_oracle/runfixup.sh) that should be run (in another console) as root to fix the problems found.

Possible output:

Verifying Physical Memory ...PASSED
Verifying Available Physical Memory ...PASSED
Verifying Swap Size ...PASSED
Verifying Free Space: lptxrac122n2:/tmp ...PASSED
Verifying Free Space: lptxrac122n1:/tmp ...PASSED
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 'rac122-cluster-scan' ...
    Verifying Name Service Switch Configuration File Integrity ...PASSED
  Verifying DNS/NIS name service 'rac122-cluster-scan' ...PASSED
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 "192.168.20.0" ...PASSED
    Verifying subnet mask consistency for subnet "10.128.72.0" ...PASSED
  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: PRVG-0446 : Proper hard limit for maximum open file descriptors
              was not found on node "lptxrac122n1" [Expected >= "65536" ; Found
              = "4096"].

Verifying Single Client Access Name (SCAN) ...WARNING
lptxrac122n2: PRVG-11368 : A SCAN is recommended to resolve to "3" or more IP
              addresses, but SCAN "rac122-cluster-scan" resolves to only
              "/10.128.79.23"

lptxrac122n1: PRVG-11368 : A SCAN is recommended to resolve to "3" or more IP
              addresses, but SCAN "rac122-cluster-scan" resolves to only
              "/10.128.79.23"


CVU operation performed:      stage -pre dbcfg
Date:                         Dec 3, 2018 11:29:37 AM
CVU home:                     /oracle-inst/
User:                         oracle
******************************************************************************************
Following is the list of fixable prerequisites selected to fix in this session
******************************************************************************************
--------------                ---------------     ----------------
Check failed.                 Failed on nodes     Reboot required?
--------------                ---------------     ----------------
Hard Limit: maximum open      lptxrac122n1        no
file descriptors


Execute "/tmp/CVU_12.2.0.1.0_oracle/runfixup.sh" as root user on nodes "lptxrac122n1" to perform the fix up operations manually

Press ENTER key to continue after execution of "/tmp/CVU_12.2.0.1.0_oracle/runfixup.sh" has completed on nodes "lptxrac122n1"

Fix: Hard Limit: maximum open file descriptors
Result:
"Hard Limit: maximum open file descriptors" was successfully fixed on all the applicable nodes

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.  All rights reserved.


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  RESTRICTED OPEN_TIME
--------------- ---------- ---------- ------------------------------
PDB$SEED        READ ONLY  NO         03-DEC-18 07.16.38.734 PM +01:
                                      00

SNTL            READ WRITE NO         03-DEC-18 07.18.06.241 PM +01:
                                      00


SQL> exit

Full custom URL to connect from java:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=lptxrac122n1.lab.ptx.axway.int)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=lptxrac122n2.lab.ptx.axway.int)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SNTL)(SERVER=DEDICATED)))