11G authentication failure - Validate Catalog

When you move repositories between machines and copy the catalog it is possible that there will be conflicting permissions between the details in the catalog and details held in weblogic.

I have previously mentioned how to reset the GUIDS - the glue between weblogic authentication and the catalog.

Sometimes this is not enough - usually when you find that have no permission to change settings on your My Dashboard or you cannot change settings in My Account.

A light touch 'refresh' may be something like:
If you add the following to your instanceconfig.xml file
<Validate>OnStartup</Validate>
<ValidateItems>None</ValidateItems>
<ValidateLinks>None</
ValidateLinks>
<ValidateAccounts>Clean</ValidateAccounts>
<ValidateHomes>None</ValidateHomes>
and open a command line in ../instances/instance1/bin
you can use opmnctl to stop and start the services. This may take some time depending on the size of your catalog.
Remove the Validate section from your instanceconfig.xml and stop/start opmnctl.

To force a 'deep clean' you can opt for something like:

<ps:Validate>OnStartupAndExit</ps:Validate>

<ps:ValidateAccounts>Clean</ps:ValidateAccounts>

<ps:ValidateHomes>Report</ps:ValidateHomes>

<ps:ValidateItems>Clean</ps:ValidateItems>

<ps:ValidateLinks>Clean</ps:ValidateLinks>

As always the documentation is available here from Oracle.

Hiding Catalog and Open links from Users in OBIEE 11.1.1.5

Oracle support have thought of this for us - Useful but limiting and only really applies to 11.1.1.5

How to remove Catalog, Open, Advanced, Help, Home and Search links in OBIEE 11.1.1.5 [ID 1349315.1]

In order to accomplish this following steps need to be performed:

In OBIEE 11.1.1.5 the following new expressions have been added in saw.sessioninfos.xml file. This file is under $ORACLE_HOME/bifoundation/web/msgdb/common/

Edit saw.sessioninfos.xml file, you will see following tags:

<gdexpression id="hdrLinkCatalog" expr="true" />
<gdexpression id="hdrLinkOpen" expr="true" />
<gdexpression id="hdrLinkAdvanced" expr="true" />
<gdexpression id="hdrLinkHelp" expr="true" />
<gdexpression id="hdrLinkHome" expr="true" />
<gdexpression id="hdrLinkGSearch" expr="true" />

Each of these control the display of a UI element in the global header.
By setting the value to "false" instead of "true", the corresponding UI element in the global header can be hidden.

For changes to take effect, please re-start BI Services and clear Browser cache.

IMPORTANT: Finally, note that this change is global, meaning will affect all users. Currently there is an Enhancement Request which has as objective to control these changes via permissions so it can be set at user level, (Bug 10173641).

Upgrade 11.1.1.3 to 11.1.1.5

Only undertake the OBIEE upgrade if you have fully backed up database and OBIEE install. This is an in-place upgrade that is not for the faint hearted and I would recommend setting a good 2-3 hours aside to finish.

Pre-requisites.

The details in this article only really apply if you are:
1. Running 32 bit Windows Server 2003 and OBIEE 11.1.1.3 with Weblogic 10.3.3
2. You have installed OBIEE 11.1.1.3 in D:\OBIEE11G

You have read the upgrade / patch details on the Oracle Website

You have downloaded the Weblogic patch from Oracle

You have downloaded the OBIEE 11.1.1.5 disks from Oracle and unpacked them correctly.

Step 1.


Shut down all beasvc processes, OPMN and the Oracle Weblogic NodeManager. No processes or threads should be running as services for the next steps.

Step 2.

Upgrade Weblogic using the patch (wls1035_upgrade_win32.exe).

Select "Next" and accept all defaults.

Step 3.

Some settings have not set correctly in D:\OBIEE11G\user_projects\domains\bifoundation_domain\bin\setDomainEnv.cmd.

Edit the file and ensure that the correct (new) paths are set for all the JAVA HOMES.

set BEA_JAVA_HOME=D:\OBIEE11G\jrockit_160_24_D1.1.2-4

set SUN_JAVA_HOME=D:\OBIEE11G\jdk160_24

