Index

Symbols

? 3.2.11
@ 3.2.11

A

administrative accounts 1.4.1.2.1.2
administrative users
- password files, multitenant environment 15.2.1.4
administrator privileges 1.4.1.2.1.2
ALTER DATABASE statement 15.1.4
- application roots 14.1.2, 17.2
- CDBs 15.5.1
- database partially available to users 15.3.2.1
- MOUNT clause 15.3.2.1
- OPEN clause 15.3.2.2
- READ ONLY clause 15.3.2.3
ALTER PLUGGABLE DATABASE statement 15.5.1, 16.4.2, 17.2
- DROP SNAPSHOT clause 12.5
- MATERIALIZE clause 8.6.3
- SET MAX_PDB_SNAPSHOTS clause 12.1.2.2, 12.2
- SNAPSHOT clause 12.3, 12.4
- SNAPSHOT COPY clause 8.6.3
- UNPLUG INTO clause 13.1, 14.3, 14.6
ALTER SESSION statement
- SET CONTAINER clause 15.2.2.2
- setting time zone 4.1.10.1
ALTER SYSTEM statement
- CDBs 15.4.2
- CONTAINER clause 15.4.2
- ENABLE RESTRICTED SESSION clause 15.3.2.4
- PDBs 16.3
- QUIESCE RESTRICTED 15.3.4.2
- RESUME clause 15.3.5
- SUSPEND clause 15.3.5
- UNQUIESCE 15.3.4.3
application common objects 1.4.1.4, 17.4, 17.4.1
- CONTAINERS clause 17.5.1
- creation 17.4.1.1, 17.4.3
- DDL statements 17.4.5
- DML statements 17.4.4, 17.5.1
- naming rules 1.4.1.1.2
- restrictions 17.4.2
application containers
- about 14.1
- administering 17, 17.1.1
- application common objects 1.4.1.1.2, 1.4.1.4, 17.4, 17.4.3, 17.5.1
- application PDBs 14.1.3
- application roots 14.1.2, 17.3.5.2
- applications 17.1.2.2, 17.1.2.3
- applications created implicitly 17.1.4
- application seeds 14.1.4
  - creating 14.5, 14.5.3
  - preparing for 14.5.2
- application synchronization 17.1.5
- application versions 17.1.2.3.2
- bulk inserts 17.3.9
- compatibility version 17.3.8
- container maps 17.6.1
  - creating 17.6.2
- creating 14.2, 14.2.3
- DML statements 17.5, 17.5.1
- dropping 14.4
- how an application upgrade works 17.1.2.3.1
- installing applications 17.1.2, 17.1.2.1, 17.1.2.2, 17.3.2.1
- managing applications 17.3.1
- migrating an application 17.1.3
- migrating applications into 17.3.5
- patching applications 17.1.2.4, 17.3.4.1, 17.3.4.2
- preparing for 14.2.2
- purpose 14.1.1, 14.1.1.1, 14.1.1.2, 14.1.1.3
- SQL*Loader 17.3.9
- synchronizing applications 17.3.6
- synchronizing with proxy PDBs 17.3.7
- uninstalling applications 17.3.10.1, 17.3.10.2
- unplugging 14.3, 14.3.1
- upgrading applications 17.1.2, 17.1.2.3, 17.3.3.1
- viewing extended data-linked objects 17.7.8
- viewing information about 17.7.1
- viewing patches 17.7.4, 17.7.5
- viewing shared objects 17.7.7
- viewing SQL statements 17.7.3
- viewing status 17.7.2
- viewing synchronization errors 17.7.6
- views 17.7
Application Continuity 3.3.4
- RESET_STATE 4.4.3
application PDBs 14.1.3
- application synchronization 17.1.5
- cloning 8.1.1
- creating 14.8, 17.3.5.3
application roots 14.1.2
- ALTER DATABASE statement 17.2
- ALTER PLUGGABLE DATABASE statement 17.2
- application PDBs
  - modifying 17.2
- creating 17.3.5.2
- modifying 17.2
applications
- in application containers 17.1.2, 17.1.2.2, 17.1.2.3, 17.1.2.3.1
  - at different versions 17.1.2.3.2
  - created implicitly 17.1.4
  - migrating an application 17.1.3
  - patching 17.1.2.4, 17.3.4.2
  - synchronization 17.1.5
