Create Database Schemas Using the Repository Creation Utility (RCU)

To create the database schemas using RCU:

1. Execute the rcu.bat(sh) from the Oracle_Home\oracle_common\bin folder.

   This launches the Repository Creation Utility.

   

2. On the Welcome screen, click Next.

3. On Create Repository, select the Create Repository option and then select the System Load and Product Load option.

4. On Database Connection Details, complete the following fields to enter the database connection information:

   • Database Type

   • Host Name

   • Port

   • Service Name

   • Username

   • Password

   • Role

5. Click Next.

6. Click OK after the prerequisites check completes.

   

7. On Select Components, perform these steps:

   1. Select the Create new prefix option and enter a new schema prefix.

   2. In the Component column, click the AS Common Schemas check box.

   3. Click Next.

   4. After a second prerequisites check, click OK.

8. On Schema Passwords, select the Use same passwords for all schemas option and then enter a password for all schemas.

9. Click Next.

   

10. On Map Tablespaces, review the tablespaces information and click Next.

11. In the Confirmation dialog box, click OK to confirm tablespaces creation.

12. On Summary, click Create.

13. On Completion Summary, review the summary and then click Close.