Oracle Business Intelligence Enterprise Edition 11.1.1.9.0

Oracle Business Intelligence Enterprise Edition 11.1.1.9.0 is now available.

The newest version of OBIEE is now available to download from OTN.

The patching and upgrading looks fairly straightforward and I'll let you know what happens and how it happened as soon as I've done the upgrade.

Instructions and documentation on upgrading are available here.

General documentation about 11.1.1.9 is available here.

Until then

OBIEE version 11.1.1.7.131017 has been released

The Business Intelligence Enterprise Edition 11.1.1.7.131017 patch set has been released, and is available to download from My Oracle Support (https:\\support.oracle.com).

Per the patch readme:
This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.7.0 and 11.1.1.7.1.

It is also available for Exalytics customers who have applied the Exalytics PS3 patch.

Patch 17530796 - OBIEE BUNDLE PATCH 11.1.1.7.131017 (Patch) is comprised of the following patches, which are not available separately:

    Patch 16913445 - Patch 11.1.1.7.131017 (1 of 8) Oracle Business Intelligence Installer (BIINST)
    Patch 17463314 - Patch 11.1.1.7.131017 (2 of 8) Oracle Business Intelligence Publisher (BIP)
    Patch 17300417 - Patch 11.1.1.7.131017 (3 of 8) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM))
    Patch 17463395 - Patch 11.1.1.7.131017 (4 of 8) Oracle Business Intelligence Server (BIS)
    Patch 17463376 - Patch 11.1.1.7.131017 (5 of 8) Oracle Business Intelligence Presentation Services (BIPS)
    Patch 17300045 - Patch 11.1.1.7.131017 (6 of 8) Oracle Business Intelligence Presentation Services (BIPS)
    Patch 16997936 - Patch 11.1.1.7.131017 (7 of 8) Oracle Business Intelligence Presentation Services (BIPS)
    Patch 17463403 - Patch 11.1.1.7.131017 (8 of 8) Oracle Business Intelligence Platform Client Installers and MapViewer

Also you must download:

Patch 16569379 - Dynamic Monitoring Service patch

The instructions to apply the bundle patch are given in the patch readme along with some important notes if you are upgrading from 11.1.1.6.x versions.

The new functionality in this patch includes:

    Support for Microsoft Internet Explorer 10
    Support for Oracle BI Mobile App Designer
    Support for improved exporting functionality into Microsoft Excel
For more information please refer to document:
OBIEE 11g 11.1.1.7.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics (Doc ID 1595219.1)
In addition we strongly recommend you review this document:
OBIEE Suite Bundle Patches (Doc ID 1591422.1), which explains the new naming convention, the strategy behind bundle patches and other interesting facts about OBIEE patching. Please take some time to review it.

OBIEE 11g 11.1.1.7.1 is Available

The Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.1 patch set has been released.  This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.7.0. 

Now available to download from My Oracle Support  

Patch 16556157: OBIEE BUNDLE PATCH 11.1.1.7.1

This single OBIEE 11.1.1.7.1 patch set download is comprised of the following:

• 1 of 6 Oracle Business Intelligence Installer (BIINST)
• 2 of 6 Oracle Business Intelligence Publisher (BIP)
• 3 of 6 EPM Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM))
• 4 of 6 Oracle Business Intelligence Server (BIS)
• 5 of 6 Oracle Business Intelligence Presentation Services (BIPS)
• 6 of 6 Oracle Business Intelligence Platform Client Installers and MapViewer

Ensure to review the readme file on the Installer download for important installation instructions
The following is also required to be downloaded and applied:
Patch 16569379: Dynamic Monitoring Service patch

Additional important notes are available in  the following document:
Document 1566124.1: OBIEE 11g 11.1.1.7.1 is Available for Oracle Business Intelligence Enterprise Edition

Upgrade a Simple install to 11.1.1.7

Upgrading a simple install to 11.1.1.7 from 11.1.1.6.2 BP1

Following on from the previous article on upgrading an enterprise install of OBIEE here's how to do the same for a simple install.