- uninstalling 17.3.10.2
application seeds 1.4.3.2.1.1, 14.1.4
- creating 14.5, 14.5.3
- dropping 14.7
- preparing for 14.5.2
- unplugging 14.6
at-sign 3.2.11
automatic undo management 4.1.5
AVAILABILITY MAX clause 9.3.2.2
AVAILABILITY NORMAL clause 9.3.2.1

B

backups
- after creating new CDBs 3.2.14
batch jobs, authenticating users in 3.3.3
bigfile tablespaces
- setting database default 4.1.9.1

C

catcdb.sql 3.2.11
catcon.pl 15.6.3
CDB
- creating and configuring 3
- creating with DBCA 3.1.1
CDB_PDB_HISTORY view 15.7.8.1
CDB_PDBS view 15.7.3
CDBs 1.2, 1.4.1, III
- administering 15
- ALTER DATABASE statement 15.5.1
- ALTER PLUGGABLE DATABASE statement 15.5.1
- ALTER SYSTEM statement 15.4.2
- application common objects 1.4.1.1.2, 17.4, 17.4.1.1, 17.5.1
  - querying 15.7.6.4
- application containers 14.1, 14.1.1, 14.1.1.1, 14.1.1.2, 14.1.1.3
  - application common objects 17.4.1.1
  - application upgrades 17.1.2.3.1
  - bulk inserts 17.3.9
  - compatibility version 17.3.8
  - creating 14.2, 14.2.3
  - DML statements 17.5
  - dropping 14.4
  - installing applications 17.1.2.1, 17.1.2.2, 17.3.2.1
  - migrating applications into 17.3.5
  - patching applications 17.3.4.1
  - preparing for 14.2.2
  - synchronizing applications 17.3.6
  - uninstalling applications 17.3.10.1, 17.3.10.2
  - unplugging 14.3
  - upgrading applications 17.1.2.3, 17.3.3.1
- application PDBs 14.1.3
  - cloning 8.1.1
  - creating 14.8, 17.3.5.3
- application seeds 14.1.4
  - creating 14.5
  - dropping 14.7
  - preparing for 14.5.2
  - unplugging 14.6
- backing up 3.2.14
- CDB fleets 5, 5.2
  - CDB member 5.4
  - lead CDB 5.1, 5.3
- common objects 1.4.1.4
- common roles 1.4.1.3, 1.4.1.3.1
- common users 1.4.1.2, 1.4.1.2.1
  - naming rules 1.4.1.1.2
- compatibility violations 16.5.1
- connecting to 15.2.1
  - ALTER SESSION statement 15.2.2.2
  - CONNECT command 15.2.2.1
- container data objects 15.7.1.2
  - querying 15.7.5
- container maps 17.6
- containers 15.6.1.1, 15.7.2
- CONTAINERS clause 15.7.6.2, 15.7.6.3
- creation 1.4.3.1
- current container 15.1.1, 15.7.7
- data definition language (DDL) 15.6.2
- DBMS_SQL package 15.6.4
- default temporary tablespace, specifying 4.1.7
- DML statements 15.6.1, 17.5.1
- dropping 4.7
- ENABLE_PLUGGABLE_DATABASE initialization parameter 3.2.1.2
- ENABLE PLUGGABLE DATABASE SEED FILE_NAME_CONVERT clause 3.2.1.3.1
- executing PL/SQL code 15.6.4
- initialization parameters 15.7.8
- local roles 1.4.1.3, 1.4.1.3.2
- local users 1.4.1.2, 1.4.1.2.2
- modifying 15.4.2, 15.5.1, 15.5.2
- monitoring 15.7
- mounting a database 15.3.1.5.4
- Oracle Database Vault 15.1.2
- Oracle Managed Files 3.2.1.3.2
- PDB_FILE_NAME_CONVERT initialization parameter 3.2.1.3.3
- PDB lockdown profiles 15.1.7.1
- PDBs
  - modifying 15.5.1
  - refreshing 16.4.4.1
