Opened 6 years ago

Closed 6 years ago

Last modified 6 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 by Jani Tiainen, 6 years ago

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

Maybe this could be documented in database spesific documentation?

Version 0, edited 6 years ago by Jani Tiainen (next)

comment:2 by Mariusz Felisiak, 6 years ago

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 by Tim Graham, 6 years ago

Component: Database layer (models, ORM)Documentation

comment:4 by Jani Tiainen, 6 years ago

Owner: changed from nobody to Jani Tiainen
Status: newassigned

comment:6 by Mariusz Felisiak, 6 years ago

Triage Stage: AcceptedReady for checkin

comment:7 by Tim Graham <timograham@…>, 6 years ago

Resolution: fixed
Status: assignedclosed

In 583b9fc:

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

comment:8 by Tim Graham <timograham@…>, 6 years ago

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