Versions Compared

Old Version 8

changes.mady.by.user Erick Jones

Saved on

compared with

New Version Current

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.

Info
titleWindow 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

Requirements

See FlexDeploy System Requirements for details on software and hardware requirements.

Automated Installer Instructions

If you are using the automated installer, do not follow this guide.

Manual Schema Installation Instructions

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

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

Info

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.

Info

You must be in /database/oracle/install folder from extracted zip, launch sqlplus(use full path if not available on PATH environment), login as sys or system and then execute the script.

Note - requires running as a user like system or sys with privileges to create users and objects within those schema users

...

You may need to select your PDB before following the steps depending on your Oracle version and installation.

Step 1. Create FlexDeploy schema objects.

  • CreateFlexDeploySchemas.sql <password>

    • password – the password to use for

      FD, FF, and

      the FD_ADMIN

      users, which are

      user 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

Next

Installation Instructions - Application Tier

Mike

I am a Senior Architect at Flexagon working primarily to develop integration solutions for our clients. I've worked with a wide array of technologies over the years, including Oracle Fusion Middleware.  I have designed and implemented many integrations between third-party systems (in house, Salesforce, other cloud vendors) and Oracle E-Business Suite using Oracle SOA Suite.  I also have extensive experience architecting and developing solutions for E-Business Suite (OA Framework and PL/SQL).

 

Jim

I have over 25 years of broad and deep experience using relational databases, with the last 10 years focused primarily on Oracle. I have held DBA, architecture, and management roles over my career. At Flexagon, I lead the FlexDeploy development for database and cloud related strategies.

 

Jack

...

SqlPlus

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
languagebash
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>>

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.
Image Added