This discussion is archived
2 Replies Latest reply: Jan 22, 2010 5:37 AM by 364013 RSS

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

364013 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points