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
Community showcase
Posted 2 hours ago in Canada

TOPIC TUESDAY - Oct 16th - Fav Atlassian Logo

Hey folks, We are back with your Topic Tuesday Question for the week. This week we are asking what is your fav new Atlassian logo? My vote would be for Statuspage. Let us know your thoughts! &nbs...

12 views 1 0
View post

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