Oracle Database 23c Free installation on Red hat Enterprise Linux 8 and connect with SQL Developer

In this video we are going to show you how to install and configure Oracle Database 23c Free - Developer Release on Red hat Enterprise Linux 8.

Oracle Database Free CPU Limitations:
Oracle Database Free limits itself automatically to two cores for processing. For example, on a computer with 2 dual-core CPUs (four cores), if a large number of database clients try to simultaneously run CPU-intensive queries, then Oracle Database Free will process the queries at the rate of just two cores even if more CPU capacity is available.

Oracle Database Free Installation and Runtime Restrictions:
Oracle Database Free restricts itself to only one installation per logical environment. The logical environment can either be a virtual host such as a VM or container, or a physical host. If you attempt to start more than one Oracle Database Free installation in such a logical environment, then an ORA-00442: Oracle Database Free single instance violation error is displayed and your database will not start.

This does not affect any existing installation or new installations of Oracle Database Standard Edition 2 or Oracle Database Enterprise Edition.

Oracle Database Free User Data Limitations:
The maximum amount of user data in Oracle Database Free cannot exceed 12 GB. If the user data grows beyond this limit, then the system displays an ORA-12592 error.

Oracle Database Free RAM Limitation:
The maximum amount of RAM for Oracle Database Free cannot exceed 2 GB, even if more is available.

Other Requirements:
A static ip address was already set to access the database in host machine.
SQL Developer installed in host machine to access the database.
Linux User "oracle" is created to install and configure the database.
Open the Oracle database port in Firewall (if you are using VM or try to access the database outside the network) by executing the command "firewall-cmd --add-port=1521/tcp --permanent"

First we need to install below rpm dependencies needed by Oracle Database 23c on Red hat Enterprise Linux 8.

NOTE: all the above mentioned rpms are available in Red hat Enterprise Linux 8 DVD iso file itself.

Fourth, set the ORACLE_HOME environment variable and add the oracle HOME's bin directory to linux path

Finally, access the database via sqlplus.

Oracle 23c new Features:

JSON

JSON-Relational Duality
JSON Schema
XML and JSON Search Index Enhancements
Enhancement to JSON_TRANSFORM
JSON/JSON_VALUE will Convert PL/SQL Aggregate Type to/from JSON
JSON_ARRAY Constructor by Query
ORDERED in JSON_SERIALIZE
Precheckable Constraints using JSON SCHEMA
Predicates for JSON_VALUE and JSON_QUERY
Tools to Migrate JSON Text Storage to JSON Type Storages
SQL

Annotations
Direct Joins for UPDATE and DELETE Statements
IF [NOT] EXISTS Syntax Support
New Database Role for Application Developers
Aggregation over INTERVAL Datatypes
Automatic PL/SQL to SQL Transpiler
DEFAULT ON NULL for UPDATE Statements
Extended CASE Controls
GROUP BY Column Alias or Position
SELECT Without FROM Clause
SQL BOOLEAN Data Type
SQL Domains
SQL UPDATE RETURN Clause Enhancements
Table Value Constructor
Unicode 15.0 Support
Graph

Property Graph: Native Representation of Graphs in Oracle Database
Property Graph: Support for the ISO/IEC SQL Property Graph Queries (SQL/PGQ) Standard
Property Graph: Use JSON Collections as a Graph Data Source
Property Graph: Use Native Representation of Graphs in Oracle Database with Graph Tools
Microservices

OKafka (Oracle's Kafka Implementation)
Prometheus/Grafana for Oracle
Python and REST Drivers for Transactional Event Queues (TxEventQ)
Transactional Event Queues (TxEventQ) Propagation

General

Multilingual Engine JavaScript Support for JSON Data Type
Efficient Table DDL Change Notification
Multilingual Engine JavaScript Modules and Environments
Multilingual Engine JavaScript SODA API
Multilingual Engine Module Calls
Multilingual Engine Post-Execution Debugging
Oracle Call Interface (OCI) Support for String Indexed PL/SQL Associative Arrays
SQL*Plus ARGUMENT Command
Unicode IVS (Ideographic Variation Sequence) Support and more ...

#23c #oracle23c #oracle23cfree #oracletutorial #oracle #oracledba #oracleinstallation #oracledatabase23c

[AnkitKumar]

How we can change ORACLE_HOME path. As i want to install into /u01 mount point

[mr.jadda_]

thank you, sir. Can we install 23c on RHEL 7.9. Is it supported on 7 or it is supported from RHEL8 only?? thx

[webfrasse]

Why not use Oracle Linux, it's free. Waaaay easier...