Opened 3 years ago

Closed 3 years ago

Last modified 3 years 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 Changed 3 years ago by Tim Graham

comment:2 in reply to:  1 Changed 3 years 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 3 years ago by Tim Graham

Component: Database layer (models, ORM)Documentation
Summary: db settings does not support SERVICE_NAMEDocument how to use SERVICE_NAME with Oracle
Triage Stage: UnreviewedAccepted

comment:4 Changed 3 years ago by mardini

Owner: changed from nobody to mardini
Status: newassigned

comment:6 Changed 3 years ago by Tim Graham <timograham@…>

Resolution: fixed
Status: assignedclosed

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 3 years 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 3 years 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