Category: Oracle SOA 12C

  • Resource manager is unavailable. ORA-17002 SQLErr (0) Weblogic

    Data source issue in Oracle Weblogic/SOA Error:   Internal Exception: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMFAIL start() failed on resource ‘dsname_doamain’: XAER_RMFAIL : Resource manager is unavailable oracle.jdbc.xa.OracleXAException: XAErr (-7): Resource manager is unavailable. ORA-17002 SQLErr (0)           at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1113)   Solution:   Go to data source–> Connection Pool and Advanced  …

  • Oracle SOA BPEL Email error Could not connect to SMTP host: smtp.gmail.com

    I configured email server in Enterprise Manger and then I used email activity in BPEL to send notifications. But I was facing the below issue. After much troubleshooting I figured it out as network issue. My server was behind proxy server and it was blocking such type traffic then I have to check it with…

  • Linux command to set ORACLE_HOME temporary

    When someone is newbie, these types of command are really helpful. I just want to share how to set  ORACLE_HOME path easily. Following is the command. export ORACLE_HOME=/Oracle/Middleware/Oracle_Home To check ORACLE_HOME use the following command echo $ORACLE_HOME It should be: /Oracle/Middleware/Oracle_Home

  • 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  …

  • 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…