Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 23 Next »

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

Window Quick Start

The Windows Quick Start automatically creates and configures the database tier components within the linked Oracle XE installation. You can skip the steps on this page when using the Windows Quick Start.

Supported Databases

FlexDeploy requires one of the following databases to be installed and running.

  • Oracle XE, version 11.2
  • Oracle Standard, version 11.2
  • Oracle Enterprise, version 11.2
  • Oracle Standard, version 12.1
  • Oracle Enterprise, version 12.1

Installation Instructions

FlexDeploy has three schemas (FD, FF, and FD_ADMIN) which must be created, and populated with its seed data.

From the directory where you extracted downloaded FlexDeploy zip file, navigate to the /database/install directory, and run the following SQL scripts using sqlplus (NOTE: requires running as a user like system or sys with privileges to create users and objects within those schema users):

You must be in /database/install folder in extracted zip, launch sqlplus, login as sys or system and then run both scripts one after another.

  • 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
  • LoadFlexDeployMasterData.sql
    • Example: @LoadFlexDeployMasterData.sql

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


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:

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

See Windows example below. As you run scripts specified above, you will see output on screen and it will be spooled in file as well in same folder.

Next Step - Installation Instructions - Application Tier


  • No labels