Specifies steps to perform after the installation.
After you run Oracle Universal Installer perform the following post-installation steps:
After you install Oracle Airlines Data Model, obtain the IP Patch. The IP Patch includes additional documentation. To obtain the IP Patch and for the latest information about Oracle Airlines Data Model patch sets, go to My Oracle Support at https://support.oracle.com
.
Review the Security chapter in the Oracle Airlines Data Model Implementation and Operations Guide.
oadm_sys
schema directly. For security reasons, you may want to grant only select privileges to users who work with these reports.oadm_sys
schema.PGA_AGGREGATE_TARGET
is set to the proper value.Describes how to unlock the OADM_SYS account and set a password on this account.
Unlocking the OADM_SYS Account
At the end of the installation, the OADM_SYS account is locked. To unlock this account:
Related Topics
Describes how to unlock the OADM_SAMPLE account.
Unlocking the OADM_SAMPLE Account
At the end of the installation of the Oracle Airlines Data Model sample reports, the OADM_SAMPLE account is locked. To unlock this account:
Related Topics
Describes how to recompile the OLAP Views.
Recompiling OLAP Views
After you unlock the OADM_SAMPLE account, login with this account and execute the following statements to recompile the OLAP views in the sample schema:
ALTER VIEW CUST_RVN_VIEW_OLAPC COMPILE; ALTER VIEW CUST_RVN_VIEW_FIN COMPILE;
By default, when you perform a Sample Reports type of Oracle Airlines Data Model installation, the sample reports connect to oadm_sys
schema directly. For security reasons, you may want to grant only select privileges to users who work with these reports.
Limiting User Privileges
To grant only select privileges, perform the following steps:
To set up a working OLAP environment for an Oracle Airlines 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;
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:
Related Topics
Describes recompiling all objects in oadm_sys
schema.
Recompiling Objects in OADM_SYS
To ensure that all Oracle Airlines Data Model objects are valid, log in to the database with a DBA id and password and recompile all objects in OADM_SYS by issuing the following SQL statements:
exec utl_recomp.recomp_serial('OADM_SYS');
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
.
See Also:
For information on tuning the PGA_AGGREGATE_TARGET
initialization parameter, see Oracle Database Performance Tuning Guide
After Oracle Business Intelligence Suite Extended Edition is installed, follow these steps to install an Oracle Business Intelligence Suite Extended Edition catalog for Oracle Airlines Data Model. If you install the Oracle Airlines Data Model sample reports, then configure the database connection information for the Catalog.
If you install the Oracle Airlines Data Model sample reports then deploy the Oracle Airlines Data Model RPD and webcat on the Oracle Business Intelligence Suite Extended Edition instance.
Installing RPD and WebCat
After you use the installer to install the sample reports you can find the RPD file and the webcat file in the directory $ORACLE_HOME/oadm/report
, in the following files:
oadm.rpd
oadmwebcat.zip
Before you deploy the webcat, unzip oadmwebcat.zip
.
Perform the following steps to deploy the Oracle Airlines Data Model RPD and webcat:
See Also:
For more information, see Oracle Fusion Middleware Administrator's Guide