4 Installing Oracle Database Free

This section covers the following topics:

Authenticated Users Group Restriction for Oracle Database Free Installations on Windows

On Microsoft Windows, there is a requirement that the directory where you install Oracle Database Free 23ai, and any of its parent directories other than the root directory, (for example, C:\) cannot be modified by the Authenticated Users group.

Oracle recommends that you accept the default installation location provided during the installation or enter an installation path consisting of directories that do not exist yet. The installer will create these directories for you with the permissions set correctly.

Alternatively, you may provide an installation location consisting of existing directories and allow the installer to change the permissions on these directories, removing access by the Authenticated Users group. You should only allow the installer to change permissions on existing directories if you are sure that this will not impact other applications using these directories.

For more information, see step 8 in Running the Installer.

Note:

  • This restriction applies to the Authenticated Users group which cannot have the modify (Write/Rename/Delete) access on these directories. Administrators who are members of that group will still be able to install.
  • Non-server Windows operating systems, for example Windows 11, have modify access granted by default to the Authenticated Users group for directories created under C:\

Manually Changing Permissions on Installation Directories

As the installer can create directories with the correct permissions or change permissions on existing directories, it is not required that you change the permissions yourself. However, if you wish to change the permissions, you may perform these steps:
  1. Disable the inheritance of the top directory in the path.
    C:\> icacls c:\dbfree /inheritancelevel:d

    Note:

    It is not necessary to perform this command on every directory in the path:
  2. Remove the Authenticated Users permissions from each directory in the path:
    C:\> icacls c:\dbfree /remove:g *s-1-5-11
    C:\> icacls c:\dbfree\mydb /remove:g *s-1-5-11

Checking the Permissions of Your Directories

To check the permissions of the directories in the path where you want to install Oracle Database Free, perform one of the following steps for each directory in the path:

  1. Run the icacls utility to check the permissions of the directory. For example: C:\> icacls c:\dbfree
  2. In File Explorer, right-click the directory and select the Security tab.

If you see that the Authenticated Users group can modify any of the directories in the path other than the root directory (for example, C:\), then you will not be able to install Oracle Database Free in that directory.

Running the Installer

Most users will install Oracle Database Free by downloading the installation package, extracting the files, double-clicking setup.exe, and answering graphical user interface prompts as needed.

Note:

  • 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.

To install Oracle Database Free:

  1. Log on to Windows with Administrator privileges.

    You must be a direct member 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. Otherwise, you may receive a prerequisite check failure for Administrator privileges during the install.

  2. If the ORACLE_HOME or TNS_ADMIN environment variables have been set, then delete them.

  3. Download the Microsoft Windows version of Oracle Database Free.

  4. Extract the downloaded zip file to a temporary location. Locate setup.exe and double click it. The installation of the prerequisites will take place, if applicable, to the environment.

  5. In the Welcome to the InstallShield Wizard for Oracle Database 23ai Free window, click Next.

  6. In the License Agreement window, read the text of the agreement and if you agree to its terms, select I accept the terms in the license agreement and then click Next. If you do not accept the terms, cancel the installation and delete the Oracle Database 23ai Free software from the computer.

  7. The installer now performs a prerequisite check to ensure that:

    • the version and edition of Windows is supported

    • the environment variables ORACLE_HOME and TNS_ADMIN are not set

    • the installation user is a direct member of the Administrators group

    • there is no Oracle Database Free or Oracle Database Express Edition service already created

    If any of these checks fail, a Prerequisite Checks window will open notifying the user. In that case, cancel the installation, fix the problem, and retry the installation.

  8. In the Destination Folder window, either accept the default location or click Change and type a path containing directories that do not exist yet into the Folder Name field in the Change Current Destination Folder dialog box. This allows the installer to create the directories for you. Do not use the Create New Folder icon in the Change Current Destination Folder dialog box. You may also select an existing installation directory. However, do not select a directory that has spaces in its name. Click Next.

    Figure 4-1 Change Current Destination Folder Dialog Box



    On Microsoft Windows, there is a requirement that the directory where you install Oracle Database Free 23ai, and any of its parent directories cannot be modified by the Authenticated Users group. If you chose an existing directory and do not meet this requirement, the following warning screen appears:

    If you see this message, Oracle recommends that you click Change and type a path containing directories that do not exist yet in the Folder Name field in the Change Current Destination Folder dialog box. This allows the installer to create the directories for you with the correct permissions. Do not use the Create New Folder icon in the Change dialog box as it will not create folders with the proper permissions.

    Alternatively, select the Modify permissions on provided directories checkbox and click Next. The installer changes the permissions on the existing directories, removing access by the Authenticated Users group. Select this checkbox only if you are sure that changing the permissions will not impact other applications that use these directories.

    Note:

    If you wish to check directory permissions or set the permissions manually see Authenticated Users Group Restriction for Oracle Database Free Installations for more details.
  9. In the Oracle Database Information window, enter and confirm the single database password to use for the SYS, SYSTEM, and PDBADMIN database accounts. Then click Next.

    Note:

    The same password will be used for these accounts. The password should conform to the Oracle recommended standards. See Oracle Database Security Guide for more information about guidelines for securing passwords.

  10. In the Summary window, review the installation settings, and if you are satisfied, click Install. Otherwise, click Back and modify the settings as necessary.

  11. When the installation is complete, the Oracle Database Installed Successfully window is displayed.

    Make a note of the connection strings provided for multitentant container database and the pluggable database. Click Finish to close the installer.