Not as straightforward as the upgrade of the enterprise install where it is all wizard driven. For this upgrade you can start out as for the enterprise upgrade for the first couple of steps and then do the rest manually.

As with the enterprise upgrade do a software only install specifying the middleware home that you want patched

Then run the patch set assistant for the MDS and BIPLATFORM schemas. If you do this step manually make sure that you upgrade MDS first.

Now instead of running the configuration wizard, which runs all the steps for you, you will run the following manually.

Assume the following: 

the simple install is in the directory C:\obiee11g on windows.
our simple install is version 11.1.1.6.2 BP1

1. Upgrade the system components.

cd C:\obiee11g\user_projects\domains\bifoundation_domain\bin
startweblogic.cmd
(once the server is in the RUNNING state)
set ORACLE_HOME=C:\obiee11g\Oracle_BI1
cd C:\obiee11g\instances\instance1\bin
opmnctl startall
cd c:\obiee11g\Oracle_BI1\opmn\bin
--note replace localhost with your servername if appropriate
run 
upgradenonj2eeapp.bat -oracleInstance c:\obiee11g\instances\instance1 -adminHost localhost -adminPort 7001 -adminUsername weblogic

Unregister instance...

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

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

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

Redeploying NonJ2EEManagement Application...weblogic.Deployer invoked with optio
ns:  -adminurl V01228730:7001 -username weblogic -name NonJ2EEManagement -source
 C:\obiee11g\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear -redeploy -uploa
d -noexit
<23-Apr-2013 14:12:42 o'clock BST> <Info> <J2EE Deployment SPI> <BEA-260121> <In
itiating redeploy operation for application, NonJ2EEManagement [archive: C:\obie
e11g\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear], to configured targets.
>
Task 0 initiated: [Deployer:149026]deploy application NonJ2EEManagement on Admin
Server.
Task 0 completed: [Deployer:149026]deploy application NonJ2EEManagement on Admin
Server.
Target state: redeploy completed on Server AdminServer

Done
Command succeeded.
re-register instance...

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

Registering instance
Command succeeded.
Successfully upgraded NonJ2EEManagement.ear and the registeration.
C:\obiee11g\instances\instance1\bin>

2. update the shared libraries and security.

cd C:\obiee11g\user_projects\domains\bifoundation_domain\bin
stopWeblogic.cmd
cd C:\obiee11g\oracle_common\common\bin
wlst
upgradeJRF('c:/obiee11g/user_projects/domains/bifoundation_domain')
upgradeOpss(jpsConfig="c:/obiee11g/user_projects/domains/bifoundation_domain/config/fmwconfig/jps-config.xml", jaznData="c:/obiee11g/oracle_common/modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml")
exit()

