2 Replies Latest reply: Jan 22, 2010 7:37 AM by 364013 RSS

    login fails in http://host:7777/pls/apex/f?p=737677

    364013
      Hi all,

      I installed ILMA 1.4 in a Oracle Database 9.2.0.8 with APEX 3.2.1 and when I try to access ILMA
      with user ilm_admin appears the error below:

      ORA-22921: length of input buffer is smaller than amount requested

      I already verified the HTTP server logs and didn't find any error message.

      Did anybody could help to solve problem?

      Thanks in advance.
        • 1. Re: login fails in http://host:7777/pls/apex/f?p=737677
          KLaker
          A few things to check.

          1) Can you access the APEX admin page?
          2) Don't forget usernames and passwords are case-sensitive so make sure you use the correct case
          3) Try creating a new database user, e.g. ILM_USER, and then run the sql script GRANT_PRIVS which is included with the other ILM installation scripts
          4) Try installing the ILM demo application and see if you can access the main page of the demo app

          Hope this helps

          Keith
          Keith Laker | Senior Principal Product Manager | Data Warehousing
          Oracle Data Warehouse, Database Product Management
          Southgate Centre Two, 321 Wilmslow Road, Heald Green, Cheadle, Cheshire. SK8 3PW
          • 2. Re: login fails in http://host:7777/pls/apex/f?p=737677
            364013
            Hi Keith,

            thanks for your help.

            1) Can you access the APEX admin page?

            Yes, I can.

            URL: http://10.255.100.86:7777/pls/apex/f?p=4550:10:64563111930496530

            2) Don't forget usernames and passwords are case-sensitive so make sure you use the correct case

            Yes, I'm using.

            3) Try creating a new database user, e.g. ILM_USER, and then run the sql script GRANT_PRIVS
            which is included with the other ILM installation scripts

            [oracle@odbsrv92 ilma]$ sqlplus "/ as sysdba"

            SQL*Plus: Release 9.2.0.8.0 - Production on Fri Jan 22 09:00:36 2010

            Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


            Connected to:
            Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
            With the Partitioning, OLAP and Oracle Data Mining options
            JServer Release 9.2.0.8.0 - Production

            SQL> create user ilm_user identified by Oracle$05 default tablespace ilm temporary tablespace temp;

            User created.

            SQL> @grant_privs ilm_user

            Session altered.


            Session altered.

            old 1: GRANT MANAGE TABLESPACE TO &ilm_user
            new 1: GRANT MANAGE TABLESPACE TO ilm_user

            Grant succeeded.

            old 1: GRANT ALTER TABLESPACE TO &ilm_user
            new 1: GRANT ALTER TABLESPACE TO ilm_user

            Grant succeeded.

            old 1: GRANT ALTER ANY TABLE TO &ilm_user
            new 1: GRANT ALTER ANY TABLE TO ilm_user

            Grant succeeded.

            old 1: GRANT DROP ANY TABLE TO &ilm_user
            new 1: GRANT DROP ANY TABLE TO ilm_user

            Grant succeeded.


            PL/SQL procedure successfully completed.






            Granting execute privileges on object types...

            old 2: l_user varchar2(30) := '&ilm_user';
            new 2: l_user varchar2(30) := 'ilm_user';

            PL/SQL procedure successfully completed.

            URL: http://10.255.100.86:7777/pls/apex/f?p=737677:11

            Login with ilm_user fail
            Error message: ORA-22921: length of input buffer is smaller than amount requested




            4) Try installing the ILM demo application and see if you can access the main page of the demo app

            I installed ILM Demo successfuly but login with ilm_demo fail
            Error message: ORA-22921: length of input buffer is smaller than amount requested
            URL: http://10.255.100.86:7777/pls/apex/f?p=737677:11


            Regards,
            Valter Aquino