|Oracle® Business Intelligence Infrastructure Quick Installation Guide
Part Number B31764-01
Part No. B31764-01
Before you install Oracle Business Intelligence Enterprise Edition (referred to throughout this guide as Oracle BI) in a production environment, or if there is an existing Oracle software installation on the computer, Oracle recommends reviewing the following books:
The primary audience for this guide include system administrators, network administrators, Application Server administrators, and developers.
The Oracle Business Intelligence Infrastructure Quick Installation Guide is not meant as a substitute for the Oracle Business Intelligence Infrastructure Installation and Configuration Guide. This Quick Install Guide is intended to show only the basics of Oracle Business Intelligence, for the following type of deployment:
Table 1 shows the contents of the Oracle Business Intelligence Infrastructure Quick Installation Guide:
This section describes pre-installation requirements for installation of Oracle Business Intelligence.
The Oracle Business Intelligence infrastructure consists of servers, programs, and tools used to build Oracle Business Intelligence applications.
The Oracle Business Intelligence product includes an installer program that can install the complete Oracle BI suite, or one or more Oracle BI product components. The Oracle BI infrastructure components are shown in Table 2. These components are installed using the Complete installation option.
For a list of all installation options and the components that they install, see the Oracle Business Intelligence Infrastructure Installation and Configuration Guide.
|Installation Option||Oracle BI Components Installed|
NOTE: For a complete description of supported hardware and operating systems versions, see the System Requirements and Supported Platforms for Oracle Business Intelligence, located on the Oracle Technology Network.
Before you install Oracle Business Intelligence, you must have the appropriate permissions for installing and configuring on your company system, as shown in Table 3.
|System Component||Permission Type|
Administrator for individual machine
Before you run the Oracle Business Intelligence installer, you must have completed the third-party software installations shown in Table 4.
The number of third-party components required to be installed or configured depends on the details of your particular deployment. Third-party software documentation is available from the third-party vendor (such as Java from Sun Microsystems and MDAC from Microsoft Corporation).
The Sun release name was originally Java 2 Platform, Standard Edition 1.5.0 (J2SE Development Kit 1.5.0). The numbering system changed to 5.0 (J2SE 5.0). Both 1.5.0 and 5.0 refer to the same platform and products.
Java SDK must be installed before you run the Oracle Business Intelligence installer, otherwise the installation cannot progress. If you do not have this software, follow the procedure shown in Section 2.3.1, "Installing the Java SDK Components"
You need this information during the installation. Make a note of the directory where Java is installed. For example,
Microsoft Data Access Components (MDAC)
http://java.sun.com/javase/downloads/index.jsp), for JDK 5.0 Update 9, click Download.
Before you install any Oracle BI Server components, you must have Microsoft Data Access Components (MDAC) installed. MDAC, which provides a complete ODBC stack, is considered a Windows system component and is included with many applications. To check to see that it is installed on your particular computer, use the following procedure.
These files are generally located in the C:\Program Files\Common Files\System\OLE DB folder.
If you do not need to install MDAC, proceed to the topic Section 3.1, "Running the Oracle BI Installer Under Windows". If you do need to install Microsoft Data Access Components, use the following procedure.
NOTE: For the appropriate version to use, see System Requirements and Supported Platforms for Oracle Business Intelligence on Oracle Technology Network.
In the Search box, type the words MDAC download and press Enter.
Under Windows 2003 and Windows XP operating systems, DEP (Data Execution Prevention) is turned on by default for all Windows programs and services. Before you run the Oracle BI Infrastructure installer, turn off the Data Execution Prevention setting for all programs and set for only essential Windows programs and services in order for certain Oracle Business Intelligence components to install successfully. This procedure is necessary for the installer to complete. When running the Oracle BI Installer on Windows 2003 or Windows XP operating systems, the installer will direct you to disable DEP.
After the installation has completed, the Data Execution Prevention function can be changed back to the original setting.
The following steps guide you through the installer.
The installation program window appears and prompts you through each screen. Provide the requested input for each screen.
To continue to the next screen, click Next. To return to a previous screen, click Back.
Accept the default drive (C:\) and directories, or click Browse to change them.
Select the default component setup type, Complete.
This option installs the components shown in Table 2, "Oracle BI Infrastructure Components and Installation Options".
The application server instance under which Oracle BI Presentation Services runs. The choices given are:
(Installed during this installation)
(Must be installed on this machine before running this installer.)
NOTE: If you do not have Microsoft IIS installed, then this screen will not appear.
Select Oracle Containers for J2EE (OC4J).
JAVA_HOME is the system variable assigned to the location of the Sun Java Development Kit, version 1.5.0 or higher, referred to in Section 2.3.
The Administrator password must be a minimum of 6 characters and include at least one digit.
Leave Cluster Account Information blank, because you are not running machines in a cluster for this installation.
Services Startup Type:
You can change the Windows Services Startup settings. The default settings are:
NOTE: The Services Startup Type set to Automatic means that the Oracle BI server services starts automatically when the computer is rebooted. Overall system performance may be affected by this.
The default is English.
To choose a different language, click the drop down box and select the desired language.
Summarizes the components to be installed (the list shows the same components as Table 2), and shows the installation location and size.
At the end of the installation, choose Accept to restart the computer, or choose to restart at a later time.
If you attempt to run Oracle BI without restarting your computer, several services may fail to work correctly.
If you did not restart the computer at the end of the installation process, you must restart the computer before trying to run the Oracle Business Intelligence software.
The Basic installation type uses Oracle Containers for J2EE (OC4J). The Java process in the OC4Jcomponent cannot be restarted automatically after you restart your computer. You must start the OC4J process before starting Oracle Business Intelligence.
For more information about starting and stopping OC4J, refer to the file Readme.txt, located in the directory <installation drive>:\OracleBI\oc4j_bi\.
To start Oracle Business Intelligence, in the Windows Start menu, select Programs > Oracle Business Intelligence > Presentation Services.
The initial configuration of Oracle Business Intelligence is made by the installer in accordance to your input during the installation process.
However, you must configure the Oracle BI Scheduler before running Oracle BI. Otherwise, the Scheduler service fails to start and the Delivers component does not function. See Section 4.2, "About Oracle BI Scheduler".
You can also configure the demonstration application deployed with the Basic installation. See Section 4.1, "Using the Demonstration Application".
The Basic installation type installs a demonstration application that includes a repository (paint.rpd), presentation catalog, and XML data source.
The paint.rpd file is located in the directory <installation drive>:\OracleBI\server\Repository. To administer or configure the repository, use the following procedure.
NOTE: The repository paint.rpd user passwords expire 90 days from the date the Oracle BI Server installation was performed. The Administrator user password does not expire.
NOTE: Click Menu > Help > Help Topics to call up the Server Administration Guide, which has a complete description of the Administration Tool features and the repository.
The Scheduler components are:
The Scheduler uses a single commercial back-end database to store pertinent information about a job, its instances, and its parameters. The Scheduler works with all the supported databases for Oracle Business Intelligence. For the complete list of supported databases, see System Requirements and Supported Platforms.
Table 5 gives brief descriptions of the database tables used by Oracle Business Intelligence Scheduler. The scripts are located in <installation drive>:\OracleBI\server\Schema.
|Table Name||Table Description|
This table is used by Scheduler to store information about scheduled jobs.
The S_NQ_INSTANCE table stores information about scheduled job instances.
This table stores error messages for Scheduler job instances that do not complete successfully.
This table holds information about Scheduler job parameters for scheduled jobs.
In addition to the database tables shown in Table 5, the scripts create the
The following procedures configure Oracle BI Scheduler for a stand-alone deployment of Oracle Business Intelligence.
You can either create a new database in which to store the tables or use an existing database.
Use the appropriate procedure for your back-end database, as shown in Section 4.4, "Creating an Oracle BI Scheduler Database and Tables for Specific Databases".
The following procedures describe how to create a database and tables for specific relational databases:
For usage statistics, create the table in SAACCT.Oracle.sql.
For usage statistics, create the table in SAACCT.MSSQL.sql.
The Data Source Name used in the Job Manager Scheduler configuration must match the Oracle database service alias created in Step 3 of Section 4.4, "Creating an Oracle BI Scheduler Database and Tables for Specific Databases".
To configure the database using Job Manager, use the following procedure.
(Select Programs > Oracle Business Intelligence > Job Manager.)
Select the appropriate Database Type from the drop down list (for example, Oracle 10g R1).
The Call Interface is updated automatically according to the Database Type chosen.
(Settings > Control Panel > Administrative Tools > Services)
The Data Source Name used in the Job Manager Scheduler configuration must match an existing ODBC Data Source Name (DSN) for the SQL Server S_NQ_SCHED database used in Section 4.4.2, "Creating a Scheduler Database and Tables for SQL Server".
If you do not have a System DSN entry, create a new one as shown in the following procedure.
(Select Settings > Control Panel > Administrative Tools > Data Sources (ODBC).)
To update Scheduler to use the SQL Server S_NQ_SCHED database, use the following procedure.
(Select Programs > Oracle Business Intelligence > Job Manager.)
Select the appropriate Database Type from the drop down list (for example, SQL Server 7.0/2000).
The Call Interface is updated automatically according to the Database Type chosen.
For details of configuring BI Publisher, see the Appendices of the Oracle Business Intelligence Infrastructure Installation and Configuration Guide.
For an overview, suggestions, links, and tutorials on using this software, access the web page Welcome to Oracle Business Intelligence Enterprise Edition (10.1.3.2), available on the drive on which you installed the software:
For additional configuration details, or for configuration beyond the scope of this quick installation, see the companion documentation for this release:
For more information, see these Oracle resources:
Printed documentation is available for sale in the Oracle Store at:
You can also contact your Oracle representative to purchase printed documentation.
To download free release notes, installation documentation, white papers, or other collateral, please visit the Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at
If you already have a user name and password for OTN, then you can go directly to the documentation section of the OTN Web site at
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 that 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 on 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:
At the Support Web Center you will find information on Oracle Support Services, such as:
With Oracle Product Support, you have round-the-clock access to MetaLink, Oracle Support Services premier Web support offering. MetaLink 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.
MetaLink options include:
You can access MetaLink at:
If you do not have a currently supported license, you can purchase the most recent version of an Oracle product from the Oracle Store (
If you do have a currently supported license, then you can place non-urgent requests for version update shipments through the iTAR feature on MetaLink. You will need to 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, please provide the following information to the Client Relations Analyst:
Outside the U.S.A., please call your local Oracle Support Center.
For information on our Premium Services, including onsite support, OracleGOLD, remote services, and upgrade packages, visit the Support Web Center at
http://www.oracle.com/support or call your Support Sales Representative in the U.S.A at 1-800-833-3536.
|Resource||Contact Information/ Web Site|
Purchase additional products, full-use licenses, version updates, and documentation in the U.S.A.
Access technical resources for developers
Access installation documentation
Access information about technical support
Locate local Oracle Support Centers outside the U.S.A.
Select Contact Support
Locate local Oracle offices outside the U.S.A.
Call Client Relations in the U.S.A.
Speak with your sales representative in the U.S.A.
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at:
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week. For TTY support, call 800.446.2398.
Copyright © 2006 Oracle Corporation. All Rights Reserved.
Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.