Oracle SOA/Tools/Middleware and Other Technology tips

Calibrating Panasonic TC-P65VT30

2012-01-24T03:37:00.001+05:30

This is the calibration I carried on my Plasma according to D-Nice seetings explained in http://www.highdefjunkies.com

D-Nice's panel prep is step 1, and is used primarily to evenly age phosphors to such a degree that that the calibration settings you'll apply in step 2 will get the most consistent results.

****UNDER NO CIRCUMSTANCE SHOULD THESE SETTINGS BE USED WITH ANY OTHER SOURCE MATERIAL BEYOND THE PANEL PREP USB/SD CARD FILES****
Recommended 100 Hour Panel Prep Settings for North American Panasonic TC-PxxST30/GT30/VT30 models (ONLY to be used with Evangelo2's USB/SD Card Files!!!!!!!!)
*****Note: This procedure is designed to prepare your display for the reference settings listed below by aging all pixels equally with the same content.

This procedure is NOT designed nor recommended to be used as Break-in, Image Retention and/or Burn-in prevention.*****

To begin, here is a spelled out guide for setup if you want to know exactly which buttons to press when doing the initial setup, credit to IanS @http://www.highdefjunkies.com:

i: Put the batteries in your remote, and hit the red 'power' button
This will take you through a couple of initial setup steps. Skipped everything you can, as you can revisit this in the menu after you have done the prep.
ii: Plug your USB stick, with the photos on it, into the side of the TV. If you used a Mac to put the photos on, see question 2.
iii: Press 'VIERA TOOLS' -> Media-Player -> Photos
This will show thumbnails of all the pictures on your USB stick
iv: Now, press 'MENU' on your remote
Choose 'Picture' -> go in and make all the settings from post #1 up to the 'Slideshow Settings'
This will apply the settings to the photos in your slideshow
When done press the 'RETURN' button on your remote
v: Now press the red rectangular button under the 'R' on your remote
vi: Set the 'Slideshow Settings' from post #1
vii: Choose the top menu item here and press it to 'start slideshow'
viii: wait for 4 days or 100 hours :

iX:Enter into SM menu or ProSettings in Remote and enter Post #2

(for VT30 models, you can enter them in remote itself directly choosing HDTV source like BluRay-for each HDMI input and then advanced picture settings ProSettings in menu)

Initial Break-in with Photo-Slides-100 hrs Post#1

Photo Settings
Picture Mode: Custom
Contrast: 100
Brightness: 50
Color: 70
Tint: 0
Sharpness: 50
Color Temp: Cool2
Photo Enhancement: Off
C.A.T.S: Off
Video NR: Off
Pro Settings
***Leave all settings in this menu at their default***
HDMI Settings
***Leave all settings in this menu at their default***
Advance Picture
Block NR: Off
Mosquito NR: Off
Motion Smoother: Off
Slideshow Settings
Frame: Off
Photo Effect: Off
Transition Effect: Off
Photo Size: Normal
Burst Playback: Off
Display Interval: Slow
Repeat Playback: On

Entering into ServiceMenu (SM)
2011 Models : _X3 / S30 / ST30 / GT30 / VT30
2010 Models : _X24 / C2 / U2 / S2 / G20 / G25 / GT20 / GT25 / VT20 / VT25

· Press and hold the {VOL -} button ON THE PLASMA TV.

· Then press the {INFO} button on the remote control 3 times.

· "Start Adjustment Menu" message will be displayed followed
by the Service Menu after few seconds.

· ADJUST {Picture Adjustment}

· WB-ADJUST {White Balance Adjustment}

· OPTION {Option Setting}

· V-SUS {V-SUS Adjustment}

· AGING

· SRV-TOOL {Service Tool}

{1} & {2} buttons move through options

Press the {2} button once to select "SRV-TOOL".

Then press the {OK} button to access it.

Using the cursor keys, highlight the right side
of the last item "PTCT :00.00.00.00.00" :

Then press and hold the {MUTE} button for 3 seconds.

Time and Count will be displayed in red color:

__TIME = Hours : Minutes of operation.
COUNT = Times the Plasma was powered on.

To exit, unplug the power cable.
WARNING BY BRUZZI: The {VOL+} and {VOL-} buttons are used
to change values while in the Service Menu. Make sure not to touch
those buttons when navigating menus / sub-menus.

EPROM Updated Post#2

EPROM Updated MJ Series North American TC-P65VT30 Reference Settings
*****Note: These settings are designed exclusively to be used on North American TC-P65VT30 displays after completing the Panel Prep procedure listed post #1.

Please do not use these settings unless you have follow post #1 entirely.*****

Picture
Picture Mode: Custom
Contrast: 72
Brightness: 55
Color: 36
Tint: 0
Sharpness: 0
Color Temp: Warm2
Photo Enhancement: Off
C.A.T.S: Off
Video NR: Off
Pro Settings
Colorspace: Normal
W/B High R: 0
W/B High G: 0
W/B High B: 0
W/B Low R: 0
W/B Low G: 0
W/B Low B: 0
10 Point W/B
10 W/B R: -10
10 W/B G: 0
10 W/B B: -14
20 W/B R: 5
20 W/B G: 0
20 W/B B: 18
30 W/B R: 3
30 W/B G: 0
30 W/B B: 7
40 W/B R: 6
40 W/B G: 0
40 W/B B: 13
50 W/B R: 5
50 W/B G: 0
50 W/B B: 18
60 W/B R: 7
60 W/B G: 0
60 W/B B: 8
70 W/B R: 2
70 W/B G: 0
70 W/B B: 7
80 W/B R: 6
80 W/B G: 0
80 W/B B: 15
90 W/B R: -1
90 W/B G: 0
90 W/B B: 6
100 W/B R: 3
100 W/B G: 0
100 W/B B: 9
10 Point Gamma
10 Gain: -50
20 Gain: -10
30 Gain: -3
40 Gain: -24
50 Gain: -26
60 Gain: -20
70 Gain: -24
80 Gain: -25
90 Gain: -5
100 Gain: 0
CMS
R-Hue: 3
R-Sat: -3
R-Lum: 50
G-Hue: 7
G-Sat: 14
G-Lum: -49
B-Hue: -13
B-Sat: 22
B-Lum: 49
Y-Hue: -24
Y-Sat: 5
Y-Lum: -19
C-Hue: 36
C-Sat: -14
C-Lum: -15
M-Hue: 16
M-Sat: 7
M-Lum: 15
Black Extension: 0
Gamma Adjustment: 2.2
Panel Brightness: Mid
Contour Emphasis: Off
AGC: 0
HDMI Settings
***Leave all settings in this menu at their default***
Advance Picture
Block NR: Off
Mosquito NR: Off
Motion Smoother: Off
Black Level: Light
3:2 PullDown: Auto

Reference:

http://www.highdefjunkies.com/showthread.php?9896-Official-Panasonic-TC-PXXVT30-Owner-s-Discussion

http://www.highdefjunkies.com/showthread.php?9134-2011-Panasonic-Settings-Issues-Thread

http://www.highdefjunkies.com/showthread.php?1772-The-Official-quot-How-to-Check-the-Hours-Used-on-Your-Plasma-quot-Thread

http://www.highdefjunkies.com/showthread.php?9134-2011-Panasonic-Settings-Issues-Thread&p=277581&viewfull=1#post277581

http://www.highdefjunkies.com/showthread.php?9631-2011-Panasonic-Fluctuating-Brightness-Master-Discussion-Thread&p=277047&viewfull=1#post277047

http://www.controlcal.com/forum/showthread.php?t=755

http://www.controlcal.com/forum/showthread.php?p=6281

http://www.valueelectronics.com/images/pdf/VE%202011%20shoot-out%20results.pdf

Common Issues faced in OEM 10gR5

2011-12-08T06:45:00.001+05:30

Disk FULL

Due to DBSNMP password expiry resulting in sysman log file full.

Set a separate PROFILE where password never expires or create a policy and make sure you update the configuration in OEM once password expires and changes.

Same filesystem is used by other Application which are writing huge log files or Core files

Make sure you use a separate mount point/partition for OEM Agent.

EMD upload error: XML error during upload in the sysman emagent.trc we can find ORAXML-217 invalid character 2 (U+0002)

Apply patch Apply Patch 9244383 and Patch 9404807 and increase timeout for metric upload.

Metric Upload failing due to Timeout

Cleared upload directory, Increase timeout UploadWaitTime=600 and UploadTimeout=3600 in emd.properties.

Wrong Status

SOA 10.1.3 was upgraded with patch to 10.1.3.5 Showing wrong status

need to re-discover components and Re-Synch agents and provide BPEL configuration credentials.
make sure CLASSPATH in emd.properties includes optic.jar and other JAR's from SOA Home as first entry.
Apply Patch 8993048
Follow ESBDT notification as mentioned in previous post.

NOTIFICATION for Middleware Application Server components including ESBDT in OEM 10gR5

2011-12-08T06:25:00.000+05:30

Issue: OEM 10gR5 sends critical alerts for OC4J_ESBDT down which is down in a cluster as it is Singleton.

Resolution :

1) Create a SYSTEM ALL_Middleware Including Oracle_HTTP_Server, oc4j ( Without ESBDT), WebLogic
    Add this to System Generated "Application Server Availability and Critical States" notification changing to
    "Apply rule to specified Oracle Application Server targets or groups containing Oracle Application Server targets"
    This notification handles all types of Application Server components other than oc4j_ESBDT which are to be set as singleton.

2) Remove Availability "DOWN" from "OC4J Availability and Critical States"

3) Create one System and one Generic Service for each ESBDT Cluster and choose option Define availability based on system
   and "At least one key component is up" option (Singleton) and choosing availability UP option.

4) Create new notification for ESBDT "OC4J_ESBDT_Down_Notification"
   Choose the all the ESBDT Genric Service created above for each cluster

Ref: BUG:8544644 GRID CONTROL DETECTS SOA ESB-DT CONTAINER DOWN in CLUSTER and SENDS ALARM

OMS server of EM GRID 11g JVM was crashing

2011-09-29T23:20:00.000+05:30

E-WL: WebLogic Crash With Error Message: Illegal memory access. [54] in JRockit Dump [ID 971488.1]

Increase the Thread Stack in following file:

/u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain/bin/startEMServer.sh

OLD

USER_MEM_ARGS="-Xms256m -Xmx512m -XX:MaxPermSize=512m"

if [ "${JAVA_VENDOR}" = "Sun" ] ; then

if [ "${PRODUCTION_MODE}" = "" ] ; then

USER_MEM_ARGS="-Xms256m -Xmx512m -XX:MaxPermSize=512m -XX:CompileThreshold=8000 -XX:PermSize=128m"

fi

NEW

USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m -Xss1024k"

if [ "${JAVA_VENDOR}" = "Sun" ] ; then

if [ "${PRODUCTION_MODE}" = "" ] ; then

USER_MEM_ARGS="-Xms2048m -Xmx2048m -XX:MaxPermSize=512m -XX:CompileThreshold=8000 -XX:PermSize=128m -Xss1024k"

fi

===== BEGIN DUMP =============================================================
JRockit dump produced after 0 days, 18:46:46 on Tue Jul 12 21:07:43 2011

    **********************************************************
    *  If you see this dump, please go to                    *
    *  http://edocs.bea.com/jrockit/go2troubleshooting.html  *
    *  for troubleshooting information.                      *
    **********************************************************

Additional information is available in:
  /u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain/jrockit.7054.dump
  /u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain/core or core.7054

Error Message: Illegal memory access. [54]
Signal info  : si_signo=11, si_code=1 si_addr=0x80
Version      : BEA JRockit(R) R27.6.5-32_o-121899-1.6.0_14-20091001-2106-solaris-sparcv9
CPU          : SPARC64-VI (portid 1024 impl 0x6 ver 0x93 clock 2150 MHz)
Number CPUs  : 16
Tot Phys Mem : 68719476736 (65536 MB)
OS version   : SunOS 5.10 Generic_142900-11 sun4u
Thread System: Solaris Threads
Java locking : Lazy unlocking enabled (class banning) (transfer banning)
State        : JVM is running
Command Line : -client -Xms256m -Xmx1024m -XX:MaxPermSize=512m -XX:CompileThreshold=8000 -XX:PermSize=128m -Dweblogic.Name=EMGC_OMS1 -Djava.security.policy=/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/lib/weblogic.policy -Dweblogic.system.BootIdentityFile=/u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain/servers/EMGC_OMS1/data/nodemanager/boot.properties -Dweblogic.nodemanager.ServiceEnabled=true -Dweblogic.security.SSL.ignoreHostnameVerification=true -Dweblogic.ReverseDNSAllowed=false -DINSTANCE_HOME=/u01/home/dba/oracle/product/middleware/oms11g/em/EMGC_OMS1 -DORACLE_HOME=/u01/home/dba/oracle/product/middleware/grid/oms11g -Ddomain.home=/u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain -Djava.awt.headless=true -Ddomain.name=GCDomain -Docm.repeater.home=/u01/home/dba/oracle/product/middleware/grid/oms11g -Djava.security.egd=file:///dev/urandom -Xverify:none -da -Dplatform.home=/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3 -Dwls.home=/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server -Dweblogic.home=/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server -Ddomain.home=/u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain -Dcommon.components.home=/u01/home/dba/oracle/product/middleware/grid/oracle_common -Djrf.version=11.1.1 -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Djrockit.optfile=/u01/home/dba/oracle/product/middleware/grid/oracle_common/modules/oracle.jrf_11.1.1/jrocket_optfile.txt -Doracle.domain.config.dir=/u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain/config/fmwconfig -Doracle.server.config.dir=/u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain/config/fmwconfig/servers/EMGC_OMS1 -Doracle.security.jps.config=/u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain/config/fmwconfig/jps-config.xml -Djava.protocol.handler.pkgs=oracle.mds.net.protocol -Digf.arisidbeans.carmlloc=/u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain/config/fmwconfig/carml -Digf.arisidstack.home=/u01/home/dba/oracle/product/middleware/oms11g/user_projects/domains/GCDomain/config/fmwconfig/arisidprovider -Dweblogic.alternateTypesDirectory=/u01/home/dba/oracle/product/middleware/grid/oracle_common/modules/oracle.ossoiap_11.1.1,/u01/home/dba/oracle/product/middleware/grid/oracle_common/modules/oracle.oamprovider_11.1.1 -Dweblogic.jdbc.remoteEnabled=false -Dweblogic.management.discover=false -Dweblogic.management.server=https://myhost.oracle.com:7101 -Dwlw.iterativeDev= -Dwlw.testConsole= -Dwlw.logErrorsToConsole= -Dweblogic.ext.dirs=/u01/home/dba/oracle/product/middleware/grid/patch_wls1032/profiles/default/sysext_manifest_classpath -Dsun.java.launcher=SUN_STANDARD weblogic.Server
java.home    : /u01/home/dba/oracle/product/middleware/jrmc-3.1.2-1.6.0/jre
j.class.path : /u01/home/dba/oracle/product/middleware/grid/patch_wls1032/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/u01/home/dba/oracle/product/middleware/jrmc-3.1.2-1.6.0/lib/tools.jar:/u01/home/dba/oracle/product/middleware/grid/utils/config/10.3/config-launch.jar:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/lib/weblogic_sp.jar:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/lib/weblogic.jar:/u01/home/dba/oracle/product/middleware/grid/modules/features/weblogic.server.modules_10.3.2.0.jar:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/lib/webservices.jar:/u01/home/dba/oracle/product/middleware/grid/modules/org.apache.ant_1.7.0/lib/ant-all.jar:/u01/home/dba/oracle/product/middleware/grid/modules/net.sf.antcontrib_1.0.0.0_1-0b2/lib/ant-contrib.jar:/u01/home/dba/oracle/product/middleware/grid/oracle_common/soa/modules/commons-cli-1.1.jar:/u01/home/dba/oracle/product/middleware/grid/oracle_common/soa/modules/oracle.soa.mgmt_11.1.1/soa-infra-mgmt.jar:/u01/home/dba/oracle/product/middleware/grid/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/common/eval/pointbase/lib/pbclient57.jar:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/lib/xqrl.jar:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/lib/weblogic_sp.jar:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/lib/weblogic.jar:/u01/home/dba/oracle/product/middleware/grid/modules/com.bea.core.apache.log4j_1.2.13.jar
j.lib.path   : /u01/home/dba/oracle/product/middleware/jrmc-3.1.2-1.6.0/jre/lib/sparcv9/jrockit:/u01/home/dba/oracle/product/middleware/jrmc-3.1.2-1.6.0/jre/lib/sparcv9:/u01/home/dba/oracle/product/middleware/jrmc-3.1.2-1.6.0/jre/../lib/sparcv9:/u01/home/dba/oracle/product/middleware/grid/patch_wls1032/profiles/default/native:/u01/home/dba/oracle/product/middleware/grid/oms11g/lib:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/native/solaris/sparc64:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/native/solaris/sparc64/oci920_8:/usr/lib
JAVA_HOME    : /u01/home/dba/oracle/product/middleware/jrmc-3.1.2-1.6.0
_JAVA_OPTIONS: 
LD_LIBRARY_PATH: /u01/home/dba/oracle/product/middleware/jrmc-3.1.2-1.6.0/jre/lib/sparcv9/jrockit:/u01/home/dba/oracle/product/middleware/jrmc-3.1.2-1.6.0/jre/lib/sparcv9:/u01/home/dba/oracle/product/middleware/jrmc-3.1.2-1.6.0/jre/../lib/sparcv9:/u01/home/dba/oracle/product/middleware/grid/patch_wls1032/profiles/default/native:/u01/home/dba/oracle/product/middleware/grid/oms11g/lib:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/native/solaris/sparc64:/u01/home/dba/oracle/product/middleware/grid/wlserver_10.3/server/native/solaris/sparc64/oci920_8
LD_LIBRARY_PATH_32: 
LD_LIBRARY_PATH_64: 
LD_PRELOAD   : 
LD_PRELOAD_32: 
LD_PRELOAD_64: /usr/lib/sparcv9/libumem.so:
StackOverFlow: 0 StackOverFlowErrors have occured
OutOfMemory  : 0 OutOfMemoryErrors have occured
C Heap       : Good; no memory allocations have failed
GC Strategy  : Mode: static, with strategy: singleconcon
GC Status    : OC currently running, in phase: initial marking. This is OC#1347.
Heap         : 0x2b00000 - 0x42b00000  (Size: 1024 MB)
Compaction   : 0x2b00000 - 0x3300000  (Current compaction type: internal)
CompRefs     : References are compressed, with heap base 0x0.

