While configuration of rcu script (Repository Creation Utility)

While Configure OGG repository account getting below error.


Refer: (Doc ID 2370454.1)


The selected Oracle database is not configured to use the AL32UTF8
character set. Oracle strongly recommends using the AL32UTF8 character
set for databases that support Oracle Fusion Middleware.

bash-4.1$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Sat Nov 9 21:30:28 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1469792256 bytes
Fixed Size     2288488 bytes
Variable Size   973079704 bytes
Database Buffers   486539264 bytes
Redo Buffers     7884800 bytes
Database mounted.
SQL>
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

System altered.

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> alter database character set AL32UTF8;
alter database character set AL32UTF8
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set


SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

Database altered.

SQL>

SQL> shutdown; 
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1469792256 bytes
Fixed Size     2288488 bytes
Variable Size   973079704 bytes
Database Buffers   486539264 bytes
Redo Buffers     7884800 bytes
Database mounted.
Database opened.
SQL>






Refer:

https://deepdba.wordpress.com/2009/11/25/steps-to-migrate-the-characterset-of-database/

http://oracle.ittoolbox.com/documents/changing-the-character-set-of-an-oracle-database-18618#