Opened 7 years ago

Closed 7 years ago

#9972 closed (fixed)

dbshell can't connect to Oracle database

Reported by: lijinguo@… Owned by: nobody
Component: Database layer (models, ORM) Version: master
Severity: Keywords: oracle, dbshell
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

When we connect to the database using dbshell, No response is received.

Attachments (2)

client.py.diff (695 bytes) - added by lijinguo@… 7 years ago.
9972.diff (2.9 KB) - added by ikelly 7 years ago.

Download all attachments as: .zip

Change History (7)

Changed 7 years ago by lijinguo@…

comment:1 Changed 7 years ago by ikelly

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset

On my install, SQL*Plus rejects the connect string produced by this patch. What version of SQL*Plus are you using? What settings.py database settings are you using?

comment:2 Changed 7 years ago by lijinguo@…

Oracle version:Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL*Plus version: SQL*Plus: Release 10.2.0.4.0 - Production

cx_Oracle version: 4.4.1

about database settings:

DATABASE_ENGINE = 'oracle'
DATABASE_NAME = 'xe'
DATABASE_USER = 'dba'
DATABASE_PASSWORD = 'password'
DATABASE_HOST = '192.168.1.111'
DATABASE_PORT = '1521'

Changed 7 years ago by ikelly

comment:3 Changed 7 years ago by ikelly

  • Triage Stage changed from Unreviewed to Accepted

Does this patch work for you?

comment:4 Changed 7 years ago by lijinguo@…

Great, it's work for me. Who will close this ticket?

comment:5 Changed 7 years ago by ikelly

  • Resolution set to fixed
  • Status changed from new to closed

(In [9713]) Fixed #9972: The dbshell command was ignoring the DATABASE_HOST and DATABASE_PORT settings in Oracle.

Note: See TracTickets for help on using tickets.
Back to Top