3 Running the cleanMR Script

Instead of removing OracleAS Metadata Repository schemas and tablespaces from your database by running SQL statements manually, you can remove these objects by running the cleanMR script. The script executes the SQL statements in the repca_cleanup.sql file, located in the same directory as the cleanMR script.

Contents:

Section 3.1, "Copy the Directory to Your Hard Disk"
Section 3.2, "Run the cleanMR Script"

3.1 Copy the Directory to Your Hard Disk

You cannot run the cleanMR script directly from the "Oracle Application Server Metadata Repository Creation Assistant and Utilities" CD-ROM or the Oracle Application Server DVD because the script needs to create a file in the directory containing the script.

Copy the entire clean directory from the CD-ROM or DVD to your hard disk. Ensure that you can access the hard disk from the computer where the database is installed, because you must run the cleanMR script on the computer that is running the database.

Table 3-1 Location of the cleanMR Script on CD-ROM and DVD

Media	Location of the cleanMR Script
CD-ROM	"Oracle Application Server Metadata Repository Creation Assistant and Utilities" CD-ROM mount_point`/repCA/repca/clean/cleanMR`
DVD	mount_point`/repca_utilities/repca/clean/cleanMR`

The following example copies the directory to the /opt/oracle directory.

CD-ROM (assumes /cdrom is the mount point):

prompt> cp -r /cdrom/repCA/repca/clean /opt/oracle

DVD (assumes /cdrom is the mount point):

prompt> cp -r /cdrom/repca_utilities/repca/clean /opt/oracle

3.2 Run the cleanMR Script

You must run the cleanMR script on the computer that is running the database.

The cleanMR script is located in the clean directory that you copied to your hard disk (see Section 3.1, "Copy the Directory to Your Hard Disk").

Run the script from the clean directory that you copied to your hard disk. The following example assumes you copied the clean directory to the /opt/oracle directory.

prompt> cd /opt/oracle/clean
prompt> ./cleanMR -OH db_OH -DBSID sid [-DBUSER dbuser] -DBPASSWD password [-DBROLE dbrole]

Table 3-2 Parameters for the cleanMR Command

Parameter	Optional or Required	Description
`-OH` `db_OH`	Required	Specifies the ORACLE_HOME directory for the database.
`-DBSID` `sid`	Required	Specifies the SID of the database.
`-DBUSER` `dbuser`	Optional	Specifies the database user that the script will use to connect to the database. If not specified, the default user is "SYS".
`-DBPASSWD` `password`	Required	Specifies the password for DBUSER.
`-DBROLE` `dbrole`	Optional	Specifies the database user role. If not specified, the default role is "SYSDBA".

Example:

cleanMR -OH /opt/oracle/oradb -DBSID hrdb -DBPASSWD topsecret

Notes:

The script does not remove the ODS schema, and it does not remove these tablespaces: OLTS_ATTRSTORE, OLTS_BATTRSTORE, OLTS_CT_STORE, OLTS_DEFAULT, OLTS_SVRMGSTORE. These objects pertain to Oracle Internet Directory.

If you want the script to remove these objects, search for the object names and uncomment the corresponding lines in the repca_cleanup.sql file (located in the same directory as the cleanMR script).
The script does not remove data files.