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.
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.
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):
Your database user needs the 'CONNECT' role
According to my db admin the following roles are permitted:
CREATE DATABASE LINK
CREATE MATERIALIZED VIEW
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.
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
Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production 0
PL/SQL Release 126.96.36.199.0 - Production 0
"CORE 188.8.131.52.0 Production" 0
TNS for Linux: Version 184.108.40.206.0 - Production 0
NLSRTL Version 220.127.116.11.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.
It’s been great to hear from fellow users over the last few weeks about the best tips and fun moments you’ve had working on Confluence since the transition to working remote. I’d love to keep the c...
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