Opened 4 years ago

Closed 4 years ago

#31153 closed Bug (invalid)

Fix "common" user creation on Oracle 12c+.

Reported by: Moritz Schaffenroth Owned by: nobody
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: yes UI/UX: no



when running the tests on django 3.0 against a Oracle 12c database i get the following errors:

python test
Creating test database for alias 'default'...
Failed (ORA-01543: tablespace 'TEST_A_GUI' already exists)
It appears the test database, test_A_GUI, already exists. Type 'yes' to delete it, or 'no' to cancel: yes
Destroying old test database for alias 'default'...
Creating test user...
Failed (ORA-65096: invalid common user or role name)
Got an error creating the test user: ORA-65096: invalid common user or role name

This seems to be the following problem:
The solution can be found here:
It is to execute the following sql before creating the user:
alter session set "_ORACLE_SCRIPT"=true;
I created a pull request for this issue:


Change History (1)

comment:1 Changed 4 years ago by Mariusz Felisiak

Component: UncategorizedDatabase layer (models, ORM)
Resolution: invalid
Status: newclosed
Summary: Fix user creation on Oracle 12cFix "common" user creation on Oracle 12c+.
Type: UncategorizedBug
Version: 3.0master

You don't need to use this undocumented parameter when you create a local users at the PDB level, what you should do. IMO we shouldn't support creating test "common" users, see article for details.

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