....

.....

 Stack 0: start=0xffffffff79b00000, end=0xffffffff79b44000, guards=0xffffffff79b0a000 (ok), forbidden=0xffffffff79b06000
Thread Stack Trace:
    at findNext+288()@0xffffffff7d9bc9f4
    at refIterGetNext2+52()@0xffffffff7d9bcb74
    at triWorkChunkIteratorStep+328()@0xffffffff7d9cad80
    at triWorkChunkIteratorGetNext+28()@0xffffffff7d9cafe0
    at mmSingleConProcessWorkChunk+160()@0xffffffff7d9db880
    at mmSingleConProcessThreadRoots+56()@0xffffffff7d9dbb8c
    at mmSingleConMark+144()@0xffffffff7d9dbf64
    at mmGCMainLoop+616()@0xffffffff7d88793c
    at mmGCMainThread+812()@0xffffffff7d8c558c
    at tsiThreadStub+144()@0xffffffff7d946b0c
    at ptiThreadStub+8()@0xffffffff7d9ab090
    at _lwp_start+0()@0xffffffff7ecd64b8
    -- Java stack --

    **********************************************************
    *  If you see this dump, please go to                    *
    *  http://edocs.bea.com/jrockit/go2troubleshooting.html  *
    *  for troubleshooting information.                      *
    **********************************************************

===== END DUMP ===============================================================

SOA BPEL 10G Schema

2011-05-27T01:44:00.001+05:30

Ref:

Oracle BPEL 10g Purging Strategies White Paper

http://www.oracle.com/technetwork/middleware/bpel/learnmore/bpeldehydrationstorepurgestrategies-192217.pdf

Oracle BPEL Process Manager 10g Database Schema Partitioning

http://www.oracle.com/technetwork/middleware/bpel/documentation/bpel10gpartitioning-133743.pdf

requested array is larger than heap" in Oracle workshop 10.3 for OSB

2011-03-15T18:27:00.000+05:30

If you are getting the " requested array is larger than heap" in Oracle workshop 10.3 for OSB
Then

1) In the file C:\Oracle\MiddleWare_OSB10g\workshop_10.3\workshop.ini increase the

-Xmx1024m

-XX:MaxPermSize=512m

2) Remove the .dat file For Eg:
C:\TRAINING\OSB\Workspaces\.metadata\.plugins\org.eclipse.wst.server.core\publish\publish0.dat
Recreate the Server and test again.

aruN

Upgrading from SOA 11.1.1.3 PS2 to 11.1.1.4 PS3

2011-01-27T16:30:00.001+05:30

Wanted to write an article on the upgrade of SOA PS3 but found good one already posted at:

Upgrading to SOA Suite 11gR1 PS3 (11.1.1.4.0)

How to use Axigen Mail server for SOA11g Notification and Approval in Workflow Testing

2010-09-06T22:07:00.001+05:30

1) Install the Axigen fro the http://www.axigen.com ( you can try another free one http://www.hmailserver.com/)

2) if you are using WindowsXP start the wizard as runas and after the services are configured change the “Axigen Mail Server” to Logon as specific OS user account.

Start the Wizard:

Provide admin user password

Provide your sample email domain server

Configure Services: Note: use localhost ip or static ip for access from other machine

After the service is configured goto Weadmin URL say http:127.0.0.1:9000/ and configure other details

Like adding users achrist and abavera to your email server domain and enabling SSL for IMAP/SMTP services etc…

If webadmin not working enable it manually by searching webadmin in axigen.cfg file.

If any problem you can check manually axigen.cfg file.

For test purpose change all the certfile=”none” caFile = "none" and dhParamFile = "none"

3) Now goto EM-Security Realm-> You specific user whom tasks will be assigned->Change the email attribute to proper email id here for eg: abavera@dogmatixmail.org

4) Now, goto EM Console->Right click on SOA-Infra->SOA Administration->Worklflow Notification Properties

Notification Mode: Email,

From Address:            achrist@dogmatixmail.org
Actionable Address:    achrist@dogmatixmail.org
Reply to Address:        NoReply@oracle.com

5)Go to the Messaging Driver page

Configure UserMessaging Email Server driver:

The changes done here goes to

/oracle/Fusion11g/Middleware/user_projects/domains/soa_domain1//config/fmwconfig/servers/soa_server1/applications/usermessagingdriver-email/configuration/driverconfig.xml

Now, configure mail client say Outlook for user abavera with your example email server domain to receive and approve the workflow request.

Troubleshoot:

In the incoming mail id make sure you are using the domain name also, if the domain name is part of userid. First thing to check whether the email server configuration is proper is test the mail by sending and receiving using any client eg: outlook Now, if this is working then goto EM->Usermessaging and check the Message Latency graph. if the graph is not receiving or sending then the line will be straight line. You should monitor it as soon as you approve the request from mail. Further debugging info to get: 1) Right click on SOA in EM and goto Logs->LOG Configuration Enable Finest 32 Trace to oracle.sdp, oracle.soa.services.notification and oracle.soa.services.workflow Upload the soa Server log.

2) In the UserMessaging Server in EM for Email Driver configuration enable DEBUG and monitor console

Reference:

http://download.oracle.com/docs/cd/E14571_01/integration.1111/e10226/ns_config.htm#SOAAG37120

A Sample of data-sources.xml,bpel.xml and oc4j-ra.xml for AQ using XA Datasource in 10.1.3.X

2010-08-13T20:26:00.003+05:30

========================================bpel.xml============================== <?xml version = '1.0' encoding = 'UTF-8'?> <BPELSuitcase>    <BPELProcess id="RawQueuePayloadUsingNativeFormat" src="RawQueuePayloadUsingNativeFormat.bpel">       <partnerLinkBindings>          <partnerLinkBinding name="Dequeue">             <property name="cacheConnections">false</property>             <property name="wsdlLocation">Dequeue.wsdl</property>             <property name="retryMaxCount">10</property>             <property name="retryInterval">60</property>          </partnerLinkBinding>          <partnerLinkBinding name="Enqueue">             <property name="wsdlLocation">Enqueue.wsdl</property>             <property name="retryMaxCount">10</property>             <property name="retryInterval">60</property>             <property name="cacheConnections">false</property>          </partnerLinkBinding>       </partnerLinkBindings>       <activationAgents>          <activationAgent className="oracle.tip.adapter.fw.agent.jca.JCAActivationAgent" partnerLink="Dequeue">             <property name="portType">Dequeue_ptt</property>          </activationAgent>       </activationAgents>    </BPELProcess> </BPELSuitcase>
============================================================================== ======/SOA/10.1.3.1/OracleAS_1/j2ee/oc4j_soa/config/data-sources.xml============
==============================================================================<managed-data-source connection-pool-name="AQSAMPLE_POOL" jndi-name="jdbc/aqSample" name="AQSAMPLE_DS" manage-local-transactions="false" tx-level="global" /> <connection-pool name="AQSAMPLE_POOL" validate-connection='true'>       <connection-factory factory-class="oracle.jdbc.xa.client.OracleXADataSource" user="scott" password="welcome1" url="jdbc:oracle:thin:@localhost:1521:orcl" connection-retry-interval="60" max-connect-attempts="60" commit-record-table-name="" validate-connection-statement="select 'x' from dual"/>       <connection-properties>           <property name="oracle.jdbc.ReadTimeout" value="300000"/>       </connection-properties> </connection-pool> ==============================================================================
==/SOA/10.1.3.1/OracleAS_1/j2ee/oc4j_soa/application-deployments/default/AqAdapter/oc4j-ra.xml==
==============================================================================<connector-factory location="eis/AQ/aqSample" connector-name="AQ Adapter">                 <config-property name="xADataSourceName" value="jdbc/aqSample"/>                 <config-property name="dataSourceName" value=""/>                 <config-property name="connectionString" value=""/>                 <config-property name="userName" value=""/>                 <config-property name="password" value=""/>                 <config-property name="defaultNChar" value="false"/>                 <config-property name="useDefaultConnectionManager" value="true"/>                 <connection-pooling use="none">                 </connection-pooling>                 <security-config use="none">                 </security-config>         </connector-factory> ==============================================================================

Note: I am using useDefaultConnectionManager not private connection

Additional properties you check for RAC and other timeouts:

validate-connection="true" time-to-live-timeout="60" abandoned-connection-timeout="60" property-check-interval="600" inactivity-timeout="60" initial-limit="10" max-connections="20" min-connections="10"
<property name="connectionCachingEnabled" value="true"/>
<property name="fastConnectionFailoverEnabled" value="true" />

For 10.1.3.X XA Datasource Requirement refer:
Oracle Metalink/Support note:738108.1
http://www.oracle.com/technology/tech/soa/pdf/oracle-soa-suite-xa-rac-guide.pdf
http://www.oracle.com/technology/tech/java/newsletter/articles/oc4j_datasource_config.html
http://www.oracle.com/technology/tech/java/newsletter/articles/oc4j_data_sources/oc4j_ds.htm
http://download.oracle.com/docs/cd/B25221_04/web.1013/b14427/datasrc.htm#sthref442

http://www.oracle.com/technology/pub/notes/technote_ds_caching.html

http://www.oracle.com/technology/sample_code/products/rac/index.html

Does SOA PS2 upgrades BAM schema to 11.1.1.3?

2010-07-07T17:15:00.001+05:30

After upgrading your SOA from PS1(11.1.1.2) to PS2(11.1.1.3) you will find that there are no scripts are upgrade schema for the BAM. Refer my earlier post for PS1 to PS2 patch upgrade.

The version of BAM schema still shows as 11.1.1.2 when you check using the query

select version, mr_type from schema_version_registry where MR_TYPE='BAM'

This is expected as PS2 doesn’t have any changes for BAM schema.

PS2 upgrade schema scripts only has changes for these components:

Oracle Portal (PORTAL), Oracle Identity Management (OID), SOA Infrastructure (SOAINFRA), Audit Services(IAU)

How to debug Java class related issues

2010-06-30T15:43:00.001+05:30

First check the logs for the issue and find out the class name

Look for Caused by: <classs name>

Now, search for that class in your product installed home.

Use this utility to find the JAR files which this class file resides

https://jarscan.dev.java.net/servlets/ProjectDocumentList

For eg:

cd $SOA_HOME

java -jar jarscan.jar -class org.quartz.impl.StdSchedulerFactory

Now, if you have source code access you can look into the file or you can use jd-gui (http://java.decompiler.free.fr/) to look into the class to see what’s really happening

Sending kill -3 in windows

2010-06-28T18:45:00.000+05:30

Want to send a kill -3 to Java process like in Unix try this:

http://www.latenighthacking.com/projects/2003/sendSignal/

How to upgrade SOA11gR1_PS1(11.1.1.2) to SOA11gR1_PS2(11.1.1.3) for Linux x86

2010-05-07T17:47:00.003+05:30

Here are brief steps:
1) Stop Domain/instance
2) Apply WLS 10.3.3 patch update (using wls 10.3.3 upgrade installer)
3) Apply FMW PS2 sparse patch to upgrade the binaries to11.1.1.3
4) Apply RCU Patch Scripts using the PSA to upgrade existing schema to 11.1.1.3
5) Start Domain/instance
6) Download JDEV 11.1.1.3
If you have Metalink Account then Goto support.us.oracle.com->Patches&Updates->Product or Family Advanced Search then follow screenshot to choose the product

Otherwise goto
http://www.oracle.com/technology/products/soa/soasuite/collateral/downloads.html#11.1.1.3.0
Or
You can directly download these 3 required softwares from support.oracle.com
Ø WLS 10.3.3 Patch upgrade BUG number: 9645506
Ø SOA 11gR1_PS2 Sparse Patch BUG number: 9585621
Ø Jdev 11.1.1.3 Studio Edition: http://download.oracle.com/otn/java/jdeveloper/11.1.1.3.0/jdevstudio11113install.bin
http://www.oracle.com/technology/software/products/jdev/htdocs/soft11.html
Oracle SOA Composite Editor
http://www.oracle.com/technology/products/jdev/101/update/fmw_products.xml#oracle.sca.modeler

Here are steps in Detail:

1) Stop Domain/instance
2) Apply WLS 10.3.3 patch update (using wls 10.3.3 upgrade installer)
Use the upgrade installer ->
http://download.oracle.com/docs/cd/E14571_01/doc.1111/e14142/prepare.htm#WLSIG195
http://download.oracle.com/docs/cd/E14571_01/doc.1111/e14142/guimode.htm
You can directly download by providing BUG number: 9645506 for Linux x86
Or
Use the Smart Update tool->
http://download.oracle.com/docs/cd/E14571_01/doc.1111/e14143/service.htm#SUTUG175

I am Using the upgrade installer:
chmod +x wls1033_upgrade_linux32.bin
./wls_1033_upgrade_linux32.bin

Screenshots:

3) Apply FMW PS2 sparse patch
After downloading the SOA PS2, extract 4 disks.
Start the installation like this from Disk1
./runInstaller -jreLoc /oracle/Fusion11g/Middleware/jdk160_18
Follow the screenshots:

4) Apply RCU Patch Scripts using the PSA to upgrade existing schema to 11.1.1.3
Run PSA ( Patch set Assistant). This will be installed in OH/bin folder after completing 3 step that is applying PS2 sparse patch.
First Check pre-requisite:
sqlplus / as sysdba

      show parameter aq_tm_processes;

       If the outcme is 0 then

       alter system set aq_tm_processes=1 scope=both;

      PSA will be in your SOA ORACLE_HOME.  $SOA_ORACLE_HOME/bin

     For Eg: /oracle/Fusion11g/Middleware/Oracle_SOA1/bin

           You can run

./psa -dbType Oracle -dbConnectString '//garuda.idc.oracle.com:1521/orcl' -dbaUserName sys -schemaUserName soa11gr2_soainfra

Screenshots:

You can use the SQL command below to verify that the schema version in schema_version_registry has been properly updated:

SELECT version, status FROM schema_version_registry WHERE owner='SOA11GR2_SOAINFRA';

SELECT version, status,owner FROM schema_version_registry;

For Oracle databases, be sure to recompile database objects after running the Patch Set Assistant by connecting to the database as SYS and running the following from SQL*Plus:

SQL> @?/rdbms/admin/utlrp.sql

This will compile the database objects that were updated by Patch Set Assistant.

Then issue to following query to ensure there are no longer any invalid database objects:

SELECT owner, object_name FROM all_objects WHERE status='INVALID';

None of the database objects for the updated schema should be invalid at this point.

Refer: http://download.oracle.com/docs/cd/E14571_01/doc.1111/e16793/patch_set_assistant.htm

5) Start Domain/instance

6) Download JDEV 11.1.1.3

http://www.oracle.com/technology/software/products/jdev/htdocs/soft11.html

Other References from Oracle SOA Suite Product Management team:

My iPhone2G from Ebay Story

2010-03-05T18:00:00.002+05:30

Won the iPhone 2g in the bid for 209$ and Internatianl Shipping 28$
USPS Tracking Link
http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=CQ003851850US
Shipped from USA:
Label/Receipt Number: CQ00 3851 850U S
Class: Priority Mail International Parcels
Service(s): International Parcels
Status: Out of Foreign Customs
    -Out of Foreign Customs, February 13, 2010, 4:21 pm, INDIA
    -Arrived Abroad, February 13, 2010, 2:49 pm, INDIA
    -International Dispatch, February 09, 2010, 3:52 pm, FOREIGN CENTERJERSEY CITY NJ 099
    -Arrival
    -Electronic Shipping Info Received, February 01, 2010
