Oracle Database 23ai installation on RHEL 8.10 and connect with SQL Developer 24.3
0In this video we are going to show you how to install and configure Oracle Database 23ai Free - Developer Release on Red hat Enterprise 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 23ai on Red hat Enterprise 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 Red hat Enterprise Linux 8 DVD iso file itself.
Second install oracle-database-preinstall-23ai-1.0-0.5.el8.x86_64.rpm
Third install oracle-database-free-23ai-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
Finally, access the database via sqlplus and sqldeveloper.
Oracle Database 23ai new Features:
AI Vector Search
JSON Relational Duality
Operational Property Graphs in SQL
Microservice Support
Lock-Free Reservations
Kafka APIs for TxEventQ
JavaScript Stored Procedures
Priority Transactions
Data Use Case Domains
Many Data Type and SQL Enhancements
Improved Machine Learning Algorithms
Sharding Enhancements
Schema Privileges
Developer Role
SQL Firewall
Azure AD OAuth2 Integration
#23ai #oracle23ai #oracle23aifree #oracletutorial #oracle #oracledba #oracleinstallation #oracledatabase23ai