- PDB snapshots 12
  - configuring automatic creation 12.3
  - creating manually 8.5.1, 12.4
  - dropping 12.5
  - setting maximum number 12.1.2.2, 12.2
- plugging in PDBs
  - methods for 6.2
  - preparing for 6.6
- prerequisites for 2.1
- root container
  - modifying 15.5.4
- seed PDBs 1.4.3.2.1.1
- snapshot copy PDBs 8.6.1.1
  - materializing 8.6.3
- specifying control files 4.2.4
- SQL scripts 15.6.3
- standby database 15.1.2
- tasks for 1.4.2.1
- tools for 1.4.2.2
- Transparent Data Encryption 15.1.2
- undo mode 3.2.1.5, 15.5.3
- unplugging PDBs 13.1
- viewing information about 15.7
- views 15.7.1.3
character sets 2.3.4.1
CloneDB 4.6.1
clonedb.pl Perl script 4.6.1.2
CLONEDB parameter 8.1
cloning
- a database 4.6
cloning an application PDB 8.1.1
cloning a PDB 8.1
- local 8.2.1, 8.2.2
- refreshable clone PDBs 8.4, 16.4.4.2
- remote 8.3.1, 8.3.2
- using split mirrors 8.7
column encryption 3.3.2
COMMON_USER_PREFIX parameter 15.6.2.1
commonality, principles of 1.4.1.1.1
common objects 1.4.1.4
common roles 1.4.1.3, 1.4.1.3.1
common user accounts 1.4.1.2
- naming rules 1.4.1.1.2
common users 1.4.1.2.1
- prefix 15.6.2.1
compatibility level 4.2.9.1
COMPATIBLE Initialization Parameter 4.2.9.1
configuring
- a CDB 3
CONNECT command
- starting an instance 15.3.1.4
CONNECT command, SQL*Plus
- CDBs 15.2.2.1
container data objects 15.7.1.2
- definition 15.7.1.2
- querying 15.7.5
container maps 17.6, 17.6.1
- creating 17.6.2
CONTAINERS_DEFAULT attribute 17.4.1
CONTAINERS_PARALLEL_DEGREE parameter 15.7.6.2, 15.7.6.4
CONTAINERS clause 15.7.6.2, 15.7.6.3, 15.7.6.4, 17.4.1, 17.5.1
CONTROL_FILES initialization parameter
- overwriting existing control files 4.2.4
- when creating a CDB 4.2.4
CONTROLFILE REUSE clause 4.2.4
control files
- default name 4.2.4
- mirroring 4.2.4
- overwriting existing 4.2.4
- specifying names before CDB creation 4.2.4
- unavailable during startup 15.3.1.5.1
CREATE_FILE_DEST clause 6.3.4.2, 6.3.4.3, 8.2.4.3
CREATE DATABASE statement 3.2.1.1
- clauses 4.1.1
- DEFAULT TEMPORARY TABLESPACE clause 4.1.7
- ENABLE_PLUGGABLE_DATABASE initialization parameter 3.2.1.2
- ENABLE PLUGGABLE DATABASE SEED FILE_NAME_CONVERT clause 3.2.1.3.1
- example of CDB creation 3.2.10
- password for SYS 4.1.2
- password for SYSTEM 4.1.2
- setting time zone 4.1.10.1
- specifying FORCE LOGGING 4.1.11
- undo_mode_clause 3.2.1.5
- UNDO TABLESPACE clause 4.1.5
CREATE PFILE FROM MEMORY statement 4.3.8
CREATE PLUGGABLE DATABASE statement 1.4.3.2.1.1, 1.4.3.2.1.2
- application containers 14.1
- AS PROXY clause 1.4.3.2.4, 11.1
- clauses 6.5
- DEFAULT TABLESPACE clause 6.3.2
- file locations 6.3.4
- HOST clause 11.1.4.1
- logging_clause 16.4.1, 16.4.1.2
- MAX_AUDIT_SIZE clause 6.3.1
- MAX_DIAG_SIZE clause 6.3.1
- NO DATA clause 8.2.2
- PATH_PREFIX clause 6.3.4.4
- pdb_force_logging_clause 16.4.1
- PDB listener host name 11.1.4
- PDB listener port number 11.1.4
- PORT clause 11.1.4.2
- REFRESH MODE clause 8.4
- RELOCATE clause 1.4.3.2.3, 9.1, 9.4, 9.5
- SERVICE_NAME_CONVERT clause 6.4
- SNAPSHOT COPY clause 1.4.3.2.1.2.2, 8.1, 8.6.1.1
- SNAPSHOT MODE clause 12.1.3
- SOURCE_FILE_DIRECTORY clause 10.1.2.2
- SOURCE_FILE_NAME_CONVERT clause 10.1.2.1
- source file locations 10.1.2
- STORAGE clause 6.3.1
- USER_TABLESPACES clause 6.3.3
- USING clause 1.4.3.2.2, 10.2
- USING SNAPSHOT clause 8.5.1
CREATE ROLE statement 1.4.1.3.1
creating
- a CDB 3
- database services 4.4.1.4
creating an application PDB 17.3.5.3
creating CDBs
- backing up the new CDB 3.2.14
- default temporary tablespace, specifying 4.1.7
- ENABLE_PLUGGABLE_DATABASE initialization parameter 3.2.1.2
- example 3.2.10
- Oracle Managed Files 3.2.1.3.2
- overriding default tablespace type 4.1.9.2
- PDB_FILE_NAME_CONVERT initialization parameter 3.2.1.3.3
- SEED FILE_NAME_CONVERT clause 3.2.1.3.1
- setting default tablespace type 4.1.9.1
- specifying bigfile tablespaces 4.1.9, 4.1.9.2
- undo_mode_clause 3.2.1.5
- UNDO TABLESPACE clause 4.1.5
- using Oracle Managed Files 4.1.8
- with DBCA 3.1.1
creating PDBs 6
current container 15.1.1

