problems in installing hermes2 with oracle

[refka]

Hi all,
I'm a beginner with hermes2, and I tried to install
hermes2_installer_20090507.jar using "hermes2_install.pdf" including
( tomcat 5.5 , oracle 10g Express edition,jre1.5.0_02 ) but acctually
for oracle creation database there is only this link
http://www.peacetech.com/flipper/oracle9i/901_doc/server.901/a90117/create.htm
but it doesn't work. So I tried to follow steps presented for postgres
and mysql..and here is my steps:
since oracle 10g XE has only one database so I created shemas:
1. I created a shema with username corvus and password corvus
2. I logged in corvus shema and I created two shemas named ebms and
as2 with the same password: corvus
3. To assign access privileges to users, I entred those commands for
corvus, ebms and as2:

ALTER USER corvus IDENTIFIED BY corvus ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to corvus;


The installation was successful but at http://localhost:8080/corvus/admin/ebms/message_history
I have the same error( Error occurs when plugin ebms initiates) and
when I refer to log files,I find in ebms.log this error:


2009-11-11 08:48:41 [Thread-2 ] <ERROR> <cecid.ebms.spa> <Error in
collecting message from outbox>
hk.hku.cecid.piazza.commons.dao.DAOException: Unable to begin
transaction
by java.sql.SQLException: Listener refused the connection with the
following error:
ORA-12505, TNS:listener does not currently know of SID given in
connect descriptor
The Connection descriptor used by the client was:
127.0.0.1:1521:ebms

at hk.hku.cecid.piazza.commons.dao.ds.DataSourceTransaction.begin
(DataSourceTransaction.java:96)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceProcess.start
(DataSourceProcess.java:84)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeQuery
(DataSourceDAO.java:437)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeQuery
(DataSourceDAO.java:416)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.find
(DataSourceDAO.java:348)
at
hk.hku.cecid.ebms.spa.dao.MessageDataSourceDAO.findOutboxProcessingMessagesByTimestamp
(MessageDataSourceDAO.java:131)
at hk.hku.cecid.ebms.spa.task.OutboxCollector.getTaskList
(OutboxCollector.java:47)
at hk.hku.cecid.piazza.commons.module.ActiveTaskModule.execute
(ActiveTaskModule.java:137)
at hk.hku.cecid.piazza.commons.module.ActiveModule.run
(ActiveModule.java:213)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Listener refused the connection with
the following error:
ORA-12505, TNS:listener does not currently know of SID given in
connect descriptor
The Connection descriptor used by the client was:
127.0.0.1:1521:ebms

