5 Replies Latest reply: May 28, 2012 8:03 PM by RM Raja RSS

We are getting error message “IMP-00003: ORACLE error 1452 encountered” while trying to install ITSM 7.6.04 SP2 on Oracle 11g R2 using Stack Installer

Mussie Zemikael

Hi Guys,

 

We are getting error message “IMP-00003: ORACLE error 1452 encountered”while trying to install ITSM 7.6.04 SP2 on Oracle 11g R2 using Stack Installer

Full error message:

132 rows imported

IMP-00017: following statement failed with ORACLE error 1452:

"CREATE UNIQUE INDEX"I1049_41050_1" ON "T1049" ("C41050" )  PCTFREE 10 INIT"

"RANS 2 MAXTRANS 255STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUF"

"FER_POOL DEFAULT) TABLESPACE"ARSYSTEM" LOGGING"

IMP-00003: ORACLE error 1452 encountered

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Full error log attached

Steps we have taken:

  • -       We are trying to install ITSM on the same server as the DB server (localnot remote)
  • -       We are able to TNS ping
  • -       We are able to connect to the instance via SQLPLUS
  • -       We are able to connect via ODBC
  • -       We have made sure that all the variables (ORACLE_HOME, TNSADMIN,ORACLE_BASE) are setup as per the AR Installation document

We have tried installing ITSM using SSI and it failed twice with the sameerror message.

Environmental Details:

ITSM 7.6.04 SP2 (Stack Installer for Oracle)

DB – Oracle 11g R2 for 64 Bit

OS – Windows 2008 R2 Enterprise

 

Regards,

Mussie