Opened 16 years ago

Closed 16 years ago

#9972 closed (fixed)

dbshell can't connect to Oracle database

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

Description

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

Attachments (2)

client.py.diff (695 bytes ) - added by lijinguo@… 16 years ago.
9972.diff (2.9 KB ) - added by Erin Kelly 16 years ago.

Download all attachments as: .zip

Change History (7)

by lijinguo@…, 16 years ago

Attachment: client.py.diff added

comment:1 by Erin Kelly, 16 years ago

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 by lijinguo@…, 16 years ago

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'

by Erin Kelly, 16 years ago

Attachment: 9972.diff added

comment:3 by Erin Kelly, 16 years ago

Triage Stage: UnreviewedAccepted

Does this patch work for you?

comment:4 by lijinguo@…, 16 years ago

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

comment:5 by Erin Kelly, 16 years ago

Resolution: fixed
Status: newclosed

(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