Connecting to oracle DB through python

Question

I'm trying to connect to an oracle db using python through PyCharm, below is my code and a screenshot of the connection details

Code:

import cx_Oracle   
try:
    conn = cx_Oracle.connect('sys/123@//localhost:1521/XEPDB1')    
except:
    print("Connection Error")
    exit()

Output

Connection Error

Osamazx · Accepted Answer · 2021-04-21 18:14:22Z

2

There are multiple ways to do that, either with SID or service name

SID :

import cx_Oracle
dsn_tns = cx_Oracle.makedsn('server', 'port', 'sid')
conn = cx_Oracle.connect(user='username', password='password', dsn=dsn_tns)

Service name :-

import cx_Oracle
dsn_tns = cx_Oracle.makedsn('server', 'port', service_name='service_name')
conn = cx_Oracle.connect(user='username', password='password', dsn=dsn_tns)

You can refer to this documentation HERE

answered Apr 21, 2021 at 18:14

Osamazx

4651 gold badge5 silver badges12 bronze badges

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

3 Comments

iAlsunaid Over a year ago

Thanks! it worked. However, I faced another error ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

iAlsunaid Over a year ago

this is how I wrote it: tns = cx_Oracle.makedsn("localhost","1521", service_name="XEPDB1") conn = cx_Oracle.connect(user="sys", password="123", dsn=tns)

Christopher Jones Over a year ago

Regarding connecting as SYSDBA, search the doc link in the answer for the syntax to use: mode=cx_Oracle.SYSDBA. A general note: Avoid using SIDs; their use was obsoleted a decade or more ago.

Fernando Ulisses dos Santos · Accepted Answer · 2024-01-03 12:42:05Z

0

For new versions:

import oracledb

conn = oracledb.connect(user='sys', password='pass', dsn='localhost:1521/database', mode=oracledb.SYSDBA)

for normal users use: mode=oracledb.AUTH_MODE_DEFAULT

answered Jan 3, 2024 at 12:42

Fernando Ulisses dos Santos

1772 silver badges8 bronze badges

Collectives™ on Stack Overflow

Connecting to oracle DB through python

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related