BI Publisher upgrade from 10.1.3.4.0 to Ver 10.1.3.4.1

This i  did long ago, thought of sharing it.

Link to BI publisher documents: http://download.oracle.com/docs/cd/E12844_01/welcome.html

Patch to be applied: 10023449

BI PUB note 797057.1

Pre-Patch steps:

1.Cold backup of Middle Tier.

2. Shutdown the application servers and backup the directory,

<ORACLE_HOME>/j2ee/home/

 cp –R home home_bkp 

3.startup the services.

Steps to upgrade

Upgrade
from 10.1.3.4.0d (patch 8284524, 8398280) and 10.1.3.4.1 does not require step
8 and step 9.

1- Make a backup copy of the xmlp-server-config.xml file located in

<application installation>/WEB-INF/ directory, where your application server unpacked the BI Publisher war or ear file.




    Example:

    In an Oracle AS/OC4J 10.1.3 deployment, the location is

<ORACLE_HOME>/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/xmlp-server-config.xml

Note: Make sure the backup xml is outside the <ORACLE_HOME>/j2ee/home

2- Back up all the directories under the BI Publisher repository

    (for example: {Oracle_Home}/xmlp/XMLP).

 3.- If you are using Scheduling, back up your existing BI Publisher Scheduler

schema.

Take an export of BI schema(differs from customer to customer) and hotbackup of database.

4- Shut down BI Publisher.

Cd $ORACLE_HOME/j2ee/home



java -jar admin_client.jar deployer:oc4j:opmn://hostname:<request port>/home
oc4jadmin simple4u -stop xmlpserver

EG:  java -jar admin_client.jar
deployer:oc4j:opmn://hostname:10522/home oc4jadmin *** -stop xmlpserver

10/10/23
00:53:32 Notification ==>Stopping manageable object:
oc4j:j2eeType=J2EEApplication,name=xmlpserver,J2EEServer=standalone

10/10/23
00:53:32 Notification ==>Stop completed for state manageable object:
oc4j:j2eeType=J2EEApplication,name=xmlpserver,J2EEServer=standalone



5- Undeploy the BI Publisher application ("xmlpserver") from your J2EE
application server. 



EG: java
-jar admin_client.jar deployer:oc4j:opmn://hostname:10522/home oc4jadmin****
-undeploy xmlpserver

10/10/23

01:11:54 Notification ==>Application UnDeployer for xmlpserver STARTS.

10/10/23
01:11:55 Notification ==>Removing all web binding(s) for application
xmlpserver from all web site(s)

10/10/23
01:12:00 Notification ==>Application UnDeployer for xmlpserver COMPLETES.

 Delete the xmlpserver directory else the deployment fails in next step.



6- Deploy the 10.1.3.4 xmlpserver.ear or xmlpserver.war to your application

server. 

EG: java -jar

admin_client.jar deployer:oc4j:opmn://hostname:10522/home oc4jadmin ****
-deploy -file /u01/patches/oc4j/xmlpserver.ear -deploymentName xmlpserver
-bindAllWebApps

  java -jar admin_client.jar

deployer:oc4j:opmn://hostname:10522/home oc4jadmin ***** -deploy -file /u01/patches/oc4j/xmlpserver.ear -deploymentName xmlpserver -bindAllWebApps

10/10/23
02:47:50 Notification ==>Application Deployer for xmlpserver STARTS.

10/10/23
02:47:50 Notification ==>Copy the archive to /u01/product/asmt_10131/j2ee/home/applications/xmlpserver.ear

10/10/23
02:47:51 Notification ==>Initialize /u01/product/asmt_10131/j2ee/home/applications/xmlpserver.ear
begins...

10/10/23
02:47:51 Notification ==>Unpacking xmlpserver.ear

10/10/23
02:47:55 Notification ==>Done unpacking xmlpserver.ear

10/10/23
02:47:55 Notification ==>Unpacking xmlpserver.war

10/10/23
02:48:13 Notification ==>Done unpacking xmlpserver.war

10/10/23
02:48:13 Notification ==>Initialize /u01/product/asmt_10131/j2ee/home/applications/xmlpserver.ear
ends...

