Index

As this ebook edition doesn't have fixed pagination, the page numbers below are hyperlinked for reference only, based on the printed edition of this book.

A

Access Control List (ACL) 5, 259

settings 259, 260

Active Session History (ASH) chart 186

Activity Auditing 254-256

ADB autonomous capabilities

Active Data Guard 9

Database In-Memory 9

Database Vault 9

multitenant option 9

Parallel SQL 9

Real Application Clusters (RAC) 9

Transparent Database Encryption (TDE) 9

ADB building blocks 8

ML 12

OCI 11

Oracle best practices 12

Oracle DBEE 9, 10

Oracle Exadata Database Machine 10, 11

Oracle knowledge base 12

ADB infrastructure deployment

dedicated deployment 17-19

shared deployment 17

ADB service

benefits 25, 26

key principles 25

ADW-D 20

Always Free ADBs 6, 44

administrator credentials, creating 47, 48

advance options 49, 50

basic information 45, 46

characteristics 6

configuration options 47

creating 44

deployment type 46

license type, selecting 48

network access, defining 48

workload type 46

Application Express (APEX) 4, 16, 115

Artificial Intelligence (AI) 4

ASH Analytics 186-189

associated specifications, AuDG

automatic failover 117

manual failover 117

naming convention, after switchover 116

naming convention, before switchover 116

operations 118

primary 116

region and roles specification 116

remote 116

RPO 117

RTO 117

status 117

ATP-D 20

AuDG implementation 126

AuDG, disabling 143-146

AuDG, enabling 126-134

manual switchover operation (local standby), performing 134-138

manual switchover operation (remote standby), performing 138-143

OCI Events Service, leveraging 146, 147

AuDG paired regions 112

automated backup

in OCI portal 152

Automatic Database Diagnostic Monitor (ADDM) 189

automatic security patch update 262, 263

audit logs 263

autonomous container database

creating 64-66

Autonomous Database (ADB) 4, 5, 157

actions 178

APIs list 57-60

associated terminologies 109

benefits 24, 25

business benefits 28-36

capabilities 21

classification 13

cloning 192

connectivity 181

Instance Wallet 181

migration considerations 69-72

on Exadata Cloud@Customer 19, 20

Performance Hub 184

policy requirements 51, 52

Regional Wallet 181

Scale Up/Down button 191, 192

starting 179

stopping 179

use cases 26, 27

value proposition 25

wallet zip file 182

Autonomous Data Guard (AuDG) 110

associated specifications 115

general notes 147, 148

local standby 111, 112

remote standby (cross-region standby) 112-114

Autonomous Data Warehouse (ADW) 4, 13

Autonomous Data Warehouse Cloud Service (ADWCS) 32

Autonomous JSON Database (AJD) 4, 14

benefits 15, 16

autonomous JSON instance 119

Autonomous Transaction Processing (ATP) 4, 14, 157

auto scaling

enabling 192

Availability Domains (ADs) 111

B

backup 151

automated backup 152

manual backup 152

Bill of Material (BOM) 36

for autonomous databases 37

Bring Your Own License (BYOL) 34, 196

business benefits, of ADB 28-36

C

Center for Internet Security (CIS) 218

Certificate Authority (CA) 258

CIDR Block 260

cloning, autonomous database

access control list 197

administrator credentials 195

administrator password 198

configuration 194

database, moving 201

database network access 195

database, renaming 200

databases, registering with Data Safe 212-222

license type, updating 199

Operations Insights, enabling 205-210

performing 192, 193

private endpoint access 196

Security Assessment 222, 223

Service Console 201-203

terminate option 211

updated network access 197

User Assessment 223-226

workload type, changing 204, 205

Cloud@Customer 4

Cloud Migration Advisor 70

Cloud Premigration Advisor Tool (CPAT) 71

Command-Line Interface (CLI) 7

cross-region standby, AuDG 112, 113

features 114, 115

custom encryption key 257

D

Database Administrator (DBA) 229

database backups

restoring 159-162

Data Definition Language (DDL) 217

Data Discovery 246-250

categories, for sensitive types 246

data encryption 256

Access Control List (ACL) 259-261

automatic security patch update 262

database backup encryption 258

encryption of data at rest 256, 257

encryption of data in transit 257

SQL command restrictions 262

SQL*Net Connection 261

Data Masking 250

policies 251

policies, creating 251-254

Data Pump 151, 162

Data Safe 236-240

dedicated ADB

provisioning 62

dedicated deployment 17-19

dedicated Exadata infrastructure

creating 62

deploying 62

domain forwarding 115

Dynamic Routing Gateways (DRGs) 6

E

encryption key

managing 257

Enterprise Manager 211

Exadata Cloud@Customer (ExaC@C)

using 19

Exadata Cloud Infrastructure (ExaCS) 26

Exadata VM cluster

creating 63, 64

expdp utility 152

G

Geographic Information Systems (GIS) 22

GoldenGate Microservices hub

configuration, in source database 95-97

provisioning 86-95

setting up 86

target deployment DB environment, preparing 98

target GoldenGate Admin user, activating 98

H

hardware security module (HSM) 43

highly available (HA) database 109

Hybrid Columnar Compression (HCC) 11

I

IAM considerations 51

Independent Oracle Users Group (IOUG) 27

Instance Wallet 181

downloading 181, 182