D

database
- cloning 4.6
- cloning in a multitenant environment 4.6.2
- cloning with CloneDB 4.6.1
- cloning with Oracle ASM 4.6.3
- data dictionary views reference 3.4
- starting up 15.3.1
database clouds 4.4.2
database consolidation 1.3.1
Database Resource Manager 1.3.1
- used for quiescing a database 15.3.4.1
databases
- administrative accounts 1.4.1.2.1.2
- altering availability 15.3.2
- mounting to an instance 15.3.2.1
- opening a closed database 15.3.2.2
- quiescing 15.3.4.1
- read-only, opening 15.3.2.3
- recovery 15.3.1.5.7
- restricting access 15.3.2.4
- resuming 15.3.5
- shutting down 15.3.3
- starting up 1.4.1.2.1.2
- suspending 15.3.5
- undo management 4.1.5
database services
- about 4.4.1.1
- controlling automatic startup of 15.3.1.3
- creating 4.4.1.4
- data dictionary views 4.4.4
- managing application workloads with 4.4
data blocks
- altering size of 4.2.5.1
- nonstandard block size 4.2.5.2
- specifying size of 4.2.5
- standard block size 4.2.5
data definition language (DDL)
- CDBs 15.6.2
data dictionary 1.4.1.2.1.2, 3.4
- See also: views, data dictionary
- PDBs 1.3.2
data files
- unavailable when CDB is opened 15.3.1.5.1
data-linked application common objects 14.2.1
data-linked common objects 17.4.1
data manipulation language
- CDBs 15.6.1
DB_BLOCK_SIZE initialization parameter
- setting 4.2.5
DB_CREATE_FILE_DEST initialization parameter 6.3.4.2
DB_DOMAIN initialization parameter
- setting for database creation 4.2.2
DB_NAME initialization parameter
- setting before database creation 4.2.2
DBA_APP_ERRORS view 17.7.6
DBA_APP_PATCHES view 17.7.5
DBA_APP_PDB_STATUS view 17.7.2
DBA_APP_STATEMENTS view 17.7.3
DBA_APP_VERSIONS view 17.7.4
DBA_APPLICATIONS view 17.7.1
DBA_OBJECTS view 17.3.5.2
- shared objects 17.7.7
DBA_PDB_SAVED_STATES view 16.5.4
DBA_PDB_SNAPSHOTFILE view 12.6
DBA_PDB_SNAPSHOTS view 12.6
DBA_PROFILES view 17.3.5.2
DBA_ROLES view 17.3.5.2
DBA_TABLES view
- extended data-linked objects 17.7.8
DBA_USERS view 17.3.5.2
DBCA
- exit codes 20
DBMS_CREDENTIAL package 15.1.7.2
DBMS_PDB package 6.2, 8.3.2, 17.3.5.2
DBMS_SQL package
- CDBs 15.6.4
DDL_LOCK_TIMEOUT initialization parameter 4.2.7
DDL lock timeout 4.2.7
DEFAULT TABLESPACE clause 6.3.2
default temporary tablespaces
- specifying at CDB creation 4.1.7
- specifying bigfile temp file 4.1.9.2
- specifying for root 3.2.10.1, 3.2.10.2
distributed databases
- database clouds 4.4.2
- Global Data Services 4.4.2
- starting a remote instance 15.3.1.5.9
DROP DATABASE statement 4.7
DROP PLUGGABLE DATABASE statement 13.2, 14.4, 14.7

