Oracle® Fusion Middleware

Quick Installation Guide for Oracle Business Intelligence

11g Release 1 (11.1.1)

E16518-05

February 2013

This guide provides instructions for installing, configuring, and deinstalling Oracle Business Intelligence products on a single computer. Oracle Business Intelligence products include Oracle Business Intelligence Enterprise Edition, Oracle Business Intelligence Publisher, Oracle Real-Time Decisions, and Oracle Essbase.

The following topics are covered:

1 Installation Overview

This guide provides instructions for installing, configuring, and deinstalling Oracle Business Intelligence on a single computer using the Simple Install type. The Simple Install type installs Oracle Business Intelligence products with the default settings in the minimum number of steps.

Note:

The Simple Install type is ideally suited for standalone, single-user deployments, such as for demonstration, evaluation, or development purposes. You cannot scale out, add components to, or use the Configuration Assistant on instances of Oracle Business Intelligence that are installed with the Simple Install type.

1.1 What is Installed

The Oracle Business Intelligence installation media includes the following products, with all the technology required to install, configure, and run them:

You can install any one of the following combination of products:

  • Oracle Real-Time Decisions or Oracle BI Publisher

  • Oracle Real-Time Decisions and Oracle BI Publisher

  • Oracle BI EE and Oracle BI Publisher

  • Oracle BI EE, Oracle BI Publisher, and Oracle Real-Time Decisions or Oracle Essbase Suite

  • Oracle BI EE, Oracle BI Publisher, Oracle Real-Time Decisions, and Oracle Essbase Suite

Note that Oracle BI EE includes Oracle BI Publisher, so Oracle BI Publisher is always automatically selected if you choose to install Oracle BI EE. Note also that you if you install Oracle Essbase Suite you must install Oracle BI EE and Oracle BI Publisher.

Oracle Business Intelligence 11g Installer creates all the runtime components and the infrastructure for the products you choose to install. After running Oracle Business Intelligence 11g Installer, the installed products share the same Oracle Fusion Middleware infrastructure in a single WebLogic domain.

All Oracle Business Intelligence products intended for a WebLogic domain must be installed and configured at the same time. You cannot install some products now and then install others to the same WebLogic domain later. For example, if you choose to install and configure Oracle BI EE but not Oracle Real-Time Decisions, you cannot later add Oracle Real-Time Decisions to the WebLogic domain. Similarly, any WebLogic domains that contain Oracle Business Intelligence 11g products should not be extended later to include other Oracle Fusion Middleware products.

1.2 What is Configured

When you select the Simple Install type, the installer uses default configuration settings for all components.

To perform the configuration, you specify the folder where you want the installer to install Oracle Business Intelligence. The folder you specify becomes the Middleware home. If the folder does not exist, the installer creates it for you. If you select an existing folder, the folder must be empty.

For more information about the Middleware home, see Oracle Fusion Middleware Installation Planning Guide.

2 System Requirements and Certification

For system requirement and certification information, refer to the following documents, available on Oracle Technology Network (OTN):

3 Preparing to Install

Before installing Oracle Business Intelligence components, you must first perform the following tasks:

3.1 Installing and Configuring a Database

Installation of Oracle Business Intelligence requires the availability of a database. The database must be up and running, and does not have to be on the same computer where you are installing the components. The database must also be compatible with the Repository Creation Utility (RCU), which is used to create the schemas required by Oracle Business Intelligence.

Note:

RCU is available only on Linux and Windows operating systems. Either the Linux RCU or Windows RCU may be used to create schemas in a supported database.

For the latest information about supported databases, visit the Oracle Fusion Middleware Certification document at following URL:

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

After you have installed a database, ensure that it is configured correctly by referring to the "Repository Creation Utility Requirements" section in the System Requirements and Specification document:

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-requirements-100147.html

3.2 Obtaining the Repository Creation Utility (RCU)

RCU is available either on its own installation CD-ROM in the bin directory, or in a ZIP file on Oracle Technology Network (OTN):

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

Click All Supported Platforms for the Oracle Business Intelligence version you are installing. Scroll down the page and look for Repository Creation Utility in the "Required Additional Software" section. After downloading the .zip file, extract the contents to a directory of your choice; this is referred to as the RCU_HOME directory.

Note:

On Windows systems, ensure that you do not unzip the RCU .zip file to a directory name containing spaces.

RCU is available only on 32-bit Linux and Windows platforms. Either the Linux RCU or Windows RCU may be used to create schemas on any supported database platform.

3.3 Starting the Repository Creation Utility (RCU)

