Express Setup for the Aternity Oracle Database Server (Oracle 18c or 19c)

Use the express setup of the Aternity Oracle Database to quickly and easily set up the Aternity Oracle Database Server for trial and small deployments. Even if you are not a licensed Oracle DBA, you can easily complete the express setup of the Aternity Oracle Database.

Note

This procedure is relevant for Oracle 18c or 19c. File names and paths may vary accordingly.

Procedure

  1. Step 1 Log in to the computer as a local administrator.

    To verify you are a local administrator on this computer, not a domain administrator, open the System control panel, select Advanced system settings > Computer Name, and confirm the Change button is active.

  2. Step 2 Download from the Aternity Support Site (learn more) all Oracle related packages to a temporary directory, such as d:\tmp (It can be any drive, but not the System C drive).
    You are prompted to unpack each setup package in its own directory in steps 3-5!

    For the purpose of this article, D: will be used as the selected drive.

    Package Files

    Silent_install_Oracle18c.zip or Silent_install_Oracle19c.zip

    Contains the express database setup script files, as supplied by Aternity, including:

    • Install.bat is the main file you launch to create a new Aternity database. It silently runs the Oracle software setup, and then creates and configures the database.

    • aternity.dbt is the database template file that contains the settings to create the Aternity database. You choose a *.dbt file, such as aternity_<version>_medium.dbt, based on your deployment size, and rename it to aternity.dbt, which the setup script uses.

    • custom.sql stops some unnecessary Oracle jobs from running.

    • db_install.rsp is the response file that automatically provides parameters needed for the installation process.

    DB Templates (included in the folder Silent_install_Oracle)

    The folder which contains the database template files for the possible deployment sizes.

    Oracle18c.zip or Oracle19c.zip installation package, including WindowsX64_180000_db_Home or WindowsX64_190000_db_Home

    Contains the original database setup and configuration files for Oracle, as supplied by Oracle.

    This package must be unpacked to D:\<any_path_as_desired>\product\18.3 or D:\<any_path_as_desired>\product\19.3 depending on the version you deploy.

  3. Step 3 Create a destination directory for the Oracle software, such as D:\Oracle, and one for the Oracle database itself, such as D:\oradata.

    The Oracle software hosts and runs the database, though the software and the database can have different pathnames.

  4. Step 4 Unpack each setup package in its own directory on the Oracle Database Server, where the path does not contain any spaces or special characters.
  5. Step 5 Unpack the Oracle installation package WindowsX64_<version>_db_Home to the target directory on the Oracle Database Server, such as \product\<version> (It can be any drive, but not the System C drive).
  6. Step 6 Open a command prompt as an administrator.

    Search for cmd on your computer, right-click and select Run as Administrator.

    Open the computer's command prompt as an administrator
  7. Step 7 Run the express database setup by navigating to your installation file directory, and enter install.bat.
    You must run the batch file from the installation directory. Do NOT install from another directory by using the full absolute path.
  8. Step 8 Provide the path to the Oracle installation directory where you unpacked the file.

    If you extracted the files to D:\oracle\product\<version>, enter D:\oracle.

  9. Step 9 Provide the destination directory of the database (D:\oradata).
    File Description
    Oracle software installation directory

    Enter the path to the Oracle installation directory where you unpacked the file.

    ORACLE_BASE

    The target destination path for the Oracle software, which hosts and runs the database is automatically set to <drive letter>:\oracle.

    ORACLE_HOME

    It corresponds to the environment in which Oracle database products run. This includes the location of installed product files. The destination path is automatically set to <drive letter>:\oracle\product\18.3

    Oracle database files

    Enter the target destination path for the Aternity Oracle database. The default is d:\oradata.

  10. Step 10 Confirm the settings and enter y. The script opens a new window and starts setting up Oracle with this database configuration.

    The express database setup may take up to several hours. It may sometimes appear non-responsive, but it is working in the background. The setup may open more than one command window at a time. Do NOT close any of the setup windows until the setup has completed.

    Tip

    If you receive an Oracle Error 534, Cannot add user to application launch ACL, you can safely ignore it.

  11. Step 11 Once the setup has completed, press any key and continue creating the Aternity database.

    This closes the secondary window which it opened earlier.

    The express setup succeeded

    You can check the logs after the installation, for example, if you encounter errors:

    • Aternity's express database setup log, D:\oracle\product\<version>\Oracle_install.log

    • Oracle's software installation log, D:\oracle\product\<version>\cfgtoollogs\oui

    • Oracle's database creation log, D:\oracle\cfgtoollogs\dbca\aternity

  12. Step 12 In the new command window that opens, define passwords for the two mandatory Oracle database users.

    Every Oracle database must have the following two users defined:

    Enter passwords for the Oracle default users
    Field Description
    SYS

    Enter the password for the mandatory internal user called SYS, which owns the core base data in the database. It has SYSDBA privileges.

    SYSTEM

    Enter the password for the SYSTEM user which you can use as a proxy user to access the database as SYSDBA.

    Verify success with the message 100% complete.

    View the progress of creating the Aternity database
  13. Step 13 Check the status of the setup in the log file.

    Open <setup path>\cfgtoollogs\dbca\aternity\aternity.log and search for Database creation complete, to confirm it was successful. If required, the setup log for the underlying Oracle software is located in D:\oracle\product\18.3\Oracle_install.log.

  14. Step 14 Check the status of the Oracle services.

    Open the Windows Task Manager or the Windows Services to check the status of the Oracle services. Verify it displays the five Oracle services, four Running and one Stopped.

    Check the status of the Oracle services in the Windows Task Manager
  15. Step 15 Check the compatibility of the internal structure of the database by verifying the database.