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