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!

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...

IM Landing Page Filter - Now Available

We’ve added the capability for you to filter across the summary details on the main Infrastructure Monitoring ...

Dynamic Links from Alerts to IM Navigators - New in Observability Cloud

Splunk continues to improve the troubleshooting experience in Observability Cloud with this latest enhancement ...