Context Navigation

← Previous Ticket
Next Ticket →

#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)

follow-up: 2 comment:1 by Tim Graham, 10 years ago

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

in reply to: 1 comment:2 by anonymous, 10 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 Tim Graham, 10 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