Oracle 12c settings

[Alexander Sailer]

Dear community, 

I'm going to move a confluence 6.7.2 instance from an Ubuntu to a Windows server. 

Therefore I'm going to use an Oracle 12c db, but I' not sure about the correct settings. 

• charset: 
  AL32UTF8
  
• Tablespace configuration
  ID: ?
  Tablespacename: ?
  Size (GB): ?
  
  
• Schema configuration
  ID: ?
  Schema: ?
  Default Tablespace: ?
  
  

I'm not an Oracle db administrator and therefor in our company there's a db request with this questions. It would be very helpful if anyone could give me some hints. 

Kidn regards

Alexander Sailer

[Nic Brough -Adaptavist-]

Everything they need is covered in https://confluence.atlassian.com/conf67/database-setup-for-oracle-945103514.html

[Alexander Sailer]

Thx for your answer. 

I requested the db with a user and got it.  When I try to setup the connection I got the following error with the test (connection test): 

Permission error

Your database user needs the 'CONNECT' role

According to my db admin the following roles are permitted: 

CREATE DATABASE LINK
CREATE TABLE
CREATE SEQUENCE
CREATE CLUSTER
ALTER SESSION
CREATE SESSION
CREATE PROCEDURE
CREATE TYPE
CREATE VIEW
CREATE SYNONYM
CREATE MATERIALIZED VIEW
CREATE TRIGGER

My db admin told me the connect role is not explicit available. With the SQL developer I'm able to connect to db. I'm not able to verify the settings, but after a restart of the confluence service and try to reconfigure the error persists. 

BTW:

Confluence 6.7.2 version. This is because I'd like to move some content from another confluence server with exact this version. 

I installed the bundle on a Windows Server 2016 (as an admin)

I also copied the "ojdbc8.jar" thin client driver as it is descriped in the docu for Confluence 6.7

DB: 
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
"CORE 12.1.0.2.0 Production" 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0

Any hints for me? 

[Nic Brough -Adaptavist-]

Hmm, that's an interesting one.  12c explicitly has an equivalence between "Create Session" and "being in the Connect role" and you have that set, so it should be working.

It should not be giving you the error you are seeing, because Oracle should be letting it in.

I think this one might have to go to Atlassian support directly over at https://support.atlassian.com - if you struggle to raise it there, please let us know here and we'll nudge them directly.  And if you get a good answer, please share it too!

[Snorre Selmer]

I know I'm doing a bit of thread necromancy here, but I had a similar issue a while back. I had all the permissions I should have needed to set up an Oracle connection, but turns out one permission was _implicitly_ granted through one of the roles I had, and that wasn't good enough for Confluence, it had to be _explicitly_ granted.