if "%JAVA_VENDOR%"=="Oracle" (
 set JAVA_HOME=%BEA_JAVA_HOME%
) else (
 if "%JAVA_VENDOR%"=="Sun" (
  set JAVA_HOME=%SUN_JAVA_HOME%
 ) else (
  set JAVA_VENDOR=Oracle
  set JAVA_HOME=D:\OBIEE11G\jrockit_160_24_D1.1.2-4
 )
)

Step 4.

Now will perform a software only install of 11.1.1.5. Start the installer and select software only install, the existing middleware home and defaults for all the other options.

Step 5.

Now we upgrade the MDS and BIPLATFORM schemas. Ensure these are backed up before starting.
From the command line we will now upgrade the database schemas

cd D:\OBIEE11G\Oracle_BI1\bin

psa.bat -dbConnectString localhost:1521:dbname -dbaUserName sys -schemaUserName YOUR_BIPLATFORM

You will be prompted for the password for SYS and YOUR_BIPLATFORM. Here is the output.

D:\OBIEE11G\Oracle_BI1\bin>psa.bat -dbConnectString strashtdbs043v:1521:tkitt01
-dbaUserName sys -schemaUserName TEST_BIPLATFORM
Oracle Fusion Middleware Patch Set Assistant 11.1.1.5.0

Enter the database administrator password for "sys":
Enter the schema password for schema user "YOUR_BIPLATFORM":
Log file is located at: D:\OBIEE11G\Oracle_BI1\upgrade\logs\psa2011-11-15-13-55-
22PM.log
Updating the Oracle Fusion Middleware Metadata Schema to release 11.1.1.5.0.
Updating schema for component Oracle BI PLATFORM.
The command completed successfully

The we upgrade the MDS schema in a similar fashion.

psa.bat -dbConnectString localhost:1521:dbname-dbaUserName sys -schemaUserName YOUR_MDS



Once again you will be prompted for the SYS and MDS password.

D:\OBIEE11G\Oracle_BI1\bin>psa.bat -dbConnectString strashtdbs043v:1521:tkitt01
-dbaUserName sys -schemaUserName TEST_MDS
Oracle Fusion Middleware Patch Set Assistant 11.1.1.5.0

Enter the database administrator password for "sys":
Enter the schema password for schema user "TEST_MDS":
Log file is located at: D:\OBIEE11G\Oracle_BI1\upgrade\logs\psa2011-11-15-13-57-
17PM.log
Updating the Oracle Fusion Middleware Metadata Schema to release 11.1.1.5.0.
Updating schema for component Oracle Metadata Services.
The command completed successfully


Step 6.

Now we will upgrade the system components. Open a seperate command window and

cd d:\OBIEE11G\user_projects\domains\bifoundation_domain\bin
startWebLogic.cmd


Once Weblogic has started the following commands can be run:

cd d:\OBIEE11G\Oracle_BI1\opmn\bin
set ORACLE_HOME=d:\OBIEE11G\Oracle_BI1
upgradenonj2eeapp.bat -oracleInstance d:\OBIEE11G\instances\instance1 -adminHost localhost -adminPort 7001 -adminUsername weblogic

Replace the "localhost" with your machine name, and you should have an output similar to the following. You will be prompted for the weblogic adminuser password a couple of times as the instance is re-registered.

D:\OBIEE11G\Oracle_BI1\opmn\bin>upgradenonj2eeapp.bat -oracleInstance d:\OBIEE11G\instances\instance1 -adminHost xxxxxxxxxx -adminPort 7001 -adminUsername weblogic
Unregister instance...

Command requires login to weblogic admin server (xxxxxxxxxx):
  Username: weblogic
  Password:

Unregistering instance
Command succeeded.
redeploy NonJ2EEManagement.ear...

Command requires login to weblogic admin server (xxxxxxxxxx):
  Username: weblogic
  Password:

Redeploying NonJ2EEManagement Application...weblogic.Deployer invoked with options:  -adminurl xxxxxxxxxx:7001 -username weblogic -name NonJ2EEManagement -source D:\OBIEE11G\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear -redeploy -upload -noexit
<15-Nov-2011 14:12:31 o'clock GMT> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiating redeploy operation for application, NonJ2EEManagement [archive: D:\OBIEE11G\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear], to configured targets.>
Task 0 initiated: [Deployer:149026]deploy application NonJ2EEManagement [Version=11.1.1] on AdminServer.
Task 0 completed: [Deployer:149026]deploy application NonJ2EEManagement [Version=11.1.1] on AdminServer.
Target state: redeploy completed on Server AdminServer