10/10/23
02:48:13 Notification ==>Starting application : xmlpserver

10/10/23
02:48:13 Notification ==>Initializing ClassLoader(s)

10/10/23
02:48:13 Notification ==>Initializing EJB container

10/10/23
02:48:13 Notification ==>Loading connector(s)

10/10/23
02:48:13 Notification ==>Starting up resource adapters

10/10/23
02:48:13 Notification ==>Initializing EJB sessions

10/10/23
02:48:13 Notification ==>Committing ClassLoader(s)

10/10/23

02:48:13 Notification ==>Initialize xmlpserver begins...

10/10/23
02:48:13 Notification ==>Initialize xmlpserver ends...

10/10/23
02:48:13 Notification ==>Started application : xmlpserver

10/10/23
02:48:13 Notification ==>Binding web application(s) to site default-web-site
begins...

10/10/23
02:48:13 Notification ==>Binding xmlpserver web-module for application xmlpserver
to site default-web-site under context root xmlpserver

10/10/23
02:48:14 Notification ==>Initializing Servlet:
oracle.apps.xdo.service.report.ReportTemplateService for web application
xmlpserver

10/10/23
02:48:14 Notification ==>Initializing Servlet:
oracle.apps.xdo.servlet.XDOServlet for web application xmlpservr

10/10/23
02:48:15 Notification ==>Initializing Servlet:
oracle.apps.xdo.servlet.scheduler.quartz.ExtendedQuartzInitializerServlet for
web application xmlpserver



7- Copy the saved backup copy of the xmlp-server-config.xml file from step 1 to
the newly created BI Publisher 

<application
installation>/WEB-INF/ directory, where your application server unpacked the
BI Publisher war or ear file.

Example:

    In an Oracle AS/OC4J 10.1.3 deployment, the location is

  <ORACLE_HOME>/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/xmlp-server-config.xml





8- Copy ssodefaults.xml to the following directory. And replace [host]:[port]

with your server's information. 

Default values for other properties can be updated depending on your configuration.

   <ExistingRepository>\XMLP\Admin\Security



9- Copy database-config.xml to the following directory.

     <ExistingRepository>\XMLP\Admin\Scheduler

10- Restart xmlpserver application or Application Server

Optional configuration:

If you use JNDI for Scheduler, update the following line in
{Oracle_Home}/xmlp/XMLP/Admin/Scheduler/quartz-config.properties.

OLD:

org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.oracle.OracleDelegate




NEW:

org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate

Restart xmlpserver and reconfigure Scheduler with JNDI connection.





11.Restart the oc4j container.



NOTE:

Make sure the customer is aware that you are redeploying the BI publisher, so some possible customization might be lost.

IPM 10g migration issue!

We have been working on a project to migrate IPM 10g to 11g.For moing to 11g we need to install the Migration tool MCU .This can be installed on 10.1.3.6 IPM.So we upgraded it first which is simple process and applied the MCU patch .After that when we try to migrate we get

Issue:
Method not found: 'Int32 Stellent.IBPM.Interop.Imaging.DocTk.ISubDocument.get_ObjectId()'
As usual it was something new so we worked with support which has some amazing people.

Finally this they asked us to reapply the MCU patch 15868093 .This did not help.

Finally found that ,

Solution:

On the box where you are trying to use the migration tool :

--  You will need to replace the existing Internal.IBPM.Interop.Imaging.DocTk.DLL file
in the c:\Windows\Assembly folder (GAC) with the new one in the migration tool patch
"p16933027_10136_WINNT.zip":

Navigate to c:\windows\assembly and locate the file Internal.IBPM.Interop.Imaging.DocTk.DLL.
Right-click on this file and select "Uninstall".

===============================================================================
Drag and drop the new Internal.IBPM.Interop.Imaging.DocTk.DLL.

from the patch path : Oracle Imaging and Process Management\Imaging and Process Management\DSMS\
into the c:\windows\assembly