To start the Repository Creation Utility (RCU):

  1. Do one of the following:

    • If you have the RCU CD-ROM, insert the CD-ROM into your computer and access the bin directory

    • If you downloaded and extracted the RCU .zip file, access the bin directory in the RCU_HOME.

  2. Run one of the following commands, depending on your operating system:

    • UNIX:

      ./rcu

    • Windows:

      rcu.bat

  3. Continue with one of the following tasks:

3.4 Creating Schemas for Oracle Business Intelligence

Oracle Business Intelligence requires that certain schemas exist in the database before installation. You must run the Repository Creation Utility (RCU) to create the schemas in the database.

If you are creating Oracle Business Intelligence schemas in a Microsoft SQL Server or IBM DB2 database, first read the appropriate sections in the System Requirements and Specification document for important information. For installations with a Microsoft SQL Server database, read "Creating Oracle Business Intelligence Schemas in a Microsoft SQL Server Database." For installations with an IBM DB2 database, read "RCU Prerequisites for IBM DB2 Databases."

The System Requirements and Specification document can be found at the following location:

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-requirements-100147.html

To create the Oracle Business Intelligence schemas using RCU:

  1. Start RCU. See Section 3.3, "Starting the Repository Creation Utility (RCU)."

  2. Welcome Screen

    Click Next.

  3. Create Repository Screen

    Select Create.

    Click Next.

  4. Database Connection Details Screen

    If you are using an Oracle database, provide the following information:

    • Host Name: Specify the name of the computer on which your database resides in the format host.domain.com. For Oracle RAC databases, specify the Virtual IP name or one of the node names as the host name.

    • Port: Specify the database listener port number. The default port number for Oracle databases is 1521.

    • Database Name: Specify the service name for the database. Typically, the service name equals the global database name.

      If you are unsure what the service name for your database is, you can obtain it from the SERVICE_NAMES parameter in the database's initialization parameter file. If the initialization parameter file does not contain the SERVICE_NAMES parameter, then the service name equals the global database name, which is specified in the DB_NAME and DB_DOMAIN parameters.

      For Oracle RAC databases, specify the service name of one of the nodes in this field. For example: sales.foobar.com.example.

    • Username: Specify the name of a user with DBA or SYSDBA privileges. The default user name with SYSDBA privileges is SYS.

    • Password: Specify the password for the user with DBA or SYSDBA privileges.

    • Role: Select the database user's role from the drop-down list. The SYS user requires the SYSDBA role.

    If you are using a Microsoft SQL Server database, provide the following credentials:

    • Unicode Support: Select Yes or No from the drop-down list.

    • Server Name: Enter the host name, IP address, or complete server name in host\server format of the server where your database is running.

    • Port: Specify the database listener port number.

    • Database Name: Specify the name of your database.

    • Username: Specify the name of a user with DBA or SYSDBA privileges.

    • Password: Specify the password for the user with DBA or SYSDBA privileges.

    If you are using an IBM DB2 database, provide the following credentials:

    • Server Name: Enter the host name, IP address, or complete server name in host\server format of the server where your database is running.

    • Port: Specify the database listener port number.

    • Database Name: Specify the name of your database.

    • Username: Specify the name of a user with DB Owner privileges.

    • Password: Specify the password for the user with DB Owner privileges.

    Click Next. The Checking Prerequisites screen opens. If there are errors, details about the error appear on the Database Connection Details screen. Fix the errors and click Next again.

    After the prerequisite checks conclude with no errors, click OK to dismiss the screen.

  5. Select Components Screen

    Near the top of the screen, select Create a new Prefix. If you are the only user of the database instance, you may use the default prefix DEV. If you are sharing the database instance with other Oracle Fusion Middleware users, refer to Oracle Fusion Middleware Repository Creation Utility User's Guide for more information about prefixes.

    Click the Business Intelligence check box. This automatically selects the Metadata Services (MDS) and Business Intelligence Platform schemas, which are required by Oracle Business Intelligence.

    Note:

    • If your organization has an MDS schema installed in a supported database, you do not need to install the MDS schema again with RCU. You can use the existing MDS schema for your Oracle Business Intelligence installation. For this option, deselect the Metadata Services schema in the Select Components screen of RCU. Then, when you install Oracle Business Intelligence, specify the details for the existing MDS schema in the MDS Schema screen.

    • Do not click the Oracle AS Repository Components check box, as this configures RCU to install many other schemas that are not required by Oracle Business Intelligence.

    • Make a note of the schema name and the prefix value from this screen; you will need them later in the installation process. You must provide the schema name in the format prefix_schemaname. For example, if you use the default prefix DEV, supply the following schema name for the BIPLATFORM schema:

      DEV_BIPLATFORM

    Click Next. The Checking Prerequisites screen opens. If there are errors, details about the error appear on the Select Components screen. Fix the errors and click Next again.

    After the prerequisite checks conclude with no errors, click OK to dismiss the screen.

  6. Schema Passwords Screen

    Near the top of the screen, select Use same password for all schemas.

    In the Password field, enter a password for accessing the schemas. Enter the password again in the Confirm Password field.

    Note:

    Remember or make a note of the schema passwords from this screen; you will need them later in the installation process.

    Click Next.

  7. Map Tablespaces Screen

    Click Next. The Creating Tablespaces screen opens. If there are errors, details about the error appear on the Map Tablespaces screen. Fix the errors and click Next again.

    After the tablespaces are created with no errors, click OK to dismiss the screen.

  8. Summary Screen

    Click Create. The Create screen opens. If there are errors, details about the errors appear on the Summary screen. Fix the errors and click Next again.

    After the schemas are created with no errors, click OK to dismiss the screen.

  9. Completion Summary Screen

    Click Close.