Configuration, Database Files, and Logs Location

The following table lists important locations such as Oracle Base, Oracle Home, Database files, and logs. <INSTALL_DIR> is the installation directory chosen by you during the time of install. The default installation directory is C:\app\<username>\product\23ai, where <username> is the name of the Windows user performing the installation.

Table 4-1 Configuration, Database Files and Logs Location

File Name and Location Purpose

<INSTALL_DIR>

Oracle Base

This is the root of the Oracle Database Free directory tree.

<INSTALL_DIR>\dbhomeFree

Oracle Home

This home is where the Oracle Database Free is installed. It contains the directories of the Oracle Database Free executables and network files.

<INSTALL_DIR>\oradata\Free

Database files

<INSTALL_DIR>\diag\rdbms\free\free\trace

Diagnostic logs

The database alert log is <INSTALL_DIR>\diag\rdbms\free\free\trace\alert_free.log

<INSTALL_DIR>\cfgtoollogs\

Database installation, creation, and configuration logs.

The <INSTALL_DIR>\cfgtoollogs\dbca\Free\Free.log file contains the results of the database creation script execution.

%Program Files%\Oracle\Inventory\logs

Software installation logs.

Performing a Silent Installation

If you plan to install Oracle Database Free on multiple computers or bundle it with a third-party application, then you may want to perform a silent installation, in which you download the installation file and run it at a command line using the provided response files.

If you have an existing version of Oracle Database Free, you can save your data by exporting it to data files. After you install the new version of Oracle Database Free, you can import this data into the new database.

To perform a silent installation of Oracle Database Free:

  1. Log on to Windows with Administrator privileges.

    You must be 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.

  2. Download Oracle Database Free for Microsoft Windows. Extract the files to a temporary directory.

  3. Open the FREEInstall.rsp response file and modify the settings if necessary.

    Note:

    For information on response file parameters, see Table 4-2.
  4. If the ORACLE_HOME environment variable has been set, then delete it.

  5. Run the installation file with the FREEInstall.rsp response file.

    For example, if you extracted the setup.exe file and the FREEInstall.rsp file to a directory called free_temp, you would enter the following command:

    c:\free_temp> setup.exe /s /v"RSP_FILE=c:\free_temp\response\FREEInstall.rsp" /v"/L*v c:\free_temp\setup.log" /v"/qn"

    After the installation is complete, Oracle Database Free starts.

Response File Parameters

The following table describes the important response file parameters. The parameter value cannot be empty. You must specify a valid value for the parameters.

Table 4-2 Response File Parameters

Parameter Purpose Default Value

INSTALLDIR

The install directory location.

Replace [USERNAME] with current user.

INSTALLDIR=C:\app\<username>\product\23ai

PASSWORD

The Oracle Database Free password.

All users are set with this password. Reset the password immediately after the installation is complete.

PASSWORD=passwordvalue

LISTENER_PORT

The listener port.

LISTENER_PORT=0

If listener port is set to 0, available ports will be automatically allocated starting from 1521.

CHAR_SET

The character set of the database.

CHAR_SET=AL32UTF8

DB_DOMAIN

Specify the database domain name for the database unique name specification.

 
SOFTWARE_ONLY For software-only installations, specify SOFTWARE_ONLY=TRUE. This is required for True Cache configurations. SOFTWARE_ONLY=FALSE
MODIFY_DIRECTORY_PERMISSIONS

Specify MODIFY_DIRECTORY_PERMISSIONS=TRUE if the installer should modify the directory permissions when the ACL is incorrect. When you provide an installation path containing directories that have permissions for the Authenticated Users group, then the silent installation fails. By modifying this flag to TRUE, the installer changes the permissions on the existing directories, removing access by the Authenticated Users group.


                                    

Note: Specify MODIFY_DIRECTORY_PERMISSIONS=TRUE if you see the following message in the log file.

SEVERE: The provided destination folder is under a directory that is modifiable by
      Authenticated users. Specify a path that is not modifiable by Authenticated
    Users.

See Authenticated Group Restriction for Oracle Database Free Installations for more details.

MODIFY_DIRECTORY_PERMISSIONS=FALSE

Note:

After the installation is successfully completed, the following message is available in the log file that you have specified as the parameter to setup.exe. For example, c:\free_temp\setup.log:

MSI (c) (28:B8) [Timestamp]: Windows Installer installed the product. Product Name: Oracle Database 23ai Free Release. Product Version: 23.0.0.0.0. Product Language: [Current Language ID]. Manufacturer: Oracle Corporation. Installation success or error status: 0.

Since silent install runs asynchronously, you can check the log file for the completion status.

If the installation fails, see the following installation log files:
  • general logs: located at %Program Files%\Oracle\Inventory\logs
  • database creation logs: located at Oracle_base\cfgtoollogs