E

ENABLE PLUGGABLE DATABASE clause 3.2.1.2
encryption, transparent data 3.3.2
environment variables
- ORACLE_SID 3.2.2
errors
- ORA-01090 15.3.3.1
- while starting a database 15.3.1.5.6
- while starting an instance 15.3.1.5.6
exit codes
- DBCA 20
export operations
- restricted mode and 15.3.1.5.5
extended data-linked application common objects 14.2.1
extended data-linked objects 17.4.1

F

fast recovery area
- initialization parameters to specify 4.2.3
FILE_NAME_CONVERT clause 8.2.4.3
Flashback PDB 15.1.6
fleets, CDB 5, 5.1, 5.2
FORCE LOGGING clause
- CREATE DATABASE 4.1.11
- performance considerations 4.1.11.2

G

GDS configuration 4.4.2
Global Data Services 4.4.2

H

HOST clause 11.1.4.1

I

import operations
- restricted mode and 15.3.1.5.5
initialization parameter file
- about 4.2.1
- creating 3.2.5
- creating by copying and pasting from alert log 4.3.10
- creating for database creation 3.2.5
- default locations 15.3.1.2.1
- editing before database creation 4.2
- individual parameter names 4.2.2
- sample 4.2.1.1
- search order 15.3.1.2.1
- server parameter file 4.3
initialization parameters
- about 4.2.1
- and database startup 15.3.1.2.1
- changing 4.3.6.2
- changing values 4.3.6.1
- clearing 4.3.7
- CONTROL_FILES 4.2.4
- DB_BLOCK_SIZE 4.2.5
- DB_DOMA 4.2.2
- DB_NAME 4.2.2
- PROCESSES 4.2.6
- resetting 4.3.7
- server parameter file and 4.3, 4.3.11
- setting 4.3.6.2
- SPFILE 4.3.5
- UNDO_MANAGEMENT 4.1.5
- UNDO_TABLESPACE 4.2.8.2
instance_abort_delay_time parameter 15.3.6
instances
- abort mode 15.3.3.5
- shutting down immediately 15.3.3.3
- shutting down normally 15.3.3.2
- transactional shutdown 15.3.3.4
INTERNAL username
- connecting for shutdown 15.3.3.1

L

LEAD_CDB_URI database property 5.4
LEAD_CDB database property 5.3
lead CDB 5.1
local roles 1.4.1.3, 1.4.1.3.2
local users 1.4.1.2, 1.4.1.2.2
logging_clause 16.4.1, 16.4.1.2

M

MAX_AUDIT_SIZE clause 6.3.1
MAX_DIAG_SIZE clause 6.3.1
MAX_PDB_SNAPSHOTS database property 12.1
metadata-linked application common objects 14.2.1
metadata-linked common objects 17.4.1
mirrored files
- control files 4.2.4
mounting a CDB 15.3.1.5.4
multitenant architecture 1.4.1, III
- benefits 1.3.1, 1.3.2
- definition 1.2
multitenant container databases
- See: CDBs
multitenant environment 1.4.1

N

