Oracle DB 21c Enterprise on Windows

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

Overview

Oracle Database 21c is Oracle's innovation release featuring the latest database technologies. This AMI provides Oracle DB 21c Enterprise pre-configured on Windows Server, delivering comprehensive SQL, PL/SQL, and advanced enterprise capabilities for mission-critical applications.

Oracle Database 21c Enterprise Features

Innovation release. Latest Oracle technologies. New 21c features. Enterprise-grade stability. Production ready. Security hardened. Performance optimized. High availability. Scalability.

21c Innovations

Blockchain tables. Native JSON data type. JavaScript stored procedures. Immutable tables. AutoML. Graph analytics. In-memory enhancements. JSON-relational duality.

Enterprise Edition Advanced Features

Real Application Clusters ready. Data Guard support. Active Data Guard. Advanced compression. Advanced security. Database vault. Label security. Partitioning. In-memory database.

SQL Engine

SQL query language. ANSI SQL compliance. Complex joins. Subqueries. Window functions. Common table expressions. Analytic functions. Query optimization.

PL/SQL

Procedural language. Stored procedures. Functions. Triggers. Packages. Exception handling. Bulk operations. Collections. Native compilation.

ACID Transactions

Atomicity. Consistency. Isolation. Durability. Transaction control. Commit and rollback. Savepoints. Read consistency. Multi-version concurrency.

Data Types

Numeric types. Character types. Date and timestamp. LOB types. JSON data type. XML data type. Spatial data types.

Indexing

B-tree indexes. Bitmap indexes. Function-based indexes. Composite indexes. Index organized tables.

Partitioning

Range partitioning. List partitioning. Hash partitioning. Composite partitioning. Interval partitioning. Partition pruning.

Security

Authentication. Authorization. Role-based access. User management. Transparent Data Encryption. Data masking. Auditing. Virtual Private Database.

Backup and Recovery

RMAN backup utility. Hot backups. Incremental backups. Point-in-time recovery. Flashback technology. Archive log mode.

High Availability

Automatic restart. Redo logs. Archive logs. Flashback database. Data Guard ready. Active Data Guard ready. RAC ready.

Performance Tuning

Automatic Workload Repository. SQL tuning advisor. Execution plans. Optimizer hints. Memory management. SGA configuration. PGA tuning.

Database Objects

Tables. Views. Materialized views. Sequences. Synonyms. Database links. Stored procedures. Functions. Packages. Triggers.

Concurrency Control

Row-level locking. Multi-version read consistency. Deadlock detection. Transaction isolation levels.

Data Integrity

Primary keys. Foreign keys. Unique constraints. Check constraints. Referential integrity.

SQL Developer Tools

SQL*Plus. SQL Developer. Oracle Enterprise Manager. Data Pump. SQL Loader. DBMS packages.

Monitoring

Dynamic performance views. Data dictionary views. Alert logs. AWR reports.

JSON Support

Native JSON data type. JSON queries. JSON path expressions. Document storage. JSON-relational duality.

Application Development

JDBC connectivity. ODBC connectivity. Oracle Call Interface. REST APIs. APEX integration. .NET connectivity.

Storage Management

Tablespaces. Datafiles. Undo management. Automatic storage management.

Networking

Oracle Net Services. TNS listener. Connection strings. Service names. Connection pooling.

Database Administration

Instance management. User administration. Privilege management. Resource management. Job scheduling.

Migration Tools

Data Pump export/import. SQL Loader. External tables. Database links.

Windows Integration

Windows Server 2019. Windows Services. Event Viewer logging. Windows authentication. Active Directory support. RDP access port 3389.

AWS Optimization

EC2 optimized. EBS storage. CloudWatch integration. Systems Manager. Auto scaling ready. VPC support.

cloudimg Support

24/7 support via phone, email, chat. Oracle Database expertise. Installation assistance. Configuration tuning. Performance optimization. Troubleshooting. Migration support.

Use Cases

Enterprise applications. ERP systems. Financial applications. E-commerce platforms. Data warehousing. OLTP workloads. Business intelligence. Blockchain applications.

FAQ

Q: Which Windows versions supported?

A: Windows Server 2019.

Q: Is this Enterprise Edition?

A: Yes, Oracle DB 21c Enterprise Edition.

Q: RAC and Data Guard ready?

A: Yes, Enterprise Edition supports RAC and Data Guard.

Q: What 21c features included?

A: Blockchain tables, native JSON, JavaScript procedures, immutable tables.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.