Post-Installation Tasks

Specifies the steps to perform after the installation.

After you run Oracle Universal Installer perform the following post-installation steps:

  • After you install Oracle Utilities Data Model, obtain the IP Patch. To obtain the IP Patch for the latest information about Oracle Utilities Data Model, patch sets, go to: My Oracle Support.

  • Review the Security chapter in the Oracle Utilities Data Model Implementation and Operations Guide.

Unlocking the OUDM_SYS Account

Describes how to unlock the OUDM_SYS account and set a password on this account.

Unlocking the OUDM_SYS Account

At the end of the installation, the OUDM_SYS account is locked. To unlock this account:

  1. Connect to the database with a DBA ID.

    Note:

    The password is case sensitive.

  2. Unlock the account and set the password by issuing the following SQL statement: 
    alter user oudm_sys account unlock identified by new_password;

    WARNING:

    Enter a password for the OUDM_SYS account that is secure, according to the password guidelines described in Oracle Database 2 Day DBA. Do not to use OUDM_SYS as a password.

Related Topics

Unlocking the OUDM_USER and OUDM_REPORT Accounts

Describes how to unlock the OUDM_USER and OUDM_REPORT accounts and set a passwords on these accounts.

Unlocking the OUDM_USER and OUDM_REPORT Accounts

At the end of the installation, the OUDM_USER and OUDM_REPORT accounts are locked. To unlock these accounts:

  1. Connect to the database with a DBA ID.

    Note:

    The password is case sensitive.

  2. Unlock the accounts and set the passwords by issuing the following SQL statements: 
    alter user oudm_user account unlock identified by new_password1;
alter user oudm_report account unlock identified by new_password2;

    WARNING:

    Enter a password for each account that is secure, according to the password guidelines described in Oracle Database 2 Day DBA. Do not to use OUDM_REPORT or OUDM_USER as passwords.

Related Topics

Postinstallation for Sample Reports

If you installed the sample reports, you need to also perform several postinstallation steps.

If you installed the Oracle Utilities Data Model sample reports, then perform the following steps:

Unlocking the OUDM_SAMPLE Account

Describes how to unlock the OUDM_SAMPLE account.

Unlocking the OUDM_SAMPLE Account

At the end of the installation of the Oracle Utilities Data Model sample reports, the OUDM_SAMPLE account is locked. To unlock this account:

  1. Connect to the Database with a DBA ID.

    Note:

    The password is case sensitive.

  2. Unlock the account and set the password by issuing the following SQL statement: 
    alter user oudm_sample account unlock identified by <password>;

    WARNING:

    Enter a password for the OUDM_SAMPLE account that is secure, according to the password guidelines described in Oracle Database 2 Day DBA. Do not use OUDM_SAMPLE as a password.

Related Topics

Installing Oracle Business Intelligence Suite Extended Edition Catalog for Oracle Utilities Data Model

After Oracle Business Intelligence Suite Extended Edition is installed, follow these steps to install an Oracle Business Intelligence Suite Extended Edition catalog for Oracle Utilities Data Model. If you install the Oracle Utilities Data Model sample reports, then configure the database connection information for the Catalog.

  1. Add a definition for oudm_db for the Oracle Utilities Data Model repository to use when connecting to the database. Add this definition to the file $ORACLE_HOME/network/admin/tnsnames.ora: 
    oudm_db =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.domain)(PORT = port-number))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID) # Change your SID, Hostname, and Listener PortNumber
)
)

    Tip:

    Be careful to split these commands properly when you add them to the file; for example, do not add them as one long concatenated line of code.

    Note:

    If you want to use another database name, you must change the tnsname in the Oracle Business Intelligence Suite Extended Edition repository. See the Oracle Business Intelligence Suite Extended Edition documentation for directions for defining a database connection in repository.

Related Topics

Installing RPD and Web Catalog for Oracle Business Intelligence Suite Extended Edition

Describes installing the RPD file and deploying the Web Catalog.

If you installed the Oracle Utilities Data Model sample reports, you need to deploy the Oracle Utilities Data Model RPD and Web Catalog on the Oracle Business Intelligence Suite Extended Edition 12c instance. For more information on deploying RPD and Web Catalog in BIEE, see Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

After you use the installer to install the sample reports, you can find the RPD file and the Web Catalog file in the $ORACLE_HOME/oudm/report directory:

oudm.rpd

oudmwebcat.zip

Unzip the Web Catalog

Before you deploy the Web Catalog, you need to unzip oudmwebcat.zip.

Update the RPD Connection Pool

Do the following to update the RPD connection pool:

  1. Open Oracle Business Intelligence Developer Client Tools and select File->Open->Offline...,

    Browse to locate $ORACLE_HOME/oudm/report/oudm.rpd

  2. Double click Connection Pool in ODWT at the Physical layer.

  3. Update the Host, Port, Service and User name to point to Oracle Utilities Data Model schema.

    Note:

    In addition, follow steps 2 and 3 to update the connection pool in OUDM_OLAP at the Physical layer.

  4. Click OK to exit and then click Save.

  5. Test the connection pool to check that it is successfully configured. Right click a table in the ODWT.OUDM_SYS. Select, Update Row Count. If no errors are reported then the connection pool is successfully configured.

