How to remove ods schema from DB without using MRCA tool

Problem Description:

Error while recreating OracleAS Metadata Repository Schemas using MRCA tools.

 

I couldn’t able to remove the old schema from DB using MRCA tools.

Here I would like to cover the steps of removing ODS schema from DB directly.

Remove the failed MR installation using cleanMR. The cleanMR script is located in the ORACLE_HOME/repca/clean directory, where ORACLE_HOME specifies the directory where you installed OracleAS Metadata Repository Creation Assistant.

prompt> cleanMR -HOST db_host -PORT db_port -SERVICE_NAME service_name

[-DBUSER dbuser] -DBPASSWD password [-DBROLE dbrole]

Please refer to below section for getting details on the clearMR script execution process,

http://docs.oracle.com/cd/B28196_01/repca.1014/b28214/remove.htm#CHDBIGFG

4.7 Removing OracleAS Metadata Repository Using the cleanMR Script

The cleanMR script does not remove Oracle Internet Directory (OID) schemas, so please remove the following from the database:

  1. 1.    Schema: ODS

Tablespace: OLTS_ATTRSTORE

Tablespace: OLTS_BATTRSTORE

Tablespace: OLTS_CT_STORE

Tablespace: OLTS_DEFAULT

Tablespace: OLTS_SVRMGSTORE

e.g.

SQL> drop tablespace OLTS_ATTRSTORE cascade;

SQL> drop tablespace OLTS_BATTRSTORE cascade;

SQL> drop tablespace OLTS_CT_STORE cascade;

SQL> drop tablespace OLTS_DEFAULT cascade;

SQL> drop tablespace OLTS_SVRMGSTORE cascade;

SQL> drop schema ODS;

2.      Now recreate the ods schema using MRCA tool.

About the Author sarath

An Oracle Identity and Access Management professional, having working on Oracle Access Manager Single Sign-On implementations, Installation/Configuration of Identity Server, Web Pass, Web Gate, Access Gate, Policy Manager, Access Server, Policy Domains, Authentication /Authorization schemes, Single Sign-On (single and multi-domain), OIM, OVD, OID, OAAM, OIF, High Availability/Failover/ SSL deployment.

Leave a Comment:

1 comments
Mahendra says February 17, 2013

Sarath,

Thanks for sharing. These are very useful.

-Mahendra

Reply
Add Your Reply

Not found