AdminDBWithDDL

Purpose

Creates the Oracle InForm Admin database if you did not set it up during the Oracle InForm core software installation by selecting the Install Admin DB checkbox.

Location

<Installation_Directory>\InForm\bin\DBOra folder.

Usage

AdminDBWithDDL [connection string] [dbadmin-uid] [dbadmin-pass] [pfdbadmin-uid] [pfdbadmin-pass] [inform-tablespace] [inform-lob-tablespace]

AdminDBWithDDL [connection string] /prompt

AdminDBWithDDL [connection string] /accountparams:[parameterfile]

Where:

  • connection string—Database TNS Instance name.
  • dbadmin-uid—Oracle InForm Admin Database UID (User name).
  • dbadmin-pid—Oracle InForm Admin Database PID (Password).
  • pfdbadmin-uid—pfdbadmin Database UID.
  • pfdbadmin-pass—pfdbadmin Database PID.
  • inform-tablespace—Tablespace in database for normal Oracle InForm objects. For example, INFORM.
  • inform-lob-tablespace—Tablespace in database for large inform objects. For example, INFORM_LOB.
  • parameterfile—Path to text file containing parameters.

Command line prompts

If using prompting, you are prompted for the following parameters:

  • dbadmin-uid—Oracle InForm Admin Database UID (User name).
  • dbadmin-pid—Oracle InForm Admin Database PID (Password).
  • pfdbadmin-uid—pfdbadmin Database UID.
  • pfdbadmin-pass—pfdbadmin Database PID.
  • inform-tablespace—Tablespace in database for normal Oracle InForm objects. For example, INFORM.
  • inform-lob-tablespace—Tablespace in database for large inform objects. For example, INFORM_LOB.

Parameter file contents

When using a parameter file, the path to a text file is given. The format of the parameter file is parameter=value, with each value on a separate line, and no spaces between the parameter name, =, and value.

The parameter file must contain the following parameters:

  • AdminDbUid=[dbadmin-uid]
  • AdminDbPid=[dbadmin-pid]
  • pfdbauid=[pfdbadmin-uid]
  • pfdbapid=[pfdbadmin-pid]
  • inftablespace=[inform-tablespace]
  • inflobtablespace=[inform-lob-tablespace]

Example

  • AdminDBWithDDL trial1 /prompt
  • AdminDBWithDDL trial1 /accountparams:myparams.txt
  • AdminDBWithDDL trial1 informadmin myinformadminpassword pfdbadmin mypfdbadminpassword INFORM INFORM_LOB

Parent topic: Command and script reference