On Oracle databases, if you create schemas with a database user other than SYS or SYSTEM, you must grant that user the following AQ roles and privileges to successfully load the prefix_SOAINFRA schema:

GRANT ALL ON dbms_aqadm TO new_user WITH GRANT OPTION;GRANT ALL ON dbms_aq TO new_user WITH GRANT OPTION;

If you are an application developer and want to build WebCenter Portal applications, you must run RCU a second time to create a second version of the WebCenter (prefix_WEBCENTER on Oracle and Microsoft SQL Server databases or prefix_WC on IBM DB2 databases) schema. Note that this schema is separate from the WebCenter schema used by Oracle WebCenter Spaces, so you should make sure you use a different schema prefix. For information about the WebCenter services that require the WebCenter schema, see Table 5-1 in Oracle Fusion Middleware Installation Guide for Oracle WebCenter.

A separate dialog window will appear while RCU checks connectivity and some database prerequisites. When the database checking as passed without errors, click OK to dismiss the dialog window and go to the next screen.

You must remember the prefix and schema names for the components you are installing; you will need this information during the configuration phase of your product installation. Oracle recommends that you write these values down.

You must remember the passwords you enter on this screen; you will need this information during the configuration phase of your product installation. Oracle recommends that you write these values down.

A separate dialog window will appear while RCU checks connectivity and some database prerequisites. When the database checking as passed without errors, click OK to dismiss the dialog window and go to the next screen.

Note the location of the log files, then click Close to dismiss the screen.

2.6.1 Dropping Shared Tablespaces

Tablespaces that are shared among multiple schemas will not be 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 Section A.9.1, "Default Tablespace Mappings").

If you then drop the DEV_IAU schema, the DEV_IAS_TEMP tablespace would not be dropped since it is also being used by the DEV_MDS schema.

2.6.2 Dropping Schemas and Deleting Datafiles (Windows Only)

If your database is running on a Windows operating system, and you are using RCU to drop schemas from that database, some components datafiles are not dropped. These datafiles are located in the oradata directory in the database Oracle home.

For example, the following datafiles must be removed for Oracle Internet Directory (OID):

ATTRS1_OID.DBF

BATTRS1_OID.DBF

GCATS1_OID.DBF

GDEFAULT1_OID.DBF

SVRMG1_OID.DBF

IASTEMP.DBF

In the event you want to re-create the dropped schema, you must first manually delete the datafiles before re-creating the schema.

2.7 Creating the Portal Demo Schema

The Oracle Portal repository includes a demo schema (portal_schema_user_name_DEMO) that can not be installed using RCU. If you want to install this schema for testing purposes, you must do so using the instdemo.sql script: