After a successful installation of Oracle
Internet Directories (OID)(It is part of Oracle identity management). I attempted
to remove it and re-install it with a different configuration.
I started to get a error message as INST-5174
I have removed the ODS related schemas in
the database using cascade option.
SQL> DROP USER ODS CASCADE;
SQL> DROP USER ODSSM CASCADE;
That didn't not work and the error still
appears.
Note:
·
The
Database is 11g and it was brand new before installing OID so there is no other
data doesn't show any other schemas related to OID.
Finding:
I have reviewed the installation log file
and oracle is trying connect to the database and does some pre-check; in that
oracle find the below entire in the sys user table
SQL> SELECT mrc_name FROM schema_version_registry where
comp_id = 'OID';
MRC_NAME
------------------------------
DEFAULT_PREFIX
Table description
SQL> desc schema_version_registry
Name
Null? Type
-----------------------------------------
-------- ----------------------------
COMP_ID NOT NULL
VARCHAR2(30)
COMP_NAME
VARCHAR2(255)
MRC_NAME NOT NULL
VARCHAR2(30)
MR_NAME
VARCHAR2(30)
MR_TYPE
VARCHAR2(30)
OWNER
VARCHAR2(30)
VERSION
VARCHAR2(30)
STATUS
VARCHAR2(11)
UPGRADED
CHAR(1)
START_TIME
TIMESTAMP(6)
MODIFIED
TIMESTAMP(6)
I have found some other rows which are
present in the table;
SQL> select * from schema_version_registry where
COMP_ID='OID';
OID
Oracle Internet Directory
DEFAULT_PREFIX OID
IM ODS
11.1.1.7.0 VALID
N
30-SEP-14 09.09.07.464367 AM
SQL> delete schema_version_registry where COMP_ID='OID';
1 row deleted.
SQL> commit;
Commit complete.
I have used the delete statement to delete the row; I
HAVE DONE THIS IN THE DEV SYSTEM. IF YOU ARE DOING IT IN THE PRODUCTION SYSTEM,
Check with oracle support.
Happy Learning
No comments:
Post a Comment