at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>
(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection
(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection
(DriverAdapterCPDS.java:177)
at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection
(DriverAdapterCPDS.java:132)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS
(InstanceKeyDataSource.java:749)
at
org.apache.commons.dbcp.datasources.SharedPoolDataSource.registerPool
(SharedPoolDataSource.java:202)
at
org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo
(SharedPoolDataSource.java:159)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection
(InstanceKeyDataSource.java:669)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection
(InstanceKeyDataSource.java:653)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceTransaction.begin
(DataSourceTransaction.java:92)
... 9 more
2009-11-11 08:48:41 [Thread-3 ] <ERROR> <cecid.ebms.spa> <Error in
collecing message from inbox>
hk.hku.cecid.piazza.commons.dao.DAOException: Unable to begin
transaction
by java.sql.SQLException: Exception d'E/S: The Network Adapter could
not establish the connection
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceTransaction.begin
(DataSourceTransaction.java:96)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceProcess.start
(DataSourceProcess.java:84)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeQuery
(DataSourceDAO.java:437)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeQuery
(DataSourceDAO.java:416)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.find
(DataSourceDAO.java:348)
at
hk.hku.cecid.ebms.spa.dao.MessageDataSourceDAO.findInboxPendingMessagesByTimestamp
(MessageDataSourceDAO.java:103)
at hk.hku.cecid.ebms.spa.task.InboxCollector.getTaskList
(InboxCollector.java:43)
at hk.hku.cecid.piazza.commons.module.ActiveTaskModule.execute
(ActiveTaskModule.java:137)
at hk.hku.cecid.piazza.commons.module.ActiveModule.run
(ActiveModule.java:213)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Exception d'E/S: The Network Adapter
could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>
(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection
(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection
(DriverAdapterCPDS.java:177)
at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection
(DriverAdapterCPDS.java:132)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS
(InstanceKeyDataSource.java:749)
at
org.apache.commons.dbcp.datasources.SharedPoolDataSource.registerPool
(SharedPoolDataSource.java:202)
at
org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo
(SharedPoolDataSource.java:159)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection
(InstanceKeyDataSource.java:669)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection
(InstanceKeyDataSource.java:653)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceTransaction.begin
(DataSourceTransaction.java:92)
... 9 more
2009-11-11 08:48:41 [Thread-2 ] <ERROR> <cecid.ebms.spa> <Error in
collecting message from outbox>
hk.hku.cecid.piazza.commons.dao.DAOException: Unable to begin
transaction
by java.sql.SQLException: Listener refused the connection with the
following error:
ORA-12505, TNS:listener does not currently know of SID given in
connect descriptor
The Connection descriptor used by the client was:
127.0.0.1:1521:ebms

at hk.hku.cecid.piazza.commons.dao.ds.DataSourceTransaction.begin
(DataSourceTransaction.java:96)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceProcess.start
(DataSourceProcess.java:84)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeQuery
(DataSourceDAO.java:437)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeQuery
(DataSourceDAO.java:416)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.find
(DataSourceDAO.java:348)
at
hk.hku.cecid.ebms.spa.dao.MessageDataSourceDAO.findOutboxProcessingMessagesByTimestamp
(MessageDataSourceDAO.java:131)
at hk.hku.cecid.ebms.spa.task.OutboxCollector.getTaskList
(OutboxCollector.java:47)
at hk.hku.cecid.piazza.commons.module.ActiveTaskModule.execute
(ActiveTaskModule.java:137)
at hk.hku.cecid.piazza.commons.module.ActiveModule.run
(ActiveModule.java:213)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Listener refused the connection with
the following error:
ORA-12505, TNS:listener does not currently know of SID given in
connect descriptor
The Connection descriptor used by the client was:
127.0.0.1:1521:ebms

at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>
(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection
(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection
(DriverAdapterCPDS.java:177)
at
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection
(DriverAdapterCPDS.java:132)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS
(InstanceKeyDataSource.java:749)
at
org.apache.commons.dbcp.datasources.SharedPoolDataSource.registerPool
(SharedPoolDataSource.java:202)
at
org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo
(SharedPoolDataSource.java:159)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection
(InstanceKeyDataSource.java:669)
at
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection
(InstanceKeyDataSource.java:653)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceTransaction.begin
(DataSourceTransaction.java:92)
... 9 more


Now my questions are:
1. If I have problem installing oracle 10g Release 2(10.2.0.4) and
even I tried oracle 11g and I got the same error, so can oracle 10g XE
work with hermes?
2.did I miss a step or what I did for creating ebms and as2 databases
is right? And if not can u give me steps to follow plz.
3. What does this error mean exactly, especially it's the same for
ebms and as2??
I really need ur help, and sorry for my bad english and my long post.
regards, Refka.

[Kit]

Hi Refka,

can u connected to the ebms/as2 database thru other client program
such as TOAD?
can u find those created tables in the 2 databases after the
installation?

Regards,
Kit Yuen, Software Engineer
Apacus Software - Innovate, Simplify

Email: kit....@apacus.com
Site: http://www.apacus.com

On Nov 11, 4:09 pm, refka <refk...@gmail.com> wrote:
> Hi all,
> I'm a beginner with hermes2, and I tried to install
> hermes2_installer_20090507.jar  using "hermes2_install.pdf" including
> ( tomcat 5.5 , oracle 10g Express edition,jre1.5.0_02 ) but acctually

> for oracle creation database there is only this linkhttp://www.peacetech.com/flipper/oracle9i/901_doc/server.901/a90117/c...

> but it doesn't work. So I tried to follow steps presented for postgres
> and mysql..and here is my steps:
> since oracle 10g XE has only one database so I created shemas:
> 1. I created a shema with username corvus and password corvus
> 2. I logged in corvus shema and I created two shemas named ebms and
> as2 with the same password: corvus
> 3. To assign access privileges to users, I entred those commands for
> corvus, ebms and as2:
>
> ALTER USER corvus IDENTIFIED BY corvus ACCOUNT UNLOCK;
> GRANT CONNECT, RESOURCE to corvus;
>

> The installation was successful but athttp://localhost:8080/corvus/admin/ebms/message_history

[refka]

Thank u for ur quick response,
it works finally!!
Just now I've download Toad for Oracle Freeware version and I put
same SID and database name that I put in hermes and it doesn't work,
then I changed I put
SID :XE
Database: ebms
password: corvus
It was just the wrong SID
Then I could connect to toad soo I used same parameters with hermes
and now it works..
Best regards, thank you so much.
Refka.

[refka]

hi again,
now I can connect I'm sure of that but it works only if I create
tables manually means after installing hermes I have to access to
oracle and execute the code existing here C:\Program Files\hermes2\sql
\oracle_ebms in ebms schema, request by request to get ebms Plugin and
same to get as2 Plugin without errors..
is that normal?? I don't know if this can make any other problem in
the future...
regards,Refka.

[Kit]

Hi Refka,

in XE, u have to create 2 different users. one for ebms and one for
as2.
during the installation, the SID should be xe. and the username is
used for mapping either ebms and as2 databases.

Regards,
Kit Yuen, Software Engineer
Apacus Software - Innovate, Simplify

Email: kit....@apacus.com
Site: http://www.apacus.com

[refka]

hi Kit,
thank you very much for ur help, now it works very well.
regards, Refka.