Oracle Discoverer 11g Installation Tutorial for Windows 7 64-bit
How to Install Oracle Discoverer 11g on Windows 7 64-bit
Oracle Discoverer 11g is a powerful and user-friendly tool for querying, analyzing, and reporting data from various sources. It allows you to create and manage business intelligence applications that can help you gain insights and make informed decisions. In this article, you will learn how to install Oracle Discoverer 11g Administrator and Desktop on Windows 7 64-bit, which are the client components of Oracle Discoverer 11g. You will also learn how to verify the installation and launch the applications.
oracle discoverer 11g windows 7 64 bit 26
What is Oracle Discoverer 11g?
Oracle Discoverer 11g is a component of Oracle Fusion Middleware, which is a comprehensive and integrated platform for developing, deploying, and managing enterprise applications. Oracle Discoverer 11g provides an intuitive and interactive interface for accessing and analyzing data from relational databases, multidimensional databases, web services, XML files, and other sources. You can use Oracle Discoverer 11g to create reports, charts, graphs, crosstabs, pivot tables, gauges, maps, and other visualizations that can help you understand your data and discover patterns, trends, and outliers. You can also share your findings with others by publishing your reports on the web or exporting them to various formats.
Features and benefits of Oracle Discoverer 11g
Some of the features and benefits of Oracle Discoverer 11g are:
It supports a wide range of data sources, including Oracle Database, Oracle Essbase, Microsoft SQL Server, IBM DB2, MySQL, Sybase, Teradata, web services, XML files, and more.
It provides a rich set of functions and operators for manipulating data, such as arithmetic, logical, string, date, conversion, aggregation, ranking, windowing, analytical, OLAP, spatial, and custom functions.
It allows you to create complex queries using drag-and-drop or SQL statements.
It enables you to perform ad hoc analysis by changing the layout, format, style, filter, sort order, calculation, drill down/up/through/across/sideways options of your reports.
It offers various types of reports and visualizations that can suit different needs and preferences.
It allows you to customize your reports by adding titles, headers, footers, logos, images, comments, notes, hyperlinks, conditional formatting rules,
rules, and more.
It supports multiple languages and currencies for displaying data and reports.
It integrates with other Oracle Fusion Middleware components, such as Oracle Business Intelligence Enterprise Edition, Oracle WebLogic Server, Oracle WebCenter, Oracle Identity Management, and more.
It provides security and access control features, such as authentication, authorization, encryption, auditing, and single sign-on.
It enables you to schedule and automate the execution and delivery of your reports.
It allows you to collaborate and communicate with other users by sending emails, exporting reports, printing reports, subscribing to reports, commenting on reports, and more.
System requirements and supported platforms for Oracle Discoverer 11g
Before you install Oracle Discoverer 11g Administrator and Desktop on Windows 7 64-bit, you need to make sure that your system meets the minimum requirements and supports the compatible platforms. The following table summarizes the system requirements and supported platforms for Oracle Discoverer 11g Administrator and Desktop:
Component
Requirement
Operating system
Windows 7 64-bit (Professional, Enterprise, or Ultimate edition)
Processor
Intel Pentium 4 or higher
Memory
At least 2 GB of RAM
Disk space
At least 1 GB of free disk space
Java Runtime Environment (JRE)
JRE 1.6.0_26 or higher (32-bit or 64-bit)
Oracle Fusion Middleware
Oracle Fusion Middleware 11g Release 1 (11.1.1.7.0) or higher (32-bit or 64-bit)
Data sources
Oracle Database 10g Release 2 (10.2.0.4) or higher (32-bit or 64-bit)
Oracle Essbase 11.1.2.1 or higher (32-bit or 64-bit)
Other data sources supported by Oracle Database Gateway for ODBC (32-bit or 64-bit)
Browsers
Internet Explorer 8 or higher (32-bit or 64-bit)
Firefox 3.6 or higher (32-bit or 64-bit)
Chrome 10 or higher (32-bit or 64-bit)
Safari 5 or higher (32-bit or 64-bit)
How to download Oracle Discoverer 11g
To install Oracle Discoverer 11g Administrator and Desktop on Windows 7 64-bit, you need to download the installation files from either Oracle Software Delivery Cloud or My Oracle Support. The following sections describe how to download Oracle Discoverer 11g from each source.
Downloading from Oracle Software Delivery Cloud
Oracle Software Delivery Cloud is a web-based service that allows you to download Oracle software products and updates. To download Oracle Discoverer 11g from Oracle Software Delivery Cloud, follow these steps:
If you have an existing account, sign in with your username and password. If you do not have an account, click on "Sign up" and follow the instructions to create a new account.
Select your preferred language and accept the terms and restrictions.
In the "Select a Product Pack" section, choose "Oracle Fusion Middleware" from the drop-down list.
In the "Platform" section, choose "Microsoft Windows x64 (64-bit)" from the drop-down list.
Click on "Go".
In the search results, find the item named "Oracle Fusion Middleware 11g Media Pack for Microsoft Windows x64 (64-bit)" and click on it.
In the list of files, find the file named "V44416-01.zip" and click on it.
Select a download location and click on "Download". The file size is about 1 GB.
Wait for the download to complete.
Extract the zip file to a folder of your choice.
In the extracted folder, find the file named "ofm_disc_win_11.1.1.7.0_64_disk1_1of1.zip" and extract it to another folder of your choice.
Downloading from My Oracle Support
My Oracle Support is a web-based service that allows you to access Oracle support resources, such as patches, updates, documentation, and knowledge base. To download Oracle Discoverer 11g from My Oracle Support, follow these steps:
Go to https://support.oracle.com/.
If you have an existing account, sign in with your username and password. If you do not have an account, click on "Register" and follow the instructions to create a new account.
Click on the "Patches & Updates" tab.
In the "Patch Search" section, click on "Product or Family (Advanced)".
In the "Product" field, type "Oracle Discoverer" and select it from the list.
In the "Release" field, select "Oracle Discoverer 11.1.1.7.0".
In the "Platform" field, select "Microsoft Windows x64 (64-bit)".
Click on "Search".
In the search results, find the patch named "Oracle Fusion Middleware 11g Release 1 (11.1.1.7.0) for Microsoft Windows x64 (64-bit)" and click on it.
Click on "Download". The patch number is 15923919 and the file size is about 1 GB.
Select a download location and click on "Download".
Wait for the download to complete.
Extract the zip file to a folder of your choice.
In the extracted folder, find the file named "p15923919_111170_Generic.zip" and extract it to another folder of your choice.
How to install Oracle Discoverer 11g Administrator and Desktop
After you have downloaded Oracle Discoverer 11g from either Oracle Software Delivery Cloud or My Oracle Support, you can proceed to install Oracle Discoverer 11g Administrator and Desktop on Windows 7 64-bit. The following sections describe how to install Oracle Discoverer 11g Administrator and Desktop step by step.
Preparing for installation
Before you run the installer, you need to perform some preparatory tasks, such as checking the prerequisites, setting the environment variables, and disabling the antivirus software. The following steps describe how to prepare for installation:
Check that your system meets the minimum requirements and supports the compatible platforms for Oracle Discoverer 11g Administrator and Desktop, as described in the previous section.
Check that you have installed JRE 1.6.0_26 or higher on your system. You can verify your JRE version by opening a command prompt and typing java -version. If you do not have JRE installed or have an older version, you can download and install JRE from https://www.oracle.com/java/technologies/javase-downloads.html.
Set the environment variable JAVA_HOME to point to the directory where JRE is installed. For example, if JRE is installed in C:\Program Files\Java\jre6, then set JAVA_HOME=C:\Program Files\Java\jre6. You can set the environment variable by following these steps:
Right-click on "My Computer" and select "Properties".
Click on "Advanced system settings".
Click on "Environment Variables".
Under "System variables", click on "New".
In the "Variable name" field, type JAVA_HOME.
In the "Variable value" field, type the path to your JRE directory.
Click on "OK".
Disable any antivirus software that may interfere with the installation process. You can enable it again after the installation is complete.
Close any applications that may use the same ports or resources as Oracle Discoverer 11g, such as web browsers, email clients, or other Oracle products.
Running the installer
After you have prepared your system for installation, you can run the installer to install Oracle Discoverer 11g Administrator and Desktop on Windows 7 64-bit. The following steps describe how to run the installer:
Locate the folder where you extracted the installation files from either Oracle Software Delivery Cloud or My Oracle Support.
In the folder, find the file named setup.exe and double-click on it to launch the installer.
The installer will display a welcome screen. Click on "Next".
The installer will display a screen for choosing the installation type. Select "Custom" and click on "Next".
The installer will display a screen for choosing the installation location. You can accept the default location or browse to a different location. Click on "Next".
The installer will display a screen for choosing the products to install. Select "Oracle Discoverer Administrator" and "Oracle Discoverer Desktop" and click on "Next".
The installer will display a screen for reviewing the installation summary. Click on "Install".
The installer will display a progress bar and show the status of the installation. Wait for the installation to complete.
The installer will display a screen for confirming the installation success. Click on "Finish".
Configuring the connection to Oracle Fusion Middleware
After you have installed Oracle Discoverer 11g Administrator and Desktop on Windows 7 64-bit, you need to configure the connection to Oracle Fusion Middleware, which is the server component of Oracle Discoverer 11g. The following steps describe how to configure the connection:
Launch Oracle Discoverer Administrator by clicking on "Start" > "All Programs" > "Oracle Fusion Middleware 11g - Discoverer" > "Discoverer Administrator".
The application will display a login screen. Enter your username and password for Oracle Fusion Middleware and click on "Connect".
The application will display a screen for choosing the connection type. Select "Connect to an existing EUL" and click on "Next".
The application will display a screen for choosing the EUL (End User Layer) location. Enter the host name, port number, service name, username, and password for your Oracle Database that contains the EUL schema and click on "Next".
The application will display a screen for choosing the EUL language. Select your preferred language and click on "Next".
The application will display a screen for confirming the connection details. Click on "Finish".
The application will connect to Oracle Fusion Middleware and open the main window.
How to verify the installation
After you have configured the connection to Oracle Fusion Middleware, you can verify that Oracle Discoverer 11g Administrator and Desktop are installed and working properly on Windows 7 64-bit. The following steps describe how to verify the installation:
Launch Oracle Discoverer Desktop by clicking on "Start" > "All Programs" > "Oracle Fusion Middleware 11g - Discoverer" > "Discoverer Desktop".
The application will display a login screen. Enter your username and password for Oracle Fusion Middleware and click on "Connect".
The application will display a screen for choosing the connection type. Select "Connect to an existing EUL" and click on "Next".
The application will display a screen for choosing the EUL location. Enter the same details as you did for Oracle Discoverer Administrator and click on "Next".
The application will display a screen for choosing the EUL language. Select your preferred language and click on "Next".
The application will display a screen for confirming the connection details. Click on "Finish".
The application will connect to Oracle Fusion Middleware and open the main window.
In the main window, click on "File" > "Open" > "Workbook".
The application will display a screen for choosing a workbook to open. Select any workbook that is available in your EUL and click on "Open".
The application will open the workbook and display the report in a worksheet.
Verify that the report shows the correct data and format.
Conclusion
In this article, you have learned how to install Oracle Discoverer 11g Administrator and Desktop on Windows 7 64-bit, which are the client components of Oracle Discoverer 11g. You have also learned how to download Oracle Discoverer 11g from either Oracle Software Delivery Cloud or My Oracle Support, how to configure the connection to Oracle Fusion Middleware, and how to verify the installation. By following these steps, you can enjoy the benefits of Oracle Discoverer 11g, such as querying, analyzing, and reporting data from various sources.
FAQs
Here are some frequently asked questions about Oracle Discoverer 11g:
Q: What is the difference between Oracle Discoverer Administrator and Desktop?
A: Oracle Discoverer Administrator is a tool for creating and managing EULs, which are metadata repositories that store information about data sources, business areas, folders, items, joins, conditions, calculations, hierarchies, summaries, and more. Oracle Discoverer Desktop is a tool for creating and viewing workbooks, which are collections of worksheets that display reports based on EULs.
Q: How can I update Oracle Discoverer 11g to the latest version?
A: You can update Oracle Discoverer 11g to the latest version by applying patches or updates from My Oracle Support. You need to apply the patches or updates to both Oracle Fusion Middleware and Oracle Discoverer 11g Administrator and Desktop.
Q: How can I uninstall Oracle Discoverer 11g from Windows 7 64-bit?
A: You can uninstall Oracle Discoverer 11g from Windows 7 64-bit by using the deinstaller program that is located in the installation folder. You need to run the deinstaller as an administrator and follow the instructions to remove Oracle Discoverer 11g from your system.
Q: How can I get help or support for Oracle Discoverer 11g?
A: You can get help or support for Oracle Discoverer 11g by accessing the online documentation, tutorials, forums, blogs, videos, webinars, podcasts, newsletters, and other resources that are available on https://www.oracle.com/middleware/technologies/discoverer.html. You can also contact Oracle Support or your local Oracle representative for technical assistance or feedback.
Q: How can I learn more about Oracle Discoverer 11g?
A: You can learn more about Oracle Discoverer 11g by enrolling in online or classroom courses that are offered by https://education.oracle.com/. You can also take certification exams that validate your skills and knowledge of Oracle Discoverer 11g. dcd2dc6462