The initial database setup procedure creates the database instance and creates a database user and password. The user must have permission to create, alter, and drop tables.
A database administrator typically performs the initial database setup steps and then provides the values for the database properties to the system administrator.
Review “Oracle Initial Setup” to determine the initial size for your database and then complete the procedures that follow to create the database instance, user, and password. Follow the appropriate procedure for your database: “Oracle Initial Setup” or “SQL Server Initial Setup”.
Oracle initial setup
SQL server initial setup
- Create a new database instance for the application database tables.
- Identify the database instance name, host name or IP address, and desired locations
of tablespaces for your application.
If you install more than one Precisely application, each application requires its own schema or database.
Multiple instances of an application in the same tablespace data directory folder require that you specify an unique tablespace prefix.
- Create an application database user and password with permission to create, alter,
and drop tables and views within the application tablespaces.
This user does not need full administrative privileges, but must have the ability to insert, update, select, and delete all data in the application tables.
Important: Do not use two special characters, such as $$, for the database user password. The system processes double special characters as an escape sequence, which prevents configuration validation and password encryption.
- If you plan to use a bulk loading utility, but the database and server are on two different machines, verify that the SQL Server database client is installed on the machine where the application will run.