Opened 4 years ago

Closed 4 years ago

Last modified 4 years ago

#29757 closed Cleanup/optimization (fixed)

Document that easy connect string can be used to connect to pluggable databases on Oracle.

Reported by: Jani Tiainen Owned by: Jani Tiainen
Component: Documentation Version: 2.1
Severity: Normal Keywords: oracle
Cc: Mariusz Felisiak Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Oracle 12c with pluggable databases uses service name instead of service id (sid) to connect to database if PORT is provided.

Without port connection uses tnsnames.ora definitions or full DSN string in name

Django code uses only sid when port is defined (3rd parameter of makedsn(...) call)

makedsn(...) call has additional parameter service_name (4th parameter)

It's a bit inconvenient to build full DSN string for connection.

Sample full DSN string:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=foobar)))

Change History (8)

comment:1 Changed 4 years ago by Jani Tiainen

Apparently there is possibility to use Oracle easy connect strings as well.

Maybe this could be documented in database specific documentation?

Last edited 4 years ago by Tim Graham (previous) (diff)

comment:2 Changed 4 years ago by Mariusz Felisiak

Cc: Mariusz Felisiak added
Summary: Add simple support for service name as database credentials for Oracle backendDocument that easy connect string can be used to connect to pluggable databases on Oracle.
Triage Stage: UnreviewedAccepted
Type: New featureCleanup/optimization

comment:3 Changed 4 years ago by Tim Graham

Component: Database layer (models, ORM)Documentation

comment:4 Changed 4 years ago by Jani Tiainen

Owner: changed from nobody to Jani Tiainen
Status: newassigned

comment:5 Changed 4 years ago by Jani Tiainen

Has patch: set

comment:6 Changed 4 years ago by Mariusz Felisiak

Triage Stage: AcceptedReady for checkin

comment:7 Changed 4 years ago by Tim Graham <timograham@…>

Resolution: fixed
Status: assignedclosed

In 583b9fc:

Fixed #29757 -- Documented Oracle DSN and Easy Connect options.

comment:8 Changed 4 years ago by Tim Graham <timograham@…>

In 93f4080:

[2.1.x] Fixed #29757 -- Documented Oracle DSN and Easy Connect options.

Backport of 583b9fc4101e5930c39f49d664d41a1596ba78f4 from master

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