ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Troubleshooting Databases

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

The following appears in the atlassian-stash.log when testing a connection to an Oracle DB:

2012-10-17 15:59:55,818 WARN  [http-7990-17] stash 959x29x1 1m1q59y 10.11.44.156 "POST /admin/db/edit HTTP/1.1" c.a.s.i.m.DefaultMigrationService A connection could not be opened with the DataSource java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
...
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor 

Cause

Stash does not support connecting to Oracle servers using a TNS Alias or SID for identification - STASH-4148 - Getting issue details... STATUS .

Resolution

As currently Stash supports connecting to an Oracle DB only using a Service Name (refer to the "Database Name" parameter on the table you'll see on this link) you'll need to configure a Service Name for your database and specify that as a connection parameter on the "Database Name" field.

 

For more information what Service Name is, please refer to Defining Database Services.

 

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.