Oracle Internet Directory - Required Schemas already loaded

Posted by Brandon Kreisel on Server Fault See other posts from Server Fault or by Brandon Kreisel
Published on 2013-06-28T15:58:20Z Indexed on 2013/06/28 16:24 UTC
Read the original article Hit count: 752

Filed under:
|
|

After a successful installation of Oracle Internet Directories (OID) I attemped to remove and re-install it with a different configuration.

First I ran ./runInstaller.sh -deinstall from the OID middleware directory to uninstall.

Then i ran the installer again but it complained on the Specify Schema Database step.

Upon connecting to the database, the installer threw: INST-5174: Required schemas are already loaded in the specified database.

I connected to the target database and removed the OID schemas I knew of

SQL> drop user ODS cascade;
SQL> drop user ODSSM cascade;

That didn't not work and the error still appears. What steps am I missing?

Note:

  • The Database is 11g and it was brand new before installing OID so there is no other data
  • select * from all_users doesn't show any other schemas related to OID from what I can tell, the latest user creation date is OCT 2010

© Server Fault or respective owner

Related posts about Oracle

Related posts about oracle11g