NOTE: You will need to drag and drop into the actual content window pane of c:\windows\assembly,
as this is how interops are registered in Windows. This is best accomplished by opening two explorer
windows to do the drag.

Drag from the patch zip file path
----  Oracle Imaging and Process Management\Imaging and Process Management\DSMS\Internal.IBPM.Interop.Imaging.DocTk.DLL

Then drop the file into the right-hand window pane of c:\windows\assembly.
=================================================================================


Restart your service(s)


This fixed the issue and now we are ready to setup 11g to kick start the migration.

The files created in the ODI servers with OS users are having the permission -rw-r-----

We recently got an issues where implementer said that when he created files from ODI agent ,he got issues like file had -rw-r-----(640) permission only .We checked that at OS level teh usmask was set to 022.But we were wondering then from where was agent picking up the umask value.It seems like the umask is explicitly set on startWebLogic.sh and startNodeManager.sh .We need to fix this to fix the issue.


-bash-3.2$ grep umask startWebLogic.sh
umask 037

-bash-3.2$ grep umask startNodeManager.sh

umask 027

So we need to change umask to 022 in both locations and restart services to fix the issues.Same goes with weblogic log file permissions.

WebCenter Custom Portal domain extension ,Custom Portal Component Schemas Are Not Displayed

We were today extending a webcenter customer's domain as they wanted a custom portal to deploy their portal application.While were following Doc ID 1339004.1 to do the same.We found that we couldn't proceed to 

Configure JDBC Component Schema screen

We found that its a known issue as per Doc ID 1527347.1

Also if you don't find this screen, just click next twice and voila you get the screen.

Cannot Start OIM After Applying WLS PSU patches

Issue:Unable to start OIM after patch application.

=====================================================

To see the stack trace for thread that is initializing this, set the logging level of oracle.adf.share.ADFContext to FINEST>
<Mar 22, 2013 1:49:51 AM CDT> <Error> <Deployer> <BEA-149205> <Failed to initialize the application 'oim [Version=11.1.1.3.0]' due to error java.security.AccessControlException: access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=oim,keyName=OIMSchemaPassword read).
java.security.AccessControlException: access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=oim,keyName=OIMSchemaPassword read)
        at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
        at java.security.AccessController.checkPermission(AccessController.java:546)
        at oracle.security.jps.util.JpsAuth$AuthorizationMechanism$3.checkPermission(JpsAuth.java:436)
        at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:496)
        at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:519)
        Truncated. see log file for complete stacktrace
Caused By: java.security.AccessControlException: access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=oim,keyName=OIMSchemaPassword read)
        at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
        at java.security.AccessController.checkPermission(AccessController.java:546)
        at oracle.security.jps.util.JpsAuth$AuthorizationMechanism$3.checkPermission(JpsAuth.java:436)
        at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:496)
        at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:519)
        Truncated. see log file for complete stacktrace

Patch applied:

--------------

Patch 14736140: 10.3.5.0.6 Patch Set Update (PSU) for WebLogic Server 10.3.5.0

Found couple of notes on oracle to fix this, but they referred to different patches and versions of OIM.This is how i fixed it.

Solution:

=========

1. Stop the servers


2. On each node (if is cluster), add the following in DOMAIN_HOME/config/fmwconfig/system-jazn-data.xml:


<grant>
  <grantee>
    <codesource>
      <url>file:${wls.home}/../../patch_wls1035/patch_jars/*</url>
    </codesource>
  </grantee>
  <permissions>
    <permission>
      <class>oracle.security.jps.service.credstore.CredentialAccessPermission</class>
     <name>context=SYSTEM,mapName=oim,keyName=*</name>
     <actions>read,write</actions>
    </permission>
   </permissions>
</grant>

3.From the below location

Oracle_home/wlserver_10.3/server/lib

in the file weblogic.policy

add the below lines

grant codeBase "file:/patch_wls1035/patch_jars/*" {
  permission java.security.AllPermission;
};

Its best to add full path in step 3, as above didnot work for me and after making it absolute path,OIM started up.
(grant codeBase "file:<MW_HOME>/patch_wls1035/patch_jars/*")

4.Start the servers.