Your database must be configured to use AL32UTF8 as the default character

[Anjireddy Avula]

I'm trying to connect the oracle 12 database with atlasian conflunece . But i'm getting the above error. We checked with the database team they mentioned the oracle already set with UTF-8 format. How i can solve this problem.

[Nic Brough -Adaptavist-]

I am sorry, but your database team is wrong.  When Confluence connects to the server, it asks what the encoding is.  Oracle is telling it that it is not AL32UTF8, so unless your database team has somehow configured the database to lie about it, it is not using that encoding.

You'll need to get them to set it up as AL32UTF8

To confirm, the question Confluence asks can be run when logged into the database with an SQL tool.  Try

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

and you'll see that the database is not set correctly.