rotating 183, 184

Internet Gateways (IGWs) 6

Internet of Things (IoT) 13

J

Java Key Store (JKS) 183

JavaScript Object Notation (JSON) 5

L

local standby, AuDG 111, 112

logical online migration, with ZDM

architecture 73

workflow 74, 75

M

Machine Learning (ML) 4

manual backup 152

creating 157, 158

manual backup, through OCI portal 153

Cloud credentials, generating 153-155

object storage bucket, creating 155-157

manual database backups, with Data Pump 162

Autonomous Database schemas, refreshing 170, 171

backup, creating directly to object storage 167, 168

database links, between autonomous databases 171-175

dump set, creating 162-167

import backup 169, 170

Maximum Availability Architecture (MAA) 12

migration

considerations 69-72

database character set 86

implementing, autonomous database with ZDM 76

on-premises database migration, ZDM used 73

time zone, maintaining 86

ZDM response file, preparing 99

Zero-Downtime Migration tool 72, 73

ML, in ADB

capabilities 22, 23

Mutual Transport Layer Security (mTLS) 257

N

networking considerations 60

Network Interface Cards (NICs) 11

Network Security Group (NSG) 233-236

O

Object Store bucket

creating 83

OCI 11, 25

free tier account 42

OCI API key pair

generating, in pem format 78-82

OCI Command-Line Interface (OCI CLI) 179, 180

installing 83

setting up, in source database server 99

OCI Data Migration Service (DMS) 70

OCI Events Service 146

OCI free tier account

Always Free ADBs 44

Always Free resources 42, 43

OCI Free Trial 42

reference link 42

OCI portal 179, 180

automated backup 152

OCI user authentication token

creating 84, 85

on-premises database migration, with ZDM

logical online migration 73-75

methods 73

operating system access restriction 229, 230

ADMIN users, for database 230-232

Network Security Group (NSG) 233-236

private endpoint 232, 233

operations, AuDG

Add New Standby operation 124

automatic failover operation 123

disable operation 118

enable operation 119-121

manual failover operation 123, 124

peer Autonomous Database state 125, 126

switchover operation 121, 122

termination operation 124

Operations Insights

enabling 205-210

optimizer statistics 13

Oracle Best practices 12

Oracle Cloud Infrastructure (OCI) 109

Oracle CPU processor (OCPU) 44

Oracle Data Miner (ODM) 5

Oracle Data Safe 212

using, with autonomous database 212-222

Oracle DBEE 9, 10

Oracle Exadata Database Machine 10

Oracle Free Tier account

reference link 6

Oracle Machine Learning for Python (OML4Py) 5

Oracle Machine Learning Notebooks 16

Oracle Management Repository (OMR) 211

Oracle REST Data Services (ORDS) 16, 115

P

Patch Now option 18

peer Autonomous Database state 125

available state 126

provisioning state 125

role change in progress state 126

pem format

OCI API key pair, generating in 78-82

Performance Hub 184

accessing 184

ASH Analytics 186-189

Automatic Database Diagnostic Monitor (ADDM) 189

Automatic Workload Repository (AWR) report 185, 186

average active sessions 185

blocking sessions 190

SQL monitoring 189

workload 190

Pluggable Database (PDB) 7

Point-in-Time Restore (PITR) 20

policy requirements 51, 52

ADB permission 52-55

API coverage 52-55

resource types, for dedicated ADB 52

supported variables 52

private endpoint

configuring, for shared ADB 61

Public Key Cryptography Standards (PKCS) 256

R

Recovery Appliance (RA) 20

Recovery Manager (RMAN) 151, 152

Regional Wallet 181

downloading 181, 182

rotating 183, 184

REST API 180

RPO 117

RTO 117

S

Secure Socket Layer (SSL) 5

security 229

Security Assessment 241-243

User Assessment 244, 245

sensitive types, categories

academic information 246

biographic information 246

employment information 246

financial information 246

healthcare information 246

identification information 246

IT information 246

serverless shared ADB

deploying 61

Service-Level Agreements (SLAs) 12

Service Request (SR) 24

several administration challenges 23

shared deployment 17

Simple Oracle Document Access (SODA) 15

Software Development Kit (SDK) 7

SQL monitoring 189

SSH key pair

preparing 83

status, AuDG 117

disabled 117

enabled 117

Stock Keeping Unit (SKU) 36

for autonomous databases 37

Structured Query Language (SQL) 5

T

target autonomous database

creating 78

TDE (Transparent Data Encryption) 256

Time to Deliver (TTD) 26

Time to Install (TTI) 26

TLS (Transport Layer Security) 256

U

User Assessment 244, 245

V

Virtual Cloud Network (VCN) 5, 60

W

wallet zip file

cwallet.sso 182

ewallet.p12 182

keystore.jks 183

ojdbc.properties 183

Readme 182

sqlnet.ora 182

tnsnames.ora 182

truststore.jks 183

Z

ZDM migration

dry run 100, 101

running 101-106

steps 75

ZDM software 76

configuring 76

directories, creating 77

directories, exporting 77

downloading 77

installing 76, 77

packages, installing 76

prerequisites 76

zdm group, creating 76

zdm users, creating 76

Zero Data Loss Recovery Appliance (ZDLRA) 20

Zero Downtime Migration (ZDM) 70, 72

on-premises database migration, performing with 73