Done
Command succeeded.
re-register instance...

Command requires login to weblogic admin server (xxxxxxxxxx):
  Username: weblogic
  Password:

Registering instance
Command succeeded.
Successfully upgraded NonJ2EEManagement.ear and the registeration.
D:\OBIEE11G\Oracle_BI1\opmn\bin>
Step 7.

Upgrade Fusion Middleware Shared Libraries, and Security Elements. First we need to shutdown Weblogic

cd d:\OBIEE11G\user_projects\domains\bifoundation_domain\bin

stopWebLogic.cmd

This will close down the Weblogic command window you started previously.

Now we do some Weblogic Scripting to upgrade the

cd d:\OBIEE11G\oracle_common\common\bin

wlst

upgradeJRF('d:/OBIEE11G/user_projects/domains/bifoundation_domain')

upgradeOpss(jpsConfig="d:/OBIEE11G/user_projects/domains/bifoundation_domain/config/fmwconfig/jps-config.xml", jaznData="d:/OBIEE11G/oracle_common/modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml")

exit()
----- output ------------
D:\OBIEE11G\oracle_common\common\bin>wlst

CLASSPATH=D:\OBIEE11G\patch_wls1035\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\patch_oepe1050\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\patch_ocp360\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\JROCKI~1.2-4\lib\tools.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\weblogic.jar;D:\OBIEE11G\modules\features\weblogic.server.modules_10.3.5.0.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\webservices.jar;D:\OBIEE11G\modules\ORGAPA~1.1/lib/ant-all.jar;D:\OBIEE11G\modules\NETSFA~1.0_1/lib/ant-contrib.jar;;D:\OBIEE11G\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-wlstman.jar;D:\OBIEE11G\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\lib\ADFSCR~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\IGFWLS~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\OBIEE11G
\ORACLE~1\common\wlst\RESOUR~1\OVDWLS~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar

PATH=D:\OBIEE11G\patch_wls1035\profiles\default\native;D:\OBIEE11G\patch_oepe1050\profiles\default\native;D:\OBIEE11G\patch_ocp360\profiles\default\native;D:\OBIEE11G\WLSERV~1.3\server\native\win\32;D:\OBIEE11G\WLSERV~1.3\server\bin;D:\OBIEE11G\modules\ORGAPA~1.1\bin;D:\OBIEE11G\JROCKI~1.2-4\jre\bin;D:\OBIEE11G\JROCKI~1.2-4\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\OBIEE11G\Oracle_BI1\bin;D:\OBIEE11G\Oracle_BI1\opmn\bin;D:\OBIEE11G\Oracle_BI1\opmn\lib;D:\OBIEE11G\Oracle_BI1\perl\bin;D:\OBIEE11G\Oracle_BI1\products\Essbase\EssbaseServer\bin;D:\OBIEE11G\WLSERV~1.3\server\native\win\32\oci920_8

Your environment has been set.

CLASSPATH=D:\OBIEE11G\patch_wls1035\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\patch_oepe1050\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\patch_ocp360\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\JROCKI~1.2-4\lib\tools.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\weblogic.jar;D:\OBIEE11G\modules\features\weblogic.server.modules_10.3.5.0.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\webservices.jar;D:\OBIEE11G\modules\ORGAPA~1.1/lib/ant-all.jar;D:\OBIEE11G\modules\NETSFA~1.0_1/lib/ant-contrib.jar;;D:\OBIEE11G\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-wlstman.jar;D:\OBIEE11G\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\lib\ADFSCR~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\IGFWLS~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OVDWLS~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\OBIEE11G\utils\config\10.3\config-launch.jar;D:\OBIEE11G\WLSERV~1.3\common\derby\lib\derbynet.jar;D:\OBIEE11G\WLSERV~1.3\common\derby\lib\derbyclient.jar;D:\OBIEE1
1G\WLSERV~1.3\common\derby\lib\derbytools.jar;;

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

