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 https://blogs.czapski.id.au/wp-content/uploads/2010/06/01_Installing_Oracle_SOA_Suite_for_HL7_exploration_v1.1.pdf.
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
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
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
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
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!
And you point is?