ODI 12c Repository Creations Step By Process in Oracle XE 11.2 Database

1) Go to Oracle\Middleware\Oracle_Home\oracle_common\bin  Call  rcu.batch for windows and rcu.sh for Unix.

2)Select System Load & Product Load

3) Provide your database details.  With SYSDBA privileged user.

4) Checking the DB requirement.  IF Oracle Database should be Greater than 11.2.0.3.
If you are using Oracle 12C. Check below requirement if you are getting below error in 12c.

Oracle DB 12c:--ORA-65096: invalid common user or role name

follow below rules.

http://www.ludovicocaldara.net/dba/playing-with-oracle-12c-users-and-roles/

5) Select below options for Repository users.

6) Validating the requirements.

7)Common Password for all users.

8) Master Repository and Work Repository Credentials.

9) It will create below list of Users and Table Spaces.

10). click on Create button to create all Repository tables.

11) Done.