Jun 19

As Sun Microsystems, and SeeBeyond before it, Oracle provides support for integration of systems which use HL7 v2.x messaging. Unlike Sun, and SeeBeyond before it, Oracle treats HL7 messaging as Business to Business exchanges (B2B) and uses the B2B part of the Oracle SOA Suite to accomplish the task [1].

There are numerous articles on Oracle SOA Suite and on Oracle B2B. To wade through this material to get to a concise set of steps needed to get started with HL7 messaging is a chore precisely because there is so much material about the SOA Suite and so little on how to deal with HL7 suing it. I set off to work out what it takes to do HL7 messaging and to document it for myself and others.

This article walks through the installation and configuration of all Oracle software necessary to implement HL7 v2.x messaging as development / experimentation environment. It assumes a single machine with limited resources.

I expect that there will be subsequent articles in this series which will use this infrastructure to implement specific HL7 v2.x examples.

The complete article, 01_Installing_Oracle_SOA_Suite_for_HL7_exploration_v1.1.pdf, can be found at http://blogs.czapski.id.au/wp-content/uploads/2010/06/01_Installing_Oracle_SOA_Suite_for_HL7_exploration_v1.1.pdf.

10 Responses to “Installing Oracle SOA Suite 11g for HL7 Exploration”

  1. Gevik says:

    This seems like an ok option for folks who have no choice but to stay with WebLogic and have very little legacy SeeBeyond code. Reading through the doc, it seems very convoluted (albeit complete) to setup an HL7 messaging layer. Furthermore, customers running on eGate/SRE (who use Monk) need to consider other aspects such as converting their Monk code to Java. Follow this link http://www.gotmonk.com and you can learn more.

    • Hello, Gevik.
      Long time no hear :-)
      I am not making recommendations. I am providing instructions so people can have an opportunity to work out for themselves what is involved and decide as they see fit with minimum effort up front.

      Regards

      Michael

  2. Harley says:

    I experienced the following error when configuring Weblogic Domain using Oracle/SOA setup.

    Component Schema=BAM Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_ORABAM
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’BAM’ and (version=’11.1.1.6.0′ or version=’11.1.1.5.0′ or version=’11.1.1.4.0′ or version=’11.1.1.3.0′ or version=’11.1.1.2.0′)

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=SOA Infrastructure
    Driver=oracle.jdbc.xa.client.OracleXADataSource
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_SOAINFRA
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’SOAINFRA’ and version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=User Messaging Service
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_ORASDPM
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’ORASDPM’ and version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=OWSM MDS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_MDS
    Password=********
    SQL Test=select 1 from schema_version_registry where
    owner=(select user from
    dual) and mr_type=’MDS’ and
    version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=SOA MDS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_MDS
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’MDS’ and version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=BAM Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_ORABAM
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’BAM’ and (version=’11.1.1.6.0′ or version=’11.1.1.5.0′ or version=’11.1.1.4.0′ or version=’11.1.1.3.0′ or version=’11.1.1.2.0′)

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=SOA Infrastructure
    Driver=oracle.jdbc.xa.client.OracleXADataSource
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_SOAINFRA
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’SOAINFRA’ and version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=User Messaging Service
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_ORASDPM
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’ORASDPM’ and version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=OWSM MDS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_MDS
    Password=********
    SQL Test=select 1 from schema_version_registry where
    owner=(select user from
    dual) and mr_type=’MDS’ and
    version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=SOA MDS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_MDS
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’MDS’ and version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=BAM Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_ORABAM
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’BAM’ and (version=’11.1.1.6.0′ or version=’11.1.1.5.0′ or version=’11.1.1.4.0′ or version=’11.1.1.3.0′ or version=’11.1.1.2.0′)

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=SOA Infrastructure
    Driver=oracle.jdbc.xa.client.OracleXADataSource
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_SOAINFRA
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’SOAINFRA’ and version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=User Messaging Service
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_ORASDPM
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’ORASDPM’ and version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=OWSM MDS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_MDS
    Password=********
    SQL Test=select 1 from schema_version_registry where
    owner=(select user from
    dual) and mr_type=’MDS’ and
    version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Component Schema=SOA MDS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/EX
    User=DEV_MDS
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’MDS’ and version=’11.1.1.6.0′

    IO Error: The Network Adapter could not establish the connection
    CFGFWK-60850: Test Failed!

    Any help?

    • Hello, Harley.

      It seems to me that the “EX” in jdbc:oracle:thin:@localhost:1521/EX should actually be “XE”, which is the SID for the “Oracel Light” database.

      Regards

      Michael

  3. rishi says:

    hi sir,
    when creating weblogc domain i am getting the below errors.plz solve tis error.

    Component Schema=BAM Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/xe
    User=DEV_ORABAM
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’BAM’ and (version=’11.1.1.3.0? or version=’11.1.1.2.0?)
    ORA-01017: invalid username/password; logon denied
    CFGFWK-60850: Test Failed!
    Component Schema=SOA Infrastructure
    Driver=oracle.jdbc.xa.client.OracleXADataSource
    URL=jdbc:oracle:thin:@localhost:1521/xe
    User=DEV_SOAINFRA
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’SOAINFRA’ and version=’11.1.1.3.0?
    ORA-01017: invalid username/password; logon denied
    CFGFWK-60850: Test Failed!
    Component Schema=User Messaging Service
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/xe
    User=DEV_ORASDPM
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’ORASDPM’ and version=’11.1.1.2.0?
    CFGFWK-20850: Test Successful!
    Component Schema=OWSM MDS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/xe
    User=DEV_MDS
    Password=********
    SQL Test=select 1 from schema_version_registry where
    owner=(select user from dual) and mr_type=’MDS’ and
    version=’11.1.1.2.0?
    CFGFWK-20850: Test Successful!
    Component Schema=SOA MDS Schema
    Driver=oracle.jdbc.OracleDriver
    URL=jdbc:oracle:thin:@localhost:1521/xe
    User=DEV_MDS
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’MDS’ and version=’11.1.1.2.0?
    CFGFWK-20850: Test Successful!

    • Hello, Rishi.

      I would have thought that your issue was fairly simple, judging by the log you attached:
      “ORA-01017: invalid username/password; logon denied”
      Invalid username/password. You need to remember what password you provided when you run the repository creation utility to create the SOA_INFRA and other schemas in the DB.

      I suspect you already figured this out anyway.

      All the best

      Michael

  4. Ferdi says:

    Hi Michael,

    do You know in that time, how to convert the Monk Code to Java?
    I’m not so good in programing, but I should to get so many Infos as possible. Do You random know: is there in Monk written collaborations/rules something difficult, what we can’t write in Java??

    Regadrs

    Ferdinand

    • Hello, Ferdinand.

      Alas, this is not an easy proposition.

      I am aware the a company called NextGate, run and peopled by some very talented ex-SeeBeyond folks, had a tool and services on offer, but having just looked at their site, http://www.nextgate.com/services/datagate-egate-javacaps-support/, I can’t find references to it any more. Still, get in touch with them and see if they can help you.

      There was a poject, “GoMonk”, at one point, which is also gone from the Ether.

      Naturally, there are plenty of people in India whi can hand-convert Monk to Java.

      Regards

      Michael

  5. goutham says:

    Component Schema=SOA Infrastructure
    Driver=oracle.jdbc.xa.client.OracleXADataSource
    URL=jdbc:oracle:thin:@localhost:1521/xe
    User=DEV_SOAINFRA
    Password=********
    SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’SOAINFRA’ and version=’11.1.1.7.0′

    ORA-01017: invalid username/password; logon denied

    CFGFWK-60850: Test Failed!

Leave a Reply

preload preload preload