Configure the Schema Creator Utility

Configure and execute the schema creator utility before installing the application pack.

Creating database users/schemas (RDBMS) is one of the primary steps in the comprehensive OFSAAAI installation process. The Schema Creator utility enables you to quickly get started with the installation by creating Database User(s)/ Schema(s) (RDBMS), assigning the necessary GRANT(s), and creating the required entities in the schemas.

Prerequisites for configuring the Schema Creator utility

• Oracle User ID/Password with SYSDBA privileges
• JDBC Connection URL for RAC/Non RAC database
• The HOSTNAME/IP of the server on which OFSAA is getting installed.

For HIVE installation, you must also have the following:

• HIVE connection credentials (For example: Kerberos connection properties).
• Hostname/IP of the HIVE Server installation