Describes the preinstallation tasks.
Before you install the Oracle Communications Data Model perform the following tasks:
Back up the Oracle Database.
Perform the preinstallation steps:
PROCESSES
initialization parameter be set to a value greater than the default database installation value.tnsnames.ora
file includes a value for SERVICE_NAME
.Provides the overview to ensure that for each type of installation, the required software is installed.
Ensuring that Required Software is Installed
Perform the following steps to ensure that for each type of installation, the required software is installed:
See Also:
As discussed in Software Requirements you must have certain software installed before you can successfully install the Oracle Communications Data Model component or the Oracle Communications Data Model sample data and reports.
Provides the commands to check that Oracle Advanced Analytics and OLAP options are installed.
Confirming that Oracle Advanced Analytics and OLAP Options are Installed
To check that the Oracle Advanced Analytics and OLAP options are installed, log in as SYS and enter the following SQL queries:
SELECT VALUE FROM V$OPTION WHERE PARAMETER ='Data Mining'; SELECT VALUE FROM V$OPTION WHERE PARAMETER ='OLAP';
If these queries return TRUE
, the options are installed.
Before you install the sample data and reports for Oracle Communications Data Model, confirm that Oracle Business Intelligence Suite Extended Edition is installed.
To test that Oracle Business Intelligence Suite Extended Edition is installed, open the following link in a browser:
http://hostname:7001/analytics
The sample Oracle Business Intelligence Suite Extended Edition login window is displayed.
Note:
The 7001
value in the link is the value of the default Oracle Business Intelligence Suite Extended Edition port; if you specified a different port when you installed Oracle Business Intelligence Suite Extended Edition, use the value for that port.
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 Communications 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 Communications 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 Communications Data Model.
Disabling the Oracle Database Vault Option
The Oracle Communications 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 Communications 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:
For more information, see Oracle Database Vault Administrator's Guide.
Related Topics
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 Communications 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:
CSOCDM= (DESCRIPTION= (ADDRESS = (PROTOCOL =TCP)(HOST=example00eaxy-scn)(PORT=1521)) (CONNECT_DATA = (SERVER =DEDICATED) (SERVICE_NAME =csocdm.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 =csocdm.us.oracle.com)
)
)
Use example00eax as the service name to install Oracle Communications 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.