How to set up a connection to Oracle through sqlalchemy?

Question

Oracle

Hello. I'm trying to connect to an Oracle database using sqlalchemy:

import sqlalchemy as sql
e=sql.create_engine('oracle://user:[email protected]:port/sid')
e.connect()

I am getting error
ORA-12541: TNS:no listener.
At the same time, through Toad, the connection via TNS works fine, but when using a direct connection, the same error occurs.
It seems to me that I have listener.ora configured incorrectly, but I have no idea how and what to write there, since I have no experience with Oracle.

Answer 1

what is currently written in listener.ora, tnsnames.ora ?
and on what platform the base is installed, it does not hurt to find out.