connect confluence datacenter to Oracle Database (19c)

[Claus Westerkamp]

Hello!

I am following this guide to setup OracleDB for confluence
https://confluence.atlassian.com/doc/database-setup-for-oracle-173821.html


instructions tell to connect Oracle as sysdba, which works fine

1. Use the sqlplus command to access Oracle via the command line

[oracle@oracle-linux-8-database-19c ~]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 6 14:17:48 2023
Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle.  All rights reserved.Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

next step fails:
Create a Confluence user (for example confluenceuser). It's important that this user is only granted the required privileges:

create user confluenceuser identified by confluenceuserpassword default tablespace confluence quota unlimited on confluence;


ERROR at line 1:
ORA-65096: invalid common user or role name

How do I configure OracleDB to get connected by confluence?

I am no expert on Oracle, I just follow Atlassians instructions

[Robert Wen_Cprime_]

My first guess might be that your password may not be meeting any password policies.  I'd talk with your DBAs to be sure.

https://docs.oracle.com/cd/E95618_01/html/sbc_scz810_adminsecurity/GUID-5E974486-498E-4369-892C-E214D375AE1C.htm#GUID-5E974486-498E-4369-892C-E214D375AE1C

[Claus Westerkamp]

thank you for hint Robert, will check!