2 Replies Latest reply on Sep 25, 2007 7:20 PM by 543302

    ILM Install Problem


      I've downloaded the ilm assistant and receive a datatype mismatch on the install during the execution of the ilma_app.sql script. The error I receive follows:

      ......Message BACKUP_HELP
      ......Message ASM_HELP
      ERROR at line 1:
      ORA-01461: can bind a LONG value only for insert into a LONG column
      ORA-06512: at "FLOWS_030000.WWV_FLOW_API", line 8426
      ORA-06512: at line 22

      I reviewed the ilma_app.sql script and it appears that there are extraneous characters around starting around line 100527. If I remove the following block:

      '<P>ASM delivers higher performance than raw, sustained over time, with the ease of use of a file system. ASM¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿';


      h:=h||'¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿s intelligent mirroring technology enables up to triple data ';

      h:=h||'protection, even on non-RAID storage arrays, empowering low cost storage deployment reliably. '||chr(10)||
      '<P>The ILM Assistant can only advise whether ASM is being used. Refer to Enterprise Manager for more detailed information on the ASM configuration.'||chr(10)||

      then the install succeeds. Can someone verify if I'm missing something or if there's a corruption in the file?

      Thank you.

        • 1. Re: ILM Install Problem
          Jack Raitto-Oracle
          What is your language setting? You might want to check out this thread: problems installing ilm assitant Our default language setting is en.us. If your language setting is different, you can run into installation problems similar to what you are seeing.

          Does that help?

          Thanks, Jack
          • 2. Re: ILM Install Problem

            This is a known problem that I thought was fixed in the 1.1 kit. Perhaps the patch has not been uploaded yet.

            In the meantime, you can edit the ilma_app.sql file and search for 'ASM delivers'. This should place you near the bad string. Once there, you can delete all of the garbage from the string. It really doesn't matter if you get the resultant string correct, since this particular item is not exposed in the current ILM Assistant. Just make sure the PL/SQL syntax is correct. Then, save the file and retry the installation.