Opened 5 years ago

Closed 5 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

Description

Hi,

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

python manage.py 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:
https://stackoverflow.com/questions/57952435/django-tutorial-testcase-failed-to-create-testuser-on-oracle-express-database
The solution can be found here: https://stackoverflow.com/questions/33330968/error-ora-65096-invalid-common-user-or-role-name-in-oracle
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:
https://github.com/django/django/pull/12301

BR,
Moritz

Change History (1)

comment:1 by Mariusz Felisiak, 5 years ago

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