I have the following installed on my home computer:
- Oracle 18c Express Edition (it's not a geodatabase since I don't have an ArcGIS Server/Enterprise license). Purpose: personal/learning.
- ArcGIS Pro 3.1.1 Personal Use
In ArcGIS Pro, I can connect to the Oracle database's SYS user using a database connection in Catalog:
Now, I want to create a database user called TEST_USER so that I can create Oracle tables/FCs using ArcGIS Pro/Catalog (I'll import the data from a mobile or file GDB for testing purposes).
I tried using the Create Database User geoprocessing tool, but I get an error:
Failed to create the new user in the database. [Success] ERROR: Failed to create new Oracle user TEST_USER (-51).
Error: Underlying DBMS error (-51).
Extended error code: (65096)
ORA-65096: invalid common user or role name
Error creating database user.
Failed to execute (CreateDatabaseUser).
Question:
How can I create a database user in an Oracle XE database using ArcGIS Pro?
I found a blurb from @MarceloMarques :
99.9% of the time the error ORA-65096: invalid common user or role name means you are logged into the CDB when you should be logged into a PDB. For example, if you used the default 19c installation settings, you should login to ORCLPDB (the PDB) instead of ORCL (the CDB).
https://community.esri.com/t5/geodatabase-questions/qery-about-oracle-and-sde/m-p/1197738/highlight/...
But I'm not sure how to log into the PDB via my ArcGIS Pro database connection, if that's the problem.
Any help would be appreciated.