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

[cmrncrick]

I am using oracledb v 2.0.1 with Python 3.11.5.

I am trying to make a new connection but I keep on getting the error noted in the title, (ORA-12514: TNS : listener does not currently know of service requested in connect descriptor).

I have already went into my tnsnames.ora file and added the information for the new connection. I have not changed the listener file. Should I have to do that?

My current listener file looks like this:

listener.ora Network Configuration File: C:\app\rmauto\product\11.2.0\client_1\network\admin\listener.ora

Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = C:\app\rmauto

Any help would be much appreciated.

[cmrncrick]

In the oracledb.makedsn() it looks like I can get a healthy connection by only using the sid parameter and not the service_name.

[anthony-tuininga]

That works, but service_name is preferred. You can find out the names of your services by running lsnrctl services. That should give you a list of services and you can use one of those. The service_name and SID will not be the same value.