stash and oracle connectivity

Anurag Vidyarthi September 2, 2012

Hi,

We are working of proof of concept for one of our client in Oslo.I am trying to test the Oracle connectivity with stash.I want to connect it to Oracle database.My Oracle database is up and running and providing connecting to all the users using the same connection details(hostname,username,password,servicename,port) but when I am trying the same in stash I am getting the error.

I checked the listener.log and it has following lines :

on Sep 03 18:27:23 2012

03-SEP-2012 18:27:23 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C: Data oracle11g product 11.2.0 dbhome_1 perl bin perl.exe)(HOST=MW7YAEK4TT8S08)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57181)) * establish * orcl * 0

Mon Sep 03 18:27:33 2012

03-SEP-2012 18:27:33 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C: Data oracle11g product 11.2.0 dbhome_1 perl bin perl.exe)(HOST=MW7YAEK4TT8S08)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57186)) * establish * orcl * 0

03-SEP-2012 18:27:35 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C: Data oracle11g product 11.2.0 dbhome_1 perl bin perl.exe)(HOST=MW7YAEK4TT8S08)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57187)) * establish * orcl * 0

Mon Sep 03 18:28:30 2012

03-SEP-2012 18:28:30 * service_update * orcl * 0

03-SEP-2012 18:28:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=services)(ARGUMENTS=64)(SERVICE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))))(VERSION=186646784)) * services * 0

03-SEP-2012 18:28:33 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(VERSION=186646784)) * status * 0

Mon Sep 03 18:29:31 2012

03-SEP-2012 18:29:31 * service_update * orcl * 0

Mon Sep 03 18:30:02 2012

03-SEP-2012 18:30:02 * service_update * orcl * 0

03-SEP-2012 18:30:07 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=anurag.vidyarthi))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0

Mon Sep 03 18:30:48 2012

03-SEP-2012 18:30:48 * service_update * orcl * 0

Mon Sep 03 18:31:03 2012

03-SEP-2012 18:31:03 * service_update * orcl * 0

Mon Sep 03 18:31:34 2012

03-SEP-2012 18:31:34 * service_update * orcl * 0

and my log.xml has following entries (last entries) :

<msg time="2012-09-03T18:32:04.602+02:00" org_id="oracle" comp_id="tnslsnr" <="" p="">

type='UNKNOWN' level='16' host_id='MW7YAEK4TT8S08'

host_addr='fe80::18be:da16:1c15:d800%20'>

<txt>03-SEP-2012 18:32:04 * service_update * orcl * 0

</txt>

</msg>

<msg time="2012-09-03T18:32:24.078+02:00" org_id="oracle" comp_id="tnslsnr" <="" p="">

type='UNKNOWN' level='16' host_id='MW7YAEK4TT8S08'

host_addr='fe80::18be:da16:1c15:d800%20'>

<txt>03-SEP-2012 18:32:24 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C: Data oracle11g product 11.2.0 dbhome_1 perl bin perl.exe)(HOST=MW7YAEK4TT8S08)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57332)) * establish * orcl * 0

</txt>

</msg>

<msg time="2012-09-03T18:32:33.302+02:00" org_id="oracle" comp_id="tnslsnr" <="" p="">

type='UNKNOWN' level='16' host_id='MW7YAEK4TT8S08'

host_addr='fe80::18be:da16:1c15:d800%20'>

<txt>03-SEP-2012 18:32:33 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C: Data oracle11g product 11.2.0 dbhome_1 perl bin perl.exe)(HOST=MW7YAEK4TT8S08)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57335)) * establish * orcl * 0

</txt>

</msg>

<msg time="2012-09-03T18:32:35.348+02:00" org_id="oracle" comp_id="tnslsnr" <="" p="">

type='UNKNOWN' level='16' host_id='MW7YAEK4TT8S08'

host_addr='fe80::18be:da16:1c15:d800%20'>

<txt>03-SEP-2012 18:32:35 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C: Data oracle11g product 11.2.0 dbhome_1 perl bin perl.exe)(HOST=MW7YAEK4TT8S08)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=57337)) * establish * orcl * 0

</txt>

</msg>

<msg time="2012-09-03T18:32:53.631+02:00" org_id="oracle" comp_id="tnslsnr" <="" p="">

type='UNKNOWN' level='16' host_id='MW7YAEK4TT8S08'

host_addr='fe80::18be:da16:1c15:d800%20'>

<txt>03-SEP-2012 18:32:53 * service_update * orcl * 0

</txt>

</msg>

<msg time="2012-09-03T18:32:56.698+02:00" org_id="oracle" comp_id="tnslsnr" <="" p="">

type='UNKNOWN' level='16' host_id='MW7YAEK4TT8S08'

host_addr='fe80::18be:da16:1c15:d800%20'>

<txt>03-SEP-2012 18:32:56 * service_update * orcl * 0

</txt>

</msg>

<msg time="2012-09-03T18:33:05.879+02:00" org_id="oracle" comp_id="tnslsnr" <="" p="">

type='UNKNOWN' level='16' host_id='MW7YAEK4TT8S08'

host_addr='fe80::18be:da16:1c15:d800%20'>

<txt>03-SEP-2012 18:33:05 * service_update * orcl * 0

</txt>

</msg>

<msg time="2012-09-03T18:33:36.494+02:00" org_id="oracle" comp_id="tnslsnr" <="" p="">

type='UNKNOWN' level='16' host_id='MW7YAEK4TT8S08'

host_addr='fe80::18be:da16:1c15:d800%20'>

<txt>03-SEP-2012 18:33:36 * service_update * orcl * 0

</txt>

</msg>

Can you guide me to the right direction my error is :

The configuration entered is not valid. A database connection could not be established. Please check your configuration and try again.

If you continue having issues, get in touch with our support team and we'll help get you up and running.

Hide details

The configuration entered is not valid. A database connection could not be established. Please check your configuration and try again.

com.atlassian.stash.internal.migration.DefaultMigrationService.getConnection(DefaultMigrationService.java:1047)

com.atlassian.stash.internal.migration.DefaultMigrationService.validateDataSource(DefaultMigrationService.java:995)

com.atlassian.stash.internal.migration.DefaultMigrationService.validateConfiguration(DefaultMigrationService.java:255)

...

I/U-feil: The Network Adapter could not establish the connection

oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)

oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)

oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)

...

The Network Adapter could not establish the connection

oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:375)

oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)

oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:678)

...

Connection refused: connect

java.net.PlainSocketImpl.socketConnect(Native Method)

java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

...

Best Regards,

Anurag

+47-94833542

1 answer

0 votes
R A October 23, 2012

I got the same problem, did you manage this issue?

By the way, this is not anout Oracale only, i am trying mysql

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events