Digital Transformation . API . Integration . IAM

Oracle Database 12c RAC In this post I'll list down the stepwise process to create a JNDI connection with Oracle RAC (Real application cluster) database. Following are the steps of the same- Step 1 Login to Weblogic server console. Navigate to left pagination menu and select data sources. Now, create a new data source connection with type- GridLink   Step 2 Specify the connection & JNDI name- Step 3 Set transaction(s) type- Step 4 Specify various GridLink options- Step 5 Setting connection properties- Step 6 Testing the connection specified in step 5 Step 7 Now click on Test All Listeners if you fill everything correctly you will come up with “connection test for jdbc…. Succeeded ”. Step 8 Now check FAN Enabled .which means  Fast Application Notification (FAN) that is a high availability notification mechanism that Oracle RAC uses to notify other processes about cluster configuration and service-level information, including status c...

Recently I have been doing the setup of Oracle Middleware products where I came across two type of data sources that are recommended for RAC database connectivity. They are- Active Grid Link/Grid Link Multi Data Source The question arises which one should I use and why? And, the answer is - Active Grid Link (AGL) Below are some facts provided by Oracle- AGL is a superior implementation to Multi Data Source (MDS) for supporting RAC clusters. The following section provides additional information on the benefits of AGL data sources. AGL: Requires one data source with a single URL. Multi data sources require a configuration with n generic data sources and a multi data source. Eliminates a polling mechanism that can fail if one of the generic data sources is performing slowly. Eliminates the need to manually add or delete a node to/from the cluster. Provides a fast internal notification (out-of-band) when nodes are available so that connections are load-balanced to...

In this post, I'll share the solution that worked for a SOA composite runtime error. I have created a soa composite with a WebService component, a mediator and a database adapter. Below error encountered during the composite web service test- Error JCA Resource , Error Oracle Mediator , ORAMED-03503: [Transaction Commit] Unable to commit transaction , Transaction has - been rolled back , XA JCA Resource SOLUTION Below solution worked for issue resolution- The issue was majorly associated with JDBC connection profile created in weblogic server. So we need to fix this inside weblogic console as per the below steps- 1. Login to weblogic server console- http://192.168.0.112:7001/console and navigate to Data Sources and click on that data source. In my case it is 'DBConnLocal06102017'. 2. Go to configuration tab and click on Transaction sub-tab. Check (mark) on 'Support Global Transactions' and select 'Emulate Two Phase Commit' option. 3. Just sav...

In my this post, I'll share the details how can you insert a new line character in your XPath expression during assignment (assign activity in BPEL). So let's get started- In this post, I am using BPEL2.0, JDEV11g, Oracle Database12c 1. Create a new SOA composite application and add a new soa peoject- Calling SPViaBPEL 2. Drag a new database adapter in composite swim lane (external references) 3. Start DB adapter configuration as below-   4. Provide DB Adapter Service name-  5. Select existing database connection to oracle database or create a new then select the same. Make sure your JNDI configuration exists in weblogic server outbound connection pool.  Please refer https://k10middleware.blogspot.in/2017/05/oracle-weblogic-server-new-data-source.html for creating a new data source in weblogic.   6. Select schema then procedure from browse option(packge.procedure_name) 7. Continue with default values. 8. Finish it. 9. Create a new BPEL process with new schem...