Deploy the RPD and Web Catalog

Perform the following steps to deploy the Oracle Utilities Data Model RPD and Web Catalog:

  1. Use your browser to open the weblogic Enterprise Manager portal: 
    http://SERVERNAME:7001/em

    Log in with the weblogic admin ID and password.

    From the Business Intelligence tab select coreapplication, then select Deployment and click Repository. Next deploy the RPD and Web Catalog.

    Note:

    When you deploy the RPD you need to provide an RPD password. Contact Oracle Support to obtain a temporary RPD password, at My Oracle Support.

  2. Use your browser to open the WebLogic console portal: 
    http://SERVERNAME:7001/console/login/LoginForm.jsp

    Log in with your WebLogic Admin ID and password. Go to your security realm and create a user named oudm and set a password for this user.

Configuring the Working OLAP Environment

To set up a working OLAP environment for an Oracle Utilities Data Model warehouse, configure the database with the specified parameter and configuration settings.

Configuring the Working OLAP Environment

  • Set sga_target to 35% of available memory.

  • Set pga_aggregate_target to 35% of available memory

  • Set olap_page_pool_size=0. (This specifies dynamic page pool.)

  • Set _olap_page_pool_hi=30 (that is, lower than default of 50).

  • Set _olap_parallel_update_threshold and _olap_parallel_update_small_threshold to a high value (for example, ~2Gb.. 2147483647). These settings turn off parallel update for the analytic workspace.

  • Set memory_max_target to value greater than SGA and PGA settings. This is maximum amount of memory used for both SGA and PGA. The SGA and PGA settings specified are the minimum settings. (Note that failure to set memory_max_target leads to failure of instance startup (the next time these settings are validated which occurs if spfile had an older and distinct setting for memory_max_target).

The following statements illustrate changing these settings:

alter system set sga_target=1365M scope=spfile;
alter system set pga_aggregate_target=1365M scope=spfile;
alter system set memory_max_target=3030M scope=spfile;
alter system set olap_page_pool_size=0 scope=spfile;
alter system set "_olap_parallel_update_small_threshold"=2147483647 scope=spfile;
alter system set "_olap_page_pool_hi"=30 scope=spfile;
alter system set job_queue_processes=5 scope=spfile;
shutdown immediate;
startup;

Re-Enabling Oracle Database Vault

Describes the process of re-enabling Oracle Database Vault if before installing you disabled Oracle Database Vault, and then you want to re-enable Oracle Database Vault.

Re-Enabling Oracle Database Vault

If you are using Oracle Database Vault and disabled this option before installation then re-enable Oracle Database Vault by taking the following steps:

  1. Shutdown the Database, Database Control console process, and listener. For example on UNIX, ensure that the environment variables, ORACLE_HOME, ORACLE_SID, and PATH are correctly set. Log in to SQL*Plus as user SYS with the SYSOPER privilege and shut down the database. Then from the command line, stop the Database Control console process and listener. For example: 
    sqlplus sys as sysoper
Enter password: password
SQL> SHUTDOWN IMMEDIATE
SQL> EXIT
$ emctl stop dbconsole
$ lsnrctl stop listener_name

    For Oracle RAC installations, shut down each database instance as follows:

    $ srvctl stop database -d db_name

    Note:

    In Oracle Database 12c, Oracle Enterprise Manager Database Express is built into the Oracle database. It requires no special installation or management.

  2. Enable Oracle Database Vault: 
    cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_on
make -f ins_rdbms.mk ioracle
  3. Startup the Database, Database Control console process, and listener. For example, on UNIX, Log in to SQL*Plus as user SYS with the SYSOPER privilege and restart the instance. Then from the command line, restart the Database Control console process and listener. For example: 
    sqlplus sys as sysoper
Enter password: password
SQL> STARTUP
SQL> EXIT
$ emctl start dbconsole
$ lsnrctl start listener_name

    For Oracle RAC installations, restart each instance as follows:

    $ srvctl start database -d db_name
  4. For Oracle RAC installations, repeat these steps for each node on which the database is installed.

Ensuring That Oracle Utilities Data Model Objects Are Valid

Describes recompiling all objects in oudm_sys schema.

Recompiling Objects in OUDM_SYS

To ensure that all Oracle Utilities Data Model objects are valid, log in to the database with a DBA id and password and recompile all objects in OUDM_SYS by issuing the following SQL statements:

exec utl_recomp.recomp_serial('OUDM_SYS');

Ensuring That PGA_AGGREGATE_TARGET is Set to the Proper Value

To improve performance ensure that the PGA_AGGREGATE_TARGET is set to the proper value.

The value specified for PGA_AGGREGATE_TARGET depends on the physical RAM of your Database Server.

Setting PGA_AGGREGATE_TARGET

Ensure that the WORKAREA_SIZE_POLICY parameter is set to AUTO.

Note:

Setting PGA_AGGREGATE_TARGET to a nonzero value has the effect of automatically setting the WORKAREA_SIZE_POLICY parameter to AUTO.

Related Topics