> ## Documentation Index
> Fetch the complete documentation index at: https://docs.flexagon.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Manual Installation Instructions - Database Tier - Oracle

> This page provides the system requirements and installation instructions for the FlexDeploy database tier. Requirements See for details on software an

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

# Requirements

See [FlexDeploy System Requirements](https://docs.flexagon.com/flexdeploy-11-1-documentation/flexdeploy-system-requirements.md) for details on software and hardware requirements.

# Automated Installer Instructions

If you are using the [automated installer](https://flexagon.atlassian.net/wiki/spaces/SHAR/pages/10125805231/Automated+Linux+Install+Upgrade), 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.

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.

> [!NOTE]
>
> ### 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.

> [!NOTE]
>
> 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 the FD\_ADMIN user created by this script.

  * Example: @CreateFlexDeploySchemas.sql welcome1

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

## SQLPlus

> [!NOTE]
>
> ### 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/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.

![sqlplus-example.png](https://mintcdn.com/flexagon-llc-ce77a95c/NkeZh5D-Nf8j_WaD/images/fd111/12590908494.png?fit=max\&auto=format\&n=NkeZh5D-Nf8j_WaD\&q=85\&s=c3f9ce0796c7c19b6444dbacced469b7)