2 Obtaining and Running Repository Creation Utility
- Obtaining RCU
In 12c, RCU is available with the Oracle Fusion Middleware Infrastructure distribution. - Starting RCU
After you install Oracle Fusion Middleware Infrastructure and create your Oracle home, you can start RCU from theORACLE_HOME/oracle_common/bin
directory. - Creating Schemas
Follow these instructions to create schemas in the database and verify that they are installed properly. - Dropping Schemas
Follow these instructions to drop schemas from the database.
Obtaining RCU
In 12c, RCU is available with the Oracle Fusion Middleware Infrastructure distribution.
For information about how to install and obtain RCU, see Installing the Infrastructure Software in Installing and Configuring the Oracle Fusion Middleware Infrastructure.
Parent topic: Obtaining and Running Repository Creation Utility
Starting RCU
After you install Oracle Fusion Middleware Infrastructure and create your Oracle home, you can start RCU from the ORACLE_HOME/oracle_common/bin
directory.
Note:
-
If you run the RCU by using a non-English database, you will need to set the following language environment variables: LANG, LC_ALL, and NLS_LANG. Use the environment commands that are appropriate for your environment.
For example, for UNIX operating systems running
csh
run the following:setenv LANG en_US.UTF8 setenv LC_ALL $LANG setenv NLS_LANG american_america
-
To start RCU, you do not need to set the JAVA_HOME environment variable. But, in case you want to use a specific JDK, ensure that the JAVA_HOME environment variable is set to the location of a certified JDK on your system.
For example, on UNIX operating systems, if your JDK is located in/home/Oracle/Java/
:setenv JAVA_HOME /home/Oracle/Java/jdk1.8.0_131
Be sure to replace the JDK location in this example with the actual JDK location on your system.
On Linux operating systems:
cd ORACLE_HOME/oracle_common/bin
./rcu
On Windows operating systems:
cd ORACLE_HOME\oracle_common\bin
rcu.bat
RCU provides a command-line interface in situations where Xserver is not available or you have access to telnet terminals without display capabilities. The command-line interface also allows you to embed RCU from command-line scripts or with some Oracle Fusion Middleware components (for example, Enterprise Manager).
For more information about using the Command Line Interface (CLI), see Running Repository Creation Utility from the Command Line.
Parent topic: Obtaining and Running Repository Creation Utility
Creating Schemas
Follow these instructions to create schemas in the database and verify that they are installed properly.
- Creating Schemas as a User with Full SYS or SYSDBA Privileges
If you are a user with full SYS or SYSDBA privileges and are able to provide valid authentication credentials for database access, follow these instructions to create schemas. - Creating Schemas as a User With Limited Database Privileges
If you are a user without SYS or SYSDBA privileges, follow these instructions to create schemas. - Verifying Schema Version Numbers
When the schemas are created in your database, RCU creates and maintains a table calledschema_version_registry
. This table contains schema information such as version number, component name and ID, date of creation and modification, and custom prefix.
Parent topic: Obtaining and Running Repository Creation Utility
Creating Schemas as a User with Full SYS or SYSDBA Privileges
If you are a user with full SYS or SYSDBA privileges and are able to provide valid authentication credentials for database access, follow these instructions to create schemas.
Click the screen name to see detailed information for that screen. Unless otherwise noted, click Next to continue to the next screen.
Table 2-1 Schema Creation Steps for Full-Privilege Users
Screen | Description |
---|---|
This screen introduces you to RCU. |
|
Select Create Repository, then select System Load and Product Load. If you do not have full SYS or SYSDBA privileges on the database, select Prepare Scripts for System Load and follow the schema creation instructions in Creating Schemas as a User With Limited Database Privileges. |
|
Specify your database connection credentials. Remember that if you are creating schemas on an IBM DB2 database, you must have already created one operating system user for each schema that you want to create. See Additional Requirements for IBM DB2 Databases for more information. Click Next when you have specified your credentials. A separate dialog window appears while RCU checks connectivity and the database prerequisites. When the database checking has passed without errors, click OK to dismiss the dialog window and go to the next screen. |
|
Select the components for which you want to create schemas, and specify a prefix to group them together. You must remember the prefix and schema names for the components you are installing; you need this information during the configuration phase of your product installation. Oracle recommends that you write down these values. |
|
Specify the passwords for your schema owners. You must remember the passwords you enter on this screen; you need this information during the configuration phase of your product installation. Oracle recommends that you write down these values. |
|
Use the Custom Variables screen to specify additional product configuration information. The Custom Variables screen appears only if you selected one or more of the following components on the Select Components screen. You can select a component on the Select Components screen only if the Oracle home in which RCU was started contains that component.
|
|
Use this screen to configure the desired tablespace mapping for the schemas that you want to create. When you click Next, a separate dialog window appears asking you to confirm that you want to create these tablespaces. Click OK to proceed and dismiss the dialog window. A second dialog window appears showing the progress of tablespace creation. After the tablespaces are created, click OK to dismiss this window and go to the next screen. |
|
Verify the information on this screen, then click Create to begin schema creation. |
|
Review the information on this screen to verify that the operation was completed successfully. Click Close to complete the schema creation and dismiss RCU. |
Parent topic: Creating Schemas
Creating Schemas as a User With Limited Database Privileges
If you are a user without SYS or SYSDBA privileges, follow these instructions to create schemas.
Note:
To create schemas in PDB using a user other than SYSDBA, RCU users need to create a common user and grant DBA to that common user, before running RCU. Local user with DBA privilege will not work correctly.Table 2-2 Schema Creation Steps for Limited-Privilege Users
Screen | Description |
---|---|
This screen introduces you to RCU. |
|
Select Create Repository, then select Prepare Scripts for System Load. See About System Load and Product Load for more information about these operations. |
|
Specify your database connection credentials. Click Next when you have specified your credentials. A separate dialog window appears while RCU checks connectivity and the database prerequisites. When the database checking has passed without errors, click OK to dismiss the dialog window and go to the next screen. Note: Performing system load and product load separately is only supported on Oracle and Oracle EBR databases. |
|
Select the components for which you want to create schemas, and specify a prefix to group them together. You must remember the prefix and schema names for the components you are installing; you need this information during the configuration phase of your product installation. Oracle recommends that you write down these values. |
|
Use the Custom Variables screen to specify additional product configuration information. The Custom Variables screen appears only if you selected one or more of the following components on the Select Components screen. You can select a component on the Select Components screen only if the Oracle home in which RCU was started contains that component.
|
|
Use this screen to configure the desired tablespace mapping for the schemas that you want to create. |
|
Verify the information on this screen, then click Generate to begin script generation. By default, the scripts are generated in the The names of the scripts generated are |
|
Review the information on this screen to verify that the operation was completed successfully. Click Close to complete the script generation and dismiss RCU. |
|
N/A |
After the scripts are created, user with SYS or SYSDBA privileges must execute the
|
N/A |
After the script is executed, start RCU again and perform the product load phase to complete schema creation. |
This screen introduces you to RCU. |
|
Select Create Repository, then select Perform Product Load. See About System Load and Product Load for more information about these operations. |
|
Specify your database connection credentials. Click Next when you have specified your credentials. A separate dialog window appears while RCU checks connectivity and the database prerequisites. When the database checking has passed without errors, click OK to dismiss the dialog window and go to the next screen. |
|
From the drop-down list, select the prefix you specified earlier in this procedure. Then, select the components for which you want to perform the product load. |
|
Specify the passwords for your schema owners. Ensure to specify the same passwords that were entered while running the You must remember the passwords you enter on this screen; you need this information during the configuration phase of your product installation. Oracle recommends that you write down these values. |
|
Use the Custom Variables screen to specify additional product configuration information. The Custom Variables screen appears only if you selected one or more of the following components on the Select Components screen. You can select a component on the Select Components screen only if the Oracle home in which RCU was started contains that component.
|
|
Verify the information on this screen, then click Data Load to begin schema creation. |
|
Review the information on this screen to verify that the operation was completed successfully. Click Close to complete the schema creation and dismiss RCU. |
|
N/A |
This optional step is needed for components that generate and must execute product load scripts requiring DBA privileges. After the product load phase is complete, someone with SYS or SYSDBA privileges must execute the This step is needed for the Audit Services (
|
Parent topic: Creating Schemas
Verifying Schema Version Numbers
When the schemas are created in your database, RCU creates and maintains a table called schema_version_registry
. This table contains schema information such as version number, component name and ID, date of creation and modification, and custom prefix.
To verify that the schemas are installed properly, run the following query after you sign in to SQL*Plus:
select comp_name, version from schema_version_registry;
The comp_name
argument retrieves the name of the component, and version
retrieves the version number. For example:
SQL> select comp_name, version from schema_version_registry; COMP_NAME -------------------------------------------------------------------------------- VERSION ------------------------------ Audit Service 12.2.1.2.0 Audit Service Append 12.2.1.2.0 Audit Service Viewer 12.2.1.2.0 COMP_NAME -------------------------------------------------------------------------------- VERSION ------------------------------ Metadata Services 12.2.1.3.0 Oracle Platform Security Services 12.2.1.0.0 Service Table 12.2.1.3.0 COMP_NAME -------------------------------------------------------------------------------- VERSION ------------------------------ User Messaging Service 12.2.1.0.0 WebLogic Services 12.2.1.0.0 8 rows selected.
Parent topic: Creating Schemas
Dropping Schemas
Follow these instructions to drop schemas from the database.
To see detailed information for a particular screen, click on the screen name. Unless otherwise noted, click Next to continue to the next screen.
Table 2-3 RCU Screens and Description for Dropping Schemas
Screen | Instructions and Action Required |
---|---|
This screen introduces you to RCU. |
|
Select Drop Repository. |
|
Specify your database connection credentials. Click Next when you have specified your credentials. A separate dialog window appears while RCU checks connectivity and the database prerequisites. When the database checking has passed without errors, click OK to dismiss the dialog window and go to the next screen. |
|
Select the prefix and the schemas that you want to drop, then click Next. A separate dialog window appears asking you to verify that you want to drop the selected schemas. Click OK to dismiss this window. A second dialog window appears while RCU checks the prerequisites for the schemas that you are dropping. After prerequisite checking is complete, click OK to dismiss this window and go to the next screen. |
|
The Custom Variables screen appears only if you selected one or more of the following components on the Select Components screen. You can select a component on the Select Components screen only if the Oracle home in which RCU was started contains that component.
|
|
Review the information on this screen, then click Drop to drop the schemas. |
|
Note the location of the log files, then click Close to dismiss the screen. |
- About Dropping Shared Tablespaces
Tablespaces that are shared among multiple schemas are not dropped. - Dropping Schemas and Deleting Datafiles (Windows Only)
If you used RCU to drop a schema from a Windows-based database, and you want to recreate the dropped schema, you will have to manually delete the datafiles that were not automatically removed when the schema was dropped.
Parent topic: Obtaining and Running Repository Creation Utility
About Dropping Shared Tablespaces
Tablespaces that are shared among multiple schemas are not dropped.
For example, if you created both the Audit Services (for example, DEV_IAU
) and Metadata Services (for example, DEV_MDS
) schemas, both schemas would use the temporary tablespace DEV_IAS_TEMP
(see Default Tablespace Mappings).
If you then drop the DEV_IAU
schema, the DEV_IAS_TEMP
tablespace would not be dropped since it is also used by the DEV_MDS
schema.
Parent topic: Dropping Schemas
Dropping Schemas and Deleting Datafiles (Windows Only)
If you used RCU to drop a schema from a Windows-based database, and you want to recreate the dropped schema, you will have to manually delete the datafiles that were not automatically removed when the schema was dropped.
Change to the DB_HOME\oradata
directory and manually delete any remaining datafiles before you recreate the schema.
Oracle recommends that you check this directory for any remaining datafiles before you attempt to recreate any dropped schema.
Parent topic: Dropping Schemas