OPatch command error, Oracle SOA 12c opatch commad

I was executing opatch command to know about version but I had been facing the following error. I could not understand why is it happening. Then I used the correct path of JDK with below command an it worked.
[oracle@bpm01 OPatch]$ ./opatch lsinventory
Exception in thread "main" java.lang.UnsupportedClassVersionError: com/oracle/cie/gdr/external/InventoryException : Unsupported major.minor version 51.0
        at java.lang.ClassLoader.defineClass1(Native Method)
        at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
        at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
        at java.net.URLClassLoader.defineClass(URLClassLoader.java:283)
        at java.net.URLClassLoader.access$000(URLClassLoader.java:58)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:197)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
        at oracle.opatch.OPatch.main(OPatch.java:548)

OPatch failed with error code 1
[oracle@bpm01 OPatch]$

Here is the command with JDK path in linux

[oracle@bpm01 OPatch]$ ./opatch lsinventory -jdk /usr/java/jdk1.7.0_75

OPatch Version : 13.2.0.0.0
  OUI  Version : 12.1.0.1.0
The OPatch version is not applicable for current OUI version.

Since OUI Version starts with 12.1, Please go to 'My Oracle Support' and get right OPatch 12.1.*.*.* based on patch 6880880, release version 12.1.0.0.0 and appropriate platform.
 I hope it could be helpful if someone faces this issue.

Read More

Oracle SOA Suite 12C search Instances by Flow ID

Well, its very simple post but you can face problem when use Oracle SOA suite 12c to search specific instance by using Flow ID  . If you have worked with Oracle SOA suite 11g, You would have observed search criteria which is very simple but in 12C, search criteria is little advance. I want to search instance by using Flow ID but in first glance I could not.

To do this click on Add/Remove filters in search window and then check flow instance. Default this option is unchecked but I think it should be checked. Following is the screenshot for detailed description.

Read More

'javac' is not recognized command error while compiling Java program

I created a Java program and tried to compile it by command line via following command but it gave me the following error
E:\Java>javac HelloClass.java
'javac' is not recognized as an internal or external command,
operable program or batch file.

So what was wrong in it? To compile Java program we need to set JDK path instead of JRE that was in my case.  So I simply set the JDK path via following command and then I compiled my program it worked fine.


E:\Java>set PATH="C:\Program Files\Java\jdk1.7.0_75\bin"

E:\Java>java -version
java version "1.7.0_75"
Java(TM) SE Runtime Environment (build 1.7.0_75-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.75-b04, mixed mode)

E:\Java>Javac ForLoopPrintStars.java

E:\Java>

Read More

Unlock user command for Oracle Database

Sometime a user gets locked and can not log in to database. To unlock it we need to run following command.

SQL> alter user username identified by Password account unlock;
User altered.
SQL>

Read More

Oracle SOA file adapter example part 2

Continuing from previous part Oracle SOA file adapter examples using mediator, will will now configure File Adapter to write file.

1)  Drag and drop a file adapter in External references lane. Name it as "WriteFileAdapter" click next and then again next on operation window select Write File. Click next again and on file configuration window give directory path where you want to write your file like i did and also give file naming convention.

2) Click next to move on Messages window. click browse for schema file icon and select Writefile from OutputData.xsd. click next and finish the file creation wizard.your composite will now look like as shown below.

3) Now double click on your Mediator component "RouteRequest" It will open .mplan file, click on green + icon and select static routing rule. A popup will come then click on service as we are going to call a service.

4) From preferences select write under WriteFileAdapter. Now we will create a mapping file to map input and output files. Click on transform icon and create a new mapping file as shown below.

 6) Now map firstName with fName and lastName with LName as shown below

7) Now deploy your project on SOA server by directly using JDeveloper or create an SAR file and deploy manually. I suppose you have an idea how to deploy composite on server.
Copy the below lines and create new xml file, then put this file to your file reading directory wait at least some seconds max 1 minute. Your file will get delete from read file directory and will be written in your output file directory, Please check to verify. Lets see instance on enterprise manager.
XML file to use

<?xml version="1.0" encoding="UTF-8" ?>
<!--  $Header: sampleinput.xml 18-may-2007.04:44:38 mahnaray Exp $ -->
<ReadFile xmlns="http://TargetNamespace.com/readFile">
   <ReadFiles>
      <FirstName>Muhammad</FirstName>
 <LastName>Nasir</LastName>
   </ReadFiles>
</ReadFile>

You can expand flow trace to check process execution. Now you can check your write file directory as shown below.

Now you have learned how to configure SOA file adapter for file read and file write. You have learned how to configure and use Oracle Mediator and how to create transformation file. Please don't hesitate to comment if you find any problem.

Read More

Oracle SOA File read and Write example using Mediator and File Adapter

The main aim of this post is to show how we can use Mediator in SOA suite and how to configure file read and write adapters. This case could be useful in many cases. This is just a sample example and in real world you can design more complex scenarios using Mediator component. But this post will give you good information how to work with Mediator.

In this post we are going to read an xml file using read operation of file adapter and then we will write this to a file by using another file adapter component.

1) Create a new SOA application using JDeveloper and give name as "SampleFileReadWrite" and click next and name your project as "SampleFileReadWritePro" make sure SOA is select click next and then finish with Empty Composite Template

2) Now we are going to create two XSD files for our File Adapter. This will show how to create an XSD file in SOA. It is schema file that defines input and output of different services. In you project right click on xsd folder. Give name as "InputData" and click OK.

3) Click on the source view of your newly created file, Copy the below XML and past(override) into your InputData file.

<?xml version="1.0" encoding="UTF-8" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
            xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd"
            xmlns:tns="http://TargetNamespace.com/readFile"
            targetNamespace="http://TargetNamespace.com/readFile"
            elementFormDefault="qualified"
            attributeFormDefault="unqualified">
  <xsd:element name="ReadFile">
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element name="ReadFiles" minOccurs="1" maxOccurs="unbounded">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="FirstName" type="xsd:string"/>
             <xsd:element name="LastName" type="xsd:string"/>
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:sequence>
    </xsd:complexType>
  </xsd:element>

</xsd:schema>

4) Similarly create a another XSD file named as "OutputData" and copy below data in it.

<?xml version="1.0" encoding="UTF-8" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
            xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd"
            xmlns:tns="http://TargetNamespace.com/readFile"
            targetNamespace="http://TargetNamespace.com/readFile"
            elementFormDefault="qualified"
            attributeFormDefault="unqualified">
  <xsd:element name="Writefile">
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element name="WriteFiles" minOccurs="1" maxOccurs="unbounded">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="FName" type="xsd:string"/>
             <xsd:element name="LName" type="xsd:string"/>
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:sequence>
    </xsd:complexType>
  </xsd:element>

</xsd:schema>

5) Now click on composite.xml file to open it if its not open already. Drag and Drop a Mediator in Components pallet of composite and give name as "RouteRequest" and select "Define Interface later " as template if not selected already.

6) Now lets configure an inbound File Adapter for file reading. Drag and Drop a File adapter Component in Exposed Services swim-lane. Give name as "ReadFileAdapter"  Click Next then again next and from Operation window select "Read File" as operation type and again click next. On file directories window, give some physical path where your server reside as shown below in my case.

7) Click next to move on File Filtering window. Enter *.xml in Include files with name pattern. click next and let the polling frequency as it is i.e 1.  Click next to move on Messages Window. At the end of URL field click on browse for scheme file icon. Expand project schema file and select readfile under InputData.xsd as shown below

8) Click next and finish the file adapter wizard. Now drag a wire from ReadFileAdapter to RouteRequest mediator. Your composite will look like this now 

Now in next part of this post I will configure File Adapter to write in a file and then will will deploy this application on SOA server and test it.
Click to move on part 2 of this post

Read More

Error(24,68): SCAC-50012 Oracle SOA BPEL Error in JDeveloper while building application

I was following one of document/tutorial to implement email notification service in BPEL. But after completing it when I tried to build it, It gave Error(24,68): SCAC-50012. It was so generic error that I could not find exact detailed error. So I did again every step that I did to build application and rebuilt application of completion of each step.

Problem came when I created a BPEL process and I left its Input and output variable as it is. I rebuilt the application and It was fine at that point, then according to tutorial I need to past some XSD elements structure to my newly created XSD file. After doing that when I compiled it gave the above error. It could be because I did not mention Input and output parameter in wizard but added new elements to XSD and It could be some data types related error So I solved it first by designing an XSD and then I created BPEL process and gave Input and output parameter. Just sharing my findings and issue resolution. Hope it might help others too.    

Read More