Showing posts with label RCU Installation failure. Show all posts
Showing posts with label RCU Installation failure. Show all posts

Wednesday, August 7, 2013

Restart RCU installation after failure


Sometimes, RCU installation might fail due to whatever reasons, in that case if you are planning to re-install RCU schema, it complains that "

The specified prefix already exists".


Resolution:
This can be resolved by following below steps.
1. Login to SQLPLUS* using SYS user.
2. Check if there are any entries in the below table.
Select * from System.SCHEMA_VERSION_REGISTRY$; 
3. You might see two entries one for DEV_BIPLATFORM and DEV_MDS.
4. Delete these entries with below SQL.
     Delete from System.SCHEMA_VERSION_REGISTRY$;
5. Then drop the users, DEV_BIPLATFORM and DEV_MDS using the below SQL.
     drop user DEV_BIPLATFORM cascade;
  drop user DEV_MDS cascade;