Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

connect confluence datacenter to Oracle Database (19c)

Claus Westerkamp March 6, 2023
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

1 answer

0 votes
Robert Wen_Cprime_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 6, 2023

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 March 6, 2023

thank you for hint Robert, will check!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.19
TAGS
atlassian, atlassian government cloud, fedramp, webinar, register for webinar, atlassian cloud webinar, fedramp moderate offering, work faster with cloud

Unlocking the future with Atlassian Government Cloud ☁️

Atlassian Government Cloud has achieved FedRAMP Authorization at the Moderate level! Join our webinar to learn how you can accelerate mission success and move work forward faster in cloud, all while ensuring your critical data is secure.

Register Now
AUG Leaders

Upcoming Confluence Events