Indian Post Tracking Link ( No use as it wont show any info)
http://services.ptcmysore.gov.in/speednettracking/Track3.aspx?articlenumber=CQ003851850US
Trying to figure out the Post office number
http://services.ptcmysore.gov.in/Spcdetails/Managers.aspx?code=9
Bangalore    560001    22861435,22861390    22861994    spc.bangalore@indiapost.gov.in    T.R.SHANKAR
I called
GPO Post office Bangalore-- Bangalore 080 2286 7302
They asked me to call Parcel section 080 2558 9993
When I called they said it is pending in Custom screening at Bangalore
and asked me to call this number: Bangalore Postal Customs: 2558 9992
and they provided me with the new India tracking number #1357
AS soon as Indian Post recieves the parcel they code it with their own number in this case mine was 1357
So no info in the Indian Post office tracking website or USPS website
Called the above number they said it got cleared and sent it back to Post, couldnt get the date when they cleared and send it back.
Figured out manually visiting GPO that it got sent to Local Post office on 19th Feb
Checked in the local Post office for my address and I found the package with custom duty as it wasnt marked as GIFT :(
The Customs duty was:
Total Value: 209.99$
Postage and Fees: 25.17$
Indian Custom duty: 1758/-
Indian Postal Fees: 100/-
-------------------------
So, total fine 1858/- :(
===========================
So, next time if you ordering something make sure you ask the vendor to mention/mark it as GIFT
Because I got one more iPhone2G without any fine:
Label/Receipt Number: LC28 9608 926U S
Class: Priority Mail International Parcels
Service(s): International Letter
Status: Acceptance
Only difference between these two is one was marked as GIFT + Service Type: International Letter
The one where custom duty charged was NOT marked as GIFT + Service(s): International Parcels

HP PEN DRIVE USB DRIVE NOT DETECTED

2010-01-27T17:46:00.001+05:30

I bought a new HP Pen drive V165W 16GB.

The problem with this is

1) It is so small to maintain it

2) The cap doesn’t attached to the body tag wire

3) It was always in-consistent in getting detected in Windows XP system

>> Solved the above problem by stopping the “Removable Storage” service, made it manual and restarted the system

Heard that the driver code the HP written ( device originally manufactured by PNY) gets conflict with the Drive Letter assign program of XP-OS.

Never faced this problem with Transcend, SanDisk drives…

How to create a new Linux ext3 Partition from free Un-partitioned space

2009-12-11T19:15:00.001+05:30

fdisk -l
Disk /dev/sda: 320.0 GB, 320072933376 bytes
255 heads, 63 sectors/track, 38913 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id System
/dev/sda1   *           1       19122   153597433+ 83 Linux
/dev/sda2           19123       20142     8193150   82 Linux swap / Solaris

df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 142G 87G 49G 65% /

fdisk /dev/sda
:n ( For new partition)
p ( for Primary Partition)
3 ( 3 partition)

Select default for start
Select default for End

:w ( Write the table information)

fdisk -l
Disk /dev/sda: 320.0 GB, 320072933376 bytes
255 heads, 63 sectors/track, 38913 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id System
/dev/sda1   *           1       19122   153597433+ 83 Linux
/dev/sda2           19123       20142     8193150   82 Linux swap / Solaris
/dev/sda3           20143       38913   150778057+ 83 Linux

Now, FORMAT the new partition to ext3 File system type

/sbin/mkfs -t ext3 /dev/sda3

mke2fs 1.39 (29-May-2006)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
18857984 inodes, 37694514 blocks
1884725 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=0
1151 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000, 7962624, 11239424, 20480000, 23887872

Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 26 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override

Lable the new Parition
e2label /dev/sda3 /PRODUCTS

Create the new mount directory
mkdir /PRODUCTS

Add as permanent entry to /etc/fstab
LABEL=/PRODUCTS /PRODUCTS ext3 defaults 1 2

partprobe

How to correct the wrong entry of /etc/fstab?

2009-12-09T19:30:00.001+05:30

I had this problem of system booting with Read-only file system because of wrong entry in /etc/fstab

Fixed this problem by remounting the root-file system with write mode

“mount -o remount,rw /”

Do this once you get the command prompt and you log in using the root user

How to use subtitles in MKV,AVI,DivX files on XBOX360?

2009-10-14T19:38:00.002+05:30

You can stream the file to your 360 with PS3 Media Server (yes it works with the 360) or TVersity. PS3 Media Server works better.

I've tried it with my 360 and it works fine. At least this way you won't have to reconvert anything since the program will do all the transcoding on the fly. If there is a subtitle SRT in the same folder as MKV or AVI movie then PS3 Media Server converts/Transcodes to proper format so that the xbxo360 can understand:

http://ps3mediaserver.blogspot.com

Another method is to use the Windows Media Player11 with Windows7 and DivX7

http://labs.divx.com/ProjectRemoulade

http://labs.divx.com/mkvwin7preview

Refer:

You would like to convert your MKV file into an MP4 file,playable in your xbox 360

http://www.elgholm.se/utils/mkv2mp4/

EncodeHD is a an application to re-encode all types of video files for use on your home media player or on-the-go device. It aims to provide a simple interface with no fuss, and give you the best speed possible without compromising on quality.

http://dcunningham.net/encodehd/

How to make two BPEL process participate in Transaction

2009-07-09T13:39:00.001+05:30

Problem:

- create a BPEL process (regardless sync or async) - create 2 invokes to 2 distinct DB partnerlinks that perform each one an insert into 2 distinct tables

make sure 2nd invoke fails for whatever reason - expected result would be that the transaction (insert) for the 1st invoke should be rolled-back as well

Solution:

Make sure the DB connection are XA enabled and not MCF.

1. To make Async one way bpel process invocations to participate in single global transaction, set bpel.xml configurations property "deliveryPersistPolicy" to "off.immediate" and 2. To force such BPEL processes to throw un-handled BPEL faults back to invoking process, set bpel.xml configurations property "handleTopLevelFault" to "false". To make sure that the all the Async one-way BPEL processes are participating in single global transaction and all the unhandled BPEL Faults and exceptions are propagated back to the invoking process, configure the following in configurations section of bpel.xml: <configurations> .... <property name="deliveryPersistPolicy">off.immediate</property> <property name="transaction">participate</property> <property name="handleTopLevelFault">false</property> </configurations>

Also refer:

http://www.oracle.com/technology/tech/soa/pdf/oracle-soa-suite-xa-rac-guide.pdf

Debugging Reports Server Engine on Solaris

2009-07-01T14:21:00.001+05:30

How to truss the Reports Server ?
truss -ef -o trussserver3.out rwserver server=vsis batch=yes

How to truss the Reports job submission?
truss -ef -o trussclient3.out rwclient.sh server=vsis report=test.rdf mode=bitmap batch=YES paramform=no destype=file desname=/tmp/test.pdf desformat=PDF userid=scott/tiger@orcl

How to truss the actual Reports Engine Java process?
ps -ef|grep rw
ps -ef|grep java

Get the java process id which is the actual process of Reports engine.
You can also get the REports Engine Java process id by
http://MyServer.com:8889/reports/rwservlet/getserverinfo?server=vsis#Engine

truss -ef -o rwenginetruss.log -p 7647

Tracing Java GC to see memory usage

Set this in reports.sh which will be picked up by engine

REPORTS_JVM_OPTIONS="-Xms3500m -Xmx3500m -Xloggc:/tmp/gc.txt";export REPORTS_JVM_OPTIONS

Checking the Java option quickly:

cd $ORACLE_HOME/j2ee/home
java -Xmx3G -jar oc4j.jar -version
java -Xmx3800m -jar oc4j.jar –version (Tested on Solaris 10)

To see memory usage of a process:

/usr/proc/bin/pmap -x 5862 ( PID)

/usr/ucb/ps -auxwww | grep vsis ( Full command of a running process)

prtdiag --memory info
prstat -a -s rss

XBOX-360 3 Red Ring Death

2009-06-24T20:14:00.002+05:30

I had this incident of 3 Ring of Death with my Xbox360 Pro.

http://en.wikipedia.org/wiki/Xbox_360_technical_problems

I was playing Call of Duty4 and suddenly the screen freeze and after checking all the troubleshooting tips online, I decided to get it repair with Microsoft.

Microsoft was having additional 3 years warranty for this problem and would repair freely or replace.

The problem with my console is that I got this console from US when it was not introduced in India and either I can get it repaired with free shipping to and fro from US local address only or get it repaired from Australian center by paying the one way shipping charges.

When I called the local Microsoft center they confirmed me that If I pay the one way shipping charge including the customs duty if any, they would repair it freely and would return it freely to my address in India.

So, I decided to send it through local courier called SM couriers (http://www.smcouriers.com/). They have a understanding with other standard parcel services like UPS,DHL. They charged me 3200/- for the one way shipment to Australia.

I had to remove the hard drive, the faceplate, the wireless adapter, any accessories, and any disc from the disc drive before shipping.

I shipped the console on 3/June/2009 with estimated delivery date of 9/Jun/2009.

Type: Package
Scheduled Delivery: 09/06/2009
Shipped To: REGENTS PARK,AU,
Shipped/Billed On:03/06/2009
Service:UPS SAVER
Weight:4.00 Kg

This is the address I sent my console:

Jay Jayapragash
Teleplan Service Solutions Asia B.V
Regents Park Estate
Block D, 391 Park Road
Regents Park, NSW, 2143
Australia

I received back my repaired console on 18/Jun/2009 to my address in India.

How to modify the each nodes logging in SOA HA

2009-06-24T19:34:00.001+05:30

Issues: By default in an HA environment when you modify a logging property from BPELConsole using the LBR URL, it may change the property in any one of the host.

As of now this is expected behavior as we don't support modifying the cluster level logging property on both all the nodes.

When you try to change the logging property in any one of the node using the local hostname and local listen port instead of LBR hostname and port still it may not work and may change the URL to LBR URL

Solution:

As UseCanonicalName is ON the HTTP Server always reconstructs the URL with the ServerName and Port of the LBR.

So, in your httpd.conf set the “UseCanonicalName off” this will make HTTP Server to use the hostname and port as supplied by the client browser.

Now, You need to create a one more additional Virtual Host entries in additional to your LBR host entries like this on each node and LBR node:

( First entry is the default entry required as per EDG guide for Oracle SOA)

------------------------------httpd.conf--------------------------

#From default section
UseCanonicalName off

<VirtualHost *:7777>
ServerName myLBR.com
Port 80
ServerAdmin arun@mymail.com
RewriteEngine On
RewriteOptions inherit
</VirtualHost>

<VirtualHost *:7777>
ServerName mylocalwebserver1.com
Port 7777
ServerAdmin arun@mymail.com
RewriteEngine On
RewriteOptions inherit
UseCanonicalName off
</VirtualHost>

How to test ESB ANT HTTPS deployment on weblogic SOA 10.1.3.4+MLR8

2009-06-24T19:14:00.002+05:30

1) Change the default password for of your Keystore and Identity store to whatever password you gave during the weblogic SOA installation.

Here by default we are using the cacerts as Keystore and Identity store.

keytool -storepasswd -new weblogic -keystore /product/9.2.3/bea/weblogic92/server/lib/cacerts -storepass changeit

2) Copy the same cacerts to BEA JavaVM directory ( Jrockit or JunJVM which ever is being used)
cp /product/9.2.3/bea/weblogic92/server/lib/cacerts /product/9.2.3/bea/jrockit_150_12/jre/lib/security/

3) Copy the same cacerts to your Oracle SOA JVM directory.
cp /product/9.2.3/bea/weblogic92/server/lib/cacerts $ORACLE_HOME/jdk/jre/lib/security/

4)Change the SOAPCALL URLs to HTTPS
"BPEL soap callback URL" and "BPEL soap server URL" from BPEL Admin
https://mymachine.oracle.com:9002

5) Change ESB_PARAMETER to HTTPS
DT_OC4J_PROTOCOL https
DT_OC4J_HTTP_PORT 9002
DT_OC4J_HOST mymachine.oracle.com

6) Enable the HTTPS SSL port for Oracle SOA Server from weblogic console
Environment->Server->OracleSOAServer->Configuration

All other steps for setting up SSL refer below topics.

http://oraforms.blogspot.com/2009/01/steps-for-enabling-ssl-for-esb-in-soa.html

How to map/modify SOA ESB project files from Webdav Jakarta Slide?

2009-05-29T18:39:00.002+05:30

To create a Slide repository mapping in windows:
Goto Windows Explorer->Uncheck Folder button from top menu
Netwrok task from left pane->Add a network place
http://<yourServer><:port>/esb/slide/ESB_Projects

Now, you can use this mapped network folder to view/modify ESB Slide

This can be used to troubleshoot lot of synchronization problems of your modified project.

How to change weblogic server admin password with Oracle SOA

2009-05-22T19:52:00.002+05:30

ISSUE:

Installation: SOA Suite 10.1.3.4 + WebLogic 9.2

The admin user weblogic is changed as follows: Admin Console -> SOA DOmain -> Security Realms -> myrealm -> Users and Groups -> weblogic -> P a s s w o r d s

ERRORS:

1) From Console if you try to start the weblogic server

Admin Console -> SOA DOmain -> Servers -> OracleSOAServer -> Server Start

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

<May 21, 2009 9:57:47 PM> <Warning> <Exception while starting server 'OracleSOAServer': java.io.IOException: Server failed to start up. See server output log for more details.> java.io.IOException: Server failed to start up. See server output log for more details. at weblogic.nodemanager.server.ServerManager.start(ServerManager.java:296) at weblogic.nodemanager.server.Handler.handleStart(Handler.java:511) at weblogic.nodemanager.server.Handler.handleCommand(Handler.java:115) at weblogic.nodemanager.server.Handler.run(Handler.java:66) at java.lang.Thread.run(Thread.java:595)

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

2) From command prompt if you try to start the weblogic server

startWeblogic.cmd

-------------------------------------------- <May 22, 2009 7:19:34 PM IST> <Critical> <Security> <BEA-090402> <Authentication denied: Boot identity not valid; The user name and/or password from the boot id entity file (boot.properties) is not valid. The boot identity may have been changed since the boot identity file was created. Please edit and update the boot id entity file with the proper values of username and password. The first time the updated boot identity file is used to start the server, these new values are enc rypted.> <May 22, 2009 7:19:34 PM IST> <Critical> <WebLogicServer> <BEA-000386> <Server subsystem failed. Reason: weblogic.security.SecurityInitializationException: Auth entication denied: Boot identity not valid; The user name and/or password from the boot identity file (boot.properties) is not valid. The boot identity may have been changed since the boot identity file was created. Please edit and update the boot identity file with the proper values of username and password. The first time the updated boot identity file is used to start the server, these new values are encrypted. weblogic.security.SecurityInitializationException: Authentication denied: Boot identity not valid; The user name and/or password from the boot identity file (bo ot.properties) is not valid. The boot identity may have been changed since the boot identity file was created. Please edit and update the boot identity file wit h the proper values of username and password. The first time the updated boot identity file is used to start the server, these new values are encrypted. at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(CommonSecurityServiceManagerDelegateImpl.java:941) at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1029) at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:854) at weblogic.security.SecurityService.start(SecurityService.java:141) at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64) Truncated. see log file for complete stacktrace > <May 22, 2009 7:19:34 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED> <May 22, 2009 7:19:34 PM IST> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down> <May 22, 2009 7:19:34 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN> -----------------------------------------------------------------------

SOLUTION:

After changing the password in the console you need to change one more place also as this environment uses boot.properties. Note: boot.properties is used so that you don't need to enter the password every time you ran a script. Refer: http://e-docs.bea.com/wls/docs70/adminguide/startstop.html#bypassing_the_interactive_prompt

So, Change the password in WLS_HOME\domains\SOADomain\servers\AdminServer\security\boot.properties

Type the new password in this file in plain text and save it. When you run the startWebLogic.sh script next time, WebLogic will overwrite the boot.properties file and replace it with an encrypted boot.properties file.

Setting up a LINUX box for ORACLE Install

2009-05-07T16:19:00.001+05:30

/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd -m -g oinstall -G dba oracle
id oracle

mkdir -p /oracle
mkdir -p /softwares

chown -R oracle:oinstall /oracle
chmod -R 775 /oracle

chown -R oracle:oinstall /softwares
chmod -R 775 /softwares

/sbin/sysctl -p

cat >> /etc/sysctl.conf <<EOF
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
EOF

cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

cat >> /etc/pam.d/login <<EOF
session required /lib/security/pam_limits.so
EOF

Oracle Reference

How to create JDBC Resources from EM for SOA 10.1.3.X

2009-04-17T18:07:00.003+05:30

================================================================
1) Goto EM console
2) Click OC4J_SOA->Administration Tab
3) Services->JDBC Resources
4) Create ‘Connection Pool’

a) Application ‘default’
b) New Connection Pool say ‘MyDSCP’
c)Give Unique name, JDBC URL and Credentials

5) Create ‘Data Sources’

a) Application ‘default’ next ( Managed Data source . selected)
b) Connection pool from List ‘MyDSCP’
c) Name ‘MyDS’, JNDI ‘jdbc/MyDS’, Connection Pool ‘MyDSCP’

6) Now Goto OC4J_SOA->Applications->default->DbAdapter->ConnectionFactories

a) Create choose default
b) JNDI Location ‘eis/jdbc/MyDS’
c) xADataSourceName =‘jdbc/MyDS

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

For 11g SOA Refer:

http://download.oracle.com/docs/cd/E14571_01/integration.1111/e10231/life_cycle.htm#BABBEDBF

Setting up Verisign Trial Certificate for SOA server using Oracle Wallet Manager (OWM)

2009-04-01T20:08:00.002+05:30