For more information about Repository Creation Utility, refer to Oracle Fusion Middleware Repository Creation Utility User's Guide.

3.5 Obtaining Oracle Business Intelligence 11g Installer

Oracle Business Intelligence 11g Installer is available from the following sources:

If you download the .zip files from OTN or Oracle Software Delivery Cloud, extract the contents to a directory of your choice; this is referred to as the bi_installer_loc.

Note:

On Windows systems, ensure that you do not extract the .zip files to a directory name containing spaces.

4 Installing Oracle Business Intelligence

This section describes how to use Oracle Business Intelligence 11g Installer to install Oracle Business Intelligence products on Windows, Linux, and UNIX operating systems. Oracle Business Intelligence products include Oracle BI EE, Oracle BI Publisher, Oracle Essbase, and Oracle Real-Time Decisions. Oracle Business Intelligence 11g Installer installs the Oracle Business Intelligence products that you select and then automatically configures them.

4.1 Before You Install Oracle Business Intelligence

Before you install Oracle Business Intelligence and related components, do the following:

  • Review the Oracle Business Intelligence chapter in the Oracle Fusion Middleware Release Notes for your platform, to ensure you understand differences between Oracle Business Intelligence and its documented functionality, and any other issues that apply to the current release.

  • Review Section 1, "Installation Overview," to ensure you understand the options and features related to installing Oracle Business Intelligence.

  • Review Section 2, "System Requirements and Certification," to ensure that your environment meets the minimum requirements.

  • Install your database before running Oracle Business Intelligence 11g Installer, and have the database running during the installation.

  • Run RCU to install the schemas that Oracle Business Intelligence requires. See Section 3, "Preparing to Install."

  • Verify that you have sufficient administrator privileges to install the software. For example, on computers running Windows 7 or Windows 2008, install Oracle Business Intelligence with the Run as Administrator option enabled.

  • If you plan to install Oracle Business Intelligence on a computer that uses Dynamic Host Configuration Protocol (DHCP), you must perform additional configuration tasks before you install Oracle Business Intelligence. See "Installing on DHCP Hosts" in Oracle Fusion Middleware Installation Planning Guide.

  • Note that you cannot install Enterprise Performance Management and Oracle Business Intelligence on the same MW_HOME.

  • If you plan to install Oracle Business Intelligence 11g on a computer that contains Oracle Business Intelligence 10g, shut down the Oracle Business Intelligence 10g instance before installing Oracle Business Intelligence 11g. To upgrade from Oracle Business Intelligence 10g to Oracle Business Intelligence 11g, refer to Oracle Fusion Middleware Upgrade Guide for Oracle Business Intelligence for further details.

  • If you plan to install Oracle Business Intelligence 11g on a computer running a Microsoft Windows operating system, ensure that the environment variable _JAVA_OPTIONS is not set. To verify whether or not _JAVA_OPTIONS is set, do one of the following:

    • Open a command prompt, navigate to the C:\ prompt, and enter the following command:

      set _JAVA_OPTIONS

      If you receive a message "Environment variable _JAVA_OPTIONS not defined", the variable is not set.

    • On your desktop, right-click My Computer and select Properties to open the System Properties dialog. Click the Advanced tab, and then click Environment Variables. In the Environment Variables dialog, look for the _JAVA_OPTIONS variable in User Variables and System Variables list boxes. If the _JAVA_OPTIONS variable does not appear in either of these list boxes, the variable is not set.

    If you determine that the _JAVA_OPTIONS variable is set, or if you have any related questions, contact your system administrator.

  • Ensure that your database is not hardened for security purposes. Installing Oracle Business Intelligence against a hardened database is not supported.