wls:/offline>
wls:/offline> upgradeJRF('d:/OBIEE11G/user_projects/domains/bifoundation_domain'
)
upgradeJRF: BEGIN
Apply patch template
Create Library "adf.oracle.businesseditor#1.0@11.1.1.2.0"
Target Library "adf.oracle.businesseditor#1.0@11.1.1.2.0" to JRF "bi_cluster"
Target Library "adf.oracle.businesseditor#1.0@11.1.1.2.0" to JRF "AdminServer"
Create Library "oracle.adf.desktopintegration.model#1.0@11.1.1.2.0"
Target Library "oracle.adf.desktopintegration.model#1.0@11.1.1.2.0" to JRF "bi_cluster"
Target Library "oracle.adf.desktopintegration.model#1.0@11.1.1.2.0" to JRF "AdminServer"
Create Library "oracle.adf.desktopintegration#1.0@11.1.1.2.0"
Target Library "oracle.adf.desktopintegration#1.0@11.1.1.2.0" to JRF "bi_cluster"
Target Library "oracle.adf.desktopintegration#1.0@11.1.1.2.0" to JRF "AdminServer"
Target Library instances from sub-templates:
Target Library "oracle.bi.adf.model.slib#1.0@11.1.1.2.0" to JRF "bi_cluster"
Target Library "oracle.bi.adf.model.slib#1.0@11.1.1.2.0" to JRF "AdminServer"
Target Library "oracle.bi.adf.view.slib#1.0@11.1.1.2.0" to JRF "bi_cluster"
Target Library "oracle.bi.adf.view.slib#1.0@11.1.1.2.0" to JRF "AdminServer"
Target Library "oracle.bi.adf.webcenter.slib#1.0@11.1.1.2.0" to JRF "bi_cluster"
Target Library "oracle.bi.adf.webcenter.slib#1.0@11.1.1.2.0" to JRF "AdminServer"
Target Library "oracle.bi.jbips#11.1.1@0.1" to JRF "bi_cluster"
Target Library "oracle.bi.jbips#11.1.1@0.1" to JRF "AdminServer"
Target Library "oracle.bi.composer#11.1.1@0.1" to JRF "bi_cluster"
Target Library "oracle.bi.composer#11.1.1@0.1" to JRF "AdminServer"
Create StartupClass "Web Services Startup Class"
Target StartupClass "Web Services Startup Class" to JRF "bi_cluster"
Target StartupClass "Web Services Startup Class" to JRF "AdminServer"
Set DiagnosticContextEnabled for server "bi_server1"
Set DiagnosticContextEnabled for server "AdminServer"
Copy JRF configuration files from D:\OBIEE11G\ORACLE~1/modules to d:/OBIEE11G/user_projects/domains/bifoundation_domain/config/fmwconfig/servers/bi_server1
Copy JRF configuration files from D:\OBIEE11G\ORACLE~1/modules to d:/OBIEE11G/user_projects/domains/bifoundation_domain/config/fmwconfig/servers/AdminServer
upgradeJRF: FINISH
wls:/offline>
wls:/offline>upgradeOpss(jpsConfig="d:/OBIEE11G/user_projects/domains/bifoundation_domain/config/fmwconfig/jps-config.xml", jaznData="d:/OBIEE11G/oracle_common/modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml")
Starting upgrade of jps configuration and security stores.
WLS ManagedService is not up running. Fall back to use system properties for configuration.
15-Nov-2011 14:23:49 oracle.security.jps.internal.tools.utility.destination.apibased.JpsDstPolicy <init>
WARNING: No identity store associate with policy store found.
Upgrade of jps configuration and security stores is done.
wls:/offline>
wls:/offline>exit()


Exiting WebLogic Scripting Tool.

D:\OBIEE11G\oracle_common\common\bin>

and now we upgrade the OBIEE home.

wlst d:\OBIEE11G\Oracle_BI1\bin\bi-upgrade.py --bioraclehome d:\OBIEE11G\Oracle_BI1 --domainhome d:\OBIEE11G\user_projects\domains\bifoundation_domain


and finally the  policy repository, and for this we need to start up weblogic from a new command window.

cd d:\OBIEE11G\user_projects\domains\bifoundation_domain\bin\
startWebLogic.cmd

once the server is running... replace localhost with your machine name and password with your weblogic adminuser password

cd d:\OBIEE11G\oracle_common\common\bin
wlst
connect ('weblogic','password','t3://localhost:7001')
upgradeWSMPolicyRepository()
exit()


