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

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Marketplace Apps

Tips on how to choose the best estimation method for your planning

Planning and grooming sessions all come with their own sets of rules. Team members meet to estimate stories or other work items, all according to an agreed-upon process. And with every session comes ...

76 views 0 11
Read article

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