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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Oracle 12c settings

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

 

 

 

1 answer

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? 

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!

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

494 views 24 9
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you