Oracle Database 23ai installation on AlmaLinux 9.5 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 AlmaLinux 9.
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.
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 23ai on AlmaLinux 9.
lm_sensors-libs-3.6.0-10.el9.x86_64.rpm
libev-4.33-5.el9.x86_64.rpm
libverto-libev-0.3.2-3.el9.x86_64.rpm
libverto-devel-0.3.2-3.el9.x86_64.rpm
libverto-0.3.2-3.el9.x86_64.rpm
keyutils-1.6.3-1.el9.x86_64.rpm
gssproxy-0.8.4-6.el9.x86_64.rpm
sysstat-12.5.4-7.el9.x86_64.rpm
chkconfig-1.24-1.el9.x86_64.rpm
libnsl-2.34-100.el9.x86_64.rpm
initscripts-10.11.6-1.el9.x86_64.rpm
rpcbind-1.2.6-7.el9.x86_64.rpm
ksh-1.0.6-3.el9.x86_64.rpm
libnfsidmap-2.5.4-25.el9.x86_64.rpm
nfs-utils-2.5.4-25.el9.x86_64.rpm
pcp-conf-6.2.0-2.el9_4.x86_64.rpm
pcp-6.2.0-2.el9_4.x86_64.rpm
pcp-libs-6.2.0-2.el9_4.x86_64.rpm
pcp-selinux-6.2.0-2.el9_4.x86_64.rpm
sssd-nfs-idmap-2.9.4-6.el9_4.x86_64.rpm
NOTE: all the above mentioned rpms are available in AlmaLinux 9 DVD iso file itself.
Second install oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm
Third install oracle-database-free-23ai-1.0-1.el9.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.
Create common user c##scott in CDB (FREE):
====================================================
create user c##scott identified by tiger;
grant connect, resource, unlimited tablespace, create domain to c##scott;
Queries to create usecase domains and table referencing domains:
=====================================================================
create domain email_dom as varchar2(100) constraint email_chk check (regexp_like (email_dom, '^(\S+)\@(\S+)\.(\S+)$')) display lower(email_dom) order lower(email_dom) annotations (Description 'Domain for Emails');
CREATE DOMAIN phone_dom AS VARCHAR2(15) CONSTRAINT phone_chk CHECK (REGEXP_LIKE(phone_dom, '^\+?[0-9]{1,3}[-. ]?[0-9]{2,3}[-. ]?[0-9]{3,4}$'));
CREATE DOMAIN cc_number_dom AS VARCHAR2(16) CONSTRAINT cc_mask CHECK (LENGTH(cc_number_dom) = 16);
CREATE DOMAIN dob_dom AS DATE;
CREATE TABLE customers (customer_id NUMBER PRIMARY KEY, customer_name VARCHAR2(50), email email_dom, phone phone_dom, credit_card cc_number_dom, date_of_birth dob_dom);
INSERT INTO customers (customer_id, customer_name, email, phone, credit_card, date_of_birth) VALUES (1, 'John Doe', 'johndoe@example.com', '555-123-4567', '1234567812345678', TO_DATE('1990-01-01', 'YYYY-MM-DD'));
INSERT INTO customers (customer_id, customer_name, email, phone, credit_card, date_of_birth) VALUES (2, 'Jane Smith', 'jane.smith@example.com', '555-765-4321', '8765432187654321', TO_DATE('1985-05-15', 'YYYY-MM-DD'));
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