Replies: 1 comment 1 reply
-
|
In the oracledb.makedsn() it looks like I can get a healthy connection by only using the sid parameter and not the service_name. |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
That works, but service_name is preferred. You can find out the names of your services by running |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
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.
Beta Was this translation helpful? Give feedback.
All reactions