Configure an Oracle database - Intergraph Smart API Manager - Installation & Upgrade - Intergraph

Smart API Manager Installation and Configuration

PPMProduct
Intergraph Smart API Manager
PPMCategory_custom
Installation & Upgrade

Using Oracle requires an existing database instance.

When connecting to an Oracle 12c (or later) database with the CDB (container database) configuration, you must specify the service name for a PDB (pluggable database) running in the container. For a non-CDB configuration, simply enter the service name for the database.

  1. In the Database Server section, provide location and name information for the database.

    Server Type

    The database type: Oracle.

    Server Name

    The name of the database server.

    Port

    The port on the database server used to connect to the database. If left blank, the default port is used (1521).

    Service Name

    The SERVICE_NAME that identifies the database on the server.

    If the Oracle database instance has been created with a domain_name (or db_domain), the corresponding SERVICE_NAME includes the domain. For example, a database instance named SAM with domain_name "acme.com" results in a service name equal to SAM.acme.com.

    You can use the lsnrctl status command on the Oracle server to verify service names.

  2. In the System Administrator Account section, provide credentials for the database user used to create or modify the database structure or schema.

    The database user you specify must have DBA privileges.

    With a PDB, your Oracle database administrator can grant DBA privileges to the local user administrator for the PDB. Then, you can use the PDB administrator credentials for System Administrator Account. This relieves the Oracle database administrator from having to hand out SYS or SYSTEM credentials, which are usually protected.

    Use Windows authentication

    The Configuration Utility connects to the database using your current Windows credentials.

    Use user name /
    password

    The Configuration Utility connects to the database using the user name and password you enter.

    The credentials you enter must already exist in the database management system.

  3. Click Test to ensure the connection is successful with the provided credentials.

  4. In the Runtime Account section, provide credentials for the database user used to connect to the database.

    The user must have read/write access to the database.

    Smart API Manager always connects to the database with these credentials, regardless of which user is logged into the Smart API Manager web client.

    Use Windows authentication (Application Pool Identity)

    Disabled and not applicable for Oracle.

    Use user name / password

    Smart API Manager connects to the database with the user name sam, which is set by the Configuration Utility and cannot be changed. You must specify a password value.

  5. Click Test to ensure the connection is successful with the provided credentials.

  6. Click Next, and continue with Step 4: Runtime configuration.