SOA 11g upgrade notes

Recently we have upgraded from SOA 10g to SOA 11g and during the process I have referred below notes, blogs, forum posts etc. Thought that this might be useful.

1. Get weblogic version:
$ . setDomainEnv.sh
$ java weblogic.version -verbose
ps -ef | grep java | grep "jdk1.6.0_33"

Weblogic:
1. http://blog.ipnweb.com/2011/01/weblogic-admin-server-11g-just-hangs.html

2. http://biemond.blogspot.in/2011/07/change-log-files-location-of-weblogic.html

3. http://ofmdeveloper.blogspot.com/2012/03/default-charset-iso-8859-1-is-not.html
  LANG and LC_ALL environment variables to a locale with the UTF-8

4. http://georgie-soablog.blogspot.com/2011/09/weblogicclassloading-and-classloader.html
  http://host:port/wls-cat/ -> WL_HOME/server/lib/wls-cat.war
5. http://blog.ipnweb.com/2012/05/joc-058-joc-043-and-joc-823-when.html
  Configure JOC 1422223.1 Run configure-joc.py

6. Tuning WebLogic Integration to avoid OOM errors (OutOfMemoryErrors) [ID 1122743.1]
  Tuning the WLI Worklist EJB's, -Dcom.bea.wli.dispatcher.cacheSize=1

7. JAVA_OPTIONS="${JAVA_OPTIONS} -verbose:gc -Xverboselog:/tmp/gc.log -Xverbose:memory"
  export JAVA_OPTIONS

8. -Dweblogic.ProductionModeEnabled=true OR 
  PRODUCTION_MODE variable in the setDomainEnv.sh

9. Enable Native IO for Muxer. Default selection but check. <Info> <Socket> <BEA-000446> <Native IO Enabled.>

10. Debug port set DEBUG_PORT=XXXX for development environment

11. How To Change Type or Version of JDK (Sun / JRockit) for a Given FMW 11g Domain [ID 1058804.1]

12. Oracle document ID 827438.1 "How to rotate .out ( stdout) log file in weblogic 9.2 (solaris/linux)" 

13. How to Timeout Weblogic Webservice Client [ID 1056121.1]

Performance:
1. Disabling Instance and Fault Count Metrics Retrieval with the System MBean Browser
2. Work Managers:
  domain.xml
   <self-tuning-thread-pool-size-min>100</self-tuning-thread-pool-size-min>
   <self-tuning-thread-pool-size-max>200</self-tuning-thread-pool-size-max>
  Adding an option to command line -Dweblogic.threadpool.MinPoolSize=100

3. Configuring the Storage of Multiple Audit Trail Messages in One Transaction http://docs.oracle.com/cd/E23943_01/admin.1111/e10226/bp_mang.htm#BABIDCFJ
  More BPEL Configuration Properties -> AsynchAuditBatchSize -> Change it from -1 to some positive int value.

4. http://wladocsbypani.blogspot.com/
  WL capacity planning

5. NOTE:979683.1 - How to Set a Timeout for a Web Service in SOA 11g ?

6. JVM Memory Monitoring, Tuning, Garbage Collection, Out of Memory, and Heap Dump Analysis For SOA Suite Integration 11g [ID 1358719.1]

7. Performance Tuning and Troubleshooting for SOA Suite Integration 11g [ID 1366419.1]

8. How To Do Basic JVM Performance Troubleshooting in Fusion Applications [ID 1374439.1]

9. Exalogic - How To Enable Exalogic Optimizations For WebLogic Server Running On Exalogic Machine [ID 1373571.1]

-XX:+UseConcMarkSweepGC -XX:+PrintGC -XX:+PrintGCDetails  -XX:+PrintGCDateStamps -Xloggc:/home/bpate16/gc.log -verbose:gc -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -XX:CMSInitiatingOccupancyFraction=70 -XX:+UseCMSInitiatingOccupancyOnly -XX:CMSIncrementalSafetyFactor=10
Troubleshooting Guide for High CPU Condition When Using JRockit JDK on Linux [ID 1134051.1]

ps -Le -o pid,user,s,lwp,pcpu | grep <WebLogic PID>

Threads and Work Managers:

1. WebLogic Server: How to Specify Self-Tuning Thread Pool Values [ID 1346882.1]

2. http://www.munzandmore.com/2010/ora/weblogic-11g-overload-protection-in-the-cloud
  -Dweblogic.threadpool.MaxPoolSize=500

MDS:
1. http://blog.ipnweb.com/2011/01/mds-01330-unable-to-load-mds.html

2. http://blog.ipnweb.com/2010/12/create-read-only-database-account-to.html

Mediator:


1. http://blog.ipnweb.com/2010/10/migrating-dynamic-lookups-from-esb-10g_18.html
mhdr:setProperty

Adapters:

1. http://blog.ipnweb.com/2010/12/remove-aq-adapter-and-addcreate-jms.html

2. http://docs.oracle.com/cd/E23943_01/admin.1111/e10226/bc_config.htm#CEGFAEFJ
  UseWorkManager inbound JCA property

3. Restarting the SOA Infrastructure Does Not Activate Endpoints When a Retired Composite is Activated

4. http://thesoaman.blogspot.com/2012/02/configure-adapter-threads-in-oracle-soa.html

5. Casting AQ$QUEUE_TABLE Enqueue and Dequeue Time Values To SESSIONTIMEZONE causes Reporting and Message Processing issues [ID 429681.1]

6. http://technology.amis.nl/2009/08/19/configure-soa-suite-11g-for-sending-email-notifications-with-google-mail/

JMS:

1. http://docs.oracle.com/cd/E13222_01/wls/docs90/config_wls/store.html

JDK:

http://orasoa.blogspot.com/2012/02/major-memory-en-cpu-improvement-on-ofm.html

JDBC:
1. http://www.sugihartono.com/middleware/weblogic/optimize-and-tuning-weblogic-server-performance-tuning-jdbc-data-source-connection-pool/
  Minimizing Server Startup Hang Caused By an Unresponsive Database: WebLogic Server includes the JDBCLoginTimeoutSeconds attribute on the ServerMBean. 
 
2. http://m-button.blogspot.in/2008/07/how-to-read-weblogic-tlog-files.html
  java weblogic.transaction.internal.TransactionLoggerImpl myserver

3. https://forums.oracle.com/forums/thread.jspa?threadID=2262103
  Propagate Weblogic ECID to Oracle Database V$SESSION.ECID 

4. Oracle.Jdbc.Driver.T4cconnection And Oracle.Jdbc.Driver.T4cpreparedstatement Building Up Memory Causing java.lang.OutOfMemoryError in B2B Application [ID 1414025.1]
-Doracle.jdbc.freeMemoryOnEnterImplicitCache=true

Coding common:

1. Prefer the local classes in the web application or web service
weblogic.xml <prefer-web-inf-classes>true</prefer-web-inf-classes>

Spring:

Master Note on Troubleshooting Spring Framework Integration with Oracle WebLogic Server [ID 1342706.1]

WLST:
http://middlewaremagic.com/weblogic/?page_id=1492

SSL:

http://jvzoggel.wordpress.com/2011/12/16/configuring-ssl-for-oracle-weblogic-and-ofmw/

Security:

Make a backup copy of the SerializedSystemIni.dat file and put it in a safe location.
Set permissions on the SerializedSystemIni.dat file such that the system administrator of a WebLogic Server deployment has write and read privileges and no other users have any privileges.

How to Convert A PEM Formatted x509 Certificatea to PKCS12 Format [ID 1006716.1]

EM Console:

http://albinoraclesoa.blogspot.com/2012/06/enable-discovery-cache-to-avoid-long.html?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+albinoraclesoablogspot%2FOracleSOA+%28Albin%27s+Oracle+SOA+Blog%29
 System MBean Browser -> emoms.props:Location=AdminServer,name=emoms.properties,type=Properties,Application=em -> oracle.sysman.emas.discovery.wls.FMW_DISCOVERY_USE_CACHED_RESULTS=true

Enqueue/Dequeue:
http://www.orafaq.com/forum/t/183049/0/

Database:
Purging ORASDPM Schema On SOA 11g [ID 1287036.1]

How to Purge Active Instances ("Running" / "Recovery Needed" State) in SOA 11g [ID 1400612.1]

How To Purge Oracle SOA Suite 11g Composites Instances Using Purge Scripts [ID 1332337.1]

SQL> grant alter session to <orabpel user>
Alter session set max_dump_file_size=unlimited;
Alter session set events '10046 trace name context forever, level 12';
tkprof <trace file> <output file name> waits=yes sys=no aggregate=no

10g / 11g SOA composite <schema> States [ID 1362028.1]

SOA 11g: Running Purge Scripts -> A Step by Step Approach [ID 1345957.1]

ALTER TABLE CUBE_SCOPE enable row movement;
ALTER TABLE CUBE_SCOPE shrink space;
ALTER TABLE CUBE_SCOPE disable row movement;
ALTER INDEX XX_XX rebuild online;

FOR LOBs:
ALTER TABLE XML_DOCUMENT MODIFY lob (DOCUMENT) (shrinkspace);

Exalogic:
1. Tuning Socket Buffer Size for VM:
sysctl -w net.core.rmem_max=4192608
sysctl -w net.core.wmem_max=4192608

Monitoring:

https://blogs.oracle.com/jamesbayer/entry/weblogic_notifications_watch_t
http://neelimabawa.blogspot.com/2011/08/how-to-configured-mail-alerts-in-oem.html