HTTP Status 500 IO Error: The Network Adapter could not establish the connection Jira Debian Squeeze Oracle with Service Name

Flacid Snake

Hi,

I'm getting this error:

HTTP Status 500 IO Error: The Network Adapter could not establish the connection

I'm trying to use an Oracle11g using Service database following these steps:

https://confluence.atlassian.com/display/JIRAKB/How+to+Connect+JIRA+to+ORACLE+Using+Service+Name

I add the property:

JVM_SUPPORT_RECOMMENDED_ARGS=" -Doracle.net.tns_admin=/opt/atlassian/jira/conf"

The folder /opt/atlassian/jira/conf contains the file tnsnames.ora which looks like:

ORAPRE13 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XEON)
)
)

I edit the dbconfig.xml as follows:

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

<jira-database-config>

<name>ORAPRE13</name>

<delegator-name>default</delegator-name>

<database-type>oracle10g</database-type>

<schema-name>jira</schema-name>

- <jdbc-datasource>

<url>jdbc:oracle:thin:@//myhost.com:1521/XEON</url>

<driver-class>oracle.jdbc.OracleDriver</driver-class>

<username>user</username>

<password>pass</password>

<pool-min-size>20</pool-min-size>

<pool-max-size>20</pool-max-size>

<pool-max-wait>30000</pool-max-wait>

<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>

<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>

<pool-max-idle>20</pool-max-idle>

<pool-remove-abandoned>true</pool-remove-abandoned>

<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

</jdbc-datasource>

</jira-database-config>

What am I doing wrong?

Thanks in advance

Flacid Snake

I tried to telnet the host and it doesn't connect, so I've asked my network administrator to check if maybe the firewall is blocking the traffic over the 1521 port