Deployment Architecture

DB Connect: How to fix Oracle SID setup error "ORA-12514, TNS: listener does not currently know of service requested in connect descriptor"?

splunkrocks2014
Communicator

I am getting the following problems while adding a new Oracle connection with SID:

**
Encountered the following error while trying to save: In handler 'databases': Error connecting to database: 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
**

However, I don't have any problems if an Oracle database with service_name defined. I followed this post:
http://answers.splunk.com/answers/73979/dbx-problems-after-upgrading-to-1-0-8.html

and I added a stanza at the beginning of database.conf as the following:

**
[default]
database.sid = true
**

After restart, I still get the same problem. Does anyone have any clues how to fix this?

Thanks,
Joe

pmdba
Builder

Either the database is not configured to register its SID with the listener, or you are not using the actual SID in your connect string. Do you have access to the database server itself, or the assistance of an Oracle DBA, to confirm what the listener will accept? How you would configure the database and listener will depend on which version of Oracle and what sort of architecture (stand-alone, stand-alone with grid infrastructure, or RAC) that you are using.

In general you are better off using a service name if that is an option; it is Oracle's preferred method for identifying databases over the network. SID, while it still works in most cases, was actually deprecated as a network identifier something like 15 years ago with Oracle 9.

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...