4.2 Starting Oracle Business Intelligence 11g Installer

To start Oracle Business Intelligence 11g Installer, open a command window and run the following commands based on your operating system:

  • UNIX:

    cd bi_installer_loc/Disk1

    ./runInstaller.sh

    Note:

    Running Oracle Business Intelligence 11g Installer as the root user is not supported.

  • Windows:

    cd bi_installer_loc\Disk1

    setup.exe

4.3 Installation Procedure

To install Oracle Business Intelligence:

  1. Start Oracle Business Intelligence 11g Installer. See Section 4.2, "Starting Oracle Business Intelligence 11g Installer." The Welcome screen opens.

  2. Welcome

    Click Next.

  3. On the Install Software Updates screen, select one of the following options:

    • Skip Software Updates

      You can choose to skip the option to download and install software updates.

    • Search My Oracle Support for Updates

      If you have a My Oracle Support account, you can specify your account name and password to have the installer automatically download applicable software updates from My Oracle Support.

      After entering your credentials, you can test the connection by clicking Test Connection.

      If you need to configure a proxy server for the installer to access My Oracle Support, click Proxy Settings. In the Proxy Settings screen, enter values for the following settings:

      • Proxy Server

      • Proxy Port

      • Proxy User Name (leave blank if your proxy server requires no authentication)

      • Password (leave blank if your proxy server requires no authentication)

    • Search Local Directory for Updates

      If you have software updates available locally, you can specify the location by using this option. In the Local Directory field, enter the location of the directory that contains the software updates, or click Browse to navigate to and select the directory.

    To continue, click Next.

  4. Prerequisite Checks

    Oracle Business Intelligence 11g Installer checks that your computer meets the prerequisites for Oracle Business Intelligence. If it does not, an error message appears.

    If an error message appears, fix the error and then click Retry to run the prerequisite check again (recommended). Repeat this until all prerequisite checks conclude with no errors.

    To stop the installation process while you fix a prerequisite error, click Abort.

    To ignore an error or warning message, and continue with the installation, click Continue (not recommended).

    Note:

    Your installation might not function normally if you continue without resolving the issue that caused an error or warning message during the prerequisite checks.

    After the prerequisite checks conclude with no errors, click Next.

  5. Select Installation Type

    By default, the Simple Install type is selected.

    Click Next.

  6. Specify Installation Location

    Specify the directory where you want to install Oracle Business Intelligence, or click Browse to navigate to the directory.

    If you specify a directory that exists, it must be empty. If you specify a new directory, the installer creates it.

    Oracle Business Intelligence 11g Installer designates the directory as the Middleware home. Oracle Business Intelligence 11g Installer also creates the Oracle home, Instance home, WebLogic home, and Domain home within this location.

    After you specify the directory, click Next.

  7. Administrator Details

    Specify the user name and password for the system administrator.

    Click Next.

  8. Configure Components

    By default, all components are configured. Leave all items checked and click Next.

  9. On the BIPLATFORM Schema screen, specify your database type, the connect string, and the username and password for the BIPLATFORM schema you created in your database using RCU.

    The Connect String should follow one of the following formats based on your database type:

    Database Type Format Description Example

    Oracle Database

    host:port:service_name

    host is the fully qualified name of the computer that hosts your database

    port is the port number over which your database communicates

    service_name is the service name, or alias, assigned to your database

    mycomputer.foobar.com.example:1526:bi

    Oracle Database with Oracle RAC

    host1:port1:instance1^host2:port2:instance2[@service_name]

    hostn is the fully qualified name of the computer that hosts your database

    portn is the port number over which your database communicates

    instancen is the name of your database instance

    service_name (optional) is the service name, or alias, assigned to your database

    computer1.foobar.com.example:1526:rac1^computer2.foobar.com.example:1526:rac2^computer3.foobar.com.example:1526:rac3@bi

    IBM DB2

    host:port:db_name

    host is the fully qualified name of the computer that hosts your database

    port is the port number over which your database communicates

    db_name is the name of your database

    mycomputer.foobar.com.example:446:mydatabase

    Microsoft SQL Server

    host:port:[instance_name]:db_name

    host is the fully qualified name of the computer that hosts your database

    port is the port number over which your database communicates

    instance_name (optional) is the name of your database instance. If omitted, the default named instance on the specified host is used.

    db_name is the name of your database

    mycomputer.foobar.com.example:1443:yourinstance:mydatabase


    Click Next.

  10. On the MDS Schema screen, specify your database type, the connect string, and the username and password for the MDS schema you created in your database using RCU.

    The Connect String should follow one of the following formats based on your database type:

    Database Type Format Description Example

    Oracle Database

    host:port:service_name

    host is the fully qualified name of the computer that hosts your database

    port is the port number over which your database communicates

    service_name is the service name, or alias, assigned to your database

    mycomputer.foobar.com.example:1526:bi

    Oracle Database with Oracle RAC

    host1:port1:instance1^host2:port2:instance2[@service_name]

    hostn is the fully qualified name of the computer that hosts your database

    portn is the port number over which your database communicates

    instancen is the name of your database instance

    service_name (optional) is the service name, or alias, assigned to your database

    computer1.foobar.com.example:1526:rac1^computer2.foobar.com.example:1526:rac2^computer3.foobar.com.example:1526:rac3@bi

    IBM DB2

    host:port:db_name

    host is the fully qualified name of the computer that hosts your database

    port is the port number over which your database communicates

    db_name is the name of your database

    mycomputer.foobar.com.example:446:mydatabase

    Microsoft SQL Server

    host:port:[instance_name]:db_name

    host is the fully qualified name of the computer that hosts your database

    port is the port number over which your database communicates

    instance_name (optional) is the name of your database instance. If omitted, the default named instance on the specified host is used.

    db_name is the name of your database

    mycomputer.foobar.com.example:1443:instance1:mydatabase


    Click Next.

  11. Specify Security Updates

    Specify your My Oracle Support email address and password (optional).

    Click Next.

  12. Installation Summary

    This screen displays the settings for this installation.

    Click Install to start the installation.

  13. Installation Progress Screen

    There is no action for you to take while this screen is displayed.

    Note:

    As the installation progresses, a WebLogic Server command window might appear temporarily. Ignore the command window, as it is expected and closes automatically.

    Click Next when the installation is complete.

  14. Configuration Progress Screen

    If a configuration task fails, an error message appears. Resolve the issue and click Retry (recommended). For information about a specific error or warning, refer to the installation log file, which typically appears in the \Inventory\logs directory (on Windows operating systems) or /oraInventory/logs directory (on Linux and UNIX operating systems).

    The following are the default locations for these directories on supported operating systems:

    • UNIX:

      USER_HOME/oraInventory/logs/

    • Windows:

      C:\\Program Files\Oracle\Inventory\logs\

    To continue with the next task without resolving the issue, click Continue (not recommended). To terminate the installation and configuration process entirely, click Abort.

    Click Next when the configuration concludes without any errors or warnings.

  15. Installation Completed Screen

    Take note of the port numbers and URL.

    Click Finish.