this will give you something like the following output

D:\OBIEE11G\oracle_common\common\bin>wlst

CLASSPATH=D:\OBIEE11G\patch_wls1035\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\patch_oepe1050\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\patch_ocp360\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\JROCKI~1.2-4\lib\tools.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\weblogic.jar;D:\OBIEE11G\modules\features\weblogic.server.modules_10.3.5.0.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\webservices.jar;D:\OBIEE11G\modules\ORGAPA~1.1/lib/ant-all.jar;D:\OBIEE11G\modules\NETSFA~1.0_1/lib/ant-contrib.jar;;D:\OBIEE11G\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-wlstman.jar;D:\OBIEE11G\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\lib\ADFSCR~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\IGFWLS~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OVDWLS~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar

PATH=D:\OBIEE11G\patch_wls1035\profiles\default\native;D:\OBIEE11G\patch_oepe1050\profiles\default\native;D:\OBIEE11G\patch_ocp360\profiles\default\native;D:\OBIEE11G\WLSERV~1.3\server\native\win\32;D:\OBIEE11G\WLSERV~1.3\server\bin;D:\OBIEE11G\modules\ORGAPA~1.1\bin;D:\OBIEE11G\JROCKI~1.2-4\jre\bin;D:\OBIEE11G\JROCKI~1.2-4\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;D:\OBIEE11G\Oracle_BI1\bin;D:\OBIEE11G\Oracle_BI1\opmn\bin;D:\OBIEE11G\Oracle_BI1\opmn\lib;D:\OBIEE11G\Oracle_BI1\perl\bin;D:\OBIEE11G\Oracle_BI1\products\Essbase\EssbaseServer\bin;D:\OBIEE11G\WLSERV~1.3\server\native\win\32\oci920_8

Your environment has been set.

CLASSPATH=D:\OBIEE11G\patch_wls1035\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\patch_oepe1050\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\patch_ocp360\profiles\default\sys_manifest_classpath\weblogic_patch.jar;D:\OBIEE11G\JROCKI~1.2-4\lib\tools.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\weblogic_sp.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\weblogic.jar;D:\OBIEE11G\modules\features\weblogic.server.modules_10.3.5.0.jar;D:\OBIEE11G\WLSERV~1.3\server\lib\webservices.jar;D:\OBIEE11G\modules\ORGAPA~1.1/lib/ant-all.jar;D:\OBIEE11G\modules\NETSFA~1.0_1/lib/ant-contrib.jar;;D:\OBIEE11G\ORACLE~1/modules/oracle.jrf_11.1.1/jrf-wlstman.jar;D:\OBIEE11G\ORACLE~1\common\wlst\lib\ADF-SH~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\lib\ADFSCR~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\lib\mdswlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\AUDITW~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\IGFWLS~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\jps-wlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\jrf-wlst.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OAMAP_~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OAMAUT~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\ossoiap.jar;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OSSOIA~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\OVDWLS~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\SSLCON~1.JAR;D:\OBIEE11G\ORACLE~1\common\wlst\RESOUR~1\wsm-wlst.jar;D:\OBIEE11G\utils\config\10.3\config-launch.jar;D:\OBIEE11G\WLSERV~1.3\common\derby\lib\derbynet.jar;D:\OBIEE11G\WLSERV~1.3\common\derby\lib\derbyclient.jar;D:\OBIEE11G\WLSERV~1.3\common\derby\lib\derbytools.jar;;

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

wls:/offline>

wls:/offline> connect ('weblogic','xxxxxxxx','t3://xxxxxxxxx:7001')
Connecting to t3://xxxxxxxxxx:7001 with userid weblogic ...
Successfully connected to Admin Server 'AdminServer' that belongs to domain 'bif
oundation_domain'.

Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.

wls:/bifoundation_domain/serverConfig> upgradeWSMPolicyRepository()
Location changed to domainRuntime tree. This is a read-only tree with DomainMBea
n as the root.
For more help, use help(domainRuntime)


Starting Operation upgradeWSMPolicyRepository ...


The following documents have been added to the repository.

