Differences

This shows you the differences between two versions of the page.

--- database:oracle:rac:commands [2018/12/03 12:41] – odefta
+++ database:oracle:rac:commands [2018/12/03 20:47] – odefta
@@ Line 47: / Line 47: @@
 ===== Verify DBCA requirements (before installing database instance) =====
-GRID_HOME: /oracle-inst
+GRID_HOME: /oracle-inst \\
-ORACLE_HOME: /home/oracle/app/oracle/product/12.2.0/dbhome_1
+ORACLE_HOME: /home/oracle/app/oracle/product/12.2.0/dbhome_1 \\
+Node1: lptxrac122n1
+Node2: lptxrac122n2
 <code>
 /oracle-inst/bin/cluvfy stage -pre dbcfg -fixup -n lptxrac122n1,lptxrac122n2 -d /home/oracle/app/oracle/product/12.2.0/dbhome_1
 </code>
+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:
@@ Line 174: / Line 178: @@
 "Hard Limit: maximum open file descriptors" was successfully fixed on all the applicable nodes
 </code>
+===== Check if instances are running in RAC =====
+Suppose global SID name is SNT:
+<code>
+srvctl status database -db SNT
+</code>
+Output should be:
+<code>
+Instance SNT1 is running on node lptxrac122n1
+Instance SNT2 is running on node lptxrac122n2
+</code>
+===== Find server pool name =====
+<code>
+srvctl status srvpool
+</code>
+Possible output:
+<code>
+Server pool name: Free
+Active servers count: 0
+Server pool name: Generic
+Active servers count: 2
+</code>