Comprehensive Tutorial: Installing and

Configuring Oracle Database 19c

Table of Contents

1. Introduction
2. Environment Preparation
3. Installation Types: Server vs Desktop
4. Installing Oracle Database 19c Software
5. Understanding Response Files
6. Creating and Configuring a Database
7. Configuring Network Connectivity
8. Verifying and Managing the Database
9. Backup and Recovery

1. Introduction <a name="introduction"></a>

Oracle Database 19c is the long-term support release of the Oracle Database
family, providing stability and performance for enterprise applications. This
tutorial provides a comprehensive guide to installing, configuring, and
managing Oracle Database 19c on Windows systems.

Key Benefits of Oracle Database 19c:

 Long-term support release (until 2027 with extended support until 2030)
 Enhanced performance and security features
 Improved automation and management capabilities
 Support for multi-tenant architecture with pluggable databases
 2. Environment Preparation <a
name="environment-preparation"></a>

System Requirements

 Memory: Minimum 1 GB RAM (4+ GB recommended)

 Disk Space: At least 10 GB free space (more for databases)
 Processor: x86-64 compatible processor
 Operating System: Windows 10/11, Windows Server 2012/2016/2019

Downloading Oracle Database 19c

1. Visit the Oracle Database 19c Download Page

2. Accept the license agreement
3. Sign in with your Oracle account (create one if needed)
4. Download the installation zip file

Key Environment Variables

Three critical variables are configured during installation:

1. ORACLE_HOME: Defines the directory where Oracle software is installed

o Example: C:\app\username\product\19.0.0\dbhome_1
2. ORACLE_SID: Identifies the system ID of the database instance

o Example: ORCL or ORC19C

3. PATH: Must include %ORACLE_HOME%\bin to execute command-line tools from
any directory

Pre-installation Checklist
 Verify sufficient disk space and memory
 Close unnecessary applications to free resources
 Remove any previous Oracle installations completely
 Check that the installation path doesn't contain spaces or special characters

3. Installation Types: Server vs Desktop <a

name="installation-types"></a>

Server Class Installation

 Purpose: Production environments, high availability

 Features Supported:

o Real Application Clusters (RAC)

o Automatic Storage Management (ASM)
o Data Guard for disaster recovery
o Complex networking scenarios
 Resource Requirements: High (multiple CPUs, large memory, extensive
storage)
 Use Cases: Enterprise applications, high transaction volumes, mission-
critical systems

Desktop Class Installation

 Purpose: Development, testing, personal use

 Features Supported:

o Single instance only

o Basic networking
o No RAC or ASM support
 Resource Requirements: Moderate (suitable for workstations)
 Use Cases: Development, testing, learning, small applications
 4. Installing Oracle Database 19c Software <a
name="installation-process"></a>

Graphical Installation Method

1. Extract the installation files from the downloaded zip archive

2. Run setup.exe from the extracted folder
3. Configuration Options:

o Select "Create and configure a single instance database"

o Choose "Desktop class" for development/testing or "Server class" for
production
o Specify Oracle base and home directories
o Set a strong password for administrative accounts
4. Prerequisite Checks:

o The installer verifies system requirements

o Resolve any issues before proceeding:

 Insufficient memory: Close other applications

 Existing Oracle installations: Remove completely
 Invalid paths: Choose clean directories
5. Installation Process:

o The installation may pause at certain percentages (e.g., 7%)

o This is normal behavior - be patient
o Installation typically takes 30-60 minutes depending on system resources
6. Completion:

