Differences

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

--- database:oracle:rac:commands [2018/12/03 10:46] – odefta
+++ database:oracle:rac:commands [2023/07/04 16:36] (current) – external edit 127.0.0.1
@@ Line 178: / 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>
+===== Automate start / stop PDB =====
+Adding the service (for admin-managed database) with PDB name SNTL:
+<code>
+srvctl add service -db SNT -service plug -preferred SNT1 -available SNT2 -tafpolicy BASIC -policy AUTOMATIC -failovertype SELECT -failovermethod BASIC -failoverretry 5 -pdb SNTL -verbose
+</code>
+Start the service:
+<code>
+srvctl start service -db SNT -s plug
+</code>
+Check that the PDB is started:
+<code>
+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:
+SNTL            READ WRITE NO         03-DEC-18 07.18.06.241 PM +01:
+SQL> exit
+</code>
+Full custom URL to connect from java:
+<code>
+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)))
+</code>