Installing the Optiva Oracle schema from the seed database

This section explains how to create a new Optiva database from a seed database.

  1. Create the Optiva schema on the Database Server.
    1. Log on to SQL Developer for Oracle 18c or Oracle 19c to connect to an Oracle Instance as DBA. Or use any other tool that allows this connection.
    2. Create a tablespace for the Optiva schema. The recommended tablespace name is ‘OPTIVA’.
    3. The dump file is created using datapump (expdp).
    4. During the import, the tablespace names are remapped by Oracle.
    5. Create the OPTIVA user with these roles: CONNECT, RESOURCE, and IMP_FULL_DATABASE.
    6. Give the Optiva user the create sequence and create view privilege to the database.
    7. Appropriate quotas in the user’s default tablespace should be granted.
    Alternative names can be used for the Optiva Schema Owner. To facilitate future upgrades, use the recommended naming scheme.
    The recommended schema naming convention is to use ‘OPTIVA’ concatenated with the schema type. For example, for a Production Optiva schema, the schema name can be: OPTIVA_PROD.
  2. Assign the appropriate default tablespace and temporary tablespace. Grant the user a quota in the tablespace so that the user can create objects as necessary.
  3. Add the seed data to the Optiva schema.
    1. Copy the fsOptivaVersionseed.dmp file on the Optiva Release CD to a folder on the local workstation that is accessible by SQL Developer.
    2. The Schema name of the FsOptivaVersionseed.dmp is FSOptivaVersion seed. Use this to re-map the schema name during the import. For example: 
      
impdp optiva/optiva@ORA DIRECTORY=DATAPUMP 

dumpfile=(fs<OptivaVersion>seed.dmp) Logfile=optiva.log  

REMAP_SCHEMA=(FS<OptivaVersion>Seed:OPTIVA_PROD)

REMAP_TABLESPACE=(OPTIVA:OPTIVA)