Download
* Download Download patchset number 8626084 from Metalink.
* Unzip into a temp directory.
* See 'readme.html' for detailed upgrade instructions.
* Steps documented here are for upgrade a fresh install of 10.3.1.x. If not a fresh install, see 'readme.xml' for extract steps to upgrade applications.
Upgrade Oracle DB
From 10.1.3.1
Upgrade orabpel schema
cd Disk1\install\soa_schema_upgrade\bpel\scripts
sqlplus /nolog
connect orabpel/welcome1
@upgrade_10131_10135_oracle.sql
Upgrade oraesb schema
cd Disk1\install\soa_schema_upgrade\esb\sql\other
sqlplus /nolog
connect oraesb/welcome1
@upgrade_10131_10135_oracle.sql
*Restart Oracle DB instance.
From 10.1.3.3
Upgrade orabpel schema
cd Disk1\install\soa_schema_upgrade\bpel\scripts
sqlplus /nolog
connect orabpel/welcome1
@upgrade_10133_10135_oracle.sql
Upgrade oraesb schema
cd Disk1\install\soa_schema_upgrade\esb\sql\other
sqlplus /nolog
connect oraesb/welcome1
@upgrade_10133_10135_oracle.sql
* Restart Oracle DB instance.
* If oraesb schema is not updated, you'll get following error message when you try to deploy ESB application:
Entity Deployment Failederror code: 1001 : 5 summary: Failed to create Service "ESBService". Fix: Ensure that the (a) Repository is available. (b) The Connection information for the Repository is Valid. Verify the detailed cause of error if available. Contact Oracle Support if error not fixable.
See this post for more details.
Upgrade to 10.1.3.5
Backup 10.1.3.x
* Backup(zip) original install.
Undeploy EJB3.0 Applications
* Login AS
* Got to: Cluster Topology -> default_group -> home -> Applications -> EJB3.0 application
* Click undeploy
Check owsm install properties
* Ensure the following values are set in the ORACLE_HOME/owsm/bin/install.properties file:
install.http.host=hostname
install.http.port=7777
* Note, I left mime as
install.http.host=myhost.my.com
install.http.port=80
Check OC4J instances are running
ORACLE_HOME/opmn/bin/opmnctl status
Processes in Instance: soaas.myhost.my.com
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
ASG | ASG | N/A | Down
OC4JGroup:default_group | OC4J:oc4j_soa | 592 | Alive
OC4JGroup:default_group | OC4J:home | 856 | Alive
HTTP_Server | HTTP_Server | 3616 | Alive
Start Oracle Installer
* Double click 'Disk1\setup.exe'
Specify File Locations
Destination
Name: oracleas1
Path: C:\product\10.1.3.1\OracleAS_2
Administrator (oc4jadmin) Password
oc4jadmin Password: welcome1
Specify Password for OWSM Schema
Hostname: localhost
Port: 1521
Service Name: orcl
ORAWSM password: welcome1
Post Installation
Enable PHP
* Enable PHP if not already done.
cd C:\product\10.1.3.1\OracleAS_2\Apache\Apache\conf
- Edit httpd.conf
# Comment out
#LoadModule php4_module modules/php4apache.dll
#AddModule mod_php4.c
# Add
LoadModule php5_module modules/php5apache.dll
AddModule mod_php5.c
# Add .php5
AddType application/x-httpd-php .php .php5
Change JDBC factoryClass in BPEL Connection Pool
* Edit C:\product\10.1.3.1\OracleAS_2\j2ee\oc4j_soa\config\data-sources.xml
* Change factory-class for "BPELPM_CONNECTION_POOL" from "oracle.jdbc.OracleDriver" to "oracle.jdbc.pool.OracleDataSource"
From:
<connection-pool name="BPELPM_CONNECTION_POOL">
<connection-factory factory-class="oracle.jdbc.OracleDriver" user="orabpel"/>
</connection-pool>
To:
<connection-pool name="BPELPM_CONNECTION_POOL">
<connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="orabpel"/>
</connection-pool>
* Restart SOA Instances
Deploy Your Enterprise Javabeans 3.0 Applications
* Redeploy EJB 3.0 applications.
Upgrade JDev to 10.1.3.5
* Don't forget to upgrade JDev to 10.1.3.5 as well.
Errors
archive cannot rename...
You could get the following error while trying to deploy your bpel application.
An error occurred while attempting to deploy the BPEL suitcase file "C:\product\10.1.3.1\OracleAS_2\bpel\domains\default\tmp\bpel_2516715.tmp"; the exception reported is: archive cannot rename C:\product\10.1.3.1\OracleAS_2\bpel\domains\default\tmp\.bpel_TestProcessor_1.0_f0df3b440d722780bb2c1a088b1d2ba2.tmp
Manually Remove Temp Directory
* Manually undeploy your bpel application using the BPEL console,
* Manually remove bpel\domains\default\tmp directory,
* Redeploy.
Use Windows Process Unlocker
* Download unlocker.
* Install unlocker.
* Navigate to bpel\domains\default\tmp directory.
* Right click locked .tmp file
* Unlock it.
* Redeploy.
See this post for details and other options.
Filed under: bpms, esb, oc4j, oracle | |Comments off
Integrate with ldap
* Edit conf/umacl.conf
userMgr.external=false
ldap.server.provider=MSActive
ldap.server.location=ldap://my.com:3268
ldap.ssl=false
ldap.user.name=me
ldap.user.password=pass
ldap.user.search.root=DC=my,DC=com
ldap.group.search.root=
Filed under: Uncategorized, bpms | |No Comments
Prepare DB
Create Tablespace
CREATE TABLESPACE EBMS_USER_DATA
DATAFILE '/oradata/EBMS_USER_DATA.ORA' SIZE 256M
DEFAULT STORAGE
(
INITIAL 16K
NEXT 16K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 50
)
ONLINE;
CREATE TEMPORARY TABLESPACE EBMS_TEMPORARY_DATA
TEMPFILE '/oradata/EBMS_TEMPORARY_DATA.ORA' SIZE 64M
EXTENT MANAGEMENT LOCAL;
Create User
CREATE USER ebms
IDENTIFIED BY pass
DEFAULT TABLESPACE EBMS_USER_DATA;
GRANT create session, create table, create sequence, create view
To ebms;
ALTER USER ebms
QUOTA UNLIMITED ON EBMS_USER_DATA;
Install SBM75
Unzip Zip File
cd /opt/sw/soa
$JAVA_HOME/bin/jar xf SBM75130.zip
cd SBM75130
Start Install Wizard
chmod u+x Install.sh
./Install.sh
Install location: /opt/sw/SBM75
Host name: sbmhost
Domain name: my.com
Username: ebms
Password: pass
Embedded Application Server (Pramati 5.0 SP4)
Or
JBoss EAP 4.3
EJB Server JNDI Port: 18026
Portal Server Http Port: 18793
Remove Ant Port: 18000
Portal URL: http://sbmhost.my.com:18793
Outgoing email server: smtp.my.com
Administrator email: me@my.com
BizLogic email: me@my.com
User Management: BusinessManager JDBC Realm
Database: Oracle 10g
Server host name: db.my.com
Port: 1525
SID: orcl
Username: ebms
Password: pass
Summary
Install location: /opt/sw/SBM75
Features: BusinessManager, Documentation
Total size: 533.2 MB
Copy license file
Copy license.xml to $SBM_HOME/conf directory.
Setup SBM75
cd $SBM_HOME/bin
./firststeps.sh
OR
./setupSBM.sh -c all
Click Prepare Repository to setup repository database.
Start Servers
Add nohup and run as background processes to startup scripts
cd $SBM_HOME/pramati/server/bin
vi startEjbServer.sh
#For Pramati:
nohup $SBM_JVM $VM_ARGS -node ejbServer -noshell &
#For JBoss:
nohup $SBM_HOME/jboss/bin/jbossrun.sh -c ejbServer -b sbmhost.my.com &
vi startPortalServer.sh
VM_ARGS="${VM_ARGS} -Djava.awt.headless=true"
#For Pramati:
nohup $SBM_JVM $VM_ARGS -node portalServer -noshell &
#For JBoss:
nohup $SBM_HOME/jboss/bin/jbossrun.sh -c portalServer -b sbmhost.my.com &
cd $SBM_HOME/bin
vi startBizLogicServer.sh
#For Pramati:
elif [ $APPSERVER_TYPE = pramati ]; then
nohup $SBM_JVM -classpath $sbmcp com.savvion.sbm.bizlogic.client.BLMain -cmd start $* &
#For JBoss:
elif [ $APPSERVER_TYPE = jboss ]; then
#$SBM_JVM $VM_ARGS -classpath $sbmcp com.savvion.sbm.bizlogic.client.BLMain -cmd start $*
nohup $SBM_JVM $VM_ARGS -classpath $sbmcp com.savvion.sbm.bizlogic.client.BLMain -cmd start $* &
vi startBizPulseServer.sh
#For Pramati:
elif [ "${APPSERVER_TYPE}" = "pramati" ]; then
nohup $SBM_JVM -DCommand.ScriptName=startBizPulseServer.sh -classpath $sbmcp com.savvion.ejb.bizpulse.manager.BizPulseClient -start &
#For JBoss:
elif [ "${APPSERVER_TYPE}" = "jboss" ]; then #$SBM_JVM $VM_ARGS -classpath $sbmcp com.savvion.ejb.bizpulse.manager.BizPulseClient -start
nohup $SBM_JVM $VM_ARGS -classpath $sbmcp com.savvion.ejb.bizpulse.manager.BizPulseClient -start &
Run startup scripts in sequnce
# Start Pramati Servers
cd $SBM_HOME/pramati/server/bin
./startEjbServer.sh -noshell
./startPortalServer.sh -noshell
# Start JBoss Servers
cd $SBM_HOME/jboss/bin
./startEjbServer.sh
./startPortalServer.sh
# Start SBM
cd $SBM_HOME/bin
./startSBM.sh
Stop Servers
cd $SBM_HOME/bin
./stopSBM.sh
# Stop Pramati Servers
cd $SBM_HOME/pramati/server/bin
./stopserver.sh portalServer
./stopserver.sh ejbServer
# Stop Jboss Servers
cd $SBM_HOME/jboss/bin
./stopPortalServer.sh
./stopEjbServer.sh
Uninstall
cd $SBM_HOME/_uninst
./uninstall.bin
Update License
*Shutdown all servers.
*Copy license.xml to /conf directory.
# For Pramati:
*Copy license.key to /pramati/server directory.
*Delete /pramati/server/lf directory.
*Restart all servers.
Filed under: bpms | |Comments off
Install SBM/Pramati as NT Service
Install ejb server as nt service
SBM_HOME\pramati\services\jsw\j2eeserver\install_server_ejbServer.cmd
Install portal server as nt service
SBM_HOME\pramati\services\jsw\j2eeserver\install_server_portalServer.cmd
Install sbm as nt service
SBM_HOME\bin\instsrv sbmservice SBM_HOME\bin\srvany.exe
Edit sbmservice registry at HLM\SYSTEM > CurrentControlSet > Services > sbmservice.
Add value: DependOnService REG_MULTI_SZ PramatiServerejbServer
Add key: Parameters
Add values under new Parameters key:
Application REG_SZ C:\Windows\system32\cmd.exe
AppParameters REG_SZ /k C:\SBM75\bin\startSBM.cmd
AppDirectory REG_SZ C:\SBM75\bin
Modify SBM_HOME\bin\startSBM.bat
set SBM_HOME=C:\SBM75
set initialdelay=240
set retryinterval=10
call %SBM_HOME%\bin\setblclientenv.cmd
echo %SBM_JVM%
%SBM_JVM% -classpath %sbmcp% com.tdiinc.common.util.ServiceManager -i %initialdelay% -f %retryinterval% -appServer pramati
start call startBizLogicServer.cmd -u ebms -p ebms
start call startBizPulseServer.cmd
exit
Filed under: bpms | |No Comments