Preinstallation Tasks

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:

Ensuring that Required Software is Installed
Provides the overview to ensure that for each type of installation, the required software is installed.
Changing the Default Value for the Maximum Processes Initialization Parameter
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.
Changing the Maximum Data Files Option
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.
Disabling the Oracle Database Vault Option
For an Oracle Database with the Oracle Database Vault enabled, disable the Oracle Database Vault before you install Oracle Communications Data Model.
Ensuring a Value is Set for the Service Name
Ensure that the tnsnames.ora file includes a value for SERVICE_NAME.

Ensuring that Required Software is Installed

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:

Confirming that Oracle Advanced Analytics and OLAP Options are Installed

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.

Confirming that Oracle Business Intelligence Suite Extended Edition is 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.

Confirming that Oracle Business Intelligence Developer Client Tools Installer is Installed

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

Changing the Default Value for the Maximum Processes Initialization Parameter

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

Changing the Maximum Data Files Option

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

Disabling the Oracle Database Vault Option

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:

On UNIX systems, 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.
Shut down the Database.
From the command line, stop the Database Control console process and the 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.
Disable Oracle Database Vault with the following commands (this is a UNIX system example):
```
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink all
```
For Oracle RAC installations, run these commands on all nodes.
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 database 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
```

For more information, see Oracle Database Vault Administrator's Guide.

Related Topics

Re-Enabling Oracle Database Vault

Ensuring a Value is Set for the Service Name

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:
1. Go to the directory: $ORACLE_HOME/network/admin
2. Edit 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:
1. Go to the directory: $ORACLE_HOME/network/admin
2. Edit 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:
1. Go to the directory:$ORACLE_HOME/network/admin.
2. 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:
1. Go to the directory: $ORACLE_HOME/network/admin
2. 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.