o Note the Enterprise Manager URL (typically http://localhost:5500/em )

o Save the installation summary for reference

Common Installation Issues and Solutions

Issue Solution

Existing Oracle Remove old Oracle directories and registry

inventory entries

Insufficient memory Close applications, increase virtual memory

Invalid installation Choose a path without spaces or special

path characters

Change default ports (1521, 5500) if already

Port conflicts
in use

5. Understanding Response Files <a

name="response-files"></a>

Response files allow for silent (unattended) installations using predefined

configuration parameters.

Key Response File Parameters

ini
# Response File Version - DO NOT MODIFY
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0

# Installation type
oracle.install.option=INSTALL_DB_AND_CONFIG

# UNIX group name (ignored on Windows)

UNIX_GROUP_NAME=

# Oracle home and base

ORACLE_HOME=C:\app\product\19.0.0\dbhome_1
ORACLE_BASE=C:\app
# Database configuration
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=ORCL
oracle.install.db.config.starterdb.SID=ORCL
oracle.install.db.config.starterdb.characterSet=AL32UTF8

# Pluggable database configuration

oracle.install.db.config.starterdb.createAsContainerDatabase=true

# Memory management
oracle.install.db.config.starterdb.memoryOption=false
oracle.install.db.config.starterdb.memoryLimit=8192

# Sample schemas
oracle.install.db.config.starterdb.installExampleSchemas=true

# Password configuration
oracle.install.db.config.starterdb.password.ALL=password123
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.DBSNMP=

# Management options
oracle.install.db.config.starterdb.managementOption=DEFAULT
oracle.install.db.config.starterdb.omsHost=
oracle.install.db.config.starterdb.omsPort=0
oracle.install.db.config.starterdb.emAdminUser=
oracle.install.db.config.starterdb.emAdminPassword=

# Recovery options
oracle.install.db.config.starterdb.enableRecovery=false
oracle.install.db.config.starterdb.recoveryAreaLocation=

# Storage options
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=C:\app\oradata

Executing Silent Installation

 cmd
setup.exe -silent -responseFile C:\path\to\response_file.rsp

6. Creating and Configuring a Database <a

name="database-creation"></a>

Using Database Configuration Assistant (DBCA)

1. Launch DBCA from Start menu or command line:

cmd

dbca

2. Database Creation Options:

o General Purpose or Transaction Processing: Balanced configuration for

most workloads
o Data Warehouse: Optimized for analytics and reporting
o Custom Database: Complete control over components and settings
3. Database Identification:

o Global Database Name: Unique identifier (e.g., ORCL.example.com )

o SID: System identifier (typically matches global name)
4. Storage Configuration:

o File System: Standard disk storage

o Oracle Managed Files: Automatic file management
o Specify data file locations
5. Fast Recovery Area:

o Enable for backup and recovery capabilities

o Allocate sufficient space (typically 2x database size)
6. Network Configuration:

o Register with listeners for client connections

o Configure network services
7. Configuration Options:

o Memory: Automatic shared memory management

o Sizing: Maximum processes and sessions
o Connection Mode: Dedicated server (recommended) or shared server
o Sample Schemas: Include example data for learning
8. Management Options:

o Enterprise Manager Database Express: Web-based management

o Register with Cloud Control (if available)
9. User Credentials:

o Set passwords for SYS, SYSTEM, and PDBADMIN accounts

o Use strong, unique passwords
10. Creation Options:

o Create database immediately

o Save as a database template
o Generate database creation scripts

7. Configuring Network Connectivity <a

name="network-configuration"></a>

Oracle Net Manager

Oracle Net Manager provides graphical configuration of network services.

Key Configuration Areas:

1. Naming Methods:

o TNSNAMES: Local configuration file (tnsnames.ora)

o EZCONNECT: Simple connect syntax (host:port/service)
o LDAP: Centralized directory service
2. Profile Configuration:

o Tracing and logging options

o Security settings (encryption, authentication)
o Routing preferences
3. Service Naming:

o Create and modify connect descriptors

o Configure load balancing and failover

Sample tnsnames.ora Entries

ini
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

Network Security Features

1. Authentication Methods:

o NTS (Windows Native Authentication)

o Kerberos
o RADIUS
2. Encryption:

o Enable for data protection in transit

o Select encryption algorithms (AES256, etc.)
3. Data Integrity:

o Checksums to detect tampering

o Configurable checksum levels
4. SSL Configuration:

o Server and client certificate authentication

o Wallet directory configuration
o Cipher suite selection

8. Verifying and Managing the Database <a

name="database-management"></a>

Listener Management
cmd
# Start listener
lsnrctl start

# Stop listener
lsnrctl stop

# Check status
lsnrctl status

Service Management

Oracle services can be managed through Windows Services:

 OracleService<SID>: Database instance service

 OracleOraDB19Home1TNSListener: Listener service
 Other supporting services

Enterprise Manager Database Express

 Access via http://localhost:5500/em
 Monitor performance metrics
 View resource utilization
 Analyze SQL performance

Key SQL*Plus Commands for Verification

sql
-- Connect to database
SQLPLUS / AS SYSDBA

-- Check database status

SELECT name, open_mode FROM v$database;

-- View instance information

SELECT instance_name, status FROM v$instance;

-- Check tablespaces
SELECT tablespace_name, status FROM dba_tablespaces;

-- Verify sample schemas

SELECT username FROM dba_users WHERE username LIKE 'HR%';

9. Backup and Recovery <a name="backup-

recovery"></a>

Enabling Archive Log Mode

sql
-- Shutdown database
SHUTDOWN IMMEDIATE;

-- Startup in mount mode

STARTUP MOUNT;

-- Enable archive logging

 ALTER DATABASE ARCHIVELOG;

-- Open database
ALTER DATABASE OPEN;

-- Verify archive log mode

ARCHIVE LOG LIST;

Using RMAN for Backups

cmd
# Connect to RMAN
rman target /

# Complete database backup

BACKUP DATABASE PLUS ARCHIVELOG;

# List backups
LIST BACKUP;

# Validate backups
VALIDATE BACKUPSET;

Backup Strategies

1. Full Backups: Complete database backup

2. Incremental Backups: Only changed blocks since last backup
3. Archive Log Backups: Critical for point-in-time recovery
4. Automated Backup Scheduling: Use Oracle Scheduler or OS utilities

Recovery Scenarios

1. Complete Recovery: Restore and recover to point of failure

2. Point-in-Time Recovery: Recover to specific timestamp
3. Tablespace Recovery: Individual tablespace restoration
 Conclusion

This comprehensive tutorial has covered the essential aspects of installing,

configuring, and managing Oracle Database 19c. Key takeaways include:

1. Proper preparation is critical for successful installation

2. Understanding the difference between server and desktop class installations
3. Response files enable automated, repeatable installations
4. Network configuration is essential for database connectivity
5. Regular verification and maintenance ensure database health
6. Proper backup strategies protect against data loss

For production environments, always refer to the official Oracle

documentation and consider engaging Oracle experts for complex
deployments. The skills learned in this tutorial provide a solid foundation for
working with Oracle Database 19c in development, test, and production
environments.

++++++++++++++++++++++++++++++++++++++++++++++

++++++++++

Comprehensive Tutorial: Installing and

Configuring Oracle Database 19c

Table of Contents

1. Introduction
2. Environment Preparation
3. Installation Types: Server vs Desktop
4. Installing Oracle Database 19c Software
5. Understanding Response Files
6. Creating and Configuring a Database
7. Configuring Network Connectivity
8. Verifying and Managing the Database
9. Backup and Recovery

1. Introduction

Oracle Database 19c is the long-term support release of the Oracle Database
family, providing stability and performance for enterprise applications. This
tutorial provides a comprehensive guide to installing, configuring, and
managing Oracle Database 19c on Windows systems.

Key Benefits of Oracle Database 19c:

 Long-term support release (until 2027 with extended support until 2030)
 Enhanced performance and security features
 Improved automation and management capabilities
 Support for multi-tenant architecture with pluggable databases

2. Environment Preparation

System Requirements

 Memory: Minimum 1 GB RAM (4+ GB recommended)

 Disk Space: At least 10 GB free space (more for databases)
 Processor: x86-64 compatible processor
 Operating System: Windows 10/11, Windows Server 2012/2016/2019

Downloading Oracle Database 19c

1. Visit the Oracle Database 19c Download Page

2. Accept the license agreement
3. Sign in with your Oracle account (create one if needed)
4. Download the installation zip file

Key Environment Variables

Three critical variables are configured during installation:

1. ORACLE_HOME: Defines the directory where Oracle software is installed

Example: C:\app\username\product\19.0.0\dbhome_1
2. ORACLE_SID: Identifies the system ID of the database instance
Example: ORCL or ORC19C
3. PATH: Must include %ORACLE_HOME%\bin to execute command-line tools
from any directory

Pre-installation Checklist

 Verify sufficient disk space and memory

 Close unnecessary applications to free resources
 Remove any previous Oracle installations completely
 Check that the installation path doesn't contain spaces or special characters

3. Installation Types: Server vs Desktop

Server Class Installation

 Purpose: Production environments, high availability

 Features Supported:

o Real Application Clusters (RAC)

o Automatic Storage Management (ASM)
o Data Guard for disaster recovery
o Complex networking scenarios
 Resource Requirements: High (multiple CPUs, large memory, extensive
storage)
 Use Cases: Enterprise applications, high transaction volumes, mission-critical
systems

Desktop Class Installation

 Purpose: Development, testing, personal use

 Features Supported:

o Single instance only

o Basic networking
o No RAC or ASM support
 Resource Requirements: Moderate (suitable for workstations)
 Use Cases: Development, testing, learning, small applications

4. Installing Oracle Database 19c Software

Graphical Installation Method

1. Extract the installation files from the downloaded zip archive

2. Run setup.exe from the extracted folder
3. Configuration Options:

o Select "Create and configure a single instance database"

o Choose "Desktop class" for development/testing or "Server class" for
production
o Specify Oracle base and home directories
o Set a strong password for administrative accounts
4. Prerequisite Checks:
o The installer verifies system requirements
o Resolve any issues before proceeding:

 Insufficient memory: Close other applications

 Existing Oracle installations: Remove completely
 Invalid paths: Choose clean directories
5. Installation Process:

o The installation may pause at certain percentages (e.g., 7%)

o This is normal behavior - be patient
o Installation typically takes 30-60 minutes depending on system resources
6. Completion:

o Note the Enterprise Manager URL (typically http://localhost:5500/em )

o Save the installation summary for reference

Common Installation Issues and Solutions

Issue: Existing Oracle inventory

Solution: Remove old Oracle directories and registry entries

Issue: Insufficient memory

Solution: Close applications, increase virtual memory

Issue: Invalid installation path

Solution: Choose a path without spaces or special characters

Issue: Port conflicts

Solution: Change default ports (1521, 5500) if already in use

5. Understanding Response Files

Response files allow for silent (unattended) installations using predefined

configuration parameters.
Key Response File Parameters

Response File Version - DO NOT MODIFY

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_s
chema_v19.0.0

Installation type
oracle.install.option=INSTALL_DB_AND_CONFIG

UNIX group name (ignored on Windows)

UNIX_GROUP_NAME=

Oracle home and base

ORACLE_HOME=C:\app\product\19.0.0\dbhome_1
ORACLE_BASE=C:\app

Database configuration
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=ORCL
oracle.install.db.config.starterdb.SID=ORCL
oracle.install.db.config.starterdb.characterSet=AL32UTF8

Pluggable database configuration

oracle.install.db.config.starterdb.createAsContainerDatabase=true

Memory management
oracle.install.db.config.starterdb.memoryOption=false
oracle.install.db.config.starterdb.memoryLimit=8192

Sample schemas
oracle.install.db.config.starterdb.installExampleSchemas=true

Password configuration
oracle.install.db.config.starterdb.password.ALL=password123
 oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.DBSNMP=

Management options
oracle.install.db.config.starterdb.managementOption=DEFAULT
oracle.install.db.config.starterdb.omsHost=
oracle.install.db.config.starterdb.omsPort=0
oracle.install.db.config.starterdb.emAdminUser=
oracle.install.db.config.starterdb.emAdminPassword=

Recovery options
oracle.install.db.config.starterdb.enableRecovery=false
oracle.install.db.config.starterdb.recoveryAreaLocation=

Storage options
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=C:\app\
oradata

Executing Silent Installation

setup.exe -silent -responseFile C:\path\to\response_file.rsp

6. Creating and Configuring a Database

Using Database Configuration Assistant (DBCA)

1. Launch DBCA from Start menu or command line:

dbca
2. Database Creation Options:
o General Purpose or Transaction Processing: Balanced configuration for most
workloads
o Data Warehouse: Optimized for analytics and reporting
o Custom Database: Complete control over components and settings
3. Database Identification:

o Global Database Name: Unique identifier (e.g., ORCL.example.com )

o SID: System identifier (typically matches global name)
4. Storage Configuration:

o File System: Standard disk storage

o Oracle Managed Files: Automatic file management
o Specify data file locations
5. Fast Recovery Area:

o Enable for backup and recovery capabilities

o Allocate sufficient space (typically 2x database size)
6. Network Configuration:

o Register with listeners for client connections

o Configure network services
7. Configuration Options:

o Memory: Automatic shared memory management

o Sizing: Maximum processes and sessions
o Connection Mode: Dedicated server (recommended) or shared server
o Sample Schemas: Include example data for learning
8. Management Options:

o Enterprise Manager Database Express: Web-based management

o Register with Cloud Control (if available)
9. User Credentials:

o Set passwords for SYS, SYSTEM, and PDBADMIN accounts

o Use strong, unique passwords
10. Creation Options:

o Create database immediately

o Save as a database template
o Generate database creation scripts

7. Configuring Network Connectivity

Oracle Net Manager

Oracle Net Manager provides graphical configuration of network services.

Key Configuration Areas:

1. Naming Methods:

o TNSNAMES: Local configuration file (tnsnames.ora)

o EZCONNECT: Simple connect syntax (host:port/service)
o LDAP: Centralized directory service
2. Profile Configuration:

o Tracing and logging options

o Security settings (encryption, authentication)
o Routing preferences
3. Service Naming:

o Create and modify connect descriptors

o Configure load balancing and failover

Sample tnsnames.ora Entries

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
 (SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

Network Security Features

1. Authentication Methods:

o NTS (Windows Native Authentication)

o Kerberos
o RADIUS
2. Encryption:

o Enable for data protection in transit

o Select encryption algorithms (AES256, etc.)
3. Data Integrity:

o Checksums to detect tampering

o Configurable checksum levels
4. SSL Configuration:

o Server and client certificate authentication

o Wallet directory configuration
o Cipher suite selection

8. Verifying and Managing the Database

Listener Management
 Start listener
lsnrctl start

Stop listener
lsnrctl stop

Check status
lsnrctl status

Service Management

Oracle services can be managed through Windows Services:

 OracleService<SID>: Database instance service

 OracleOraDB19Home1TNSListener: Listener service
 Other supporting services

Enterprise Manager Database Express

 Access via http://localhost:5500/em

 Monitor performance metrics
 View resource utilization
 Analyze SQL performance

Key SQL*Plus Commands for Verification

-- Connect to database
SQLPLUS / AS SYSDBA

-- Check database status

SELECT name, open_mode FROM v$database;
-- View instance information
SELECT instance_name, status FROM v$instance;

-- Check tablespaces
SELECT tablespace_name, status FROM dba_tablespaces;

-- Verify sample schemas

SELECT username FROM dba_users WHERE username LIKE 'HR%';

9. Backup and Recovery

Enabling Archive Log Mode

-- Shutdown database
SHUTDOWN IMMEDIATE;

-- Startup in mount mode

STARTUP MOUNT;

-- Enable archive logging

ALTER DATABASE ARCHIVELOG;

-- Open database
ALTER DATABASE OPEN;

-- Verify archive log mode

ARCHIVE LOG LIST;

Using RMAN for Backups

Connect to RMAN
rman target /
 Complete database backup
BACKUP DATABASE PLUS ARCHIVELOG;

List backups
LIST BACKUP;

Validate backups
VALIDATE BACKUPSET;

Backup Strategies

1. Full Backups: Complete database backup

2. Incremental Backups: Only changed blocks since last backup
3. Archive Log Backups: Critical for point-in-time recovery
4. Automated Backup Scheduling: Use Oracle Scheduler or OS utilities

Recovery Scenarios

1. Complete Recovery: Restore and recover to point of failure

2. Point-in-Time Recovery: Recover to specific timestamp
3. Tablespace Recovery: Individual tablespace restoration

Conclusion

This comprehensive tutorial has covered the essential aspects of installing,

configuring, and managing Oracle Database 19c. Key takeaways include:

1. Proper preparation is critical for successful installation

2. Understanding the difference between server and desktop class installations
3. Response files enable automated, repeatable installations
4. Network configuration is essential for database connectivity
5. Regular verification and maintenance ensure database health
6. Proper backup strategies protect against data loss

For production environments, always refer to the official Oracle

documentation and consider engaging Oracle experts for complex
deployments. The skills learned in this tutorial provide a solid foundation for
working with Oracle Database 19c in development, test, and production
environments.

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Comprehensive Oracle Database 19c Tutorial

with Parameter Explanations

Table of Contents

1. Introduction to Oracle Database 19c

2. Environment Preparation
3. Installation Types: Server vs. Desktop
4. Installation Process & Parameters
5. Response File Parameters Explained
6. Database Creation Parameters
7. Network Configuration Parameters
8. Verification & Management
9. Backup & Recovery Configuration

1. Introduction to Oracle Database 19c

Oracle Database 19c is the long-term support release (LTS) of Oracle's
database system, providing enhanced performance, security, and stability
for enterprise applications.

2. Environment Preparation

System Requirements & Recommendations

Paramete Minimum Recommended

Explanation
r Requirement Value

Memory for SGA (System

RAM 1 GB 4+ GB Global Area) and PGA
(Program Global Area)

Space for Oracle binaries,

Disk
10 GB 50+ GB data files, and recovery
Space
area

Processor cores for parallel

CPU
1 4+ operations and concurrent
Cores
users

TEMP Temporary space for

1 GB 5 GB
Space installation processes

Virtual memory for

Swap
2 GB 8 GB operating system
Space
operations
Key Environment Variables

Recommend
Variable Purpose Example Value
ed Practice

Separate
from
Installati
ORACLE_HO ORACLE_BAS
on C:\app\product\19.0.0\dbhome_1
ME E for
directory
multiple
installations

Root
ORACLE_BA Base directory for
C:\app\oracle
SE directory Oracle
software

Unique for
each
System
ORACLE_SID ORCL19C database
Identifier
instance on
server

Must include
Executab Oracle
PATH %ORACLE_HOME%\bin
le path binary
directory

3. Installation Types: Server vs. Desktop

Comparison Table
 Server Desktop
Feature Explanation
Class Class

Real Application Clusters

RAC Support Yes No
for high availability

Automatic Storage
ASM Support Yes No
Management for storage

Server allows more

Memory
Advanced Basic sophisticated memory
Management
tuning

Concurrent Hundreds Scalability for user

Dozens
Users + connections

Productio Developme
Use Case Environment suitability
n nt

4. Installation Process & Parameters

Critical Installation Parameters

Parameter Recommended Value Explanation

Installation INSTALL_DB_AND_CONFI Installs software and

Type G creates database

Database For production; EE for

Enterprise Edition
Edition development
Parameter Recommended Value Explanation

Oracle Home Windows service account

Virtual Account
User type

Database File Separate from Oracle home

C:\app\oradata
Location for manageability

Separate disk
Recovery Area C:\app\fast_recovery_area recommended for
production

5. Response File Parameters Explained

Database Configuration Section

Recomme
Example Expla
Parameter nded
Value nation
Value

Datab
ase
oracle.install.db.config.starterd GENERAL_P GENERAL_
worklo
b.type URPOSE PURPOSE
ad
type

oracle.install.db.config.starterd ORCL19C.exa [SID]. Uniqu

b.globalDBName mple.com [domain] e
datab
ase
 Recomme
Example Expla
Parameter nded
Value nation
Value

identi
fier

Syste
8
oracle.install.db.config.starterd m
ORCL19C characters
b.SID identi
or less
fier

Unico
de
oracle.install.db.config.starterd
AL32UTF8 AL32UTF8 chara
b.characterSet
cter
set

Enabl
e
oracle.install.db.config.starterd multit
true true
b.createAsContainerDatabase enant
archit
ecture

Memory Configuration

Exam Recomme
Explanat
Parameter ple nded
ion
Value Value

oracle.install.db.config.starterdb.m false false Manual

emoryOption memory
 Exam Recomme
Explanat
Parameter ple nded
ion
Value Value

manage
ment

Total
memory
oracle.install.db.config.starterdb.m 40-70% of
8192 for
emoryLimit total RAM
databas
e (MB)

false for Install

oracle.install.db.config.starterdb.in
true productio sample
stallExampleSchemas
n schemas

Security Parameters

Recomm
Example Explanat
Parameter ended
Value ion
Practice

Commo
n
Unique
oracle.install.db.config.starterd ComplexPw passwor
per
b.password.ALL d123! d for all
account
account
s

oracle.install.db.config.starterd SysPwd456! Different SYS

b.password.SYS from administ
SYSTEM rator
 Recomm
Example Explanat
Parameter ended
Value ion
Practice

passwor
d

SYSTEM
administ
oracle.install.db.config.starterd SystemPwd Different
rator
b.password.SYSTEM 789! from SYS
passwor
d

Monitori
ng
oracle.install.db.config.starterd MonitorPwd Unique
account
b.password.DBSNMP 012! password
passwor
d

Storage Parameters

Recomme Expla
Example
Parameter nded natio
Value
Value n

Stora
ge
type
oracle.install.db.config.starter FILE_SYSTEM_ST FILE_SYSTE
(ASM
db.storageType ORAGE M_STORAGE
for
produ
ction)
 Recomme Expla
Example
Parameter nded natio
Value
Value n

Data
oracle.install.db.config.starter
Separate file
db.fileSystemStorage.dataLoc C:\app\oradata
disk locati
ation
on

Enabl
e
oracle.install.db.config.starter true for
true flash
db.enableRecovery production
recov
ery

Reco
C:\app\ very
oracle.install.db.config.starter Separate
fast_recovery_ar area
db.recoveryAreaLocation disk
ea locati
on

6. Database Creation Parameters

DBCA Configuration Options

Recommended
Parameter Explanation
Value

Database
General Purpose Workload type
Type
 Recommended
Parameter Explanation
Value

Automatic Memory
Memory 60-70% of available
Memory allocation
Management RAM
Management method

(concurrent_users × Maximum
Processes 300
1.1) + 50 processes

Database
Block Size 8192 8192 (8KB)
block size

Connection Dedicated for Server

Dedicated Server
Mode limited users process type

Sample Schemas Configuration

Parameter Recommended Explanation

Install Sample
No for production Include HR, OE, SH schemas
Schemas

Different from Unique passwords for each

Schema Passwords
admin schema

7. Network Configuration Parameters

Listener Configuration (listener.ora)

Parameter Example Value Explanation

LISTENE
LISTENER_ORCL Listener name
R

PROTOC Communication
TCP
OL protocol

HOST localhost Server hostname

PORT 1521 Default Oracle port

List of service
SID_LIST SID_LIST_LISTENER
identifiers

TNS Names Configuration (tnsnames.ora)

Example
Parameter Explanation
Value

SERVICE_NA
ORCL19C Database service name
ME

Server type
SERVER DEDICATED
(DEDICATED/SHARED)

FAILOVER ON Enable connection failover

LOAD_BALAN
ON Enable load balancing
CE

SQLNet Configuration (sqlnet.ora)

 Explanatio
Parameter Recommended Value
n

Windows
SQLNET.AUTHENTICATION_
(NTS) authentica
SERVICES
tion

Name
NAMES.DIRECTORY _PATH (TNSNAMES, EZCONNECT) resolution
order

(SSL_RSA_WITH_AES_256_CBC_ Encryption
SSL_CIPHER_SUITES
SHA) ciphers

8. Verification & Management Parameters

Key Status Commands

Command Purpose Expected Output

lsnrctl status Listener status STATUS: READY

Database
sqlplus / as sysdba Connected to Oracle
connection

SELECT name, open_mode FROM

Database status OPEN mode
v$database;

Version
SELECT * FROM v$version; 19.0.0.0.0
information
Enterprise Manager Configuration

Default Recommended
Parameter
Value Setting

EM Express
5500 Change if conflicting
Port

Use HTTPS for

HTTPS Port 5500
security

Configuratio Advanced for

Basic
n production

9. Backup & Recovery Configuration

RMAN Configuration Parameters

Parameter Recommended Value Explanation

RECOVERY WINDOW OF 7 Backup retention

RETENTION POLICY
DAYS period

BACKUP Avoid duplicate

ON
OPTIMIZATION backups

CONTROLFILE Automatic control file

ON
AUTOBACKUP backup

DEVICE TYPE DISK or SBT_TAPE Backup destination

 Archive Log Configuration

Parameter Recommended Value Explanation

LOG_ARCHIVE_DEST LOCATION=USE_DB_RECOVERY_FILE_D Archive log

_1 EST destination

LOG_ARCHIVE_FOR Archive log

%t_%s_%r.arc
MAT file naming

ARCHIVE_LAG_TARG Force log

1800 (30 minutes)
ET switching

Flash Recovery Area

Explanati
Parameter Recommended Value
on

Recovery
DB_RECOVERY_FILE_DEST C:\app\fast_recovery_area area
location

Recovery
DB_RECOVERY_FILE_DEST_SIZE 20-30% of total storage
area size

DB_FLASHBACK_RETENTION_T Flashback
1440 (24 hours)
ARGET retention

Best Practices Summary

1. Memory Allocation: Allocate 60-70% of available RAM to the database

2. Storage Separation: Keep data files, Oracle home, and recovery areas on
separate physical disks
3. Security: Use different passwords for each administrative account
4. Character Set: Use AL32UTF8 for internationalization support
5. Backup Strategy: Implement RMAN with retention policy and control file
autobackup
6. Monitoring: Enable Enterprise Manager for performance tracking
7. Network Security: Implement SSL encryption for sensitive environments
8. Regular Maintenance: Schedule regular backups and performance checks

This comprehensive guide with parameter explanations should provide a

solid foundation for installing, configuring, and managing Oracle Database
19c in various environments. Always refer to Oracle's official documentation
for specific requirements related to your use case.