I wanted to install Oracle Enterprise Scheduler Service(ESS). Hence I started off with the installation of SOA Suite, which required a few prerequisites, which were Oracle Resource Utility Creation(RCU) and Fusion Middleware (fmw). When I try to install RCU, in the page where database details are to be given, after giving in all the details I am getting an error saying "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".Oracle documentation said ignoring this particular error would continue the installation without any further problem, but my installation was getting stopped after ignoring it. Now, I tried to alter the character set, but an error arises saying "the new character set should be a super set of the existing character set". However, I read on a forum that said AL32UTF8 and UTF8 are identical, and hence tried changing the character set to UTF8 and it got changed. Now I retried RCU installation but the same error comes and ignoring the error stops again. In the FMW configuration, in the step of Database Configuration Type, getting a success on "Get RCU Configuration" alone lets one go to the further steps, hence installing RCU has become necessary.
How do I get rid of the character set error or how do I change the character set to the required AL32UTF8?