Versions Compared

Key

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

...

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 sqlplusSQLPlus.

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.

...

  • 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

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:

...

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 Removed

...