stash and oracle connectivity

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

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

30 views 3 4
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you