======================================================================= 1) Generate CSR using the OWM Create an Oracle Wallet which contains a SSL Certificate: - Select Wallet -> New - Enter a password for the wallet (e.g Welcome1) - Wallet Type -> Standard - Create a Certificate Request. - Enter the details for the request. For example: Common Name: <host.domain> Organizational Unit: Support Organization: Oracle Location: Reading State: Berkshire Country: United Kingdom Key Size: 1024bits * Common Name has to match the host.domain that the webserver is known as. This is the ServerName parameter in the httpd.conf file and the host.domain that users will access from the browser URL. - Click OK. - Click 'Certificate:[Requested]' and select from the Menu 'Operations' and 'Export Certificate Request' - Save to a file (e.g server.csr) - Select Wallet -> Save - Save to a directory e.g /tmp/wallet/ - Open the file in a text editor and copy the contents of the certificate signing request. Refer Metalink Note:341904.1 2) Export the certificate request and save it as text file. 3) Copy paste this request in Verisign Trail Certificate website https://www.verisign.com/ssl/buy-ssl-certificates/free-ssl-certificate-trial/index.html 4) Install the Root CA Trail certificate in your browser when you get the reply from Verisign 5) Save the RootCA , Intermediate and SSLCertificate in text file with extension crt. (Details in mail you got from verisign) 6) If required take a backup of your Wallet 7) Import these RootCA , Intermediate and SSLCertificate into your OWM wallet as Trusted certificates Note, you are using wallet to manage your certificate in your Oracle SOA server. The directive is SSLWallet <YourLocation of Wallet> in ssl.conf 8) After the above steps make sure the "Certificate" node shows as Ready and subject name is your Machine name and other details Issuer name is Verisign and other details. If required delete your old User Server certificate NOTE: All the above steps are in place of STEP(4) in Metalink Note:779539.1 or http://oraforms.blogspot.com/2009/01/steps-for-enabling-ssl-for-esb-in-soa.html 9) Import the certificate in JDK keystore keytool -list -keystore $ORACLE_HOME/jdk/jre/lib/security/cacerts -storepass welcome1 keytool -delete -alias soavm -keystore $ORACLE_HOME/jdk/jre/lib/security/cacerts -storepass welcome1 (Delete old User Certificate alias) keytool -import -file /oracle/SOA/SOA10gR3/mywallet/soavmVerisignTrail.cs -keystore $ORACLE_HOME/jdk/jre/lib/security/cacerts -storepass welcome1 -alias soavm Note: I have used the same earlier User certificate on this server as in Note:779539.1 and exported this same User certificate as User Certificate Request for Verisign. 10) Restart your SOA server 11) Now, open the HTTPS URL https://soavm.oracle.com:4443/ in IE Click on the lock icon next to Address bar and make sure the certificate shows as Verisign identified this server as <Your server name> Reference: Note:779539.1 How to enable SSL/HTTPS for ESB in SOA 10.1.3.x Server? http://oraforms.blogspot.com/2009/01/steps-for-enabling-ssl-for-esb-in-soa.html ====================================================================== Note: As of now i have configured this in https://soavm.oracle.com:4443/ You can verify this in https://soavm.oracle.com:4443/esb oc4jadmin/welcome1 I have deployed ESBDemo sample using ANT with HTTPS after the Verisign Trial Certificate. This is certificate is valid till April 16,2009 as of now.

PC/Hardware Chip level Repair in Bangalore

2009-03-10T20:23:00.001+05:30

Multisofts Hard Solutions
133, Puttenahalli Main Raod,
6th Phase, J P Nagar,
Bangalore 560078
Ph:26656631/26659337

Digicomp Complete Solutions Ltd.
Sri Chakravarthi Complex,
3rd Floor, #53-58,
Sajjan Rao Circle, VV Puram,
Bangalore - 560 004.
Ph:+91 - 80 - 26758060 / 70
Fax: +91 - 80 - 26758290
customersupport@digicompindia.com

Some Tips for debugging ORACLE OPATCH issues

2009-02-25T16:40:00.002+05:30

To see all the components versions

opatch lsinventory --detail

Additional Help
opatch apply –help

To get OPatch Refer Note:293369.1 and Note: 224346.1, hosted under BUG:6880880

To get more details about errors in logs

export OPATCH_DEBUG=true

For opatch version 1.0.0.0.xx, logs are written into the patch storage area under $ORACLE_HOME/.patch_storage/<bug number>

To get additional logs when the default log wont reveal much use OS tacers like on Solaris:
truss -aefdD -o test.out opatch apply
truss -faeo /tmp/truss.out opatch apply > /tmp/applylog.out

When you apply a one-off the files

<PATCHNUMBER>\etc\config\actions and <PATCHNUMBER>\etc\config\inventory

have all the actions it has to do the platform it is supported on

The <Component> version="10.1.2.3.0" opt_req="R" means the the particular component is required to apply the patch.

This compares the version with the version in the file $ORACLE_HOME/inventory/ContentsXML/comps.xml

Platform id is picked up from the file :
%ORACLE_HOME%\inventory\ContentsXML\oraclehomeproperties.xml

This can be overridden using OPATCH_PLATFORM_ID variable

Simple Java program to check the OS info

public class platform {

 public static void main (String[] args) {
      System.out.print("Operating System: ");
      System.out.println(System.getProperty("os.name"));
      System.out.print("Operating System version: ");
      System.out.println(System.getProperty("os.version"));
      System.out.print("System Architecture: ");
      System.out.println(System.getProperty("os.arch"));
    }
  }

To use a customized centralized inventory

./runInstaller –invPtrLoc /oracle/oraInst.loc

opatch apply -invPtrLoc /oracle/oraInst.loc

To see if the OPATCH is holding a lock on a particular patch

cd $ORACLE_HOME/.patch_storage see the file patch_free

OPATCH 11g TIPS

To see Oracle Common components

Go to OPatch in Middleware home and oracle_common directory

/home/oracle/Oracle/Middleware/oracle_common/OPatch

unset ORACLE_HOME

opatch lsinventory –detail

So, if there is a dependency with your common component files and if you have set the ORACLE_HOME to SOA_HOME, the opatch compares the version to $ORACLE_HOME/inventory/ContentsXML/comps.xml and wont find the library

for Eg:

Optional component(s) missing :

[ oracle.xdk.parser.java,11.1.0.7.0 ] ,

[ oracle.jrf.thirdparty.jee, 11.1.1.1.0 ]

----------------------------------------------------------------------------------------To see the version using the RDA

./rda.sh -vdT inv

External webservice Time Out

2009-02-16T19:44:00.002+05:30

When deploying a BPEL project which refers to an External webservice is Timing out

then increase the Time out at:

For Example:

$ORACLE_HOME/j2ee/oc4j_soa/application-deployments/orabpel/ejb_ob_engine/orion-ejb-jar.xml
trasaction-timeout=3600 ( Default 36 and 120)

$ORACLE_HOME/bpel/domains/default/config/domain.xml "syncMaxWaitTime" changed to 2400 ( Default 45))

$ORACLE_HOME/j2ee/oc4j_soa/config/transaction-manager.xml, time-out changed to 7200 ( Default 60))

Troubleshooting ESB Console issues

2009-02-12T16:46:00.002+05:30

Oracle ESB - Version: 10.1.3.3 to 10.1.3.X

Note: The document assumes that your the container name running esb-dt application is OC4J_ESBDT.

1. Make sure the directory esb-dt exist in $ORACLE_HOME/j2ee/OC4J_ESBDT/application-deployments/
Check the opmn/logs/default*.log and opmn.log (in the same location) files to see if there are any ESB related exceptions logged.
2. Timeout related errors seen in log.xml
If there are timeout related issues/errors in
$ORACLE_HOME/j2ee/OC4J_ESBDT/log/OC4J_ESBDT_ESBDT_GROUP_1/oc4j/log.xml, please follow the below steps:
2.1 Increase the value of the transaction-timeout parameter in
the $ORACLE_HOME/j2ee/OC4J_ESBDT/config/transaction-manager.xml file.
Eg:

transaction-timeout="300"

2.2 Increase the value of the xa_timeout parameter in the
$ORACLE_HOME/integration/esb/esb_config.ini file
eg:

xa_timeout=3600 jms_receive_timeout=300

2.3 Login into repoistory DB as system user and then issue:

ALTER SYSTEM set OPEN_CURSORS=5000 scope=both;

2.4 Restart the ESB Server :

opmnctl stopall; opmnctl startall;

3. Make sure you can connect to your repository database to oraesb schema.
If the passoword is wrong to reset it for oc4jadmin
Check $ORACLE_HOME/j2ee/OC4J_ESBDT/config/system-jazn-data.xml
Refer: Metalink Note 470680.1
4.Check the values for the ESB_PARAMETERS.
Make sure the 'DT_OC4J_HTTP_PORT', 'DT_OC4J_HOST' and 'DT_OC4J_PROTOCOL' are correct.
This should be your loadbalancer port and host name when having a High Availability environment.
Also make sure other parameters are configured properly according to your type of JMS ( OracleASjms or OracleOJMS)
Refer: Metalink Note 453355.1
For High Availability: http://download.oracle.com/docs/cd/E10291_01/core.1013/e10294/webapp.htm#CHDCFDJG
If it is running on HTTPS then refer: Metalink Note 461419.1
5. Check if the services are running properly:
Make sure the ESB-DT application is running by issuing:

opmnctl status -l app

For Eg: If it is running then it wil be listed like this

If it is not running which means the appliction is not installed properly or it is not been started.
Try to start the application:

opmnctl startproc application=esb-dt

Note : If High Availability then do not use restartproc, use startproc or stopproc instead.

6. Make sure the Services are automatic and routing is proper:
To make it starts automatically everytime we restart the instance check these:
$ORACLE_HOME/j2ee/OC4J_ESBDT/config/default-web-site.xml

<web-app application="esb-dt" name="esb_console" load-on-startup="true" root="/esb" ohs-routing="true" />

/oracle/SOA/SOA10gR3_HA/j2ee/OC4J_ESBDT/config/server.xml

<application name="esb-dt" path="../applications/esb-dt.ear&! quot; parent="default" start="true" />

7. After ESB Console starts and If Instances are not showing up then set:

TrackingEnabled=true

8. If you encounter following error:java.lang.NoClassDefFoundError:
Encountered following exception in log.xml

java.lang.NoClassDefFoundError: org/apache/log4j/Category))

The workaround is as follows -
8.1 Backup and add the following line to the orion-application.xml file for esbdt

<imported- shared-libraries> <remove-inherited name="apache.commons.logging"/>

8.2 Restart the instance:

opmnctl stopall opmnctl startall

How to use XSLMapper Custom Defined Functions (Extension function)for ESB 10.1.3.x?

2009-02-05T16:37:00.002+05:30

My Sample extension function save in D:\myxpath

---------------------------------------
package myxpath.functions;
public class StringTest
{
    public StringTest()
    {
    }
    public static String toUpperCase(String s)
    {        return s.toUpperCase();
    }
}

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

set PATH=D:\ORACLE\jdevstudio10134\jdk\bin;%PATH%
D:\myxpath>javac StringTest.java -d .

(Note -d and . it creates the class file with directory structure)

Create the XSL Mappers extesnion XML file
D:\myxpath\myxpathExtensionFunctions.xml
==========================================
<?xml version="1.0" encoding="UTF-8"?>
<extension-functions>
<functions xmlns:sample="http://www.oracle.com/XSL/Transform/java/myxpath.functions.StringTest">

<function name="sample:toUpperCase" as="string">
      <param name="s" as="string"/>
    </function>
</functions>
</extension-functions>
============================================
For more info Refer:
SOA_Oracle_home\bpel\samples\demos\XSLMapper\ExtensionFunction\README.txt

Create the JDEV Extesnion XML file in
D:\myxpath\meta-inf\extension.xml
============================================
<?xml version = '1.0' encoding = 'UTF-8'?>
<extension xmlns="http://jcp.org/jsr/198/extension-manifest"
           id="myxpath.functions.StringTest"
           version="10.1.3"
           esdk-version="1.0">
<name>StringTest</name>
<owner>OracleBDE</owner>
</extension>
============================================
For more info refer:
<JDEV_HOME>/jdev/doc/extension/ide-extension-packaging.html

Create the JAR file
D:\myxpath>jar -cvf myxpath.functions.StringTest.10.1.3.jar myxpath\functions\StringTest.class -m meta-inf\extension.xml

Copy this JAR file to <JDEV_HOME>\jdev\extensions\
For Eg: D:\ORACLE\jdevstudio10134\jdev\extensions\myxpath.functions.StringTest.10.1.3.jar

Goto Jdev->Tools->Prefereance->XSl Maps->User Defined Extension config file and give myxpathExtensionFunctions.xml

Restart your JDEV and now you should be able to see the Custom XSL Map function under :
User Defined Function in XSL Mapper design.

Now you can use this custom function like this in design time:
<xsl:value-of select="sample:toUpperCase(string(/imp1:CustomerData/CustomerName))"/>

To use this function at runtime for ESB:
Open your j2ee\oc4j_soa\config\server.xml and add a entry below
<shared-library name="oracle.bpel.common" version="10.1.3">
as follows :
<code-source path="D:\myxpath/myxpath.functions.StringTest.10.1.3.jar"/>

Setting up JDeveloper for HTTPS/SSL Server Integration

2009-02-02T17:57:00.002+05:30

Assumption: JDeveloper zip file is extracted to c:\jdev10134\ folder.

1). Set the following command line variables.

    set ORACLE_HOME=c:\jdev10134\
    set JAVA_HOME=%ORACLE_HOME%\jdk
    set PATH=c:\jdev10134\jdk\bin;%PATH%

All the below steps are done in the command prompt having above env variables set.

2. Change the JDK truststore password same as ESB’s

The default certificate store comes with the JRE deployed within the ORACLE_HOME for the Application server.
It is located under %JAVA_HOME%\jdk\jre\lib\security. It is called "cacerts" and the default password is "changeit".

     ESB requirement is to have the oc4jadmin password and truststore password same.
     To accomdate this requirement, we need to change the truststore password to be same as oc4jadmin password.
     Below cmd would do that.

    check for the keytool being used.
    > which keytool
      $ORACLE_HOME\jdk\bin\keytool --- this should be shown. (else set the env variables properly)

> keytool -storepasswd -new welcome1 -keystore %ORACLE_HOME%\jdk\jre\lib\security\cacerts -storepass changeit
No errors should be shown. We now set the truststore password and oc4jadmin password same

3. Import of Certificate into TrustStore

       Import the newly created certificate into the default certificate store that comes with the JRE deployed within the ORACLE_HOME
       for the Application server. This step is required to facilitate any Web service clients to use the newly created certificate(e.g. IdentityService).
       This import is done with the java keytool command

    a) copy the Trusted Certificate created in Application Server env to a place accessible to JDeveloper env.
       You can use owm (Oracle Wallet Manager) to export trusted certificate
       eg: create a folder under Jdeveloper home.
       c:\jdev10134\mywallet and copy newtest.cs into this folder.

    b) > cd %ORACLE_HOME%
       > keytool -import -file %ORACLE_HOME%\mywallet\newtest.cs -keystore %ORACLE_HOME%\jdk\jre\lib\security\cacerts -storepass welcome1
        note: storepass default value 'changeit' is changed to 'welcome1' in the first step.

c) Take back up of jdev.conf file found in %ORACLE_HOME%\jdev\bin folder.

      Update the jdev.conf file with the following entries towards the end.
       AddVMOption -Djavax.net.ssl.trustStore=C:\jdev10134\jdk\jre\lib\security\cacerts
       AddVMOption -Djavax.net.ssl.trustStorePassword=welcome1

d) Invoke JDeveloper and create Application Server Connection and Integration Server Connections.
In the Integration Server connection section, choose protocol as "https" and use https port.

Note: For BPEL projects to get deployed in SSL you need to add following in build.xml

isSSL="${isSSL}" trustStore=”C:\jdev10134\jdk\jre\lib\security\cacerts”

trustPassword="welcome1"

Steps for Enabling SSL for ESB in SOA 10.1.3.x Server

2009-01-30T18:49:00.003+05:30

1) Set the following command line variables.
export ORACLE_HOME=/oracle/SOA10gR3
export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jdk/bin:$ORACLE_HOME/ant/bin:$PATH:.
export ANT_HOME=$ORACLE_HOME/ant

alias cdo='cd $ORACLE_HOME'

2) ESB requirement is to have the oc4jadmin password and truststore password same

which keytool ( Should be ORACLE_HOME's)
keytool -storepasswd -new welcome1 -keystore $ORACLE_HOME/jdk/jre/lib/security/cacerts -storepass changeit

3) Creation of Wallet.
$ORACLE_HOME/bin/orapki wallet create -wallet /home/oracle/wallet -auto_login

Creation of USER Certificate

$ORACLE_HOME/bin/orapki wallet add -wallet /home/oracle/wallet -dn "cn=soa.vm.oracle.com,ou=bde,o=oracle,l=RedwoodShores,st=CA,c=US" -keysize 1024 -self_signed -validity 360

when prompted for the password, Enter the oc4jadmin password twice
Note:cn starts with hostname and 'l' is location which is RedwoodShores, 'ou' is group, 'o' is user

4) Check of Wallet creation and Export the Certificate

$ORACLE_HOME/bin/owm &

Open the /home/oracle/wallet enter welcome1 oc4jadmin password twice

"Export the Trusted Certificate" to /home/oracle/wallet/soavm.cs

5) Update the configuration files and Restart Server.
Update the configuration files and Restart Server.
Open $ORACLE_HOME/Apache/Apache/conf/ssl.conf
Comment out the current SSLWallet location attribute and create a new entry
SSLWallet <Absolute path to the Wallet directory you created in step above>
eg: SSLWallet file:/home/oracle/wallet

6) Update of ESB Repository Schema.

Sql> Update esb_parameter set param_value='4443' where param_name='DT_OC4J_HTTP_PORT';
Sql> insert into ESB_PARAMETER values('DT_OC4J_PROTOCOL','https');
Sql> commit;
Restart the opmn process.

7) Change the SOAP URL's

Once the server is restarted. Login to Bpel Admin.

Open BPEL Admin Console http://soa.vm.oracle.com/BPELAdmin and modify the following properties:

SoapServerUrl and SoapCallbackUrl

Both properties should be changed from http to https with the hostname and full domain name in the URL.

https://soa.vm.oracle.com:4443/BPELConsole
Make sure that the correct SSL port is specified.
Test and verify certificate based HTTPS is now available.

8) Import of Certificate into TrustStore

Import the newly created certificate into the default certificate store that comes with the JRE deployed
within the ORACLE_HOME for the Application server. This step is required to facilitate any Web service
clients to use the newly created certificate(e.g. IdentityService).
This import is done with the java keytool command

keytool -import -file /home/oracle/wallet/soavm.cs -keystore $ORACLE_HOME/jdk/jre/lib/security/cacerts -storepass welcome1
Accept with yes
Note: storepass default value 'changeit' is changed to 'welcome1' in the first step.

If you get key already exists then it would have created without alias which goes as mykey alias.

keytool -list -keystore $ORACLE_HOME/jdk/jre/lib/security/cacerts -storepass welcome1
keytool -delete -alias soavm -keystore $ORACLE_HOME/jdk/jre/lib/security/cacerts -storepass welcome1
keytool -delete -alias mykey -keystore $ORACLE_HOME/jdk/jre/lib/security/cacerts -storepass welcome1
keytool -import -file /home/oracle/wallet/soavm.cs -keystore $ORACLE_HOME/jdk/jre/lib/security/cacerts -storepass welcome1 -alias soavm

Done with setup SSL setup for ESB.

Enabling JConsole for Oc4j

2008-12-10T16:58:00.000+05:30

Configuration for enabling Jconsole done in this way:
in opmn.xml for oc4j_soa add these entries:
-Dcom.sun.management.jmxremote=true -XX:+PerfBypassFileSystemCheck
-Dcom.sun.management.jmxremote.authenticate=false
-Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.port=8902

Check for if that port is free and not occupied already
netstat -an|grep 8902

cd $ORACLE_HOME/jdk/jre/lib/management
cp jmxremote.password.template jmxremote.password
vi jmxremote.password
monitorRole manager1
controlRole manager1

Now restart the oc4j and you can now see the memory usage and JVM details usinng the
jconsole application.

More info at:
http://java.sun.com/javase/6/docs/technotes/guides/management/jconsole.html

Checking JVMController memory usage for Forms

2008-12-10T16:47:00.001+05:30

If we want to check memory usage of JVMController for Oracle Forms:

Get the PID of the JVM controler
ps -ef|grep jvm

cd /proc/(PID of JVM)
watch -n1 grep Vm status

There is another tool to check the memory leak /usr/bin/memprof
But so far I am unable to use this to check the memory usage:
I am trying to start the process like this:

/oracle/FR10gR2/bin/dejvm -start jvmcontroller=myconfig

For more info on JVM:
http://download.oracle.com/docs/cd/B14099_19/web.1012/b14032/jvm.htm

Unable to bind socket: Cannot assign requested address

2008-10-23T23:01:00.000+05:30

If you get error when starting the Oracle 10.1.2.X AS using opmnctl
and your oc4j containers are not coming up.

You are getting the following error in the oc4j log in opmn/logs

[libopmnoc4j] DMS gave NULL for host or port or both for port id: rmi
[libopmnoc4j] Port information in the ONS notification is incorrect for proc: 2126512139

Error starting ORMI-Server. Unable to bind socket: Cannot assign requested address

Solution:
A) Check if your IP address or hostname is changed or if there is a conflict of resources in the network

B) It could be that there was some failed transaction and repository is not in proper sync
Once you are sure your network settings for the host are proper issue these commands:

opmnctl start
dcmctl resetdcmcacheport
dcmctl resetfiletransaction
dcmctl resethostinformation
Also it is a good idea to set the Autoarchive of repository
Setting Automatic Archiving to Save 10 Versions
dcmctl set -arch 10

Take a manual backup also:
Create archive and export it to file as below:
dcmctl createarchive -arch 23OCT2008

dcmctl exportarchive -arch 23OCT2008 -f APP4_DCMCTL_23OCT2008.BKP

How to get Thread dump for Forms Applets?

2008-08-13T17:16:00.003+05:30

Enabling the Java Console for Verbose output
Goto->ControlPanel-> Java->Java tab(Java Applet Runtime Settings)->View

Add this in the Runtime Parameters:
-verbose -Djavaplugin.trace=true -Djavaplugin.trace.option=basic|net|cache||security|ext|liveconnect|temp
You can add other optimizing parameters here.

This opens a command window with more info (verbose)
Once you get hang or Crash you will get more info or you can use Ctrl+Break key to dump the curent thread info.

Another tool to get the thread dump is from http://www.adaptj.com

You can then use the TDA to analyze the thread dump.
Thread Dump analyzer
(https://tda.dev.java.net/files/documents/4691/83255/tda-bin-1.6.zip)
https://tda.dev.java.net/ - Home page

To enable more info in the Java console:
Goto->ControlPanel-> Java->Advanced->Debugging (Enable all)
Goto->ControlPanel-> Java->Advanced->Java Console (Show Console)

Also, you can do v in the current Java console to get the Thread Stack

And see if there is any application error listed in the Java/Jinit Console

Managing and Changing the HTTP ports for ORACLE

2008-07-22T01:26:00.000+05:30

If you want to change the Oracle HTTP ports on 9.0.4 or 10.1.2 refer:
This also helps on how to change the ports to 80 on UNIX as it requires root permission on UNIX systems for anything running on port below < 1024.

9.0.4
http://download.oracle.com/docs/cd/B10464_01/core.904/b10376/ports.htm
Changing the Oracle HTTP Server Non-SSL Listen Port (with Web Cache)
Changing the Oracle HTTP Server SSL Listen Port (with Web Cache)
Changing the Oracle HTTP Server Non-SSL Listen Port (No Web Cache)
Changing the Oracle HTTP Server SSL Listen Port (No Web Cache)

10.1.2
http://download.oracle.com/docs/cd/B14099_19/core.1012/b13995/ports.htm

How to fix SMSD Crashes on 1.1.4 iPhone

2008-07-08T22:38:00.001+05:30

The problem with SMSD is it cant understand the old sms.db in /var/root/Library/SMS or /var/mobile/Library/SMS
for the existing system 1.1.4 so it crashes

So, to workaround the problem:

Install the latest Beta version of SMSD from:
a) Using Installer add source SOSiPhone - http://repo.sosiphone.com/
or
b) Manually from Amrut Joshi - SMSD, http://amrut.joshi.googlepages.com/

Do SSH to your iPhone
cd /var/root/Library/SMS
mv /var/root/Library/SMS/sms.db sms.db.old

cd /var/mobile/Library/SMS
mv /var/mobile/Library/SMS/sms.db sms.db.old

Reboot the iPhone, SMSD creates a new sms.db in /var/mobile/Library/SMS

cd /var/mobile/Library/SMS
mv /var/mobile/Library/SMS/sms.db /var/root/Library/SMS/.
cp /var/mobile/Library/SMS/sms.db.old /var/mobile/Library/SMS/sms.db

Now, the normal SMS application reads its DB from /var/mobile/Library/SMS/sms.db with all old data intact.
and Amrut's SMSD reads the DB from /var/root/Library/SMS/sms.db

Hope this helps
Arun

Finding CLASS file inside the JAR files

2008-06-24T00:57:00.005+05:30

Some time we may need to find which JAR file the class file belongs to when we get Class not found Excption and when we dont know which JAR file to add to avoid these errors:

----------------------------------------For Linux ---------------------------
#!/bin/ksh
JAVA_HOME=$ORACLE_HOME/jdk
export JAVA_HOME
PATH=$JAVA_HOME/bin:$PATH
export PATH
if [ $# -eq 0 ]
then
echo "Usage: classfind.sh className path\n"
exit 2
fi
for i in `find $2 -name "*jar" ! -type d -print`
do
result=`jar -tvf $i grep -i $1`
if [ "$result" != "" ]
then
echo $i
jar -tvf $i grep -i $1
fi
done

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

Example:

findJars.sh oracle.ias.cache.Configurator $ORACLE_HOME

------------------------For Windows------------------------------

@echo off

set path=%oracle_home%\jdk\bin;%path%

if %1abc==abc goto :usage

if %2abc==abc goto :usage
for %%i in (jar.exe) do set jarpath=%%~$PATH:i

if not defined jarpath goto :definejarpath
if not exist %2 goto :invaliddir
for /f %%i in ('dir /s/b %2\*.jar') do call :findclass %%i %1

goto :EOF
:findclass

jar -tf %1 | findstr /R "^%2 /%2"

if %errorlevel% == 0 call :echodot %1

goto :EOF

:echodot

echo Found in jar file : %1

echo.

goto :EOF
:usage

echo Usage: findjars.bat className path

goto :EOF
:definejarpath

echo jar.exe not found in the PATH.

goto :eof
:invaliddir

echo Directory/path %2 doesn't exist

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

Example:

findjars.bat oracle.ias.cache.Configurator %ORACLE_HOME%

How to send and read data from JMS queues for testing?

2008-04-14T18:17:00.000+05:30

How to send and read data from JMS queues for testing?

CheckOut:
http://hermesjms.org/confluence/display/HJMS/Home
http://www.hermesjms.com/demos/oems_demo.html

http://mike-lehmann.blogspot.com/2006/09/i-was-working-with-oracleas-jms-over.html

Installing SOA HA with easy steps for Test purpose

2008-04-08T20:31:00.011+05:30

How to Install the SOA HA with simple options using two machines.

NoDMZ, No firewalls, No webcache, No OWSM cluster/Gateway, Easy to setup and use.

The Web and Application Tier Configuration Process
(Modified section of 3.1 for our Installation )
http://download.oracle.com/docs/cd/E10291_01/core.1013/e10294/webapp.htm

The Application Tier (APPHOST1 and APPHOST2) consists of multiple computers hosting middle tier Oracle Application Server instances. Each Oracle home contains multiple Oracle Containers for J2EE (OC4J) instances on which you deploy applications. In the complete configuration, requests are balanced among the OC4J instances on the application tier computers to ensure a performant and fault tolerant application environment.The Web Tier (WEBHOST1 and WEBHOST2) consists of Oracle HTTP Servers.

Naming convention for the MySOACompany topology

Name	Description
WEBHOST1, WEBHOST2	Hosts for the web server nodes. ( same in our case ORA_HOME)
APPHOST1 (matrix), APPHOST2 (bambpel)	Hosts for the application server nodes ( same in our case ORA_HOME) on matrix.oracle.com and bambpel.oracle.com
ORA_HOME1	Oracle home on APPHOST1 and APPHOST2 for the following OC4J instances: OC4J_SOA, OC4J_ESBDT, OC4J_WSM, and Admin.
ORA_HOME2	Oracle home on APPHOST1/2 for the OC4J_GTWY instances. ( same in our case ORA_HOME). Also not clustered and using the Gateway
Matrix.oracle.com	ORA_HOME =/oracle/SOA/SOA10gR3_HA
Bambpel.oracle.com	ORA_HOME =/oracle/SOA/SOA10gR3_HA
Bambpel.oracle.com	DB_HOME /oracle/DB/DB10gR2
Matrix.oracle.com	LBR_HOME /oracle/pen-0.17.2 (Need to run as root for port 80 :LBR port)

For both the machine:
staticports.ini
Oracle HTTP Server port = 7777
Oracle HTTP Server SSL port = 4443
Oracle Notification Server Request port = 6006
Oracle Notification Server Local port = 6100
Oracle Notification Server Remote port = 6201
ASG port = 7893

Multicast for the OPMN: 225:0.0.25 8008
Multicast for the BPEL: 225:0.0.26 8009
(Note: Dont use the same multicast IP as in this example check before
whether it is already in use in your network by pinging.)

My setup is simple, no DMZ areas, two machines matrix and bambpel.
Using same Oracle Home for all OC4J instances on both machine.
Using PEN software LoadBalancer http://siag.nu/pub/pen ( No webcache)
No OWSM cluster as of now and no Gateway installed/configured.
BPEL,ESB-DT and ESB-RT are clustered.
user:oc4jadmin pwd:welcome1

Dell 620 Intel P4 3.2 matrix.oracle.com 2GB RedHat3

Dell 280 Intel P4 2.8 bambpel.oracle.com 2GB RedHat3

The complete installation and configuration process for the Web and Application tiers is detailed in this section.

1.Use the 10g Release 3 (10.1.3.1.0) Oracle Universal Installer to install the J2EE and Web tier Oracle HTTP Servers, specifying the same OPMN cluster:
a) Install an Oracle HTTP Server and Oracle Application Server instance on matrix(ORA_HOME, naming the default OC4J instance ADMIN)
b) Install an Oracle HTTP Server and Oracle Application Server instance on ORA_HOME (ORA_HOME, naming the default OC4J instance ADMIN)
c) Disable the ADMIN OC4J instance on bambpel (ORA_HOME)

2. Using Oracle Enterprise Manager 10g Grid Control Console, create these OC4J groups and OC4J instances, ensuring that the instances are part of the same OPMN cluster:

a) On APPHOST1 (matrix) in the application server instance in ORA_HOME:
· SOA_GROUP (for the OC4J_SOA instances)
· ESBDT_GROUP (for the OC4J_ESBDT instances)
· WSM_GROUP (for the OC4J_WSM instances)
· OC4J_SOA
· OC4J_ESBDT
· OC4J_WSM

b) On APPHOST2 (bambpel) in the application server instance in ORA_HOME:
· OC4J_SOA
· OC4J_ESBDT
· OC4J_WSM
· Leave the default ADMIN OC4J instance in the application server instance of ORA_HOME in the default group
· Leave the default OC4J_GTWY OC4J instance in the application server instance of ORA_HOME in the default group

3. Cluster the Oracle HTTP Server and Oracle Application Server instances
If multicast is a problem, configure static discovery of the cluster
-·Create a gateway for instance discovery, if the instances are not on the same subnet.
(gateway not required as no DMZ and firewalls)
-·Validate and discover the cluster status with the opmnctl status @cluster command

4. Configure the Web server for the load balancer
-·Add these virtual hosts to the Oracle HTTP Servers on matrix and bambpel:

!virtualhost!
ServerName matrix.oracle.com
Port 80
ServerAdmin arun@mymail.com
RewriteEngine On
RewriteOptions inherit
!virtualhost!

5. Configure the load balancer for matrix.idc.oracle.com:80
pen -l pen.log -p pen.pid -h matrix.oracle.com:80 matrix.oracle.com:7777 bambpel.oracle.com:7777
Note: You need to run this as root user, otherwise give root privilage to pen as you do for apachectl.

6. Use the standalone installer, available on the Companion CD (BPEL_10131_B34437-01.zip), to install Oracle BPEL Process Manager
On APPHOST1 (matrix) in the application server instance in ORA_HOME, install Oracle BPEL Process Manager in the OC4J_SOA instance
On APPHOST2 (bambpel) in the application server instance in ORA_HOME, install Oracle BPEL Process Manager in the OC4J_SOA instance
Perform post-installation configuration steps

7. Use the standalone installer, available on the Companion CD, to install Oracle Enterprise Service Bus run time instance (soa_linux_x86_esb_101310.cpio)
On APPHOST1 (matrix) in the application server instance in ORA_HOME, install an Oracle Enterprise Service Bus run time instance in the OC4J_SOA instance
On APPHOST2 (bambpel) in the application server instance in ORA_HOME, install an Oracle Enterprise Service Bus run time instance in the OC4J_SOA instance
Perform post-installation configuration steps

(Optional)
8. Use the standalone installer, available on the Companion CD, to install Oracle Web Services Manager.
-On APPHOST1 (matrix) in the application server instance in ORA_HOME, install Oracle WSM in the OC4J_WSM instance
-On APPHOST2 (bambpel) in the application server instance in ORA_HOME, install Oracle WSM in the OC4J_WSM instance
-Perform post-installation configuration steps, including undeploying applications as appropriate.
-On APPHOST1(matrix) in the application server instance in ORA_HOME, install Oracle WSM in the OC4J_GTWY instance
-On APPHOST2 (bambpel) in the application server instance in ORA_HOME, install OWSM to OC4J_GTWY instance
-Perform post-installation configuration steps, including undeploying applications as appropriate

9. Install the 10.1.3.3 patch set into all of the Oracle Homes.

10. Oracle Enterprise Service Bus repository instance deployment
-·Using the procedure for 10.1.3.3, deploy the Oracle Enterprise Service Bus design time to the repository instance on APPHOST1 (matrix)
-·Using the procedure for 10.1.3.3, deploy the Oracle Enterprise Service Bus design time to the repository instance on APPHOST2 (bambpel)
-·Perform post-installation configuration steps
-·Install and configure adapters as necessary

Checking multicast address