named user limits
- setting initially 4.2.10
NFS support 3.3.5
NO DATA clause 8.2.2
noncdb_to_pdb.sql script 8.3.2
non-CDBs
- cloning as PDBs 1.4.3.2.1.2, 8.3.2

O

object quarantine 15.3.6
open modes
- PDBs 16.5
ORA-01013 error message 15.3.3.6
ORACLE_SID environment variable 3.2.2
Oracle ASM 6.3.4.2, 8.7
Oracle Database Vault
- CDBs 15.1.2
Oracle Data Guard
- CDBs 15.1.2
Oracle Enterprise Manager Cloud Control 15.3.1.1.3
Oracle Managed Files 3.2.1.3.2, 6.3.4.2
- introduction 4.1.8
Oracle Multitenant option 1, III
Oracle Universal Installer 2.2
ORADIM
- creating a database instance 3.2.6
- enabling automatic instance startup 3.2.15

P

parameter files
- See: initialization parameter file
password
- setting for SYSTEM account in CREATE DATABASE statement 4.1.2
- setting SYS in CREATE DATABASE statement 4.1.2
PATH_PREFIX clause 6.3.4.3, 6.3.4.4, 8.2.4.3
PDB_FILE_NAME_CONVERT initialization parameter 3.2.1.3.3, 8.3.2
pdb_force_logging_clause 16.4.1, 16.4.1.2
PDB_OS_CREDENTIAL initialization parameter 15.1.7.1, 15.1.7.2
PDB_PLUG_IN_VIOLATIONS view 16.5.1
pdb_save_or_discard_state clause 16.5.4
pdb_to_apppdb.sql script 17.3.5.3
PDB relocation
- basic steps 9.5
- how it works 9.3
- user interface 9.4
PDBs 1.2, 1.4.1, III
- administering 16
- ALTER SYSTEM statement 16.3
- archive files 1.4.3.2.2
- cloning 1.4.3.2.1.2, 8, 8.1
- cloning application 8.1.1
- cloning local 8.2.1, 8.2.2, 8.3.1
- common users 1.4.1.1.2
- compatibility violations 16.5.1
- connecting to 15.2.1, 16.2.1
  - ALTER SESSION statement 15.2.2.2
  - CONNECT command 15.2.2.1
- consolidation of data into 1.4.3
- creating as proxies 11
- creating by plugging in 10.2
- creating from seed 1.4.3.2.1.1, 7
- creation 1.4.3.2, 6
- current container 15.1.1
- data dictionary 1.3.2
- DBMS_SQL package 15.6.4
- dropping 13.2
- encryption 8.1
- executing PL/SQL code 15.6.4
- flashback 15.1.6
- hot cloning 8.1
- instances_clause 16.5.1.3
- keystore 8.1
- lockdown profiles 15.1.7.1
- modifying 16.4
- moving 9, 9.3.2.1, 9.3.2.2
  - how it works 9.3
  - purpose 9.2
- open mode 15.7.4, 16.5
  - preserving on restart 16.5.4
- plugging in 10
  - methods for 6.2
  - preparing for 6.6
- prerequisites for 2.1
- proxy 1.4.3.2, 1.4.3.2.4, 11.1.1, 17.3.7.1
- refreshable clone 1.4.3.2.1.2.3
- refreshing 16.4.4.1
- relocate_clause 16.5.1.3
- relocating 1.4.3.2.3, 9, 9.1, 9.3.2.1, 9.3.2.2, 9.5
  - how it works 9.3
  - purpose 9.2
  - user interface 9.4
- renaming 16.4.3
- services 16.2.2
- services_clause 16.5.1.3
- SHUTDOWN command 16.5.5, 16.5.5.4
- snapshot copy 1.4.3.2.1.2.2, 8.6.1.1
- snapshots 8.6.3, 12.2, 12, 12.1, 12.1.2.1, 12.1.2.2, 12.1.3, 12.3, 12.4, 12.5, 12.6
- STARTUP command 16.5.5, 16.5.5.2, 16.5.5.3
- tasks for 1.4.2.1
- tools for 1.4.2.2
- unplugged 1.4.3.2.2
- unplugging 13.1
- views 15.7.1.3
PDB snapshot carousel
- about 12.1
- administering 12
- contents 12.1.2.2
- how it works 12.1.2
- purpose 12.1.1
- setting the maximum number of snapshots 12.2
- viewing snapshots 12.6
PDB snapshots
- viewing 12.6
pluggable databases
- See: PDBs
plugging in unplugged PDBs 10.2
PORT clause 11.1.4.2
predefined user accounts 3.3.1
privileges
- RESTRICTED SESSION system privilege 15.3.1.5.5
PROCESSES initialization parameter
- setting before database creation 4.2.6
proxy PDBs 1.4.3.2, 1.4.3.2.4, 11
- creating 17.3.7.2
- referenced PDB
  - altering listener host name 16.2.3.1
  - altering listener port number 16.2.3.2
