Pre-installation Tasks

Specifies the pre-installation tasks. Before you install the Oracle Airlines Data Model, perform these tasks.

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:

See Also:

As discussed inSoftware Requirements you must have certain software installed before you can successfully install the Oracle Airlines Data Model component or the Oracle Airlines Data Model sample data and reports.

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

Test that Oracle Business Intelligence Suite Extended Edition is installed.

Confirming 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. (Note that the 9704 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.)

http://hostname:9704/analytics

The sample Oracle Business Intelligence Suite Extended Edition login window is displayed.

Use Administrator for both the user name (ID) and the password. (There is no password for the id Administrator.)

See Also:

If Oracle Business Intelligence Suite Extended Edition is not installed, see "Oracle Business Intelligence Suite Extended Edition"

Changing the Default Value for the Maximum Processes Initialization Parameter

Oracle Airlines 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 Airlines 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 Airlines Data Model.

Disabling the Oracle Database Vault Option

The Oracle Airlines 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 Airlines 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:

  1. On UNIX systems, ensure that the environment variables, ORACLE_HOME, ORACLE_SID, and PATH are correctly set.
  2. Log in to SQL*Plus as user SYS with the SYSOPER privilege.
  3. Shut down the Database.
  4. 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.

  5. 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.

  6. 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

Related Topics

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 Airlines 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:

      CSOADM=
  (DESCRIPTION=
 (ADDRESS =  (PROTOCOL =TCP)(HOST=example00eaxy-scn)(PORT=1521))
(CONNECT_DATA =
 (SERVER =DEDICATED)
  (SERVICE_NAME =csoadm.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 =csoadm.us.oracle.com)
 )
)

    Use example00eax as the service name to install Oracle Airlines 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.

Checking the cfgtoollogs Directory

Describes steps to validate that the cfgtoollogs directory exists.

Checking the cfgtoollogs Directory

Check to validate that the directory cfgtoollogs exists in the directory $ORACLE_BASE. If the directory cfgtoollogs does not exist then create the directory in $ORACLE_BASE.