User Tools

Site Tools


database:oracle:rac:commands

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
database:oracle:rac:commands [2018/12/03 21:15] odeftadatabase:oracle:rac:commands [2018/12/03 21:25] odefta
Line 221: Line 221:
 <code> <code>
 srvctl start service -db SNT -s plug 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:
 +                                      00
 +
 +SNTL            READ WRITE NO         03-DEC-18 07.18.06.241 PM +01:
 +                                      00
 +
 +
 +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> </code>
  
database/oracle/rac/commands.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1