- synchronizing an application root replica 17.3.7.1

Q

question mark 3.2.11
quiescing a database 15.3.4.1

R

read-only database
- opening 15.3.2.3
read-only databases
- limitations 15.3.2.3
RECOVER clause
- STARTUP command 15.3.1.5.7
Recovery Manager
- starting a database 15.3.1.1.2
- starting an instance 15.3.1.1.2
recursive SQL 15.7.6.3
redo log files
- unavailable when database is opened 15.3.1.5.1
refreshable clone PDBs 1.4.3.2.1.2.3, 8.4
- switchover 16.4.4.2
REFRESH MODE clause 8.4
relocating PDBs 9
- common listener network 9.3.2.1
- isolated listener network 9.3.2.2
- user interface 9.4
REMOTE_RECOVERY_FILE_DEST parameter 8.4
RESET_STATE 4.4.3
RESTRICTED SESSION system privilege
- restricted mode and 15.3.1.5.5
RMAN
- See: Recovery Manager
roles
- in a CDB 1.4.1.3
- local 1.4.1.3.2
root container 1.4.3.1
- modifying 15.5.4

S

Sample Schemas
- description 3.3.6
SCOPE clause 4.3.6.2.1
scripts, authenticating users in 3.3.3
security
- PDBs 15.1.7
SEED FILE_NAME_CONVERT clause 3.2.1.3.1
seed PDB 1.4.3.1
server parameter file
- creating 4.3.4
- defined 4.3.1
- exporting 4.3.8
- migrating to 4.3.2
- recovering 4.3.10
- RMAN backup 4.3.9
- setting initialization parameter values 4.3.6
- SPFILE initialization parameter 4.3.5
- viewing parameter settings 4.3.11
SERVICE_NAME_CONVERT clause 6.4, 8.2.4.3
services
- controlling automatic startup of 15.3.1.3
- PDBs 16.2.2
- role-based 15.3.1.3
SET TIME_ZONE clause
- ALTER SESSION 4.1.10.1
- CREATE DATABASE 4.1.10.1
shutdown
- default mode 15.3.3.2
SHUTDOWN command
- closing a PDB 16.5.5
- IMMEDIATE clause 15.3.3.3
- interrupting 15.3.3.6
- NORMAL clause 15.3.3.2
- PDBs 16.5.5.4
single-instance
- defined 3.2.1.1
SNAPSHOT COPY clause 1.4.3.2.1.2.2, 8.1, 8.6.1.1
snapshot copy PDBs 1.4.3.2.1.2.2
SNAPSHOT MODE clause 12.1.3
snapshots, PDB 12.1
- contents 12.1.2.1
- viewing 12.6
SOURCE_FILE_DIRECTORY clause 10.1.2.2
SOURCE_FILE_NAME_CONVERT clause 10.1.2.1
SPFILE initialization parameter 4.3.5
split mirror clone PDBs 8.7
SQL*Loader
- application containers 17.3.9
SQL*Plus
- starting 15.3.1.4
- starting a database 15.3.1.1.1
- starting an instance 15.3.1.1.1
SQL scripts
- CDBs 15.6.3
SRVCTL stop option
- default 15.3.3.2
standard edition high availability
- enabling 4.5.3
- guidelines 4.5.2
- relocating databases 4.5.5
Standard Edition High Availability
- adding nodes 4.5.6
STANDBY_PDB_SOURCE_FILE_DBLINK initialization parameter 8.3.2
STANDBY_PDB_SOURCE_FILE_DIRECTORY initialization parameter 10.2
standby database
- CDBs 15.1.2
starting a CDB
- when control files unavailable 15.3.1.5.1
- when redo logs unavailable 15.3.1.5.1
starting a database 15.3.1
- forcing 15.3.1.5.6
- Oracle Enterprise Manager Cloud Control 15.3.1.1.3
- recovery and 15.3.1.5.7
- Recovery Manager 15.3.1.1.2
- restricted mode 15.3.1.5.5
- SQL*Plus 15.3.1.1.1
starting an instance
- automatically at system startup 15.3.1.5.8
- database closed and mounted 15.3.1.5.4
- forcing 15.3.1.5.6
- mounting and opening the database 15.3.1.5.2
- normally 15.3.1.5.2
- Oracle Enterprise Manager Cloud Control 15.3.1.1.3
- recovery and 15.3.1.5.7
- Recovery Manager 15.3.1.1.2
- remote instance startup 15.3.1.5.9
- restricted mode 15.3.1.5.5
- SQL*Plus 15.3.1.1.1
- when control files unavailable 15.3.1.5.1
- when redo logs unavailable 15.3.1.5.1
- without mounting a database 15.3.1.5.3
startup
- of database services, controlling 15.3.1.3
STARTUP command
- NOMOUNT clause 3.2.9
- PDBs 16.5.5.2, 16.5.5.3
- RECOVER clause 15.3.1.5.7
- starting a database 15.3.1.1.1, 15.3.1.5
- starting a PDB 16.5.5
STORAGE clause 6.3.1
switching over refreshable clone PDBs 16.4.4.2
synchronizing applications 17.3.6
SYS account
- specifying password for CREATE DATABASE statement 4.1.2
SYSAUX tablespace
- about 4.1.4.1
- creating at database creation 4.1.4.1
- DATAFILE clause 4.1.4.1
SYSTEM account
- specifying password for CREATE DATABASE 4.1.2
SYSTEM tablespace
- creating locally managed 4.1.3
SYSTEM user name 1.4.1.2.1.2
SYS user name 1.4.1.2.1.2

