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 revisionBoth sides next revision
database:oracle:rac:commands [2018/12/03 21:15] odeftadatabase:oracle:rac:commands [2018/12/03 21:16] 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> </code>
  
database/oracle/rac/commands.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1