Oracle connection arguments problem when using sqlalchemy

Question

I used sqlalchemy to connect to the oracle server from python. (cx_oracle installation and oracle instant client setup are completed.)

The code I used is as follows: (I used the ip address instead of the hostname. The ip address is a sample value.)

engine = create_engine('oracle://scott:[email protected]:1521/sidname')
q = engine.execute(test_query)
q.fetchone()

But I got the error like below.

sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-24454: client host name is not set

I didn't use hostname, but I don't know why this error occurred. Shouldn't I use the ip address?

Is there a solution?

Christopher Jones · Accepted Answer · 2021-03-31 09:39:03Z

1

That error is about the configuration of the machine you are running SQLAlchemy on, not the syntax you are using. Using an IP address is OK.

Typically Linux users update /etc/hosts and add a hostname for the loopback address. If you update your question with system information, we can help more.

answered Mar 31, 2021 at 9:39

Christopher Jones

11.1k7 gold badges32 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle connection arguments problem when using sqlalchemy

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related