Versions Compared

Old Version 51

changes.mady.by.user Karl Henselin

Saved on

compared with

New Version 52

changes.mady.by.user Karl Henselin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page provides the system requirements and installation instructions for the FlexDeploy database tier.

Requirements

  • 8GB of RAM

  • 1 or 2 CPU

  • At least 20GB of available space, may need additional space based on purge criteria and usage.

Automated Installer Instructions

If you are using the automated installer, install the Oracle Database binaries. If you use the automated installer, the FD, FF, and FD_ADMIN schemas will be created in the USERS tablespace.

That's it; go back to the automated installer documentation because the schema creation is automated.

...

Run these database scripts from where you extracted downloaded FlexDeploy zip file. Navigate to the /database/oracle/install directory, and run the following SQL scripts using sqlplus.

Info
title

Use of Tablespaces

Database scripts documented below will create FF, FD and FD_ADMIN schemas with USERS tablespace as default tablespace. You can either change to use different tablespace (update CreateFF.sql, CreateFD.sql) or configure USERS tablespace with appropriate storage configurations. Normal database backup procedures should be followed.

The AL32UTF8 character set is a good choice.

...

Step 1. Create FlexDeploy schema objects.

  • CreateFlexDeploySchemas.sql <password>

    • password – the password to use for FD, FF, and FD_ADMIN users, which are created by this script.

    • Example: @CreateFlexDeploySchemas.sql welcome1

    • Results are automatically spooled to a file called CreateFlexDeploySchemas.out


SqlPlus

title
Info

sqlplus

Oracle sqlus is part of the Oracle Client, and may be executed on any host which has it installed. If the Oracle Client is not installed on the same host as where you are installing FlexDeploy, you can copy the /database directory from your distribution to any host which does.

To launch sqlplus:



Code Block
languagebashthemeRDark
export ORACLE_HOME=<your Oracle Home directory>
export ORACLE_SID=<the SID of your database>
$ORACLE_HOME/bin/sqlplus (login as sys or system when prompted)
SQL> <<execute scripts as shown above>>

...