RCU (RUNNING REPOSITORY CREATION UTILITY)

Before starting RCU installation to create the BIPLATFORM SCHEMA and MDS SCHEMA, We need to make connection to the database that we want to add the schema. In this case, i explain it using Oracle Database 12C. 

The first step, you need to know the hostname, port and service name. In oracle, you can check it from tnsnames.ora file (in my case, see the image below)

tnsnames.ora location

this is my tnsnames ora 

tnsnames.ora content

you can see at picture above that there are 2 that services that i define. The O is my default services that i am used to connect to my oracle database through command prompt
such as:
C:\Users\Administrator > sqlplus sys@O as sysdba

but as we know, in 12C there is a new feature that we called it container and pluggable database, so when you want to create user, the default session that you log in is CDB, and in this session, you will create a common user where it's needed to add 'C##' in front of the username.

"CREATE USER C##TEST IDENTIFIED BY test"

So when you want to create user using RCU, you need to make sure, using PDB session. So, you need to set service to connect PDB. And then, i add PDBO in my tnsnames ora. 

so you can connect just like this: 

C:\Users\Administrator > sqlplus sys@PDBO as sysdba

And then, you can create user just simple as usual, 

"CREATE USER TEST IDENTIFIED BY test"

Now, we can start the RCU. 

1) download RCU from OTN http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html on required additional software.

RCU in OTN

2) open the download 'rcuHome\BIN' and then run the rcu.bat

3) this the step we must follow
https://www.dropbox.com/s/fcqpq7xx189suwe/rcu.doc
more detail about set up tnsnames, see it
http://trying2writing.blogspot.com/2013/12/set-up-tnsnamesora.html

thanks