Specifies the pre-installation tasks. Before you install the Oracle Utilities Data Model, perform these tasks.
PROCESSES
initialization parameter be set to a value greater than the default database installation value.tnsnames.ora
file includes a value for SERVICE_NAME
.You must have certain software installed before you can successfully install Oracle Utilities Data Model component or the Oracle Utilities Data Model sample data and reports.
Perform the following steps to ensure that for each type of installation, the required software is installed:
Related Topics
Provides the commands to check that Oracle Advanced Analytics and OLAP options are installed.
Test that Oracle Business Intelligence Suite Extended Edition is installed.
Related Topics
Describes how to confirm that Oracle Business Intelligence Developer Client Tools Installer is Installed.
Select the version of Oracle Business Intelligence Developer Client Tools Installer according to the version of Oracle Business Intelligence Suite Extended Edition. For example, if the version of Oracle Business Intelligence Suite Extended Edition is 12.2.1, then select Oracle Business Intelligence Developer Client Tools Installer version is 12.2.1.
For more information, see:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/index.html
Oracle Utilities Data Model requires that the initial value for the PROCESSES
initialization parameter be set to a value greater than the default database installation value.
How to determine the current value for the PROCESSES parameter
To determine the current value for the maximum processes parameter, log in as DB with DBA account, and then execute the following SQL statement:
show parameter processes;
How to change the value for the maximum processes
To change the value for the maximum processes, issue the following statements. Depending on your database options, the value specified for processes should be set to a minimum value greater than or equal to 250:
alter system set processes=250 scope=spfile; shutdown immediate startup
Oracle Utilities Data Model supports the partition of transaction-related fact tables according to your data volume estimation. To support the partition of transaction-related fact tables, you might need a different value for the maximum number of data files that is presently specified for the Database.
You can specify the start year and end year for your data. Based on your input the transaction related fact tables are partitioned by the date as one partition for each month.
How to determine the value for maximum number of data files
Use the following formula to determine the value that you need for the maximum number of data files:
Maximum Datafiles = Default Value + 300 + ((End year) - (Start year) + 1) * 12
How to determine the current value for the maximum number of data files
To determine the current value for the maximum number of data files, log in as DB with DBA account, and then execute the following SQL statement:
show parameter db_files
In the results for this statement, the value
column shows the current maximum number of data files.
How to change the value for the maximum number of data files
To change the value for the maximum number of data files, issue the following statements where new_number
is the new value that you want to specify:
alter system set db_files = new_number scope = spfile;
shutdown immediate
startup
For an Oracle Database with the Oracle Database Vault enabled, disable the Oracle Database Vault before you install Oracle Utilities Data Model.
Disabling the Oracle Database Vault Option
The Oracle Utilities Data Model installer requires additional steps on a Vault-enabled database. For an Oracle Database with the Oracle Database Vault enabled, perform the following steps to disable Oracle Database Vault before you install Oracle Utilities Data Model.
To find out if Oracle Database Vault is enabled, do the following:
SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';
If this command returns true, then the Vault option is enabled.
To disable the Vault option, do the following:
Ensure that the tnsnames.ora
file includes a value for SERVICE_NAME
.
In a Non Oracle RAC Environment
In a Non Multitenant Environment
Ensure that in tnsnames.ora
the service name is provided. To check and modify tnsnames.ora
, perform the following steps:
Go to the directory: $ORACLE_HOME/network/admin
tnsnames.ora
to make sure the SERVICE_NAME
value is provided. For example:
orcl= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = example.oracle.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
In a Multitenant Environment
In a multitenant environment, every container, root, or pluggable has its own service name and you need to use the PDB container for application users. While installing the data model you need to provide the service name of the pluggable database (PDB).
You must manually add the PDB entry in the tnsnames.ora
before proceeding with the install:
Go to the directory: $ORACLE_HOME/network/admin
tnsnames.ora
to ensure the SERVICE_NAME
value is provided. For example:
PDBORCL12 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl12. example.com) ) )
To create the entry using the description in tnsnames.ora
for the connection to the CDB, copy the CDB entry and then modify the copied CDB entry as the PDB entry.
In an Oracle RAC Environment
The important difference compared with other Oracle RAC service name configuration settings is to use a specific host name, not a Single Client Access Name (SCAN).
Note:
Although a specific host is used, Oracle Utilities Data Model is installed on all the nodes.
In a Non Multitenant Environment
Ensure that in tnsnames.ora
, the service name is provided. To check and modify tnsnames.ora
, perform the following steps:
Go to the directory:$ORACLE_HOME/network/admin
.
Edit tnsnames.ora
to add an entry to the specific host to use with the actual host name, not the scanname. For example, two Oracle RAC nodes (example00eax, example00eay), the scanname is example00eaxy-scn. and OUI starts on node example00eax. The original tns information, for example is:
CSOUDM= (DESCRIPTION= (ADDRESS = (PROTOCOL =TCP)(HOST=example00eaxy-scn)(PORT=1521)) (CONNECT_DATA = (SERVER =DEDICATED) (SERVICE_NAME =csoudm.us.oracle.com) ) )
Then add an entry specific to host example00eax.
example00eax=
(DESCRIPTION=
(ADDRESS = (PROTOCOL =TCP)(HOST=example00eax)(PORT=1521))
(CONNECT_DATA =
(SERVER =DEDICATED)
(SERVICE_NAME =csoudm.us.oracle.com)
)
)
Use example00eax as the service name to install Oracle Utilities Data Model. No change is required to the node example00eay.
In a Multitenant Environment
In a multitenant environment, every container, root, or pluggable, has its own service name and you need to use the PDB container for application users. While installing the data model you need to provide the service name of the pluggable database (PDB).
You must manually add the PDB entry in the tnsnames.ora
before proceeding with the install:
Go to the directory: $ORACLE_HOME/network/admin
Edit tnsnames.ora
to ensure the SERVICE_NAME
value is provided. For example:
example00eax = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =example00eax)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl12. example.com) ) )
To create the entry using the description in tnsnames.ora
for the connection to the CDB, copy the CDB entry and then modify the copied CDB entry as the PDB entry.Note, use actual host name(HOST =example00eax) not the scanname, for example: example00eaxy-scn.
Only the tns of the host where OUI starts needs to update the tnsnames.ora
, the other tnsnames.ora
files at other nodes do not require changes.
In previous releases of Oracle Utilities Data Model the installation scripts create the tablespaces and create the database objects in those tablespaces. In this release, Release 12.2, the Oracle Utilities Data Model installation does not create tablespaces. You must create the Oracle Utilities Data Model tablespaces prior to Oracle Utilities Data Model installation, according to your data and security requirements.
In previous releases of Oracle Utilities Data Model the installation scripts create the tablespaces and create the database objects in those tablespaces. In this release, Release 12.2, the Oracle Utilities Data Model installation does not create tablespaces. You must create the Oracle Utilities Data Model tablespaces prior to Oracle Utilities Data Model installation, according to your data and security requirements.