Environment: Operating System: Windows 11 Pro Oracle Database: 23ai Note: Please note below resource limitations before installing Oracle database 23ai. 1) Oracle Database Free CPU Limitations: Oracle Database Free limits itself automatically to two cores for processing. 2) 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. 3) Oracle Database Free User Data Limitations: The maximum amount of user data in Oracle Database Free cannot exceed 12 GB. 4) Oracle Database Free RAM Limitation: The maximum amount of RAM for Oracle Database Free cannot exceed 2 GB, even if more is available. |
Step 1: Certication 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 troubleshooting any installation issues later. Oracle Database 23ai Free for Windows x64 is supported on the following operating system versions: - Windows 10 x64 - Pro, Pro for Workstations, Enterprise, and Education editions - Windows 11 x64 - Pro, Enterprise, and Education editions - Windows Server 2016 x64 - Standard, Datacenter, and Essentials editions - Windows Server 2019 x64 - Standard, Datacenter, and Essentials editions - Windows Server 2022 x64 - Standard, Datacenter, and Essentials editions Step 2: Operating System, Storage Requirements and Prerequisites. 1) Minimum 2 GB RAM. 2) Minimum 8.5 GB for Oracle software plus 2 GB or more for temporary storage. 3) Installer user must be a part of the Administrators group on Windows to install Oracle Database Free. If you are logged in as a domain user, ensure that you are connected to the network before you install Oracle Database Free software. 4) Ensure that the directory where you install Oracle Database Free 23ai, and any of its parent directories other than the root directory (eg C:\), cannot be modified by the Authenticated Users group. 5) Before attempting to install Oracle Database Free 23ai, uninstall any existing Oracle Database XE or Oracle Database Free or database with the SID XE or FREE from the target system. The installer will use SID FREE for database creation. Any SID other than SID FREE will not be allowed. 6) If the ORACLE_HOME or TNS_ADMIN environment variables have been set, then delete them. Step 3: Download Oracle database 23ai software and copy it to target server. Click here to direct download Software ---> Oracle Database 23ai Free on Windows       Now extract the downloaded zip file to a temporary location.     Step 4: Start Oracle database 23ai software installation. Before starting installation, ensure that the directory where you install Oracle Database Free 23ai, and any of its parent directories other than the root directory (eg C:\), cannot be modified by the Authenticated Users group. If you do not meet this requirement, then the installation rolls back and fails with an error in the beginning of the log found in the installation directory you provided, in the InstallActions<timestamp>.log file (installActions2024-08-16_03-27-32AM.log). The entire installation operation will be rolled back and nothing will be installed due to this error. Error message :- "Authenticated users. ACTION: Specify a path that does not exist or is not under a directory that is modifiable by Authenticated users".  To fix the above issue: 1) Oracle recommends that you create a new, top-level empty folder to install Oracle Database Free. For example: C:\> mkdir c:\dbfree 2) Disable the inheritance of the newly created folder: C:\> icacls c:\dbfree /inheritancelevel:d 3) Remove the Authenticated Users permissions from the folder: C:\> icacls c:\dbfree /remove:g *s-1-5-11 4) Start the Oracle Database Free installation. When you reach the Destination Folder screen, the installer prompts you to enter the installation directory, click Change to select the installation directory that you newly created. For example, select c:\dbfree. You can also install Oracle Database Free in new subfolders by providing additional subdirectories under c:\dbfree. For example, c:\dbfree\product\23ai.  Double click the setup.exe file and start the installation of Oracle Database 23ai.                Oracle database 23ai installation has been completed at this stage. You can check services.msc to crosscheck the database and listener services are running.    You can check network files as well.     Step 4: Connecting to Oracle Database Free. 1) Connecting Locally using OS Authentication: When you install Oracle Database Free, your Windows user is automatically added to the ORA_DBA operating system group, which grants you the SYSDBA privileges. Use the following commands to connect to the database. These commands connect you to the root container CDB$ROOT of the multitenant database (CDB) as database user SYS.C:\Windows\System32>set ORACLE_SID=FREE C:\Windows\System32>sqlplus / as sysdba  2) Connecting to Oracle Database Using Easy Connect Naming Method: You can connect to the database using the following Easy Connect strings: - Multitenant container database: host[:port] - Pluggable database: host[:port]/service_name Connection strings for local connections were provided on the final screen of the installation.  - Multitenant container database: host[:port] C:\Windows\System32>sqlplus sys/sys123@dbserver_hostname:1521 as sysdba  - Pluggable database: host[:port]/service_name C:\Windows\System32>sqlplus sys/sys123@dbserver_hostname:1521/FREEPDB1 as sysdba  |
Thanks for reading this post ! Please comment if you like this post ! Click FOLLOW to get future blog updates !
Great work
ReplyDelete