Opened 17 months ago

Closed 16 months ago

Last modified 16 months ago

#22368 closed New feature (fixed)

Document how to use SERVICE_NAME with Oracle

Reported by: michael.cherkasov@… Owned by: mardini
Component: Documentation Version: 1.6
Severity: Normal Keywords: oracle, database, db config
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

I need to connect to oracle db, but I don't have SID of db, I know only SERVICE_NAME - that is used all the time in other tools.
To connect to db I need a dsn like this one:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host-name.com)(PORT=1523))\

(CONNECT_DATA=(SERVICE_NAME=some-service-name.com)))

but django generate the following:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host-name.com)(PORT=1523)))(CONNECT_DATA=(SID=some-service-name.com)))

the possible fix is described here:
http://stackoverflow.com/questions/19246643/how-do-i-force-django-to-connect-to-oracle-using-service-name

Change History (8)

comment:1 follow-up: Changed 17 months ago by timo

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

comment:2 in reply to: ↑ 1 Changed 17 months ago by anonymous

Replying to timo:

Does http://stackoverflow.com/a/20486810 not work?

it works fine, I think this should be added to docs.

comment:3 Changed 17 months ago by timo

  • Component changed from Database layer (models, ORM) to Documentation
  • Summary changed from db settings does not support SERVICE_NAME to Document how to use SERVICE_NAME with Oracle
  • Triage Stage changed from Unreviewed to Accepted

comment:4 Changed 16 months ago by mardini

  • Owner changed from nobody to mardini
  • Status changed from new to assigned

comment:6 Changed 16 months ago by Tim Graham <timograham@…>

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

In bfac6bef833d2520853c88188560b81bc7e3988d:

Fixed #22368 -- clarified connecting to Oracle DB using service name

Used the official terminology listed in
http://docs.oracle.com/cd/B19306_01/network.102/b14212/glossary.htm#i997309

Thanks michael.cherkasov for the report.

comment:7 Changed 16 months ago by Tim Graham <timograham@…>

In 4dd37a3a6eb744a9901eb53454a86bf304a71426:

[1.7.x] Fixed #22368 -- clarified connecting to Oracle DB using service name

Used the official terminology listed in
http://docs.oracle.com/cd/B19306_01/network.102/b14212/glossary.htm#i997309

Thanks michael.cherkasov for the report.

Backport of bfac6bef83 from master

comment:8 Changed 16 months ago by Tim Graham <timograham@…>

In 26221445df5855d189b2dc4dd76ff0a9f0bd77d0:

[1.6.x] Fixed #22368 -- clarified connecting to Oracle DB using service name

Used the official terminology listed in
http://docs.oracle.com/cd/B19306_01/network.102/b14212/glossary.htm#i997309

Thanks michael.cherkasov for the report.

Backport of bfac6bef83 from master

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