T

tablespaces
- bigfile 4.1.9
- creating undo tablespace at database creation 4.1.5, 4.1.9.2
- default temporary tablespace, creating 4.1.7, 4.1.9.2
- overriding default type 4.1.9.2
- setting default type 4.1.9.1
- single-file 4.1.9, 4.1.9.2
- SYSAUX creation 4.1.4.1
time zone
- files 4.1.10.2
- setting for database 4.1.10.1
Transaction Guard 3.3.4
Transparent Application Continuity
- RESET_STATE 4.4.3
Transparent Data Encryption 3.3.2
- CDBs 15.1.2

U

UNDO_MANAGEMENT initialization parameter 4.1.5
undo_mode_clause 3.2.1.5
UNDO_TABLESPACE initialization parameter
- for undo tablespaces 4.2.8.2
undo mode
- CDBs 15.5.3
undo tablespaces 15.1.4
- specifying at database creation 4.1.5, 4.1.9.2
- specifying for CDBs 3.2.10.1, 3.2.10.2
unplugging 13.1, 14.3, 14.6
upgrades
- database 1.3.1
USER_TABLESPACES clause 6.3.3
user accounts
- predefined 3.3.1
users
- common 1.4.1.1.2, 1.4.1.2.1
- in a newly created database 3.3.1
- limiting number of 4.2.10
- predefined 3.3.1
- user name, specifying with CREATE USER statement 15.2.1.3
USING SNAPSHOT clause 8.5.1

V

V$CLONEDFILE view 4.6.1.3
V$CON_SYS_TIME_MODEL view 15.7.1.2
V$CON_SYSSTAT view 15.7.1.2
V$CON_SYSTEM_EVENT view 15.7.1.2
V$CON_SYSTEM_WAIT_CLASS view 15.7.1.2
V$CONTAINERS view 15.7.2
V$PDBS view 15.7.3, 15.7.4, 16.4.1.2
V$TIMEZONE_NAMES view
- time zone table information 4.1.10.2
views
- data dictionary
  - for database 3.4

W

workloads
- managing with database services 4.4