4.4 After the Installation

When a Simple Install concludes, the Administration Server starts, and a browser window opens to the home page for your Oracle Business Intelligence instance. The default Oracle Business Intelligence URLs resemble the following examples:

Component Default URL Default Port

WebLogic Console

http://host:port/console

7001

Enterprise Manager

http://host:port/em

7001


5 Deinstalling Oracle Business Intelligence

Deinstalling Oracle Business Intelligence from your system involves the following:

  1. Starting the Oracle Business Intelligence deinstallation script.

  2. Stopping System Components.

  3. Deinstalling your Oracle Business Intelligence instance.

  4. Stopping the Java Enterprise Edition (JEE) components in your WebLogic domain.

  5. Dropping the Oracle Business Intelligence schemas from your database.

  6. Deinstalling the Oracle home.

  7. Deinstalling the Oracle Common home.

  8. Uninstalling Oracle WebLogic Server.

  9. Removing the Oracle Business Intelligence Domain.

  10. Removing the Oracle home (if necessary).

  11. Removing the Middleware home.

You should always use the instructions provided in this section to deinstall Oracle Business Intelligence. If you try to deinstall the software manually, you may experience problems if you try to reinstall the software again at a later time. Following the procedures in this section helps ensure that you deinstall the software properly.

The deinstall process described in this section assumes you have installed Oracle Business Intelligence with the Simple Install type. If you installed Oracle Business Intelligence with the Enterprise Install or Software Only Install type, instead refer to Chapter 5, "Deinstalling Oracle Business Intelligence" in Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence.

5.1 Starting the Oracle Business Intelligence Deinstallation Script

Navigate to the ORACLE_HOME/oui/bin (on Linux and UNIX operating systems) or ORACLE_HOME\oui\bin (on Windows operating systems) directory. Start the deinstallation script by using one of the following methods:

UNIX:

./runInstaller -deinstall

Windows:

setup.exe -deinstall