wls:/offline> upgradeJRF('c:/obiee11g/user_projects/domains/bifoundation_domain'
)
upgradeJRF: skip, JRF is up-to-date.
wls:/offline>upgradeOpss(jpsConfig="c:/obiee11g/user_projects/domains/bifoundati
on_domain/config/fmwconfig/jps-config.xml", jaznData="c:/obiee11g/oracle_common/
modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml")
{upgradeJseStoreType=null, auditStore=null, password=null, user=null, url=null,
jdbcDriver=null, jaznData=c:/obiee11g/oracle_common/modules/oracle.jps_11.1.1/do
main_config/system-jazn-data.xml, jpsConfig=c:/obiee11g/user_projects/domains/bi
foundation_domain/config/fmwconfig/jps-config.xml}
Starting upgrade of opss configuration and security stores.
WLS ManagedService is not up running. Fall back to use system properties for con
figuration.
23-Apr-2013 14:28:05 oracle.security.jps.wls.JpsWlsPlatformFactory$2 run
WARNING: Cannot get server log directory. Reason: Cannot get audit log path by e
nvironment setting..
23-Apr-2013 14:28:07 oracle.security.jps.wls.JpsWlsPlatformFactory$2 run
WARNING: Cannot get server log directory. Reason: Cannot get audit log path by e
nvironment setting..
23-Apr-2013 14:28:07 oracle.security.jps.internal.tools.utility.JpsUtilMigration
AuditStoreImpl migrateAuditStoreData
INFO: Migration of Audit Store data in progress.....
23-Apr-2013 14:28:07 oracle.security.jps.internal.tools.utility.JpsUtilMigration
AuditStoreImpl migrateAuditStoreData
INFO: Migration of Audit Store data completed, Time taken for migration is 00:00
:00
23-Apr-2013 14:28:08 oracle.security.jps.internal.tools.utility.destination.apib
ased.JpsDstPolicy <init>
WARNING: No identity store associated with policy store found.
23-Apr-2013 14:28:09 oracle.security.jps.internal.tools.utility.destination.apib
ased.JpsDstPolicy migrateDataInternal
INFO: Migration of Admin Role Members started
23-Apr-2013 14:28:09 oracle.security.jps.internal.tools.utility.destination.apib
ased.JpsDstPolicy migrateDataInternal
INFO: Migration of Admin Role Members completed in 00:00:00
Upgrade of opss configuration and security stores is done.
wls:/offline>

3. Upgrade the catalog.

edit the instancecofig.xml
and replace the "false" with "true" in the upgradeandexit tag.


cd C:\oracle\Middleware\instances\instance1\bin\

opmnctl startproc ias-component=coreapplication_obips1

then set the instanceconfig.xml back to "false"

opmnctl stopproc ias-component=coreapplication_obips1

4. Start node manager, adminserver, managed server and OPMN.

Manually Enabling BI Composer after Upgrade

This is a two step process:

Firstly you need to extend the Weblogic Domain

1. Shutdown all services - Node manager, Adminserver, Managed Server and OPMN.
2. Start the Configuration Wizard for Weblogic (in the Tools Menu)
3. On the initial scree select Extend an Existing Domain.
4. Next, select the location of your existing domain (bifoundation)
5. On the Select Extension Source screen, select Extend my domain using an existing extension template and enter the location of the oracle.bicomposer_template_11.1.1.jar file.
Usually in ORACLE_HOME/common/templates/applications/oracle.bicomposer_template_11.1.1.jar
6. Continue with the remainder of the Configuration Wizard screens to apply this template.
7. After the template is applied, restart all Oracle Instances, the Administration Server, Managed Servers, and Node Manager.

Secondly - Manually Enable BI Composer:

If you run the Configuration Assistant or the Configuration Wizard, then that program installs the files that are required for BI Composer. Before users can run BI Composer, you must manually enable BI Composer using an MBean.

Start enterprise manager http://yourserver:7001/em

To manually enable BI Composer:

Display the Fusion Middleware Control MBean Browser and lock the domain.

Navigate to the following folder:

Application Defined MBeans,
oracle.biee.admin,
Domain:bifoundation_domain,
BIDomain.BIInstance.PresentationConfiguration

Locate the following MBean:

oracle.biee.admin:type=BIDomain.BIInstance.PresentationConfiguration,biInstance=coreapplication,group=Service

Set the value of the BIComposerEnabled attribute to "true".

Commit the changes and restart the system.

To use Composer as your report creator.

1. Login as normal to OBIEE analytics.
2. Select "My Account"
3. In more recent versions of OBIEE fill in the Wizard radio button in the Analysis Editor section. In older versions of OBIEE you change the Accessibility Mode to ON.

Now when you create a new analysis you will build your "answers" in BI Composer.

OBIEE 11.1.1.7 Upgrade

I have just upgraded a test server from OBIEE 11.1.1.6.2 BP1 to the latest and greatest version 11.1.1.7

After past experiences of upgrade I was half expecting to have no nails left and be pulling my hair out, but this time it went right.

Note: If you are running a simple install, ie. everything runs from port 7001, this whole process will not work for you, and at some stage in the next week or two I'll document exactly what you have to do.

This is for the Enterprise Install only.

Software Only Installer

1. Shut down all BI processes, OPMN and node manager.
2. Run the installer and choose Software only install.
    The installer will do a few checks.
    Find the default middleware home
    Find the weblogic install
    and finally start the install.

So that is fairly painless and in about 20 minutes or so you have updated binaries.

Patch Set Assistant

1. Navigate to {middleware home}/oracle_common/bin directory

2. Run psa.bat
3. Select the component to upgrade. (Oracle Business Intelligence)
4. Then, much like most of the GUI installers, fill in the connection details of the MDS and BIPLATFORM schemas.

5. Once you verify you have backed up and are running an appropriate version of the database

6. You are asked to upgrade.

Start Weblogic

Now start the Node Manager Service 

and, navigate to {middleware_home}\user_projects\domains\bifoundation_domain\bin

and run startWebLogic.cmd

When the server is in the running state

Configuration Assistant

1. Start the configuration assistant

   {middleware_home}\Oracle_BI1\bin and run config.bat

2. Select the upgrade option

3. Fill in the details to connect to the admin server (usually 7001)

4. And off it goes.

The configuration assistant will do stopping and starting of all the appropriate services at various times and leave you with a updated OBIEE 11.1.1.7 

Compared to the previous updates this was easy, but be warned, updating a simple install means that you have to do all the steps covered by the configuration assistant manually.

I'm just getting to grips with the new features and visualisations, and hope to bring you more over the coming weeks.

Update
Here are the manual steps for upgrading a simple install. Please keep me informed of any issues you encounter.

OBIEE Patch 11.1.1.6.2 BP1

This patchset went in a lot easier than the patch to 11.1.1.6.2.

Opatch threw a couple of warnings, mainly to do with having to 'unpatch' the previous patch before applying the current patch.

Here's a list of patch numbers.

14223977 Patch 11.1.1.6.2 BP1 (1 of 7) Oracle Business Intelligence Installer
14226980 Patch 11.1.1.6.2 BP1 (2 of 7) Oracle Real Time Decisions
13960955 Patch 11.1.1.6.2 BP1 (3 of 7) Oracle Business Intelligence Publisher
14226993 Patch 11.1.1.6.2 BP1 (4 of 7) Oracle Business Intelligence ADF Components
14228505 Patch 11.1.1.6.2 BP1 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
13867143 Patch 11.1.1.6.2 BP1 (6 of 7) Oracle Business Intelligence
14142868 Patch 11.1.1.6.2 BP1 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer and
13952743 JDeveloper

Patching 11.1.1.6 to 11.1.1.6.2

The patch for upgrading to 11.1.1.6.2 is available. Details here.

Pretty much a straightforward upgrade, though a few things to watch out for:
1. Set your environment variables correctly

       set ORACLE_HOME=C:\mwhome\Oracle_BI1
       set PATH=%ORACLE_HOME%\bin;%PATH%
       set JAVA_HOME=%ORACLE_HOME%\jdk
       set PATH=%JAVA_HOME%\bin;%PATH%
       set PATH=%ORACLE_HOME%\OPatch;%PATH%

2. Make sure you run opatch from the correct directory

Open a command window (with the correct environment variables set - see 1) in the Oracle_BI1 directory.

3. When you come to Part 2. JDeveloper patch 13952743

Unpack the patch into oracle_common.
Change directory to oracle_common
Using the environment variables set in step 1 run

opatch apply 13952743 -OH C:\mwhome\oracle_common

This will patch the oracle_common directory, otherwise the patch reports nothing to upgrade.

11.1.1.6 Released

Just when you lifted your head after getting 11.1.1.5 working after upgrading from 11.1.1.3, along comes OBIEE 11.1.1.6 - released 22 Feb.

Looks like a bunch of goodies under the hood and I'll let you know what I find, but until then check out what some of the other commentators have to say:

http://www.rittmanmead.com/2012/02/obiee-11-1-1-6-now-available-for-download-release-highlights/

http://www.peakindicators.com/index.php/knowledge-base/110-new-features-with-obiee-11116

time for an upgrade?

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.