Oracle Database 23c Free installation on Rocky Linux 8 and connect with SQL Developer and start/stop
0In this video we are going to show you how to install and configure Oracle Database 23c Free - Developer Release on Rocky Linux 8.
Download link: https://www.oracle.com/database/free/get-started/
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 Requirments:
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 Rocky Linux 8.
compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm
ksh-20120801-257.0.1.el8.x86_64.rpm
libnsl-2.28-211.0.1.el8.x86_64.rpm
lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm
sysstat-11.7.3-7.0.1.el8.x86_64.rpm
NOTE: all the above mentioned rpms are available in Rocky Linux 8 DVD iso file itself.
Second install oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
Third install oracle-database-free-23c-1.0-1.el8.x86_64.rpm and follow the instructions.
Fourth, set the ORACLE_HOME environment variable and add the oracle HOME's bin directory to linux path
Fifth, access the database via sqlplus and sql developer.
Final part, how to startup and shudown the database and start and stop oracle listener in Oracle Database 23c on Rocky Linux 8.
By default oracle will not get started automatically so we need to start up the database and start the oracle listener.
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