On Windows operating systems, you can also start the deinstallation script from the Start menu. Click Start, select Programs and then Oracle Business Intelligence, and then click Deinstall.

5.2 Stopping System Components

Use the Oracle Process Manager and Notification Server (OPMN) command line tool to stop Oracle Business Intelligence system components (use the command opmnctl stopall).

For more information, see "Using the OPMN Command Line to Start, Stop, Restart, and View the Status of System Components" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Next, deinstall the Oracle Business Intelligence Instance. See Section 5.3, "Deinstalling Your Oracle Business Intelligence Instance."

5.3 Deinstalling Your Oracle Business Intelligence Instance

To deinstall your Oracle Business Intelligence instance, use the deinstallation script found in the Oracle home.

The Oracle Business Intelligence deinstallation script removes the software in the Oracle home from which it was started. This procedure does not remove any WebLogic domains.

To deinstall your Oracle Business Intelligence instance:

  1. Start the Oracle Business Intelligence deinstallation script. See Section 5.1, "Starting the Oracle Business Intelligence Deinstallation Script." The Welcome Screen opens.

  2. Welcome Screen

    Click Next.

  3. Select Deinstallation Type Screen

    Click Deinstall ASInstances managed by WebLogic Domain.

    Click Next to continue.

  4. Specify WebLogic Domain Detail Screen

    Specify the following information:

    • The host name of the domain

    • The port number for the domain

    • User name of the system administrator account

    • Password for the system administrate account

    Click Next to continue.

  5. Select Managed Instance Screen

    Click the Oracle Business Intelligence instance you want to deinstall.

    Click Next to continue.

  6. Deinstallation Summary Screen

    Verify the deinstallation settings.

    Click Deinstall to initiate the deinstallation.

  7. Deinstall Progress Screen

    This screen shows the progress and status of the deinstallation. No action is required; the installer automatically advances to the next screen when deinstallation is complete.

  8. Deinstall Completed Screen

    Click Finish.

  9. Before proceeding, verify that the deinstallation script fully removed your Oracle Business Intelligence instance by navigating to the instances directory for your operating system:

    UNIX:

    MW_HOME/instances/

    Windows:

    MW_HOME\instances\

    If the instance you deinstalled no longer exists in this directory, the deinstallation script fully removed it.

    However, if the instance still exists, navigate to OPMN for the instance and run the opmnctl stopall command. This stops all OPMN-controlled components for the instance. The location for OPMN depends on your operating system, as follows:

    UNIX:

    MW_HOME/instances/instance_name/bin/

    Windows:

    MW_HOME\instances\instance_name\bin\

Next, stop the Java Enterprise Edition (JEE) components in your WebLogic domain. See Section 5.4, "Stopping Java Enterprise Edition (JEE) Components."

5.4 Stopping Java Enterprise Edition (JEE) Components

Use Oracle Enterprise Manager Fusion Middleware Control to stop the Java Enterprise Edition (JEE) components in your WebLogic domain. See Section 4.3, "Using Fusion Middleware Control to Start and Stop Oracle Business Intelligence System Components and Java Components" in Chapter 4, "Starting and Stopping Oracle Business Intelligence" of Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Next, drop the Oracle Business Intelligence schemas. See Section 5.5, "Dropping the Oracle Business Intelligence Schemas."

5.5 Dropping the Oracle Business Intelligence Schemas

Run the Repository Creation Utility (RCU) to drop the Oracle Business Intelligence schemas from your database.

To drop the Oracle Business Intelligence schemas:

  1. Start RCU. See Section 3.3, "Starting the Repository Creation Utility (RCU)."

  2. Welcome Screen

    Click Next.

  3. Create Repository Screen

    Select Drop.

    Click Next.

  4. Database Connection Details Screen

    Provide the credentials to connect to your database. These are the same credentials you provided on this screen when you created the Oracle Business Intelligence schemas during the installation process. See Section 3.4, "Creating Schemas for Oracle Business Intelligence" for more information.

    The Checking Prerequisites screen opens, with the Database Connection Details screen in the background. If there are any errors, details about the errors appear on the Database Connection Details screen. Fix the issues that caused error messages and click Next again.

    After the prerequisite checks conclude with no errors, click OK to dismiss the screen.

    Click Next.

  5. Select Components Screen

    Select the prefix and schemas you want to drop from the repository.

    Click Next. The Checking Prerequisites screen opens, with the Select Components Screen in the background. If there are errors, details about the error appear on the Select Components Screen. Fix the error messages and click Next again.

    After the prerequisite checks conclude with no errors, click OK to dismiss the screen.

    Click Next.

  6. Summary Screen

    Click Drop. The Drop screen opens. If there are errors, details about the error appear on the Summary screen. Fix the error messages and click Next again.

    After the schemas are dropped with no errors, click OK to dismiss the screen.

    Click Next.

  7. Completion Summary Screen

    Click Close.

