How to
Upgrade from OBIEE 10g to 11g
2)
Download the 10g Sample Sales data set on a server on which Oracle BI 11g is
installed.
3)
Unzip the Sample Sales data set. You should see four new files:
- Sample_Sales_V1.3_Dataset.zip
- Sample_Sales_V1.3_Readme.txt
- Sample_Sales_V1.3_Webcat.zip
- samplesales.rpd
4)
Create a subfolder in the samples sales folder and name it as
“Sample_Sales_V1.3_Webcat”
5) Now
copy the “Sample_Sales_V1.3_Webcat.zip” in to “Sample_Sales_V1.3_Webcat”
subfolder and extract all. You will have 10 g sample sales catalog in the
folder.
6)
Create a new directory named "deliveries" in
“SampleSales\Sample_Sales_V1.3_Webcat”. In 10g, the deliveries directory is a
special directory used for data such as Dashboard snapshots used by Briefing Books.
The directory is called deliveries by default and is located in the
OracleBIData\web\catalog directory. In many cases, the 10g directory is empty.
If the 10g deliveries directory is not available, any empty directory named
deliveries can be given for upgrade. If Upgrade Assistant finds a directory
called deliveries in the same folder as the catalog, it is selected by default.
7)
Sample_Sales_V1.3_Dataset.zip contains a sample set of data in XML format for
display in Oracle BI dashboards. To make this data available for queries,
extract Sample_Sales_V1.3_Dataset.zip to the following location:
For Ex:
Note: when I installed the OBIEE
11.1.16 on my laptop and navigated to the below folder, as said in the
documentation path below, I didn’t find the server folder
%MIDDLEWARE_HOME%\instances\instance1\bifoundation\OracleBIServerComponent\
coreapplication_obis1\server\Sample
. It is
just
C:\BIHOME\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample
So what I
did was created a folder called server and dragged and dropped the sample
folder inside server folder. Now I have the files in the specified path in the
oracle Documentation.
Upgrading
the Oracle BI Repository and Catalog
1) Navigate to
the following folder
C:\BIHOME\Oracle_BI1\bin
2) Double-click
ua.bat to open Upgrade Assistant in the graphical user interface mode and
follow the screen shots below.
You can check the
log file @ C:\BIHOME\Oracle_BI1\upgrade\logs. If any errors occur during
upgrading.
Verifying the Upgrade:
1) Login to Oracle Enterprise
Manager http://localhost:7001/em
2) In the left pane, expand Business
Intelligence > coreapplication.
3) In the right pane, select the
Overview page and confirm that all system components are available.
4) Select the Deployment page.
5) Select the Repository subtab.
This page shows the current installed repository. Notice that the Upgrade
Assistance automatically uploaded the upgraded repository to the BI Server
domain. In this example, the repository is named as samplesales_BI0002.
Verifying Repository Metadata:
1) Open the repository in the
offline mode
2) Please give your Repository
password which you have mentioned in screen 3 of 8 in the upgrading process.
You will see screen as below.
3) Double-click Connection Pool A
and Click yes
4) Set the value to the OB_EE_HOME
variable
5) Go to Select Manage >
Variables to open Variable Manager
6) Double click on variable
BI_EE_HOME. Change the Default initializer to the Folder directory where you
have copied the data.zip in the earlier step.
7) Click ok to close.
8) Now check in the changes. Do not
Do any global consistence check at this point just save.
Note : nQSError: 37005 Transactional
Update Failed
If you get this error do the
following
This will resolve your problem.
Verifying Reports and Dashboards
1)
Login to OBIEE Home Page and Login
2)
3)
4) Click on Analysis
5) Select sample sales subject area
6)You will see the below screen
where you can build the sample report
7)Now build Sample report
No comments:
Post a Comment