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.