Considering the focus on AI (Artificial Intelligence),Oracle decided to change the database's name from Oracle Database 23c to Oracle Database 23ai. To get more info about Oracle Database 23ai, refer the link What is Oracle Database 23ai? Refer link for software downloads & installation guide "Oracle Database 23ai downloads and installation guide". Windows users can run Oracle Database 23ai Free using the provided container image and Docker Desktop for Windows or Oracle VM VirtualBox image. A Windows native installation is coming soon. Software Download Links: Configuration Details: Database Software: Oracle Database 23ai Operating System: Redhat Enterprise Linux 8.7 64 Bit (5.15.0-3.60.5.1.el8uek.x86_64) Step 1: Certification Matrix First step that I always prefer before installing any software is to check the Certification Matrix. It is always best practice to check this first rather than troubleshoot any installation issues later.  Here, you can see the installed operating system is Redhat Linux 8.7 64 Bit and the kernel version is 5.15.0-3.60.5.1.el8uek.x86_64 which is higher than the required kernel version.  Step 2: Operating System Requirements 1) Install below RPM packages for Red Hat Enterprise Linux 8. Install the latest released versions of the following packages: - bc - binutils - compat-openssl10 - elfutils-libelf - fontconfig - glibc - glibc-devel - ksh - libaio - libXrender - libX11 - libXau - libXi - libXtst - libgcc - libnsl - libstdc++ - libxcb - libibverbs - libasan - liblsan - librdmacm - make - policycoreutils - policycoreutils-python-utils - smartmontools - sysstat - ipmiutil (for Intelligent Platform Management Interface) - Optional RPM - libnsl2 (for Oracle Database Client only) - Optional RPM - libnsl2-devel (for Oracle Database Client only) - Optional RPM - net-tools (for Oracle RAC and Oracle Clusterware) - Optional RPM - nfs-utils (for Oracle ACFS) - Optional RPM 2) The following Network protocols are supported. IPC UDP TCP/IP TCP/IP with SSL 3) Minimum 1 GB RAM required for installation, but 2 GB is recommended. Minimum swap space of 2 GB or twice the size of RAM is required. 4) Ensure below kernel parameter are set. This will automatically will be added by preinstallation RPM package. semmsl 250 semmns 32000 semopm 100 semmni 128 shmmax 4398046511104 shmmni 4096 shmall 1073741824 file-max 6815744 aio-max-nr 1048576 ip_local_port_range 9000–65500 panic_on_oops 1 rmem_default 262144 rmem_max 4194304 wmem_default 262144 wmem_max 1048576 #Ensure firewall is stopped on server. [root@orahost opt]# systemctl status firewalld ● firewalld.service - firewalld - dynamic firewall daemon Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled) Active: inactive (dead) Docs: man:firewalld(1) #Ensure selinux is disabled. [root@orahost ~]# cat /etc/selinux/config | grep -v "#" SELINUX=disabled SELINUXTYPE=targeted Step 3: Download below RPM packages and copy to target server. 1) oracle-database-preinstall-23ai-1.0-2.el8.x86_64 2) oracle-database-free-23ai-1.0-1.x86_64         Step 4: Install preinstallation RPM before installing actual software. Oracle preinstallation RPM does the following tasks: - Performs preinstallation checks. - Automatically creates the Oracle installation owner and groups. - Adds kernel parameters in /etc/sysctl.conf file. No need to add these manually. - Extracts the database software and reassigns ownership of the extracted software to the preconfigured user and groups. - Maintains the Oracle inventory and runs all root operations required to configure the Oracle Database software for a single-instance Oracle Database creation and configuration. Execute below commands by root user. [root@orahost ~]# cd /media/sf_Downloads/ [root@orahost sf_Downloads]# ls -ltr *database* -rwxrwx--- 1 root vboxsf 1378076936 May 15 03:19 oracle-database-free-23ai-1.0-1.el8.x86_64.rpm -rwxrwx--- 1 root vboxsf 31152 May 15 03:28 oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm root@orahost sf_Downloads]# dnf -y install oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm Repository ol8_UEKR7 is listed more than once in the configuration Last metadata expiration check: 376 days, 21:43:01 ago on Thu 04 May 2023 06:43:57 AM EDT. Dependencies resolved. ============================================================================================================================================================== Package Architecture Version Repository Size ============================================================================================================================================================== Installing: oracle-database-preinstall-23ai x86_64 1.0-2.el8 @commandline 30 k Transaction Summary ============================================================================================================================================================== Install 1 Package Total size: 30 k Installed size: 78 k Downloading Packages: Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : oracle-database-preinstall-23ai-1.0-2.el8.x86_64 1/1 Running scriptlet: oracle-database-preinstall-23ai-1.0-2.el8.x86_64 1/1 Verifying : oracle-database-preinstall-23ai-1.0-2.el8.x86_64 1/1 Installed: oracle-database-preinstall-23ai-1.0-2.el8.x86_64 Complete! #Verify preinstallation RPM is installed on server. [root@orahost ~]# rpm -qa | grep -i database oracle-database-preinstall-23ai-1.0-2.el8.x86_64 Verify kernel parameters from /etc/sysctl.conf file. [root@orahost ~]# cat /etc/sysctl.conf | grep -v "#" fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65535 kernel.panic = 10 #Verify user and groups [root@orahost opt]# id oracle uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba) [root@orahost ~]# cat /etc/passwd | grep -i oracle oracle:x:54321:54321::/home/oracle:/bin/bash [root@orahost ~]# cat /etc/group | egrep -i "oinstall|dba" oinstall:x:54321:oracle dba:x:54322:oracle backupdba:x:54324:oracle dgdba:x:54325:oracle kmdba:x:54326:oracle racdba:x:54330:oracle Step 5: Start Oracle Database 23ai Installation Execute below command by root user. [root@orahost sf_Downloads]# dnf -y install oracle-database-free-23ai-1.0-1.el8.x86_64.rpm Repository ol8_UEKR7 is listed more than once in the configuration Last metadata expiration check: 376 days, 21:51:44 ago on Thu 04 May 2023 06:43:57 AM EDT. Dependencies resolved. ============================================================================================================================================================== Package Architecture Version Repository Size ============================================================================================================================================================== Installing: oracle-database-free-23ai x86_64 1.0-1 @commandline 1.3 G Transaction Summary ============================================================================================================================================================== Install 1 Package Total size: 1.3 G Installed size: 3.6 G Downloading Packages: Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Running scriptlet: oracle-database-free-23ai-1.0-1.x86_64 1/1 Installing : oracle-database-free-23ai-1.0-1.x86_64 1/1 Running scriptlet: oracle-database-free-23ai-1.0-1.x86_64 1/1 [INFO] Executing post installation scripts... [INFO] Oracle home installed successfully and ready to be configured. To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23ai.conf' and then run '/etc/init.d/oracle-free-23ai configure' as root. Verifying : oracle-database-free-23ai-1.0-1.x86_64 1/1 Installed: oracle-database-free-23ai-1.0-1.x86_64 Complete! #Verify installation RPM is installed on server. [root@orahost ~]# rpm -qa | grep -i database oracle-database-free-23ai-1.0-1.x86_64 oracle-database-preinstall-23ai-1.0-2.el8.x86_64 #You can see that DB and LISTENER have not been configured yet. root@orahost sf_Downloads]# ps -ef | grep pmon root 25683 8845 0 05:28 pts/0 00:00:00 grep --color=auto pmon [root@orahost sf_Downloads]# ps -ef | grep tns root 5 2 0 03:25 ? 00:00:00 [netns] root 25706 8845 0 05:28 pts/0 00:00:00 grep --color=auto tns #You can verify the installed binaries located in /opt/oracle/product/23ai/dbhomefree. [root@orahost sf_Downloads]# cd /opt [root@orahost opt]# ls -tlr drwxr-xr-x 8 root root 136 May 15 02:41 VBoxGuestAdditions-6.1.22 drwxr-xr-x 3 root root 22 May 16 05:27 ORCLfmap drwxr-xr-x 5 oracle oinstall 53 May 16 05:27 oracle [root@orahost opt]# cd oracle [root@orahost oracle]# ls -ltr drwxr-xr-x 3 oracle oinstall 18 May 15 04:36 product drwxrwx--- 4 oracle oinstall 78 May 16 05:27 oraInventory drwxrwxr-x 25 oracle oinstall 4096 May 16 05:27 diag [root@orahost oracle]# cd product/ [root@orahost product]# ls -ltr drwxrwxr-x 3 oracle oinstall 24 May 15 04:36 23ai [root@orahost product]# cd 23ai [root@orahost 23ai]# ls -ltr drwxrwxr-x 63 oracle oinstall 4096 May 16 05:27 dbhomeFree [root@orahost 23ai]# cd dbhomeFree/ [root@orahost dbhomeFree]# ls -ltr -rw-r--r-- 1 oracle oinstall 852 Aug 18 2015 env.ora -rw-r--r-- 1 oracle oinstall 2927 Jul 20 2020 schagent.conf -rwxr-x--- 1 oracle oinstall 2500 Oct 24 2023 runInstaller -rwx------ 1 oracle oinstall 525 Apr 24 15:45 root.sh drwxrwxr-x 2 oracle oinstall 6 Apr 24 15:45 log -rwxrwxr-x 1 oracle oinstall 5780 Apr 24 15:45 LICENSE drwxr-xr-x 2 oracle oinstall 26 May 15 04:36 QOpatch drwxr-xr-x 13 oracle oinstall 4096 May 15 04:36 OPatch drwxr-xr-x 5 oracle oinstall 52 May 15 04:36 R drwxr-xr-x 2 oracle oinstall 102 May 15 04:36 addnode drwxr-xr-x 10 oracle oinstall 107 May 15 04:37 assistants drwxr-xr-x 2 oracle oinstall 8192 May 15 04:37 bin drwxr-xr-x 4 oracle oinstall 87 May 15 04:37 clone drwxr-xr-x 6 oracle oinstall 55 May 15 04:37 crs drwxr-xr-x 4 oracle oinstall 31 May 15 04:37 crypto drwxr-xr-x 3 oracle oinstall 18 May 15 04:37 css drwxr-xr-x 11 oracle oinstall 119 May 15 04:37 ctx drwxr-xr-x 7 oracle oinstall 71 May 15 04:37 cv drwxr-xr-x 3 oracle oinstall 20 May 15 04:37 data drwxr-xr-x 2 oracle oinstall 22 May 15 04:37 dbs drwxr-xr-x 5 oracle oinstall 173 May 15 04:37 deinstall drwxr-xr-x 3 oracle oinstall 20 May 15 04:37 diagnostics drwxr-xr-x 3 oracle oinstall 20 May 15 04:37 demo drwxr-xr-x 3 oracle oinstall 19 May 15 04:37 dv drwxr-xr-x 3 oracle oinstall 18 May 15 04:37 has drwxr-xr-x 5 oracle oinstall 41 May 15 04:37 hs drwxr-xr-x 2 oracle oinstall 29 May 15 04:37 instantclient drwxr-x--- 12 oracle oinstall 4096 May 15 04:37 inventory drwxr-xr-x 9 oracle oinstall 94 May 15 04:37 javavm drwxr-xr-x 3 oracle oinstall 17 May 15 04:37 jdbc drwxr-xr-x 6 oracle oinstall 68 May 16 05:26 jdk drwxr-xr-x 2 oracle oinstall 4096 May 16 05:26 jlib drwxr-xr-x 10 oracle oinstall 112 May 16 05:26 ldap drwxr-xr-x 3 oracle oinstall 12288 May 16 05:26 lib drwxr-xr-x 5 oracle oinstall 42 May 16 05:27 md drwxr-xr-x 4 oracle oinstall 31 May 16 05:27 mgw drwxr-xr-x 10 oracle oinstall 106 May 16 05:27 network drwxr-xr-x 5 oracle oinstall 46 May 16 05:27 nls drwxr-xr-x 8 oracle oinstall 133 May 16 05:27 odbc drwxr-xr-x 5 oracle oinstall 42 May 16 05:27 olap drwxr-xr-x 4 oracle oinstall 35 May 16 05:27 oml4py drwxr-xr-x 7 oracle oinstall 65 May 16 05:27 opmn drwxr-xr-x 5 oracle oinstall 45 May 16 05:27 oracore drwxr-xr-x 4 oracle oinstall 29 May 16 05:27 ord drwxr-xr-x 3 oracle oinstall 19 May 16 05:27 oss drwxr-xr-x 8 oracle oinstall 4096 May 16 05:27 oui drwxr-xr-x 5 oracle oinstall 39 May 16 05:27 perl drwxr-xr-x 6 oracle oinstall 106 May 16 05:27 plsql drwxr-xr-x 7 oracle oinstall 88 May 16 05:27 precomp drwxr-xr-x 5 oracle oinstall 39 May 16 05:27 python drwxr-xr-x 4 oracle oinstall 29 May 16 05:27 racg drwxr-xr-x 13 oracle oinstall 140 May 16 05:27 rdbms drwxr-xr-x 3 oracle oinstall 21 May 16 05:27 relnotes drwxr-xr-x 3 oracle oinstall 18 May 16 05:27 slax drwxr-xr-x 5 oracle oinstall 119 May 16 05:27 sdk drwxr-xr-x 4 oracle oinstall 28 May 16 05:27 sqlcl drwxr-xr-x 3 oracle oinstall 17 May 16 05:27 sqlj drwxr-xr-x 3 oracle oinstall 4096 May 16 05:27 sqlpatch drwxr-xr-x 6 oracle oinstall 53 May 16 05:27 sqlplus drwxr-xr-x 6 oracle oinstall 54 May 16 05:27 srvm drwxr-xr-x 3 oracle oinstall 17 May 16 05:27 ucp drwxr-xr-x 4 oracle oinstall 31 May 16 05:27 usm drwxr-xr-x 2 oracle oinstall 33 May 16 05:27 utl drwxr-x--- 7 oracle oinstall 69 May 16 05:27 xdk -rw-rw---- 1 oracle oinstall 130 May 16 05:27 oraInst.loc drwxrwx--- 3 oracle oinstall 17 May 16 05:27 cfgtoollogs drwxrwx--- 11 oracle oinstall 4096 May 16 05:27 install The installation of the Oracle Database software is now complete. Now its time to create and configure database and listener. Step 6: Oracle Database 23ai Creation and Configuration. The configuration script creates a container database "FREE" with one pluggable database "FREEPDB1" and configures the listener "LISTENER" at the default port "1521". You can modify the configuration parameters by editing the /etc/sysconfig/oracle-free–23ai.conf file. To create the database with the default settings, execute below command by logging as a root. [root@orahost ~]# /etc/init.d/oracle-free-23ai configure [root@orahost ~]# ls -ltr /etc/init.d/oracle-free-23ai -r-xr-xr-x 1 root root 20518 Apr 24 15:46 /etc/init.d/oracle-free-23ai Here, I have used the password: India1234 #At this stage, if you try to check the service status then, it will show as "NOT CONFIGURED". [root@orahost sf_Downloads]# /etc/init.d/oracle-free-23ai status Status of the Oracle FREE 23ai service: LISTENER status: NOT CONFIGURED FREE Database status: NOT CONFIGURED #You can also see in the systemctl command that the Oracle Database 23ai service is not yet loaded. [root@orahost sf_Downloads]# systemctl status oracle-free-23ai ● oracle-free-23ai.service Loaded: not-found (Reason: Unit oracle-free-23ai.service not found.) Active: active (exited) since Thu 2024-05-16 11:32:18 EDT; 20h ago Tasks: 0 (limit: 16807) Memory: 0B CGroup: /system.slice/oracle-free-23ai.service May 16 11:31:06 orahost.localdomain systemd[1]: Starting SYSV: This script is responsible for taking care of configuring the RPM Oracle FREE Database and its> May 16 11:31:08 orahost.localdomain oracle-free-23ai[783]: Starting Oracle Net Listener. May 16 11:31:09 orahost.localdomain su[814]: (to oracle) root on none May 16 11:31:22 orahost.localdomain oracle-free-23ai[783]: Oracle Net Listener started. May 16 11:31:22 orahost.localdomain oracle-free-23ai[783]: Starting Oracle Database instance FREE. May 16 11:31:22 orahost.localdomain su[1743]: (to oracle) root on none May 16 11:31:22 orahost.localdomain su[1743]: pam_unix(su:session): session opened for user oracle by (uid=0) May 16 11:32:18 orahost.localdomain oracle-free-23ai[783]: Oracle Database instance FREE started. May 16 11:32:18 orahost.localdomain systemd[1]: Started SYSV: This script is responsible for taking care of configuring the RPM Oracle FREE Database and its > [root@orahost ~]# /etc/init.d/oracle-free-23ai configure Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts: Confirm the password: Configuring Oracle Listener. Listener configuration succeeded. Configuring Oracle Database FREE. Enter SYS user password: ******** Enter SYSTEM user password: ********** Enter PDBADMIN User Password: ********* Prepare for db operation 7% complete Copying database files Unable to copy the file "/tmp/oratab" to "/etc/oratab". 29% complete Creating and starting Oracle instance 30% complete 33% complete 36% complete 39% complete 43% complete Completing Database Creation 47% complete 49% complete 50% complete Creating Pluggable Databases 54% complete 71% complete Executing Post Configuration Actions 93% complete Running Custom Scripts 100% complete Database creation complete. For details check the logfiles at: /opt/oracle/cfgtoollogs/dbca/FREE. Database Information: Global Database Name:FREE System Identifier(SID):FREE Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details. Connect to Oracle Database using one of the connect strings: Pluggable database: orahost.localdomain/FREEPDB1 Multitenant container database: orahost.localdomain [root@orahost ~]# #You can verify the installtion log files located in "/opt/oracle/cfgtoollogs/dbca/FREE/". [root@orahost ~]# cd /opt/oracle/cfgtoollogs/dbca/FREE [root@orahost FREE]# ls -ltr -rw-r----- 1 oracle oinstall 0 May 16 05:32 rmanUtil -rw-r----- 1 oracle oinstall 506 May 16 05:34 CloneRmanRestore.log -rw-r----- 1 oracle oinstall 18759680 May 16 05:34 tempControl.ctl -rw-r----- 1 oracle oinstall 1802 May 16 05:35 cloneDBCreation.log -rw-r----- 1 oracle oinstall 4760 May 16 05:36 utlfixdirs0.log -rw------- 1 oracle oinstall 3171 May 16 05:36 utlfixdirs_catcon_28225.lst -rw-r----- 1 oracle oinstall 5394 May 16 05:36 execemx0.log -rw------- 1 oracle oinstall 3159 May 16 05:36 execemx_catcon_28320.lst -rw-r----- 1 oracle oinstall 1669 May 16 05:36 postScripts.log -rw-r----- 1 oracle oinstall 930 May 16 05:36 lockAccount.log -rw-r----- 1 oracle oinstall 9930 May 16 05:41 utlrp0.log -rw------- 1 oracle oinstall 3151 May 16 05:41 utlrp_catcon_28417.lst -rw-r----- 1 oracle oinstall 2245 May 16 05:43 postDBCreation.log -rw-r----- 1 oracle oinstall 0 May 16 05:43 PDBCreation.log -rw-r----- 1 oracle oinstall 411 May 16 05:44 plugDatabase.log -rw-r----- 1 oracle oinstall 46 May 16 05:44 postPDBCreation.log -rw-r----- 1 oracle oinstall 0 May 16 05:44 customScripts.log -rw-r----- 1 oracle oinstall 1003 May 16 05:44 FREE.log -rw-r----- 1 oracle oinstall 1158531 May 16 05:44 trace.log_2024-05-16_05-31-55AM_26352 #Now you can verify the database and listener existence by executing below comands. [oracle@orahost ~]$ ps -ef | grep pmon oracle 28848 2673 0 05:42 ? 00:00:00 db_pmon_FREE oracle 30150 30091 0 05:55 pts/0 00:00:00 grep --color=auto pmon [oracle@orahost ~]$ ps -ef | grep tns root 5 2 0 03:25 ? 00:00:00 [netns] oracle 26339 2673 0 05:31 ? 00:00:00 /opt/oracle/product/23ai/dbhomeFree/bin/tnslsnr LISTENER -inherit oracle 30155 30091 0 05:55 pts/0 00:00:00 grep --color=auto tns #Now you can login as oracle user and connect to the database by executing below commands. [oracle@orahost ~]$ id uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba) oracle@orahost ~]$ . oraenv ORACLE_SID = [oracle] ? FREE ORACLE_HOME = [/home/oracle] ? /opt/oracle/product/23ai/dbhomeFree The Oracle base has been set to /opt/oracle [oracle@orahost ~]$ env | grep ORA ORACLE_SID=FREE ORACLE_BASE=/opt/oracle ORACLE_HOME=/opt/oracle/product/23ai/dbhomeFree [oracle@orahost ~]$ which sqlplus /opt/oracle/product/23ai/dbhomeFree/bin/sqlplus [oracle@orahost ~]$ sqlplus / as sysdba SQL*Plus: Release 23.0.0.0.0 - Production on Thu May 16 05:56:04 2024 Version 23.4.0.24.05 Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to: Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free Version 23.4.0.24.05 SQL> select name,open_mode,database_role,log_mode from v$database; NAME OPEN_MODE DATABASE_ROLE LOG_MODE --------- -------------------- ---------------- ------------ FREE READ WRITE PRIMARY NOARCHIVELOG SQL> select banner from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 FREEPDB1 READ WRITE NO #You can also verify the LISTENER status. [oracle@orahost ~]$ lsnrctl status LSNRCTL for Linux: Version 23.0.0.0.0 - Production on 16-MAY-2024 05:56:46 Copyright (c) 1991, 2024, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orahost.localhost.localdomain)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 23.0.0.0.0 - Production Start Date 16-MAY-2024 05:31:53 Uptime 0 days 0 hr. 24 min. 52 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service FREE Listener Parameter File /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora Listener Log File /opt/oracle/diag/tnslsnr/orahost/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orahost.localdomain)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "189011a1798d7228e0650a0027822869" has 1 instance(s). Instance "FREE", status READY, has 1 handler(s) for this service... Service "FREE" has 1 instance(s). Instance "FREE", status READY, has 1 handler(s) for this service... Service "FREEXDB" has 1 instance(s). Instance "FREE", status READY, has 1 handler(s) for this service... Service "freepdb1" has 1 instance(s). Instance "FREE", status READY, has 1 handler(s) for this service... The command completed successfully #You can see the listener and tns entries have automatically been created by configuration script. [oracle@orahost ~]$ cd $ORACLE_HOME/network/admin [oracle@orahost admin]$ ls -ltr -rw-r--r-- 1 oracle oinstall 1866 May 19 2021 shrept.lst drwxr-xr-x 2 oracle oinstall 64 May 16 05:27 samples -rw-r----- 1 oracle oinstall 191 May 16 05:31 sqlnet.ora -rw-r----- 1 oracle oinstall 386 May 16 05:31 listener.ora -rw-r----- 1 oracle oinstall 444 May 16 05:36 tnsnames.ora [oracle@orahost admin]$ cat listener.ora # listener.ora Network Configuration File: /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora # Generated by Oracle configuration tools. DEFAULT_SERVICE_LISTENER = FREE LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orahost.localhost.localdomain)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) [oracle@orahost admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /opt/oracle/product/23ai/dbhomeFree/network/admin/tnsnames.ora # Generated by Oracle configuration tools. FREE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orahost.localhost.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = FREE) ) ) LISTENER_FREE = (ADDRESS = (PROTOCOL = TCP)(HOST = orahost.localhost.localdomain)(PORT = 1521)) #You can also connect the PDB database remotely by below command. [oracle@orahost admin]$ sqlplus sys@orahost.localdomain/FREEPDB1:1521 as sysdba SQL*Plus: Release 23.0.0.0.0 - Production on Thu May 16 06:01:40 2024 Version 23.4.0.24.05 Copyright (c) 1982, 2024, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free Version 23.4.0.24.05 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 FREEPDB1 READ WRITE NO #You can also connect the container database remotely by tns entry. [oracle@orahost admin]$ sqlplus sys@FREE as sysdba SQL*Plus: Release 23.0.0.0.0 - Production on Thu May 16 06:02:01 2024 Version 23.4.0.24.05 Copyright (c) 1982, 2024, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free Version 23.4.0.24.05 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 FREEPDB1 READ WRITE NO Please note the below limitations. Resource Limitations: 1) Oracle Database Free CPU Limitations: Oracle Database Free limits automatically to two cores for processing even if more CPU capacity is available. 2) Oracle Database Free Installation and Runtime Restrictions: Oracle Database Free limits to only one installation per logical environment (VM or container or a physical host). If you attempt to start more than one Oracle Database Free installation, then an error message "ORA-00442: Oracle Database Free single instance violation error is displayed" and 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. 3) Oracle Database Free User Data Limitations: The max amount of user data in Oracle Database Free cannot exceed 12 GB. If the user data grows beyond this limit, then an error message "ORA-12954: The request exceeds the maximum allowed database size of 12 GB error" is displayed. 4) Oracle Database Free RAM Limitation: The max amount of RAM for Oracle Database Free cannot exceed 2 GB even if more is available. |
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get next blog updates !
thanks for sharing the knowledge...
ReplyDelete