oracle/no_addressing_policy
oracle/no_authentication_client_policy
oracle/no_authentication_service_policy
oracle/no_authorization_component_policy
oracle/no_authorization_service_policy
oracle/no_messageprotection_client_policy
oracle/no_messageprotection_service_policy
oracle/no_mtom_policy
oracle/no_wsrm_policy
oracle/sts_trust_config_client_policy
oracle/sts_trust_config_client_template
oracle/sts_trust_config_service_policy
oracle/sts_trust_config_service_template
oracle/whitelist_authorization_policy
oracle/wss10_saml20_token_client_policy
oracle/wss10_saml20_token_client_template
oracle/wss10_saml20_token_service_policy
oracle/wss10_saml20_token_service_template
oracle/wss10_saml20_token_with_message_protection_client_policy
oracle/wss10_saml20_token_with_message_protection_client_template
oracle/wss10_saml20_token_with_message_protection_service_policy
oracle/wss10_saml20_token_with_message_protection_service_template
oracle/wss11_kerberos_token_with_message_protection_basic128_client_policy
oracle/wss11_kerberos_token_with_message_protection_basic128_service_policy
oracle/wss11_saml20_token_with_message_protection_client_policy
oracle/wss11_saml20_token_with_message_protection_client_template
oracle/wss11_saml20_token_with_message_protection_service_policy
oracle/wss11_saml20_token_with_message_protection_service_template
oracle/wss11_sts_issued_saml_hok_with_message_protection_client_policy
oracle/wss11_sts_issued_saml_hok_with_message_protection_client_template
oracle/wss11_sts_issued_saml_hok_with_message_protection_service_policy
oracle/wss11_sts_issued_saml_hok_with_message_protection_service_template
oracle/wss11_sts_issued_saml_with_message_protection_client_policy
oracle/wss11_sts_issued_saml_with_message_protection_client_template
oracle/wss_saml20_token_bearer_over_ssl_client_policy
oracle/wss_saml20_token_bearer_over_ssl_client_template
oracle/wss_saml20_token_bearer_over_ssl_service_policy
oracle/wss_saml20_token_bearer_over_ssl_service_template
oracle/wss_saml20_token_over_ssl_client_policy
oracle/wss_saml20_token_over_ssl_client_template
oracle/wss_saml20_token_over_ssl_service_policy
oracle/wss_saml20_token_over_ssl_service_template
oracle/wss_saml_or_username_token_service_policy
oracle/wss_sts_issued_saml_bearer_token_over_ssl_client_policy
oracle/wss_sts_issued_saml_bearer_token_over_ssl_client_template
oracle/wss_sts_issued_saml_bearer_token_over_ssl_service_policy
oracle/wss_sts_issued_saml_bearer_token_over_ssl_service_template

The following documents have changed since the last installed version of the product.
 Please import the latest version of the files using Oracle Enterprise Manager.