2008-03-25T12:50:00.001+05:30

You can use simple ping command:
ping 224.0.0.1
it shows all the servers using the above ip.

/usr/local/bin/mcfirst -4 -t 5 -c 10 225.0.0.25 6888
http://www.multicast.org.uk/lg/
http://www.venaas.no/multicast/ssmping/

Using VNC with KDE/GNOME Desktop

2008-03-14T12:10:00.000+05:30

Edit the configuration script found in $home/.vnc/xstartup
---------------------------------
xrdb $HOME/.Xresources
xsetroot -solid grey

#Default xterm
#xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
#twm &
#For GNOME
#exec gnome-session &

#For KDE
startkde &
---------------------------------
Create an alias for the server to start
vi $HOME/.bash_profile
alias startvnc='vncserver-depth 24 -geometry 1024x768'
----------------------

Now, start your VNC server using startvnc
To change the passwd: use vncpasswd

To kill a VNC Session:

vncserver -kill :1 ( :1 is 1 display it started )

ons.log.xx huge disk full

2008-02-01T17:32:00.001+05:30

If you see that in $OH/opmn/logs/ons.log.XXX is creating continously with message
Local connection 0,127.0.0.1,6101 missing form factor
then
Edit the file opmn.xml and change line

<port local="6101" remote="6200" request="6003"/>
to
<port local="portno" remote="6200" request="6003"/>

Note: Check which port no in the range from 6102 to 6109 is not being used using

netstat -a|grep and use that port no

Run this command to update the DCM repository

$OMS_HOME/dcm/bin/dcmctl updateConfig -v -d

Migrating ESB from JMS to AQ in 10.1.3.3

2008-01-22T18:20:00.000+05:30

Follow the document at:
http://iasdocs.us.oracle.com/iasdl/101310_final/core.1013/b28939/j2ee.htm#sthref154
Section from 3.1.18 to 3.1.20

Commands I followed:
C:\ORACLE\SOA10gR3\integration\esb\bin\esbdevprompt.bat
ant import-params -Dparamfile=D:\BDE\Integration_BUGS\JMS_ADAPTER_6412053\esbparam.properties -DDB_URL=jdbc:oracle:thin:@//localhost:1521/ORCL -DDB_USER=oraesb -DDB_PASSWORD=oraesb

=====================================================================================Buildfile: build.xml
[echo] ${env.PCHOME}

import-params:
[java] Creating database connection with DB_URL=jdbc:oracle:thin:@//localho
st:1521/ORCL, DB_USER=oraesb DB_PASSWORD=oraesb DB_DRIVER=oracle.jdbc.driver.Ora
cleDriver.
[java] -- listing properties --
[java] PROP_NAME_MONITOR_TOPIC_JNDI=ESBTopics/Topics/ESB_MONITOR
[java] PROP_NAME_ERROR_XATCF_JNDI=OracleOJMS/XATCF
[java] PROP_NAME_ERROR_RETRY_JNDI=ESBTopics/Topics/ESB_ERROR_RETRY
[java] DT_OC4J_HTTP_PORT=8888
[java] PROP_NAME_CONTROL_TCF_JNDI=OracleOJMS/XATCF
[java] PROP_NAME_DEFERRED_TOPIC_JNDI=ESBTopics/Topics/ESB_JAVA_DEFERRED
[java] PROP_NAME_ERROR_TOPIC_JNDI=ESBTopics/Topics/ESB_ERROR
[java] PROP_NAME_MONITOR_TCF_JNDI=OracleOJMS/TCF
[java] PROP_NAME_ERROR_TCF_JNDI=OracleOJMS/TCF
[java] PROP_NAME_INITIAL_CONTEXT_FACTORY=com.evermind.server.rmi.RMIInitial
Con...
[java] PROP_NAME_CONTROL_TOPIC_JNDI=ESBTopics/Topics/ESB_CONTROL
[java] ACT_ID_RANGE=400
[java] PROP_NAME_DEFERRED_TCF_JNDI=OracleOJMS/TCF
[java] DT_OC4J_HOST=dogmatix.idc.oracle.com
[java] PROP_NAME_DEFERRED_XATCF_JNDI=OracleOJMS/XATCF
[java] PROP_NAME_ERROR_RETRY_TCF_JNDI=OracleOJMS/XATCF
[java] Imported parameters from file D:\BDE\Integration_BUGS\JMS_ADAPTER_64
12053\esbparam.properties.

BUILD SUCCESSFUL
Total time: 2 seconds
C:\ORACLE\SOA10gR3\integration\esb\bin>
=====================================================================================

OracleASjms/ESBDeferredTopic
OracleASjms/MyXATCF

Change to

Topic: ESBTopics/Topics/ESB_JAVA_DEFERRED
Topic Connection Factory: OracleOJMS/XATCF

The step 1 to 3 is repeated again as 4-6 in 3.1.20 in document
and also step 16 the JNDI Location name only accepts small case 'ESBTopics' which is 'esbtopics'.

update esb_parameter set param_value='80' where PARAM_NAME='DT_OC4J_HTTP_PORT'
This is if your HTTP port is 80.

Getting "ESBTopics/Topics/ESB_MONITOR not found"
This is becasue in the ESB_PARAMETER table also all the JNDI names are caps ESBTopic change it to esbtopic

Full Features List for 2007 Fall Update for XBOX360

2008-01-16T17:49:00.000+05:30

http://www.xbox.com/en-US/community/news/2007/0408-im.htm
http://www.xbox.com/en-US/support/systemupdates/20071204-features.htm
http://www.xbox.com/en-US/community/personality/elle/20071130-systemupdate.htmhttp://www.xbox.com/en-US/community/personality/directorscut/20071130-newlivefeatures.htm

Checking available Methods, functions in Java Class

2007-12-17T14:58:00.000+05:30

To know all the methods avialable in the Forms Java classes one can use the below command.

For Eg:
set CLASSAPTH=%ORACLE_HOME%\forms\java\frmall.jar;%CLASSPATH%;.
javap oracle.forms.engine.Main

Above command shows all the method present in the Main class.

(javap - the standard Sun .class file printer/disassembler. )

How to Find the CPU and Mother Board Info on Linux and Windows

2007-11-25T00:39:00.000+05:30

How to Find the CPU and Mother Board Info on Linux and Windows

On Windows download the utility from
BELARC http://belarc.com/
EVEREST Free Edition 2.20 -> http://www.majorgeeks.com/download4181.html
CPUID http://www.cpuid.com/cpuz.php

on Linux use the command
dmidecode
cat /proc/cpuinfo

Is it Oracle 10g R2 Forms certified on Itanium 64-bit? I found this installation cd on OTN, is it 64-bit native build? or still is a 32-bit build?

2007-11-16T13:33:00.000+05:30

Question 1)
~~~~~~~~~~~
From certification matrix, 10gAS R2 Forms/Reports are certified on
Windows 2003 64bit. However, we can only find 32bit installation media. Is
there an installation media for Windows 64bit ? If not, does it mean that
the Forms/Reports will run as 32 bit application on the 64bit OS ?

Answers :
~~~~~~~~~
For 64bit on Itanium-2 platform separate CD/DVD available.

For Oracle Application Server releases 10.1.2.x and 10.1.3.x, are certified on Itanium-2 64 bit as native 64 bit application. (32 bit code was recompiled in 64 bit environment).
Altough the below certification link doesn’t mentions components wise whole AS componets are certified as 64 bit native application on Itanium-64.

For Oracle Application Server releases 10.1.2.x and 10.1.3.x, 32-bit native build is certified to run on 64-bit AMD64/EM64T OS.
Ref:
http://www.oracle.com/technology/software/products/ias/files/as_certification_r2_101202.html
http://www.oracle.com/technology/products/ias/pdf/as10gfaq.pdf
http://www.oracle.com/technology/products/ias/pdf/oracleas10g_intel_sod.pdf

Anyway as a client platform Itanium-2 64 and Windows 2003 (64) is not certified.
Refer:
http://www.oracle.com/technology/products/forms/htdocs/10gr2/clientsod_forms10gr2.html
------------------------------------------------------------------------------------

Question2)
~~~~~~~~~
If 10gAS R2 Forms/Reports really run as 32 bit on Windows 64bit, would
the single process limit on windows (2G Byte) apply to Forms/Reports process?

Answers:
~~~~~~~~
Architecturally there is very little reason to worry about this. With Forms each user is connected to their own process each of which will have up to 4gb (or rather 2gb) available. If a single Forms session takes up that much memory you've probably got a bigger problem!
Usually each Forms process frmweb.exe will be using ~10MB for small application and may increase to ~40MB to a very large complex applications.

Refer:
Note:312632.1

What level of Oracle metalik support will I receive if I'm still running a desupported product?

2007-10-31T18:24:00.000+05:30

What level of support will I receive if I'm still running a desupported product?

When a product is technically desupported there are mechanisms in place to ensure that customers will continue (in certain circumstances) to obtain support. These are Extended Assistance Support (EAS) and Extended Maintenance Support (EMS). Please refer to the specific desupport notice for further information.
See http://www.oracle.com/support/premier/lifetime-support-policy.htmlLifetime Support policy Overview under "Learn More" at the bottom of the page for the new Support policy effective September 2005.

Also refer Metalink note if you have the account:
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=184977.1

Spam Virus "W32.Feebs" mm

2007-10-31T17:29:00.000+05:30

"W32.Feebs.D@mm"
I ran the netstat -a as my system was very slow and saw that some foreign address was listed like:
ibucp-vip-d.blue.aol.com:5190.
Then checked using the tcpview from the www.sysinternals.com and found that svchost.exe is trying to make suspcious connection.
Some of the severs like gmail.com yahoo.com etc...

I tried to refresh my system with latest OS Images.
Deleted all partion and installed fresh WinXP but still problem was there so it may be coming up from some gdsus or obiftp servers.

Sometimes explorer crashed with mssu32.dll about which there was no info in the internet.

Sometimes the latest Symantec identified this virus as W32.Feebs.D mm I think this could be a variant of this virus.

From the ProcessExplorer I searched the DLL mssu32.dll and started killing all those threads from the processes.
Rebooted the machine and in safe mode tried the solution given in by deleting the Registry entries
http://www.symantec.com/security_response/writeup.jsp?docid=2006-011111-1747-99&tabid=3
( Find the DLL name first and search in registry and delete those entries)
The port scanning ranges from 1200 to 1300.

Running Oracle Forms using Two midtiers in which one is used as webserver and another as Oc4jServer

2007-10-26T13:44:00.000+05:30

REQUIREMENT:
Running Oracle Forms using Two midtiers in which one is used as webserver and another as Oc4jServer

There are two machines in which one acts as a web server and another acts as Forms server.

There are two setup:
--------------------
1.Web Server containing midtier with only "J2EE and Webcache" installation and Forms Server containing OC4J_BI_Forms in it.

2.Both Web server and Forms Server will contain midtiers with OC4J_BI_Forms

Both the setup has same steps to be followed to solve the issue given below:

Problem:
--------
Client accesses Forms server through Webserver URL.
While accessing the URL from web server,it doesn't route to forms server.
It gives 500 Internal Server Error

Solution:
----------
Web Server details for midtier with J2EE and Webcache installation:
-------------------------------------------------------------------
1.It must have Infratier already installed.
So after that the midtier should be installed with an option
"J2EE and Webcache" (while installing,this option will be asked).

2.This midtier installation will not contain OC4J_BI_FORMS in it.
It only contains,HTTP-Server,Webcache and OC4J in it.

3.Then in this machine,go to $/Apache/Apache/conf/mod_oc4J.conf and
include the OC4J mount point as given below:

