Preparing Oracle Server

Scripts are executed using any available methods, for example, via the SQL Plus application included in the standard kit of the Oracle DBMS front and back end.

Creating a Database User (Schema)

The next step is creating a database user (schema). This user (schema) is required to store platform metadata.

create user USER_NAME identified by USER_PASSWORD default tablespace TABLESPACE_NAME temporary tablespace TEMP_TABLESPACE_NAME profile default;

Advanced Settings

This parameter handles a prefix before user names. If this parameter is set on the Oracle server, it is required to set it in repository parameters in the Format of OS User Names box. The OS_AUTHENT_PREFIX parameter is set to default value on the server.

NOTE. Parameter values are case-sensitive.

The OS_AUTHENT_PREFIX parameter is set in the file:

S\oracle\admin\orcl\prfile\initorcl.ora,

Where:

S. S - path to the folder with installed Oracle.
orcl. Database instance (SERVICE_NAME).

The following string must be written in the file:

OS_AUTHENT_PREFIX = "VALUE"

Where VALUE - parameter value.

NOTE. If an empty OS_AUTHENT_PREFIX parameter is specified on the server, it should be left empty in the repository settings.

When integrated domain authentication is used, select the user name format in database connection settings. The format should be specified if it differs from the default one and/or a prefix before user names (OS_AUTHENT_PREFIX parameter) is set on the Oracle server. By default, Foresight Analytics Platform uses the following name format for domain authentication: DOMAIN\USER_NAME.

Determine the server domain authentication that is set in the file S\oracle\ora92\network\admin\sqlnet.ora, where S - path to the folder with installed Oracle on the server.

Add the following string to the file:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

After writing the string, reload server services in the following order:

TNSListener.
OracleService.

After server reloading, reload the services listed above. Otherwise, issues may arise during connection under the DBMS user or the domain user.

To determine domain authentication on a client computer, write the string given for the server in the file S\oracle\ora92\network\admin\sqlnet.ora, where S - path to the folder with installed Oracle on the client computer.

Restart Foresight Analytics Platform.