Oracle Internet Directory - Required Schemas already loaded
- by Brandon Kreisel
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