Oc4jMount /forms ajp13://:12502
Oc4jMount /forms/* ajp13://:12502
Oc4jMount /forms/frmservlet ajp13://:12502
Oc4jMount /forms/frmservlet/* ajp13://:12502
Oc4jMount /forms/lservlet ajp13://:12502
Oc4jMount /forms/lservlet/* ajp13://:12502

Note:-Replace ,with your forms server ip.Also 12502 is an example for OC4J_BI_FORMS port.

4.After that in $/Apache/Apache/conf/httpd.conf,the parameter UseCanonicalName must be set to Off as:

UseCanonicalName Off

5.a)In standalone HTTP Serverhome $/opmn/conf/opmn.xml

for the opmn "remote" port

For eg:if opmn.xml looks like

remote="6202"
request="6005"/>
[...]

the OPMN remote port is 6202

b)If it is standalone HTTP server,then copy the ons.conf from application server instance to /opmn/conf directory.
Edit the $/opmn/conf/ons.conf file and include the OPMN port in it as given below:

nodes=appserver:port,standaloneserver:6202

6.After the above changes and settings are done,kindly restart the opmnctl with

$/opmn/bin>opmnctl stopall

$/opmn/bin>opmnctl startall

7.Then,make the OC4J down in this web server.ie.,

goto $/opmn/bin>opmnctl stoproc ias-component=OC4J

(HTTP-Server must be Alive)
So that,when Oc4j mount point is seen,it will route it to the Oc4J_BI_FORMS of the Forms server.

8.These are the settings to be done in the Web server level when midtier contains "J2EE and Webcache" installation.

Web Server setup for midtier with OC4J_BI_Forms installed:
-------------------------------------------------------------------
1.The midtier should be installed with an option "OC4J_BI_Forms"
(while installing,this option will be asked).

2.Then in this machine,in $/Apache/Apache/conf/mod_oc4J.conf,
include the OC4J mount point as given below:

Oc4jMount /forms ajp13://:12502
Oc4jMount /forms/* ajp13://:12502
Oc4jMount /forms/frmservlet ajp13://:12502
Oc4jMount /forms/frmservlet/* ajp13://:12502
Oc4jMount /forms/lservlet ajp13://:12502
Oc4jMount /forms/lservlet/* ajp13://:12502

Note:-Replace ,with your formsserverip.Where 12502 is an example for OC4J_BI_FORMS port.

3.In $/Apache/Apache/conf/httpd.conf,the parameter UseCanonicalName must be set to Off.

UseCanonicalName Off

4.a)In $/opmn/conf/opmn.xml

for the opmn "remote" port

For eg:if opmn.xml looks like

remote="6202"
request="6005"/>
[...]

the OPMN remote port is 6202

b)Edit the $/opmn/conf/ons.conf file and include the OPMN port in it as given below:

nodes=appserver:port,standaloneserver:6202

5.After the above changes and settings are done,kindly restart the opmnctl with

$/opmn/bin>opmnctl stopall

$/opmn/bin>opmnctl startall

6.Then,make the OC4J_BI_Forms down in this server.ie.,

goto $/opmn/bin>opmnctl stoproc ias-component=OC4J

(HTTP-Server must be Alive)
So that,when Oc4j mount point is seen,it will route it to Oc4J_BI_FORMS of the Forms server.

7.These are the settings to be done in the Web server level when midtier has OC4j_BI_Forms.

Forms Server Details:
-----------------------------
1.Here,the installation must have middletier with OC4J_BI_FORMS.

2.In opmnctl status it must show :

HTTP-Server,OC4J and OC4J_BI_FORMS Alive.

3.In $/forms/server/formsweb.cfg file,
in parameter archive_jini,serverURL and codebase give the full URL path like :

archive_jini=http://:port/forms/java/frmall_jinit.jar

serverURL=http://:/forms/lservlet

codebase=http://:/forms/java

4.Edit the ons.conf which will be in $/opmn/conf directory file and
include the OPMN port in it as given below:

nodes=appserver:port,standaloneserver:6202

5.Go to $\j2ee\OC4J_BI_Forms\application-deployments\formsapp\formsweb\orion-web.xml

add these virtual paths:

real-path="formsserveroraclehome/forms/java"/>

real-path="formsserveroraclehome/jinit"/>

It must be inside the tags(ie.,before )

6.Restart OPMN with the command:

$/opmn/bin>opmnctl stopall

$/opmn/bin>opmnctl startall

7.These are the only changes to be made in Forms server.

Steps after setup:
-----------------------
After both the settings are done,

Try to access the webserver URL from webserver machine like :

http://webservername:port/forms/frmservlet

The http server of the webserver,taking the Oc4j mount point of forms server from it's mod_oc4j.conf routes to Forms server,Oc4J_BI_FORMS.It must open the form which is present in Forms server.

It will route to forms server machine and when java console is reffered,it will describe that it is loading the jar file from forms server machine.

Tools I use audio,MP3 and Video converter and Others

2007-10-19T18:41:00.000+05:30

VIDEO RELATED
http://www.nchsoftware.com/software/video.html

SWITCH-- AUDIO Converter
http://www.nch.com.au/switch/index.html

PRISM -- VIDEO Converter
http://www.nchsoftware.com/prism/index.html

VIDEO PLAYBACK- VLC Player
http://www.videolan.org/

CHAT:
http://www.pidgin.im/

code39 keyboard HID service cannot be started

2007-10-19T17:39:00.000+05:30

After un-installing the VMWARE software and rebooting my USB Keyboard stopped working in XP.

To repair this error:
1)Run regedit Click on Edit -> Find kbdclass

2) Search through for as many "Upperfilters" you can find.
Mine was under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Class\{4D36E96B-E325-11CE-BFC1-08002BE10318}

3) They most likely have 2 lots of drivers associated with it eg 'tphclhs kbdclass' , usually comes if you have installed VMWARE previously

4) Double click the 'Upperfilter' and delete the other entry except 'kbdclass'

5) Search for all instances of this and change them

6) Go to device manager and uninstall your keyboard - then 'scan for hardware changes'

7) You will most likely need to restart Keyboard should now be working fine.

Webcache Loadbalancing for FORMS an Example

2007-10-03T17:34:00.000+05:30

REQUIREMENT:
------------
To loadbalance two different midtiers using the single webcache.
Use the virtual host name as the hostname to access the Forms from
external Client machines.

SETUP:
--------
1) oblix.idc.oracle.com ----> WebCache Server
2) 10.177.59.10 ----> Form Server 1
3) 10.177.59.45 ----> Form Server 2

STEPS
-------

1)Edit $ORACLE_HOME/webcache/internal.xml add the LOADBALANCE element.
<CALYPSOINTERNALPARAMS>
<HEURISTICS CATELMFACTOR="0.0"/>
<CACHE/>
<SEARCHKEY/>
<INVALIDATION/>
<MEMORYMANAGER/>
<PPC/>
<MISCELLANEOUS/>
<OEMPERFTOOL/>
<LOADBALANCE ON="YES"/>
</CALYPSOINTERNALPARAMS>

Open your Webcache Admin Page oblix.idc.oracle.com:9400/webcacheadmin

2)[-- Origin Servers ---]
First add the Origin Server definition that the servers to which the actual request should goto.

Host Port Routing Capacity FailoverThreshold PingURL PingInterval(seconds) Protocol
----------------------------------------------------------------------------------
oblix.idc.oracle.com 7781 ENABLED 100 5 / 10 HTTP
10.177.59.10 7778 ENABLED 100 5 http://10.177.59.10:7778/ 10 HTTP
10.177.59.45 7780 ENABLED 100 5 http://10.177.59.45:7780/ 10 HTTP
----------------------------------------------------------------------------------

3)[-- Site Definitions -- ]
Now add the site definition and remove all unecessary definitions
Site
----
Host Port URLPathPrefix HTTPSOnlyPrefix URLParameterstoIgnore ClientSideCertificate
----------------------------------------------------------------------------------
oblix.idc.oracle.com 7780 Not Required
www.arunbs.com 7780 Not Required

Aliases
--------
Default Select HostName Port URLPathPrefix
----------------------------------------------------------------------------------
Yes N/A None N/A N/A
Yes N/A None N/A N/A

Note: Here we are using the www.arunbs.com(EXTERNAL) as well as oblix.idc.oracle.com(INTERNAL) access purpose.

4)[-- Site-to-Server Mapping --]
Site OriginServer
----- --------------
Priority HostName Port URLPathPrefix ESIContentPolicy HostName Port Proxy
----------------------------------------------------------------------------------
10.177.59.10 7778 No
1 oblix.idc.oracle.com 7780 /forms/ Unrestricted 10.177.59.45 7780 No

2 www.arunbs.com 7780 Unrestricted 10.177.59.10 7778 No
10.177.59.45 7780 No
----------------------------------------------------------------------------------

Note:oblix.idc.oracle.com may be hosting other application/services so URLPath prefix is used particularly to define Forms site.

5)[-- Session Binding --]
SiteName Session SessionBindingMechanism
----------------------------------------------------------------------------------
oblix.idc.oracle.com:7780 JSESSIONID OC4J-based
www.arunbs.com:7780 Any Set-Cookie Cookie-based
Default Session Binding SessionBindingDisabled n/a
----------------------------------------------------------------------------------
Note:a) You can do the session binding using JSESSIONID(OC4J-based) or
Any Set-Cookie(Cookie-based)
b) In many customers AnySet-Cookie seems to be working in most of the cases.
c)In this example we are using JSESSIONID for internal access and AnySet-Cookie for external purpose
d) Maintain the order of definitions

****APPLY CHANGEs and RESTART the Webcache***********

6) [-- Add the cookie name in both midtiers if using the (AnySet-Cookie) -- ]
[-- 10.177.59.10 and 10.177.59.45 --]
Open httpd.conf set the cookie at the end OR in Virtual host section if you are using the Virtualhost names of midtiers.
------------------------
CookieTracking On
CookieName mycookie
------------------------
NOTE: a)Make sure the cookie name is same in both the midtiers
b)make sure mod_usertrack is enabled as follows:
LoadModule usertrack_module libexec/mod_usertrack

$ dcmctl updateConfig -ct ohs
$ opmnctl restartproc process-type=HTTP_Server

TESTING EXTERNAL
----------------
1) Now, in the client machine edit the hosts file and add entry of ip (oblix.idc.oracle.com) machine as still www.arunbs.com is not in DNS
eg: 10.177.44.63 www.arunbs.com

2) Now make sure in the IE browser proxy is bypassed for this hostname
3) Run the forms URL in two new IE session (keep open both IE):
http://www.arunbs.com:7780/forms/frmservlet?
Check that the request goes to both the midtiers.
If you have different contents in test.fmx you see it goes to different midtiers.
4) Now if you have a hardware external Loadbalancer you can put alias for www.arunbs.com pointing to oblix.idc.oracle.com's IP address and use the external LBR to give access to external clients.
NOTE: You can use many firewalls in-between

References:
--------------
Note 333244.1 Using Oracle Web Cache as Load Balancer
Note 229900.1 Integrating and using Web Cache with Forms 9i for Load Balancing
Note 268830.1 Ext/Pub Webcache Won't Load Balance 2 Forms Instances:
"Advanced Configuration of Oracle Forms"
http://www.oracle.com/technology/products/forms/pdf/10g/advancedformsconf.pdf

Buttons appear very small in forms Builder on UNIX platforms

2007-10-01T18:14:00.000+05:30

To increase your the default size of your Buttons on the Unix Platforms you
need to make changes to a file called T2kMotif.rgb.

This file will be present at the following location :
ORACLE_HOME/guicommon6/tk60/admin/Tk2Motif.rgb (6i)
ORACLE_HOME/guicommon/tk/admin/Tk2Motif.rgb (10g)
Make sure you are making the changes in the correct Tk2Motif.rgb.
( Use DEBUG_SLFIND to find out, eg: export DEBUG_SLFIND=/temp/mylog.txt).

For Eg:
My Linux NLS was AMERICAN_AMERICA.UTF8 so my file found under
$ORACLE_HOME/guicommon/tk/admin/US/UTF8
( I have copied the original Tk2Motif.rgb to UTF8 folder and set Tk2Motif*fontMap: iso8859-1=UTF8)

Here are ths steps you need to follow :
1. Take a backup of this file.
2. Now in the original file find and comment out the following line:
Tk2Motif*pushb.default ButtonShadowThickness: 2

i.e change this line from
Tk2Motif*pushb.defaultButt onShadowThickness: 2
to
!Tk2Motif*pushb.defaultButtonShadowThickness: 2

3. Now in the original file find and uncomment out the following line:
Tk2Motif*expa ndNonDefaultButtons: True

i.e change this line from
!Tk2Motif*expandNonDefaul tButtons: True
to
Tk2Motif*expandNonDefaultButtons: True

4. Now restart your Forms Builder and check if the Buttons Sizes appear
correctly.

Resolving the IP and Hostnames on Linux

2007-10-01T18:06:00.000+05:30

We faced problems in our Database once our IP's got changed.
Although we changed our DB server IP to new IP's our listner was not coming up as it was not able to resolve itself.

Changed the setting in /etc/resolv.conf to reflect correctly the new changes

------------------
nameserver ( New DNS Server name)
nameserver
search ( Domain search path)

64 bit or 32 bit CPU for UNIX?

2007-08-28T13:07:00.001+05:30

64 bit or 32 bit CPU?

Solaris: isainfo -vk
HP-UX: getconf KERNEL_BITS
Linux: For Hardware: cat /proc/cpuinfo For Os Software: uname -m
AIX : uname -M

Sharing FILEs in LINUX and WINDOWS

2007-08-27T19:31:00.000+05:30

SHARING WINDOWS FILES in LINUX
SAMBA
=====
1) Edit /etc/smb.conf

2) service smb restart

3)Goto client machine:
mount -t smbfs -o workgroup=star,username=abavera //incq100ad/oraprod/softwares /mnt/Windows

http://www.samba.netfirms.com/index.htm
webmin --> http://incq068ad.idc.oracle.com:10000/

mount -t smbfs -o workgroup=star,username=abavera //incq099ad/mp3 /mnt/mp3
---------------------------------------------------
SHARING LINUX FILES in LINUX

NFS
===
Example on incq068ad

Make sure NFS service running on both the system:
If not log in as root

su - root
#service nfs restart

1) $vi /etc/exports
/softwares *(rw)

2)$service nfs restart
3)$exportfs -a

Goto incq025ad
mount -t nfs incq068ad:/softwares /mnt

mount -t smbfs -o username=root //incq054ad/myshare /softwares
Passwd:oracle

mount -t smbfs -o username=ias //incq128ad/ias /softwares
Passwd:oracle

NFS BETWEEN SOLARIS & LINUX
If you receive error messages such
as "unknown version" when attempting to
mount a Linux based NFS server from
Solaris, you probably have an
incompatibility between the NFS versions
running on both of them. Linux uses
version 2, while Solaris uses version 3.
In order to get the machines to
communicate, you have to use the vers
option on the Solaris machine as follows:

mount -o vers=2 nfsserver:/remotedir /localdir

Increasing the SWAP on LINUX

2007-08-27T19:28:00.001+05:30

dd if=/dev/zero of=/swap bs=1024 count=1024000
(bs=Block Size) (count= Actual size in Block, here 1GB)

mkswap /swap
swapon /swap

Check the total Swap now
swapon -s

Edit /etc/fstab and make this entry to make the swap mounted every time you reboot.
/swap swap swap defaults 0 0

For refreshing fstab entries
mount -a -o remount

Creating batch ldif users

2007-07-11T19:49:00.000+05:30

----------------------------------------------------------------------------------
i=102
while [ $i -lt 503 ]
do echo "dn: cn=user$i,cn=Users,dc=idc,dc=oracle,dc=com" >> r.ldif
echo "objectclass: top" >> r.ldif
echo "objectclass: person" >> r.ldif
echo "objectclass: inetorgperson" >> r.ldif
echo "objectclass: organizationalperson" >> r.ldif
echo "objectclass: orcluser" >> r.ldif
echo "objectclass: orcluserv2" >> r.ldif
echo "cn: user$i" >> r.ldif
echo "givenname:" user$i >> r.ldif
echo "sn: user$i" >> r.ldif
echo "mail: user$i@bde.idc.oracle.com" >> r.ldif
echo "uid: user$i" >> r.ldif
echo "userpassword: welcome1" >> r.ldif
echo >> r.ldifi=`expr $i + 1`
done
--------------------------------------------------------------------------------

ArunBavera-Think

2007-06-26T15:13:00.000+05:30

FORMS and PERFORMANCE

2007-06-25T17:38:00.000+05:30

PACKETS AND LATENCY
Bytes are grouped together and sent across the network in a unit called a packet. Another key factor
that affects performance is the time it takes a single packet to leave the host and reach the destination.
This factor is known as packet latency.
Packet latency can easily be determined with the use of a common network function called ping. Ping
sends a single packet across the network and back and measures the time it takes for the round trip.
Packet latency is half the time of a ping. If a ping takes .1 seconds, the latency is .05 seconds.
In a typical LAN situation, the packet latency is effectively zero seconds. Under a WAN, this value
varies depending on the type of network that is being used.

A packet latency of 50 - 60ms is considered relatively good.

It is a known fact that the VSAT doesnt gives the consistent continous
connection speed.It largely depends on the weather and climatic condition.

The connection is not consistent and that is the reason you get ash screen
(hang status ).You can monitor this by pinging the Server IP continously by the Branch y and
logging the response time and Data pocket loss information

We have faced the similar problem with many other customer who have tried the
VSAT .And we have recommended them to use either normal lines or broadband through
SATlinks

Form Tips
==========
1)Dont use much Tab canvas with all items showing in all canvas
2)Dont use Timers
3) Package all the GIF's and CLASS in JARs
FORMS90_MESSAGE_ENCRYTPION=false
FORMS90_DISABLE_PLSQL_CANCEL=1
FORMS90_DISABLE_DESCRIBE=1

Network Tips
============

1) The BUG#1951998 FIELD TO FIELD NAVIGATION CAUSES 2 PINGS TO THE APPLICATION SERVER
2) settiing Keep-Alive ON
3) Disabling the cookies Note: 251915.1
4) set NetworkStats=True Note:109597.1 BUG#2046150 ( Supported from Forms 9.0.2.12 Patch2)
to monitor the network statastics

5)serverURL=/forms90/l90servlet/perf (for full stas)
serverURL=/forms90/l90servlet/sessionperf (for summary stats at session end)

6) -Xms200M( Initial Size) -Xmx1000M ( Maximum size)
7) Increasing the TCP Window ( Buffer size) at the client machine modifying registry values to 32K
http://rdweb.cns.vt.edu/public/notes/win2k-tcpip.htm
8) Increase the numprocs (Number of JVM) thumb rule is JVM=CPU*2 in opmn.xml.
9) Use the latest Sun JVM.
10) Use the webCache port for accessing form and use loadbalnacer techniques for J2ee(Oc4j) and Apache

Please try running the Forms Listener Servlet in debug mode by
adding /debug option to the serverURL (/forms90/l90servlet/debug).
This will give detailed information (including HTTP headers) about the
GET/POST requests between
the client and application server in the OC4J application.log file.

Proxy servers may strip out some vital HTTP headers from the GET/POST
requests which may cause Forms to fail. One header to look out for
is "PRAGMA" , which is manipulated or stripped out by some proxies.

Refer:
http://otn.oracle.com/products/forms/pdf/275191.pdf
http://otn.oracle.com/products/forms/pdf/6iscalability.pdf
http://otn.oracle.com/products/forms/pdf/B10170_01.pdf and
http://otn.oracle.com/products/forms/pdf/bestpractices9i.pdf
http://www.microsoft.com/technet/itsolutions/network/deploy/depovg/tcpip2k.mspx
http://otn.oracle.com/products/ias/pdf/performance-best-practices.pdf
http://support.microsoft.com/kb/q120642/
http://rdweb.cns.vt.edu/public/notes/tcpip2000.pdf
Performance & Scalability Team
http://tpsweb.us.oracle.com/
http://isizer2.us.oracle.com
http://velocity-pc.us.oracle.com/collections/Forms9i/
http://www.oracle.com/technology/products/applications/performance/index.html
http://www.oracle.com/technology/products/applications/performance/Applications_Networking_Perspective.pdf

Tuning TCP/IP registry values to improve network performance

2007-06-25T17:36:00.000+05:30

Parameters that affect the IP forwarding performance:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters\ForwardBufferMemory = 296960HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters\MaxForwardBufferMemory = 296960
REG_DWORD, multiple of 256, default 74240. Buffer the IP allocates to store packet data in the router queue. The default value is enough for 50 1480-byte packets.
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters\NumForwardPackets = 200HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters\MaxNumForwardPackets = 200
REG_DWORD, default 50. Number of IP headers allocated for router queue. Should be at least as large as ForwardBufferMemory / IP data size of the network.
Increasing these four parameters can have significant positive effect on throughput especially with 'slow' policies. Also good for FloodGate-1 tuning.
Other TCP/IP stack parameters:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters\TcpWindowSize =65700
REG_DWORD, default 8760 for Ethernet. Larger TCP receive window size will improve performance over high-speed networks. For highest efficiency should be even multiple of TCP Maximum Segment Size (MSS).
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters\MaxFreeTcbs = 0000ffff
REG_DWORD, default 2000, timewait table size
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters\MaxHashTableSize =00004000
REG_DWORD, default 512, TCB hash table size
Increase the number of ephemeral TCP user ports available to applications - prevents the SS from running out of ports:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters\MaxUserPort = 65535
REG_DWORD, default 5000
The following registry settings were made in the sectionHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters• MaxFreeTcbs = dword:0000ffff• MaxHashTableSize = dword:00004000• MaxUserPort = dword:0000fffe• TcpNumConnections = dword:00fffffe• TcpTimedWaitDelay = dword:0000001e• TcpMaxConnectionRetransmission = dword:00000005
Ref:http://www.microsoft.com/technet/itsolutions/network/deploy/depovg/tcpip2k.mspx

MULTIBYTE CHARACTERS WRAP WITH "PDF SUBSETTING" IN UNIX

2007-06-25T17:28:00.000+05:30

AFM file generated with fontforge from sourceforege.net and using TH8TISASCII is giving the same output as Windows.

ttf2pt1 -l plane+0x0E albanWTJ.ttf or FontForge from sourceforge.net.
Font Forge gave better AFM file with correct THAI encoding. This AFM is generating same results as Windows one.

1) Use FontForge, open the TTF file, Choose Encoding -->Force Encoding --> IS8859-11 (Thai)
2) Choose File->Generate fonts to generate AFM,chose type as "PS Type 1 (Ascii). Make sure in the option Output AFM is crossed(checked).
3) After generating the AFM with "fontforge", Change EncodingScheme FontSpecific
4) Check for ASCII using "od -a AlbanyWTJgrep cr" (ref: Note 356221.1) If it returns any row then use command dos2unix AlbanyWTJ AlbanyWTJ
5) Copy the above AFM file to AFM folder
6)Add Entry of Actual Fontname to the datap462.ppd
Set NLS_LANG=AMERICAN_AMERICA.TH8TISASCII in reports.sh make sure REPORTS_ENHANCED_SUBSET=yes

Copied default Tk2Motif.rgb to directory guicommon/tk/admin/US/TH8TISASCII/
Changed the Tk2Motif*fontMapCs: iso8859-1=TH8TISASCII
Copied the albanWTJ.ttf to a folder which is in REPORTS_PATH. .

In the uifont.ali in PDF Subset I have * = "albanWTJ.ttf" Now, generated PDF has same output as Windows.

Adding Fonts to Reports Builder on UNIX

2007-06-22T17:17:00.000+05:30

Adding Fonts to Reports Builder
To build a report in a certain font, the font must be available in Reports Builder from the font picker when you are designing the report. In order for the fonts to appear in the font picker, the fonts should be added to the system or the display on which Reports Builder is running. Please review your operating system documentation for adding fonts before attempting this procedure.
To add Type1 fonts on UNIX:
Get the font-related files from the vendor. These include the PFB, PFA, and the AFM files.
Convert the PFB binary file to PFA ASCII font using one of the available convertors. Typically, you can get such converters as shareware, for example, t1ascii.
Copy the PFA files to the directory where the fonts need to be installed following the instructions for our platform.
Verify the installation of the fonts by entering the xlsfonts -u command. This command lists all the fonts that are available for that system.
If you are using a UNIX emulator like reflection X, the fonts installed on the system may not appear in the xlsfonts command. The reason for this behavior is that it is taking fonts from the font path or the font server, which is configured for this emulator. If using a font server, ensure that, after installing the font, you add the font directory to the font server configuration file and restart the font server. In the emulator, specify the font path to this font server wherever the fonts are installed. If you are still not able to see the fonts in xlsfonts, ensure that the new font directory is the first element of the catalogue in the configuration file.

Start Reports Builder on the display that points to the font server on which these fonts are installed or to the display where the fonts are installed

How To Find The Number Of Open Files for a Process Name and process pid sorted by number of open files.?

2007-06-21T20:01:00.001+05:30

1. Use following script:
lsof perl -lane '$x{"$F[0]:$F[1]"}++;END { print "$x{$_}\t$_" for sort {$x{$a}<=>$x{$b}} keys %x}'

2. Make sure lsof is in your PATH3. Perl can be used from opatch installation.

Opening Form Builder in UTF8 in UNIX

2007-06-21T19:28:00.000+05:30

Although we dont support Unicode on UNIX as X11( Motif Libraries) dont support
unicode, we can bring up the builder like this on Linux:

1) Check the locale -a to see if your Linux supports the language and set the

LANG like this export LANG=en_US.utf8
2) create folder $ORACLE_HOME/guicommon/tk/admin/US/UTF8
3) Copy the $ORACLE_HOME/guicommon/tk/admin/US/Tk2Motif.rgb ./UTF8 folder.
4) Edit Tk2Motif.rgb in UTF folder and set this value Tk2Motif*fontMapCs:
iso8859-1=UTF8
Same applicable for other languages also like Japanese etc.

To list the version of the Binaries or Oracle Developer Product

2007-06-21T14:31:00.001+05:30

To list the version of the Binaries or Oracle Developer Product

For 10g
ls $ORACLE_HOME/inventory/Components21/oracle.developer.reports.builder

For 6i
export TERM=vt220
$ORACLE_HOME/bin/f60gen |head -2

To list all component version
export TERM=vt220
$ORACLE_HOME/bin/f60gen |head -

Finding missing symbols

2007-06-19T15:56:00.000+05:30

Use symfind from ORACLE_HOME/bin directory.

Installing TTF on Linux

2007-06-19T15:49:00.000+05:30

The steps to install the Verdana font manually on Linux:
-----------------------------------------------------------
1)Login as root, Copy the Verdana.pfa file generated from verdana.ttf using
the FontForge.sourceforge.net to the following directory
/usr/lib/X11/fonts/Type1 (the user's font path may be different).

2)Make the necessary changes to the "fonts.dir" file. (NOTE:Make sure to make
a backup of this file before changing it)

There are two ways to do this :
i. Run the executable /usr/x11R6/bin/mkfontdir.
This will update the fonts.dir file with the new fonts installed into the
directory. View the file and make sure the fonts are included, if the fonts
are not, then use the next method.

ii. Modify the fonts.dir file manually by
a) incrementing the number on the first line of the file by 90. The
number represents the number of fonts found in the file.
b) Add the following lines to the file.
"Verdana.pfa -microsoft-verdana-medium-r-normal-*-0-0-0-0-p-0-iso8859-1"
(xfontsel gives the font info)

3) Open the Tk2Motif.rgb and add the font( if you want it to make default
font for builder: Optional):
Tk2Motif*fontList:
-microsoft-verdana-medium-r-normal-*-0-0-0-0-p-0-iso8859-1
4)Run the following command so openwin will rehash with the new font : "xset
fp rehash".

5) Logout and restart your X-Server
( Ctrl+ALT+Backspace kills the X-Server) type startx to start the server.

USEFUL Queries for Tool developers

2007-06-14T15:03:00.001+05:30

select * from v$version; VALID CHRACTERSETselect value from v$nls_valid_values where parameter = 'CHARACTERSET';
select * from session_privs;
select * from user_objects where status = 'INVALID';
select object_name,object_type, status from user_objects where status = 'INVALID';
alter package compile;
select nls_charset_id(value) nls_charset_id, value from v$nls_valid_values where parameter ='CHARACTERSET' order by nls_charset_id(value);
select * from SYS.V_$SESSION
alter system kill session '26,1187'; <>
select SID, SERIAL#,status, username from v$session where username = 'SCOTT'
select username from all_user;
select * from nls_database_parameters; select * from v$nls_parameters;select value from v$nls_valid_values where parameter = 'CHARACTERSET';
select rtrim(sys_context('userenv','current_schema')) from dual;

DB versionselect comp_name,status,version from dba_registry;
DBMS_SESSION.SET_NLS('nls_date_format', '''DD/MM/YYYY''')
select data_type, default_length, data_length, avg_col_len from dba_tab_columns where table_name = 'EMP_PHOTO' and column_name = 'EMP_PHOTO';Why don't you use the utlrp.sql script to recompile all DB objects
select * from v_$sqltext -- To see the SQL in the Text area select * from V_$OPEN_CURSOR --To see the open cursors in databse select v$OBJECT from V$LOCKED_OBJECT col object_name for a40 select OBJECT_NAME,OBJECT_TYPE from user_objects where status = 'INVALID'; select saddr,sid,serial#,server,osuser,process,machine,terminal,program,client_info from v$session;

Mounting USB Drive (NTFS Partitions) on to a RHEL4

2007-06-14T14:37:00.000+05:30

In case you are planning to fix up ur USB Drive (NTFS Partitions) on to a RHEL4 with Kernel Version 2.6.9-5.EL.You will need to do the following:
You'll need 2 files:
kernel-module-ntfs-2.6.9-5.EL-2.1.20-0.rr.4.10.i686.rpm --> RPM / Binaries you need to have NTFS detection.ntfsprogs-1.13.1.tar.gz --> This module is like a driver in windows which will add the related drivers to the kernel.
Download using command like, its actually pretty quick: #wget http://prdownloads.sourceforge.net/linux-ntfs/kernel-module-ntfs-2.6.9-5.EL-2.1.20-0.rr.4.10.i686.rpm#wget http://prdownloads.sourceforge.net/linux-ntfs/ntfsprogs-1.13.1.tar.gz
You need to remember:
The volume names of USB Drive. If not are not aware of you can get from "cat /etc/fstab"
Run lsusb & lsmodlsusb - A utility for displaying information about all USB buses in the system and all devices connected to them.lsmod - A program to show the status of modules in the Linux Kernel.
You need to logon as ROOT user to install both and mount the partitions.
Steps:
1) Once you attach the device to the system.2) Install the "kernel-module-ntfs-2.6.9-5.EL-2.1.20-0.rr.4.10.i686.rpm" & "ntfsprogs-1.13.1.tar.gz"
rpm -ivh kernel-module-ntfs-2.6.9-5.EL-2.1.20-0.rr.4.10.i686.rpm modprobe ntfs
3) Check /etc/fstab you'll see something like this:
/dev/sda2 /media/WD_HDD2 ntfs pamconsole,exec,noauto,managed 0 0 /dev/sda5 /media/WD_HDD1 ntfs pamconsole,exec,noauto,managed 0 0
4) In my case I created 2 folders /WD_HDD1 & /WD_HDD25) mount /dev/sda5 /WD_HDD1 (HDD Volume Name Partition1) 6) mount /dev/sda2 /WD_HDD2 (HDD Volume Name Partition2)
PS: Always remember to umount / unmount the devices before unplugging or shutting them down.

Ref:
http://rahulxarora.blogspot.com/2007/06/how-to-add-usbhdd-having-ntfs-paritions.html

Forms PM's Blogs

2007-06-14T13:10:00.000+05:30

http://www.oracle.com/technology/products/forms/
http://www.oracle.com/technology/software/products/forms/index.html
http://orafaq.com/faq/forms
http://www.geekinterview.com/Interview-Questions/Oracle/Oracle-Forms-4-0
http://www.pitss.com/
Developing application with Oracle Forms in Oracle 9i on Linux
http://sheikyerbouti.developpez.com/index_en/
http://www.smith.umd.edu/dit/oracle/frmrun.htm
Using Oracle Forms on Pegasus
http://pegasus.rutgers.edu/~youssefm/oracle/forms/
Free Oracle Training and Tutorials
oracle forms tutorial - Dev Shed
Forms2Net - Documentation
Performance Test Tool for Oracle Forms - TestNext Software & Services
A JDEVELOPER PRIMER FOR ORACLE FORMS DEVELOPERS
White Paper On Oracle Forms Java Migration Oracle Forms To Java ...
http://www.oratransplant.nl/oracle-forms-as-web-component

Forms BLOGS-Forums-Community
http://www.orablogs.com/fnimphius/
http://www.groundside.com/blog/content/DuncanMills/
http://www.groundside.com/blog/content/GrantRonald/
http://www.oracle.com/global/de/community/forms/index.html
http://forums.oracle.com/forums/forum.jspa?forumID=82

E-Business Suite
http://blogs.oracle.com/schan/

Forms PJC's
http://fdegrelle.over-blog.com/article-4153733.html
http://forms.pjc.bean.over-blog.com/
http://groundside.com/blog/DuncanMills.php?s=PJC
http://groundside.com/blog/GrantRonald.php?s=PJC

What software is installed?

2005-01-11T17:47:00.000+05:30

=====================================================================================
What software is installed?
Solaris

/bin/pkginfo -l | grep -i "software title"

example: /bin/pkginfo -l | grep -i compiler

HP-UX

/usr/sbin/swlist -l fileset | grep -i "software title"

IBM AIX

SMIT or lslpp -w | grep -i "software title"

SAMBA and NFS

2005-01-11T17:28:00.000+05:30

=====================================================================================
SAMBA
======

1) Edit /etc/smb.conf

2) service smb restart

3)Goto client machine:
mount -t smbfs -o workgroup=star,username=abavera //incq100ad/oraprod/softwares /mnt

http://www.samba.netfirms.com/index.htm
webmin --> http://incq068ad.idc.oracle.com:10000/

mount -t smbfs -o workgroup=star,username=abavera //incq099ad/mp3 /mnt/mp3

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

NFS
===
Example on incq068ad

Make sure NFS service running on both the system:
If not log in as root

su - root
#service nfs restart

1) $vi /etc/exports
/softwares *(rw)

2)$service nfs restart
3)$exportfs -a

Goto incq025ad
mount -t nfs incq068ad:/softwares /mnt

mount -t smbfs -o username=root //incq054ad/myshare /softwares*
Passwd:oracle

To view ORACLE_HOME files from browser

2005-01-11T17:23:00.000+05:30

==================================================================================== To see all your UNIX Application server ORACLE_HOME directory structure from browser:

Create a softlink for your ORACLE_HOME in the htdocs directory which is your document root

For eg:
------
ln -s $ORACLE_HOME oraclehome

then access from your browser like this

http://abavera.oracle.com:7777/oraclehome/

X version

2005-01-11T17:12:00.000+05:30

=====================================================================================
X version
=========
Linux:

vi /etc/redhat-release
uname -a
Kernel 2.4.9-e.3

rpm -qa|grep openmotif

openmotif-2.1.30-4_MLI 7.1
openmotif-2.1.30-11
openmotif-devel-2.1.30-11

Solaris:
pkginfo -l |grep CDE
pkginfo -l SUNWxwrtl -v

HP-UX:
sam

IBM RS/6000 AIX:
smit
lslpp -L|grep Motif

At Developer6i build time these versions are used:
AIX - Motif 1.2.3
Tru64 - Motif 1.2
HPUX - Motif 2.1
Linux - Motif 2.1
Solaris -OpenWin 3

File and Directory Sizes on UNIX

2005-01-11T17:01:00.001+05:30

=====================================================================================
To check Directory size

$du -d -k -s /ho2/usupport/Patch9
1085759 /h02/usupport/Patch9

$du -shmc /softwares
15G /softwares

$df -kah
$du -ka

SUN SOLARIS
$df -kab

FINDING MORE LARGE FILES

To find out the large files
on a file system.

find / -xdev -size +1024 -exec ls -al {} \; | sort -r -k 5

To check Disk free size

$df -m -h

$df -k -h
$du -ka

http://www.cyberciti.biz/faq/find-large-files-linux/

Network Port Utilities and other utilitis

2005-01-11T16:44:00.001+05:30

=====================================================================================
Network Ports
===============
Windows
--------
You can use fport, or on XP netstat -o to determine which process has the open socket.

Tool Description
pulist:
This command-line tool displays processes running on local or remote computers. PuList is similar to TList (a Support Tool on the Windows 2000 CD), but also lists the user name associated with each process on a local computer. Part of the Windows 200 resource kit

pstat:
PStat is a character-based tool that lists all running threads and displays their status. This tool is similar to Qslice.exe, but uses a command-line rather than a GUI interface. Part of the Windows 200 resource kit

fport:
Similar to lsof on UNIX - lists pid associated with an open port. WIN32. netstat -o on Windows XP is similar.

Inzider:
Similar to fport & lsof

Moriarty:
An NT diagnostic utility to determine DLL an exception occured in. WIN32.

Listdllss:
Free DLL Diagnostic Utility. WIN32

Strace :
An 'truss' diagnostic utility for WIN32. Works on NT, but doesn't seem to work on all WIN2000.

TCPTune: A TCP stack uner for WIN98/NT/95
Process Explorer:
Find out what files, registry keys and other objects processes have open, which DLLs they have loaded, and more. This uniquely powerful utility will even show you who owns each process. Windows NT/2K

Regmon: This monitoring tool lets you see all Registry activity in real-time. It works on all versions of WinNT/2K as well as Windows 9x/Me and full source is included. Can be used to debug, say OUI during an install for example.

userdump: Produce a dump of a process. A stack trace can then be produced from this, using a debugger like windbg

windbg: Windows debugger
PageHeap: The PageHeap utility can be enabled for applications so that all malloc, new, and heapAlloc allocations are monitored automatically for memory errors.

fsum: FastSum is a checksum utility similar to 'sum' on UNIX
Secure Shell: Various SSH utilities are available here, including PuTTY. A graphical SSH is available here

See also
http://www.sysinternals.com/
http://www.petri.co.il/
http://www.petri.co.il/download_free_reskit_tools.htm - Windows 2000 Resource Kit

UNIX
=====
netstat -a --program |more --> To check which program occupied which port
netstat -utp
netstat –utpn
netstat -tulpn

or
lsof
Lsof - List open files (including ports)
Lsof is a UNIX-specific tool. Its name stands for LiSt Open Files, and it does just that. It lists information about files that are open by the
processes running on a UNIX system. Among other things, it allows you to determine which process id and name is associated with a socket.

lsof -p 3396
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
f60srvm 3396 usupport cwd DIR 3,3 4096 1194419 /oraprod/dev6i
f60srvm 3396 usupport rtd DIR 3,3 4096 2 /
f60srvm 3396 usupport txt REG 3,3 36908 2650350 /oraprod/dev6i/bin/f60srvm
f60srvm 3396 usupport mem REG 3,3 494474 2910664 /lib/ld-2.2.4.so
f60srvm 3396 usupport mem REG 3,3 66037 2910677 /lib/libdl-2.2.4.so
f60srvm 3396 usupport mem REG 3,3 626018 3041482 /lib/i686/libm-2.2.4.so
f60srvm 3396 usupport mem REG 3,3 531781 3041484 /lib/i686/libpthread-0.9.so
f60srvm 3396 usupport mem REG 3,3 5790313 3041480 /lib/i686/libc-2.2.4.so
f60srvm 3396 usupport 0r CHR 1,3 66860 /dev/null
f60srvm 3396 usupport 1u CHR 136,4 6 /dev/pts/4 (deleted)
f60srvm 3396 usupport 2u CHR 136,4 6 /dev/pts/4 (deleted)
f60srvm 3396 usupport 3u IPv4 29264 TCP *:9000 (LISTEN)
f60srvm 3396 usupport 4u unix 0xec3bf080 29265 socket

How will you check the port occupied.
** netstat -a|grep 9000

netstat -a --program |grep f60srvm

Linux Services

chkconfig –list

ntsysv