Next, deinstall the Oracle home. See Section 5.6, "Deinstalling the Oracle Home."

5.6 Deinstalling the Oracle Home

To deinstall the Oracle home, use the Oracle Business Intelligence deinstallation script found in the Oracle home.

The Oracle Business Intelligence deinstallation script attempts to remove the Oracle home from which it was started. This procedure does not remove any WebLogic domains that you have created, but after you complete this step, the WebLogic domain associated with this Oracle home is unusable.

Before you deinstall the Oracle home, stop all Oracle Business Intelligence processes and servers, including all OPMN-controlled components and JEE components. See Section 5.4, "Stopping Java Enterprise Edition (JEE) Components."

To deinstall the Oracle home:

  1. Restart the Oracle Business Intelligence deinstallation script. See Section 5.1, "Starting the Oracle Business Intelligence Deinstallation Script." The Welcome Screen opens.

  2. Welcome Screen

    Click Next.

  3. Select Deinstallation Type Screen

    Click Deinstall Oracle home.

    Click Next to continue.

  4. Deinstall Oracle Home Screen

    Verify the Oracle home you are about to deinstall.

    Click Deinstall to continue.

  5. Deinstall Progress Screen

    This screen shows the progress and status of the deinstallation. No action is required; the installer automatically advances to the next screen when the deinstallation concludes.

  6. Deinstall Completed Screen

    Click Finish.

Next, deinstall the Oracle Common home. See Section 5.7, "Deinstalling the Oracle Common Home."

5.7 Deinstalling the Oracle Common Home

This section describes how to deinstall the Oracle Common home (the oracle_common directory). This directory contains its own deinstallation script.

Navigate to the MW_HOME/oracle_common/oui/bin (on Linux and UNIX operating systems) or MW_HOME\oracle_common\oui\bin (on Windows operating systems) directory. Start the deinstallation script using one of the following methods:

UNIX:

./runInstaller -deinstall -jreLoc JRE_LOCATION

Windows:

setup.exe -deinstall -jreLoc JRE_LOCATION

You must specify the absolute path to your JRE_LOCATION; relative paths do not work. You can fulfill this requirement by specifying the JDK directory that was created by Oracle Business Intelligence 11g Installer in the Middleware home.

After the deinstallation script starts, follow the steps to deinstall the Oracle Common home. These steps mirror those for deinstalling the Oracle home. See Section 5.6, "Deinstalling the Oracle Home."

After you deinstall the Oracle Common home, restart your computer if you are deinstalling on a Windows operating system. Then, continue the deinstallation process by deinstalling Oracle WebLogic Server. See Section 5.8, "Deinstalling Oracle WebLogic Server."

5.8 Deinstalling Oracle WebLogic Server

After you deinstall Oracle Business Intelligence, you can deinstall Oracle WebLogic Server. Deinstalling Oracle WebLogic Server involves deinstalling your Oracle WebLogic Server instance and removing the Oracle WebLogic Server home directory. See Chapter 7, "Uninstalling the Software" in Oracle Fusion Middleware Installation Guide for Oracle WebLogic Server.

Next, remove the Oracle Business Intelligence Domain. See Section 5.9, "Removing the Oracle Business Intelligence Domain."

5.9 Removing the Oracle Business Intelligence Domain

You can remove the Oracle Business Intelligence domain manually or by using Oracle WebLogic Server Administration Console. This section describes the manual method. For details on the method using Oracle WebLogic Server Administration Console, refer to Oracle Fusion Middleware Administrator's Guide.

To delete your Oracle Business Intelligence domain manually:

  1. Do one of the following, depending on your operating system:

    • On UNIX, run the following commands:

      > cd MW_HOME/user_projects/domains

      > rm -rf bifoundation_domain

    • On Windows operating systems, open a file manager window, navigate to the MW_HOME\user_projects\domains directory, right-click the bifoundation_domain folder, and click Delete.

  2. If you're deinstalling a scaled-out installation, an additional domain directory (bifoundation_domain) exists in the MW_HOME/user_projects/applications directory. Oracle recommends that you remove this directory using the methods described above.

Next, remove the Oracle home (if the deinstallation script did not remove it). See Section 5.10, "Removing the Oracle Home."

5.10 Removing the Oracle Home

Verify that the Oracle Business Intelligence deinstallation script removed the Oracle home directory. If it didn't, manually remove the Oracle home and all of its subdirectories.

