Step 1: Creating an Oracle Database

Because many corporate environments have a separation between the system administrator and the database administrator, the following process may require both administrators’ access and permissions.

Before proceeding, please have ready:

  • The Project/Products that your company uses. You will need the ID number for each.
  • Your subscriber number.
  • Location of the Insbridge files.

Note: It is strongly recommended that any database modification be performed by a qualified database administrator (DBA). The database setup procedures and tasks require the skill set of a database administrator. If you are not a database administrator, please stop. Improper setup may result in unwelcome changes to the database. Please consult with a qualified database administrator before proceeding.

 

When connecting to the Oracle RAC, customers can use SID. For example:

Database Name: sid (Connection usingSID)

 

Or use the Service name. To connect to the service name, a slash has to be added in front of the database name. For example:

Database Name: /servicename (Connection using SERVICE)

To continue using SID, do not use the slash before the name.

Oracle Insurance does not have specific requirements, whatever requirements are deemed necessary by your company’s internal standards will work. It is recommended that you included the version number or environment name if you are planning on creating more than one instance.

Using the Default Optimizer Features Enable

Performance may be impacted if using the default optimizer_features_enable setting on Oracle 12c. For

optimal performance, Insbridge recommends setting the optimizer_features_enable parameter to

11.2.0.4.

The command to set optimizer feature enabled on Oracle 12c is:

alter system set optimizer_features_enable = '11.2.0.4';

Ref URL: GUID-E193EC9E-B642-4C01-99EC-24E04AEA1A2C.htm

Creating an Oracle Database

These instructions are high level and require that the setup person be a DBA.

  1. On your Oracle database.

    2. Note: If you do not have database permissions, you will not be able to perform the following database procedures.

    1. Create default tablespace for the Soft Rater database.
      • If a database table needs to be added, the DDLs are located in the IBFA Installation Directory under the SoftRater/DDL folder, i.e. [INSTALL_DIR]/Insbridge/SoftRater/DDL.
      • You will have to replace the TABLESPACE name in the scripts with the tablespace name you used when you created the database.
      • On the DT tables, you will need to create one for every Project/Product. An example of the format is in the comments of the script. It requires the Project/Product ID number and the customer number.
    2. Create user IBSR and assign basic connect and resource grants.
  2. On your Oracle database, you will need to run a DT table script for each Project/Product.
  3. After all DT tables have been created, please make note of:
    • Schema
    • Instance
    • User name
    • Password

This information will need to be passed along to the Insbridge installer. This information is needed to create a logical environment.