This discussion is archived
5 Replies Latest reply: Apr 1, 2013 4:49 AM by Lorenz RSS

Bug APEX 4.2 Instance Settings

AndyPol Expert
Currently Being Moderated
Hi

I upgraded my APEX instance from 4.1 to 4.2 and now I can't go to (INTERNAL) Manage Instance->Instance Settings I see only ORA-28817: PL/SQL function returned an error. :(

Who can help me ?

Regards
  • 1. Re: Bug APEX 4.2 Instance Settings
    Christian Neumueller Expert
    Currently Being Moderated
    Hi Andy,

    we had issues with the wallet key when converting from 4.0 to 4.1, but that caused an

    ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error

    I never encountered ORA-28817 on that page before. Please help us debug this issue.

    (1) Are there any other issues with the migrated Apex instance?
    (2) Did you migrate from 4.0 or older to 4.1 before migrating to 4.2?
    (3) Are you sure you could access the Instance Settings page in 4.1?
    (4) Is a wallet configured? The changed encryption for the wallet password was the reason for that 4.1 bug.
    (5) Is a SMTP password configured?

    Regards,
    Christian
  • 2. Re: Bug APEX 4.2 Instance Settings
    AndyPol Expert
    Currently Being Moderated
    Hi Christian

    I sort out my problem.

    begin
    APEX_INSTANCE_ADMIN.SET_PARAMETER(
    P_PARAMETER =>'SMTP_PASSWORD',
    P_VALUE =>null);
    commit;
    end;

    Helped : )

    ad 1) No
    ad 2) Yes (from standard version in 11gR2 to 4.1.1)
    ad 3) Yes : )
    ad 4) No
    ad 5) API helped ;)

    Regards
  • 3. Re: Bug APEX 4.2 Instance Settings
    Christian Neumueller Expert
    Currently Being Moderated
    Hi Andy,

    good to know that you solved the issue for your instance! I'll try to reproduce it locally.

    Regards,
    Christian
  • 4. Re: Bug APEX 4.2 Instance Settings
    Jon Finke Newbie
    Currently Being Moderated
    As with some others reporting, I got the dreaded ORA-28817 when attempting to manage the instance settings.

    I upgraded from 4.1 to 4.2 a few months back. After reading some of the comments here, I tried applying the Patch Release 4.2.1.00.08 which claims to fix it - but alas - no joy - still can't manage the instance settings.

    I can also get the error via the command line:
    exec apex_instance_admin.set_parameter('WALLET_PWD',Null);
    BEGIN apex_instance_admin.set_parameter('WALLET_PWD',Null); END;
    
    *
    ERROR at line 1:
    ORA-28817: PL/SQL function returned an error.
    ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 67
    ORA-06512: at "SYS.DBMS_CRYPTO", line 44
    ORA-06512: at "APEX_040200.WWV_FLOW_CRYPTO", line 89
    ORA-06512: at "APEX_040200.WWV_FLOW_SECURITY", line 1931
    ORA-06512: at "APEX_040200.WWV_FLOW_INSTANCE_ADMIN", line 197
    ORA-06512: at line 1
    I am not sure what else to try....

    Version Info: Application Express 4.2.1.00.08

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    PL/SQL Release 11.2.0.3.0 - Production
    CORE     11.2.0.3.0     Production
    TNS for Linux: Version 11.2.0.3.0 - Production
    NLSRTL Version 11.2.0.3.0 - Production

    Note - I started a fresh thread for this item.

    Edited by: Jon Finke on Mar 27, 2013 3:03 PM
  • 5. Re: Bug APEX 4.2 Instance Settings
    Lorenz Newbie
    Currently Being Moderated
    Dear Jon,

    this worked for me:

    exec apex_instance_admin.set_parameter('SMTP_PASSWORD','...'); (replace ... with your password)
    commit;
    exec apex_instance_admin.set_parameter('WALLET_PWD',Null);
    commit;

    After this I was able to access instance settings without ORA-28817.
    Hope, that will do for you as well!

    Kind regards
    Lorenz

Legend

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