tag:blogger.com,1999:blog-8024749156431883032Thu, 29 Aug 2024 12:27:23 +0000BPELOracleSOA SUITEESB11.1.1.711gALSBOSBOracle Service Busem consoleupgrade1013311.1.1.411117Composite pageSOASQL ServerXPathdatabaseementerprise managersoa suite 11g11.1.1.611114BPEL ConsoleDB ConnectionDEBUGDVMDatabaseTable(ADDRESS)E-Business SuiteExceptionFTP AdapterFile ArchiveForms ModernizationFusion Middleware High AvailabilityJDeveloperMS SQL ServerMS SQL Server 2008 R2OC4JOPMNORASDPMOracle FormsOracle WebcastSDP-25088SDPMSOA Suite ClusterSQL DeveloperSQL Developer 3TNSListenerTOPLINK-106User Messaging ServiceXEXMLXSLcachingcompositeconnectiondatetimedownloadindexjdbc 4jtdspatachsearchsetSuccessStatusTypesuccessstatustypeMy thoughts and work on SOA; mainly on Oracle FMW Stackhttp://soasphere.blogspot.com/noreply@blogger.com (Anonymous)Blogger20125tag:blogger.com,1999:blog-8024749156431883032.post-6879485254091904379Fri, 25 Oct 2013 11:48:00 +00002013-10-29T15:50:54.292+05:3011.1.1.71111711gDatabaseTable(ADDRESS)emem consoleenterprise managerORASDPMSDP-25088SDPMsetSuccessStatusTypeSOA SUITEsuccessstatustypeTOPLINK-106upgradeUser Messaging Service problem: After upgrading current 11.1.1.4 environment to 11.1.1.7, observed below errors in SOA server Logs. This error comes every time while starting of each of the SOA managed servers.  <Error> <oracle.sdp.messaging.engine> <SDP-25088> <Unable to refresh the driver locator cache, due to the following error: Exception Description: The method [setSuccessStatusType] http://soasphere.blogspot.com/2013/10/the-successstatustype-must-be-of.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-3011458932222336851Fri, 25 Oct 2013 03:52:00 +00002013-10-25T09:25:02.234+05:3011.1.1.411.1.1.611.1.1.7111141111711gcachingComposite pageemem consoleenterprise managerFusion Middleware High AvailabilitySOA SUITEsoa suite 11gSOA Suite Clusterupgrade After upgrading the SOA Suite 11.1.1.4 cluster server to 11.1.1.7 (PS6), it is observed that the em Enterprise Manager Console (em console) is loading very slow and sometimes takes more than 120 seconds. Sometimes, trying to access any composite link will time out and leads to em home page again. In short, Fusion Middleware Control UI performance goes unpredictable in upgraded environment. Log http://soasphere.blogspot.com/2013/10/enterprise-manager-performance-very.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-3071339123349790469Thu, 24 Oct 2013 10:57:00 +00002013-10-24T23:53:42.159+05:30connectiondatabasejdbc 4jtdsMS SQL ServerMS SQL Server 2008 R2SQL DeveloperSQL Developer 3SQL Server First, if you are using older version of SQL Developer like 3.0 or earlier, and database older than SQL Server 2008, you can also try the steps from the video as Oracle has recommended @ http://www.oracle.com/technetwork/developer-tools/sql-developer/sql-server-connection-viewlet-swf-089886.html. So, how to create a SQL Server  2008 R2 connection in SQL Developer 3.2.20.09. http://soasphere.blogspot.com/2013/10/connecting-oracle-sql-developer-32-to.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-339773802033528321Thu, 07 Apr 2011 19:57:00 +00002013-10-25T17:40:56.235+05:3011.1.1.411.1.1.7BPELcompositeComposite pageem consoleindexsearchsoa suite 11g Problem: I have migrated my 10g BPEL processes to 11g. Few BPEL processes, based on input values they receive, sets the 1 to 6 index values. For a process where instance volume is higher/large, it is easy to search the instance using the index value. In 10g, I used to search on BPEL Console --> Instances tab, using "Index/Custom Key" text box. But as soon as I went to 11g, I found http://soasphere.blogspot.com/2011/04/how-to-serch-composites-for-index.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-6756556535947845057Mon, 10 Aug 2009 19:42:00 +00002009-08-11T15:26:13.921+05:30downloadOraclepatachSOA SUITEThe page is http://www.oracle.com/technology/products/soa/soasuite/collateral/downloads.html is available on OTN describes the all the versions 10.1.3.x and 11gR1. All the versions for SOA Suite, related patch numbers and those details are available on the page.Take a tour of that page...http://soasphere.blogspot.com/2009/08/release-downloads-for-soa-suite.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-4185206655237856634Mon, 10 Aug 2009 05:07:00 +00002009-08-12T18:55:12.330+05:30BPELdatabaseOracleSOA SUITETNSListenerXEIn certain cases we need to install the Database XE again. Specially when I am installing a new SOA Suite server. While uninstalling the XE, if any of your XE services are UP, your re-installation gives problem with TNSListener service startup.you can do this,1) Delete any of the following services if they exist in your Control Panel -> Administrative Tools -> http://soasphere.blogspot.com/2009/08/tnslistener-not-starting-while-re.htmlnoreply@blogger.com (Anonymous)1tag:blogger.com,1999:blog-8024749156431883032.post-142780324532675143Fri, 24 Jul 2009 09:16:00 +00002009-08-12T18:55:40.308+05:30BPELESBFile ArchiveFTP AdapterOracleSOA SUITEJDev n SOA Suite 10134.The reason that FTP Adapter failes to archive the files may be absense of archive directory or lack of privileges to write in that directory. In such cases, 1) Check the logs at domain.log2) SOA Suite in case of failure of archiving to given directory, archives the file at SOA_HOME/j2ee/home/fileftp/defaultArchive/3) the file name will be stored with a suffix of http://soasphere.blogspot.com/2009/07/ftp-adapter-failed-to-archive-files.htmlnoreply@blogger.com (Anonymous)1tag:blogger.com,1999:blog-8024749156431883032.post-2279566586834976071Wed, 22 Jul 2009 15:29:00 +00002009-07-22T22:09:22.745+05:301013311gSOA SUITEupgradeHiii there,It has been an opportunity for me now to start writing again in my blog with SOA Suite 11g release.I have already installed SOA Suite 11g successfully and created few processes on that, but that gave me a thought that why I should upgrade from 10.1.3.4 to 11g quickly ?I think it is not wise to make hurry and move to 11g platform. Few reasons for that may be,Moving to 11g platform can http://soasphere.blogspot.com/2009/07/upgrade-to-soa-suite-11g-will-i-go-for.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-4521966084528881809Tue, 16 Dec 2008 18:55:00 +00002008-12-17T00:39:10.586+05:3010133BPELBPEL ConsoleI agree that working with SOA Suite 10133 with Basic installation and configuration based on Olite keeps you busy searching for solutions to the issues you face.On my Vista Enterprise I installed 10131 basic installation and applied the patch for 10133. Also completed the post-installation task. When I opened my BPEL Console, as I expected I could not see the flow in the instances. But the http://soasphere.blogspot.com/2008/12/activities-tab-in-bpel-pm-10133-shows.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-3950883987229338851Mon, 01 Dec 2008 09:56:00 +00002008-12-01T15:45:49.211+05:30BPELExceptionOracleI was testing Remote exception and Binding exception for my sample BPEL Process and thought to put the post here.My BPEL process "exceptionRB" looks like below and calls another BPEL Process "Hello1".To create the Remote and Binding exception I played with the "Hello1" BPEL Process.To generate Remote Exception, turn the process state of "Hello1" process to "OFF" from manage tab on BPEL console (http://soasphere.blogspot.com/2008/12/generating-remote-and-binding-exception.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-8450281441830798329Sat, 15 Nov 2008 17:26:00 +00002008-11-16T00:16:29.293+05:30BPELdatetimeOracleXPathXSLIf you are require to use lots of datetime values, then you may also need to manipulate those different datetime values. Manipulating XPath 2.0 functions may be a problem. For this, You may refer to blogs by Ramkumar Menon and Antony Reynolds.I'm using XPath 2.0 functions to get date and time in BPEL Process. You can get more information about XPath 2.0 here. Below is the example I have createdhttp://soasphere.blogspot.com/2008/11/calculating-difference-between-2.htmlnoreply@blogger.com (Anonymous)1tag:blogger.com,1999:blog-8024749156431883032.post-8814037320207165730Mon, 03 Nov 2008 18:01:00 +00002009-11-03T16:05:38.873+05:30DB ConnectionJDeveloperOracleSQL ServerHere is a small example on how to create a SQL Server Connection on JDeveloper.First of all you will need the sqljdbc.jar. You can download it from the Microsoft site. sqljdbc.jar is available across different versions SQL Server 2000, SQL Server 2005, etc. I'm connecting to SQL Server 2K here using JDeveloper 10133.Once downloaded, we need to add it to the JDeveloper Libraries. I have listed http://soasphere.blogspot.com/2008/11/connecting-sql-server-from-jdeveloper.htmlnoreply@blogger.com (Anonymous)2tag:blogger.com,1999:blog-8024749156431883032.post-3128984198973634531Wed, 01 Oct 2008 06:57:00 +00002008-10-01T13:40:57.878+05:30E-Business SuiteESBOracle WebcastAs a follow-up to OpenWorld, for those of you that could not attend, Oracle is hosting a live Webcast next week on Tuesday, 7-October 9AM PDT (5PM BST, 21:30 India Standard Time) "Leveraging the Enterprise Service Bus with E-Business Suite".You can find further details here on oracle site.I got this info as I've subscribed to Juliana Button's Oracle blog.See you in the WebCast.CheersNiravhttp://soasphere.blogspot.com/2008/10/oracle-webcast-fusion-middleware-for-e.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-2369411427223560571Sun, 28 Sep 2008 08:58:00 +00002008-10-01T13:36:28.654+05:30ALSBESBOracle Service BusOSBThis post would be the first and last post in the series where we will create the ALSB example and call the BPEL service on SOA Suite. Hope you have ceated the local server instance and after starting the server you are able to view the ALSB console at http://localhost:7001/sbconsole as per my last post. For my example, today I have created seperate server instance at port 7041, but you can http://soasphere.blogspot.com/2008/09/oracle-serivce-bus-alsb-day-3.htmlnoreply@blogger.com (Anonymous)2tag:blogger.com,1999:blog-8024749156431883032.post-1943547471729468118Sat, 27 Sep 2008 19:59:00 +00002008-10-01T13:34:53.923+05:30ALSBESBOracle Service BusOSBI'm back with next episode of ALSB. Sorry for the delay in posting this. I have decided to discuss architecture post to hands-on. Today, we will discuss how we can create server/ server domain in ALSB. This will also help to get familiarized with environment. So, why we need to create this server? This is to define a local server instance which we can use to deploy our resources to. Once the http://soasphere.blogspot.com/2008/09/oracle-serivce-bus-alsb-day-2.htmlnoreply@blogger.com (Anonymous)1tag:blogger.com,1999:blog-8024749156431883032.post-3785504988675598241Sat, 27 Sep 2008 19:52:00 +00002008-09-28T12:07:50.494+05:30ALSBESBOracle Service BusOSBOracle's FMW strategy is out long back and OSB(Former ALSB) is the way going forward in terms of Oracle's Enterprise Service Bus product. Also, to notice that on SOA Suite link on oracle, they have already included included OSB as an individual product. so, here I'm startingsmall series of posts on OSB that covering introduction, features, architecture, configuration and sample tutorial http://soasphere.blogspot.com/2008/09/oracle-service-bus-alsb-day-1.htmlnoreply@blogger.com (Anonymous)3tag:blogger.com,1999:blog-8024749156431883032.post-535538727383075967Sat, 27 Sep 2008 16:43:00 +00002008-09-28T00:02:07.183+05:30BPELForms ModernizationOracle FormsSOAI was reading about Forms Modernization on OTN. There are some links to good white papers and articles are available about Oracle Forms modernization; specially EuroTransplant and Griffiths Waite. Thought to put a post of my idea about how this process is executedThe key reasons for Form’s modernization could be:Retain the current InvestmentsWith continued support and investment in the http://soasphere.blogspot.com/2008/09/oracle-forms-modernization-with-fusion.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-38138911565609027Tue, 23 Sep 2008 18:39:00 +00002008-09-25T19:50:14.436+05:30XMLXPathWas reading w3schools.com in order to learn more concepts of XPath and thought to create a post as extracting information from tutorial. Here is some ready information on XPath.What is XPath?XPath is a syntax for defining parts of an XML document XPath uses path expressions to navigate in XML documents XPath contains a library of standard functions XPath is a major element in XSLT XPath is a W3C http://soasphere.blogspot.com/2008/09/revisiting-xpath.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-7155245106364272838Tue, 23 Sep 2008 18:07:00 +00002008-09-24T00:28:19.112+05:30DEBUGOC4JOPMNSOA SUITEWhen OC4J is installed as a component of Oracle Application Server, OC4J system properties must be manually added to the opmn.xml configuration file. The file can be found at \opmn\conf directory. Options will be passed to managed OC4J instances at startup. Set Java system properties in the element where the id attribute is java-options. This element is enclosed within the subelement of http://soasphere.blogspot.com/2008/09/debug-properties-for-oc4j-configuration.htmlnoreply@blogger.com (Anonymous)0tag:blogger.com,1999:blog-8024749156431883032.post-4589387728265345991Tue, 23 Sep 2008 08:10:00 +00002009-08-19T01:58:28.300+05:30DVMESBOracleSOAFirst of all, DVM is one of the features that will remain as a part of Oracle Service Bus in future. But yes, I’m not going to discuss how to create Domain Value Mapping (DVM) in ESB control. I will try to put some other information I have been working on and I have observed.In a real time scenario there it is very common that two applications being integrated use two different values to http://soasphere.blogspot.com/2008/09/domain-value-mapping-in-oracle-esb.htmlnoreply@blogger.com (Anonymous)2