oracle/binding_authorization_denyall_policy
oracle/binding_authorization_permitall_policy
oracle/binding_permission_authorization_policy
oracle/component_authorization_denyall_policy
oracle/component_authorization_permitall_policy
oracle/component_permission_authorization_policy
oracle/log_policy
oracle/wsaddr_policy
oracle/wsmtom_policy
oracle/wsrm10_policy
oracle/wsrm11_policy
oracle/wss10_message_protection_client_policy
oracle/wss10_message_protection_service_policy
oracle/wss10_saml_hok_token_with_message_protection_client_policy
oracle/wss10_saml_hok_token_with_message_protection_client_template
oracle/wss10_saml_hok_token_with_message_protection_service_policy
oracle/wss10_saml_hok_token_with_message_protection_service_template
oracle/wss10_saml_token_client_policy
oracle/wss10_saml_token_client_template
oracle/wss10_saml_token_service_policy
oracle/wss10_saml_token_service_template
oracle/wss10_saml_token_with_message_integrity_client_policy
oracle/wss10_saml_token_with_message_integrity_service_policy
oracle/wss10_saml_token_with_message_protection_client_policy
oracle/wss10_saml_token_with_message_protection_client_template
oracle/wss10_saml_token_with_message_protection_service_policy
oracle/wss10_saml_token_with_message_protection_service_template
oracle/wss10_saml_token_with_message_protection_ski_basic256_client_policy
oracle/wss10_saml_token_with_message_protection_ski_basic256_service_policy
oracle/wss10_username_id_propagation_with_msg_protection_client_policy
oracle/wss10_username_id_propagation_with_msg_protection_service_policy
oracle/wss10_username_token_with_message_protection_client_policy
oracle/wss10_username_token_with_message_protection_service_policy
oracle/wss10_username_token_with_message_protection_ski_basic256_client_policy
oracle/wss10_username_token_with_message_protection_ski_basic256_service_policy
oracle/wss10_x509_token_with_message_protection_client_policy
oracle/wss10_x509_token_with_message_protection_service_policy
oracle/wss11_kerberos_token_client_policy
oracle/wss11_kerberos_token_service_policy
oracle/wss11_kerberos_token_with_message_protection_client_policy
oracle/wss11_kerberos_token_with_message_protection_service_policy
oracle/wss11_message_protection_client_policy
oracle/wss11_message_protection_service_policy
oracle/wss11_saml_or_username_token_with_message_protection_service_policy
oracle/wss11_saml_token_identity_switch_with_message_protection_client_policy
oracle/wss11_saml_token_with_message_protection_client_policy
oracle/wss11_saml_token_with_message_protection_client_template
oracle/wss11_saml_token_with_message_protection_service_policy
oracle/wss11_saml_token_with_message_protection_service_template
oracle/wss11_username_token_with_message_protection_client_policy
oracle/wss11_username_token_with_message_protection_service_policy
oracle/wss11_x509_token_with_message_protection_client_policy
oracle/wss11_x509_token_with_message_protection_service_policy
oracle/wss_http_token_client_policy
oracle/wss_http_token_over_ssl_client_policy
oracle/wss_http_token_over_ssl_service_policy
oracle/wss_http_token_service_policy
oracle/wss_saml_or_username_token_over_ssl_service_policy
oracle/wss_saml_token_bearer_over_ssl_client_policy
oracle/wss_saml_token_bearer_over_ssl_client_template
oracle/wss_saml_token_bearer_over_ssl_service_policy
oracle/wss_saml_token_bearer_over_ssl_service_template
oracle/wss_saml_token_over_ssl_client_policy
oracle/wss_saml_token_over_ssl_client_template
oracle/wss_saml_token_over_ssl_service_policy
oracle/wss_saml_token_over_ssl_service_template
oracle/wss_username_token_client_policy
oracle/wss_username_token_over_ssl_client_policy
oracle/wss_username_token_over_ssl_service_policy
oracle/wss_username_token_service_policy

upgradeWSMPolicyRepositoryOperation Completed.

wls:/bifoundation_domain/serverConfig>

Step 8

Upgrade the Oracle BI Presentation Server Catalog
With the presentation server down we will do an upgrade of the catalog. First we have to edit the instanceconfig.xml file to force an upgrade.

<ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
<ps:UpgradeAndExit>false</ps:UpgradeAndExit>
</ps:Catalog>

to 

<ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
<ps:UpgradeAndExit>true</ps:UpgradeAndExit>
</ps:Catalog> 

Start the presentation service and then edit the instanceconfig.xml back to its original 'false' setting.

Now reboot to test that all your services come up as expected.

Good luck and let me know how you get on.

Adding a Excel spreadsheet as a datasource in OBIEE

OBIEE can combine Excel spreadsheets as sources of data into your BI solution.

Here's a quick run-through of the stepsyou should take to include the spreadsheet.



1. Open the excel file to the sheet in the workbook you want to use as a datasource.

2. Ensure you have no filters set.

3. Highlight the range of rows and columns you wish to use, including the column headings. The column headings will become the column names. Right click and give your range selection a name or you can go to Formulas-->Define Name and give the scope and range.

4. Each spreadsheet can have multiple named ranges. Each named range will become a "table".

5. Now you need to create a System DSN for the Excel data source. Open the Data Sources (ODBC) from the Control Panel or Administrative Tools menu.  Select the Microsoft Excel Driver from the list of drivers.

6. Give the DSN a name and browse to the spreadsheet with the named range and click on Ok.

7. Open the OBIEE Administraton Tool. For OBIEE 10g go to Administration tools and click on File>Import from Database. Select the DSN which you created for Excel. For OBIEE 11g select File>Import Metadata - the DSN should be in the list of DSN data sources available, select the DSN and continue to import as normal through the wizard.

8. When you click on Import, it will import all the tables present in that excel file.

9. Once you get the tables in physical layer, you can play around with those tables to create subject area.