To manually remove the Oracle home, do one of the following, depending on your operating system:

  • On UNIX operating systems, run the following commands:

    cd MW_HOME

    rm -rf ORACLE_HOME

  • On Windows operating systems, open a file manager window, navigate to your Middleware home, right-click the ORACLE_HOME directory, and click Delete.

Next, remove the Middleware home. See Section 5.11, "Removing the Middleware Home."

5.11 Removing the Middleware Home

To manually remove the Middleware home, do one of the following, depending on your operating system:

  • On UNIX operating systems, run the following commands:

    cd MW_HOME_Parent_Dir

    rm -rf MW_HOME

  • On Windows operating systems, open a file manager window, navigate to the parent directory of your Middleware home, right-click the MW_HOME, and click Delete.

This is the final step of the deinstallation process.

6 Additional Resources

See the Oracle Business Intelligence documentation library for a list of related Oracle Business Intelligence documents.

In addition, go to the Oracle Learning Library for Oracle Business Intelligence-related online training resources.

6.1 Oracle Support Services

If you purchased Oracle Product Support, you can call Oracle Support Services for assistance. Oracle Support Services include phone assistance, version updates and access to our service offerings. You have access to phone support 24 hours a day, 7 days a week. In the U.S.A., you can call Product Support at 1-800-223-1711.

Ensure you have your CSI (CPU Support Identifier) number ready when you call. Keep the CSI number for your records, because it is your key to Oracle Support Services. The Oracle Store sends the CSI number to you in an e-mail alert when it processes your order. If you do not have your CSI number and you are in the U.S.A., you can look up your CSI number by accessing our online Order Tracker which provides detailed order information. Go to the Oracle Store and click Order Tracker located above the top navigation bar.

For Oracle Support Services locations outside the U.S.A., call your local support center for information on how to access support. To find the local support center in your country, visit the Support Web Center at http://www.oracle.com/support.

At the Support Web Center you will find information on Oracle Support Services, such as:

  • Contact Information

  • Instructions for Accessing Electronic Services

  • Helpful Web Sites

  • Support Resources

  • Oracle Support Portfolio

  • Oracle Support Services news

With Oracle Product Support, you have round-the-clock access to My Oracle Support (formerly OracleMetaLink), Oracle Support Services premier Web support offering. My Oracle Support offers you access to installation assistance, product documentation, and a technical solution knowledge base.

It has technical forums, where you can post questions about your Oracle products and receive answers from Oracle Technical Support Analysts and other Oracle users. The questions and answers remain posted for the benefit of all users.

My Oracle Support options include:

  • Technical Assistance Request (TAR) access

  • Patch Downloads

  • Bug Database Query Access

  • Product Life-Cycle Information

You can access My Oracle Support at http://metalink.oracle.com.

6.2 Version Updates

If you do not have a currently supported license, you can purchase the most recent version of an Oracle product from the Oracle Store at http://shop.oracle.com.

If you do have a currently supported license, you can place non-urgent requests for version update shipments through the iTAR feature on My Oracle Support. You must log the iTAR type as a U.S. Client Relations/Non-Technical Request.

You can also request Version Update shipments in the U.S.A. by calling Client Relations. When requesting a Version Update, provide the following information to the Client Relations Analyst:

  • CSI Number

  • Contact Information

  • Platform

  • Product Name

  • Shipping Address

  • Product Version Number

Outside the U.S.A., call your local Oracle Support Center.

6.3 Premium Services

For information on our Premium Services, including on-site support, OracleGOLD, remote services, and upgrade packages, visit the Support Web Center at http://www.oracle.com/support.

You can also call your Support Sales Representative in the U.S.A at 1-800-833-3536.

6.4 Quick Reference

For quick access to additional information, refer to Table 1:

Table 1 Links to Additional Information and Resources

I want to... Contact Information or Web Site

Access technical resources for developers.

http://www.oracle.com/technetwork/index.html

Access installation documentation.

http://www.oracle.com/technetwork/indexes/documentation/index.html

Access information about technical support.

http://www.oracle.com/support

Locate local Oracle Support Centers outside the U.S.A.

http://www.oracle.com/support

Call Client Relations in the U.S.A.

1-800-223-1711

Speak with your sales representative in the U.S.A.

1-800-ORACLE-1

Locate TTY Access to technical support in the U.S.A.

1-800-446-2398


7 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.


Oracle Fusion Middleware Quick Installation Guide for Oracle Business Intelligence, 11g Release 1 (11.1.1)

E16518-05

Copyright © 2010, 2013, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.