#22368 closed New feature (fixed)
Document how to use SERVICE_NAME with Oracle
Reported by: | 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)
follow-up: 2 comment:1 by , 11 years ago
comment:2 by , 11 years ago
Replying to timo:
Does http://stackoverflow.com/a/20486810 not work?
it works fine, I think this should be added to docs.
comment:3 by , 11 years ago
Component: | Database layer (models, ORM) → Documentation |
---|---|
Summary: | db settings does not support SERVICE_NAME → Document how to use SERVICE_NAME with Oracle |
Triage Stage: | Unreviewed → Accepted |
comment:4 by , 10 years ago
Owner: | changed from | to
---|---|
Status: | new → assigned |
comment:6 by , 10 years ago
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
Does http://stackoverflow.com/a/20486810 not work?