By Bruno.Borges on Sep 05, 2013
This week I had the opportunity to play a little with the new and recently released Oracle DB 12c. This version brings a new approach for databases, calledPluggable Databases. There are plenty of articles and YouTube videos already explaining this and I will not focus this article on it. Instead, I want to help you on How to Install Oracle Fusion Middleware Infrastructure on Oracle DB 12c.
There are a couple of steps and commands to be followed, and some very important observations. Starting with a simple one:
Do NOT execute the RCU installer on top of a CDB.
One more time: do NOT execute RCU on top of a CDB.
If you do point the RCU tool to install over a CDB, you might get this message:
Now with this in mind, I believe you have understood that the first step is, obviously, to create a PDB. There are some options, but I will use pure SQL commands.
Step 0 - Use the correct encoding for your Database install
Step 1 - Create a PDB to hold the FMW Infrastructure Data
The following command will create a PDB called PDBFMW with a user "fmw" and password "welcome1".
SQL> CREATE PLUGGABLE DATABASE PDBFMW ADMIN USER fmw IDENTIFIED BY welcome1
Step 2 - Open the PDB for changes
SQL> ALTER PLUGGABLE DATABASE PDBFMW OPEN READ WRITE
Step 3 - Fix user privileges
SQL> GRANT SYS TO fmw
Step 4 - Run the RCU tool
Database Type: Oracle Database
Host Name: db12c (change to your DB IP address)
Service Name: pdbfmw (here you use the PDB name)
Password: welcome1 (or whatever you defined)