RSS

RCU Schema Configuration failed with the error “The specified prefix already exists”

16 Nov

We all know that we need to create RCU schemas before starting OBIEE 11G (In fact, for any Fusion Middleware application) Installation. Because it is the base store for FMW.

Recently I came across a scenario where my customer created RCU schemas with Oracle Repository Creation Utility (RCU) version 11.1.1.3.0 and Installed OBIEE 11.1.1.3.0. Now after new OBIEE 11.1.1.5.0 release he wants to upgrade his application from 11.1.1.3.0. But he is not interested at the In-place upgrade. So we uninstalled weblogic and OBIEE 11.1.1.3.0 and started RCU 11.1.1.3.0 to drop the _BIPLATFORM and _MDS schemas.

The RCU shown up with successful message and so we thought everything is cleaned up and it’s good to create schemas again. I started RCU 11.1.1.5.0 and selected Oracle Business Intelligence component and given prefix as DEV. But am not able to assign this prefix and got a message like “The specified prefix already exists”.  Though I got successful dropped schemas message, just for cross check I looked at database for the DEV_BIPLATFORM and DEV_MDS schemas. There I am not seeing any of them.

Then I checked at dropped schemas log generated by RCU and realized that there is an entry in System.SCHEMA_VERSION_REGISTRY$ table which is stopping me to assign the same DEV prefix which we used for earlier version schemas.

Actually the RCU should drop schemas using mdsschemamanager.pl script. This script has capability to do cascade delete and will delete entries in System.SCHEMA_VERSION_REGISTRY$ table.

To make sure this log into RCU DATABASE as sys and run the following SQL Query:

Select * from System.SCHEMA_VERSION_REGISTRY$;

If this query returns any record then it means the RCU didn’t drop the schemas properly.

Actually what happened in this case is the RCU schemas were not dropped using mdsschemamanager.pl script, it’s just dropped with normal schema delete and the resulting repository record for the schema is not clean. Keep in mind, this is just in case if you want to use same prefix. Otherwise RCU will let you proceed to create new prefixed Schemas.

If the RCU schemas have been deleted incorrectly using the RCU drop user command, then We need to clean these entries before starting new repository schemas creation.

To do this, run the following SQL*Plus command as sys to complete the removal of the RCU schemas records in the repository database:

delete from System.SCHEMA_VERSION_REGISTRY$;

Once you confirmed there are no entries in System.SCHEMA_VERSION_REGISTRY$  table and start the RCU to create repository schemas with the prefix (DEV in my case). The RCU will go smooth and wont complain with any error.

Hope this helps you in your RCU issues troubleshooting.

 

Thanks,

Shiva

Advertisements
 
7 Comments

Posted by on November 16, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , , , , , , , , , ,

7 responses to “RCU Schema Configuration failed with the error “The specified prefix already exists”

  1. Zeeshan

    December 15, 2011 at 2:59 am

    hi,
    We have databas server oracle 10g release 10.2.0.3.0 on separate solaris machine I am trying to install OBIEE 11g on solaris 10 on separate machine, while performing prerequiste for OBIEE 11G i am installing RCU for repository creation, but cant succeeded it show me error Current Platform is not supported Supported Platform are Linux and Windows. As in oracle.com there rcu available only for linux and windows my question is there is an alternative way to install repository, kindly send me prerequiste steps so that i install OBIEE 11G successfully.

    Best Regards
    Zeeshan
    zeeshan4767@gmail.com

     
  2. abbi

    May 19, 2012 at 6:46 pm

    Thanks Shiva. It’s helped me alot

     
  3. Kumae

    June 12, 2012 at 6:40 pm

    In my case it was different, It didnt allowed to use same prefix, We need to delete tablespaces from rcu untility while we drop else it wont allow, it gave me pop with notification and path. I went to Oracle database path and deleted the file manually and ran successfully with same name

     
  4. sathish

    November 16, 2013 at 1:11 pm

    HI shiva,

    I want to install OBIEE 11G ON SOLARIS server.I have completed Oracle 11g installation.But when i try to install install RCU on the same,Its not supported.Even i have tried to install windows RCU file on windows machine by connecting with DB (on solaris).But its not happen.please help to reach the same.

    Regards,

    sathish

     
  5. chakravarthy gajula

    November 19, 2013 at 11:35 am

    Thanks a lot Shiva, this saved someones time and job 🙂

     
  6. selmvammuthu

    February 18, 2015 at 12:38 pm

    Thanks Good doc

     
  7. Zahid

    July 27, 2016 at 7:02 am

    Perfect one

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: