1 2 Previous Next 21 Replies Latest reply: Jul 16, 2009 5:46 AM by Klaker-Oracle RSS

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

    624403
      Hi all,

      I can not login as user admin.

      I have read entries about this POST but, noone worked for me.
      I have run

      oracle@host:/cgx1/SoftwareRepository/Oracle/oracle_application_express/apex/$ sqlplus "S9010@DCGAL00 as sysdba" @apxchpwd
      ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
      ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle;

      Allways i am said:
      1 error has occurred

      * Invalid Login Credentials


      I also i have tried with APEX_PUBLIC_USER:

      1 error has occurred

      * User APEX_PUBLIC_USER has insufficient privileges to run the ILM Assistant

      How can i change password for admin user?.

      Thank you veru much
        • 1. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
          Klaker-Oracle
          Have you tried logging into the ILM application with the user name ADMIN and using your default password that was used during the install process? This should work. You can add additional users. The install guide explains how to add new users in Chapter 9 (assuming you are running the latest version of the ILM application):

          http://www.oracle.com/technology/software/deploy/ilm/ilma_install_guide.pdf

          For 9i you need the following privileges:
          ALTER ANY TABLE
          ALTER TABLESPACE
          DROP ANY TABLE
          MANAGE TABLESPACE

          For 10g you need the following privileges:
          ADVISOR
          ALTER ANY TABLE
          ALTER TABLESPACE
          DROP ANY TABLE
          MANAGE TABLESPACE

          finally you need to grant your new user access to the ILM packages. You will need to connect to your database using SQLPlus as the SYS user and run the script GRANT_PRIVS {new_user_name}.

          Hope this helps

          Keith
          • 2. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
            689133
            Hi i have same problem didu solved? thanks fo your help

            Ana
            • 3. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
              624403
              Yes. I created another user and run the script grant_privs.sql for this new user
              It worked!
              • 4. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                689133
                The user name and password must have how many characters?
                I i'm receiving this:

                ORA-22921: length of input buffer is smaller than amount requested
                • 5. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                  Klaker-Oracle
                  I did some testing with ILMA 1.3 and the ADMIN user will not work. This is a lightweight APEX user installed by the ILMA scripts, however, since APEX 1.2 you have to use a database user for authentication within APEX. Therefore, the ADMIN user will not work if you try to use this user to log in to the ILMA application. We will be amending the documentation to indicate you do need to create a new database user and then run the grant_privs script to create a valid user than can run the ILMA app.

                  Apologies for the confusion.

                  Keith
                  • 6. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                    Klaker-Oracle
                    I am not aware of any limits on the number of characters. Try something very simple to see if that works, for example create a user called ILM with the same password. Then run the grant_privs script to ensure the user has the correct privileges. If that does not work then can you let me know

                    Which version of the database are you using
                    What is the URL you are using to run ILMA

                    Keith
                    • 7. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                      689133
                      Hi, i have created a user : ilm/ilm but it does not work... i'm implmenting this using Oracle 9.2.0.8, APEX 3.2, ILMA 1.3. Thanks
                      • 8. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                        689133
                        This is de URL:
                        http://seti84/pls/apex/f?p=737677
                        • 9. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                          689133
                          Hi when i get the error :

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

                          A severe error has occurred. Possible causes may include moving directly to a page using the browser history or
                          Back key, multiple users attempting to change the same data or an application defect. Please visit the Support page
                          under the Help Tab to report the error.

                          I check the the conecctins to the database and i found a conection fro the aplex_public user.

                          Can anyone help me please this is urgent.

                          Ana
                          • 10. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                            Klaker-Oracle
                            I don't have access to a 9i environment but I can explain how I configured my 10gR2 environment, which should be similar. To get this working I installed the HTTP server that is part of the Companion CD (I think?) and then after starting the database instance and listener you need to have both the OraHttpASControl and OraHttpProcessManager processes running. Do you have all the required services installed and running in your environment?

                            Regards

                            Keith
                            • 11. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                              689133
                              Are they services? I only Have httpserver as a service, but i dont know how to get the other process to run. Thanks for answer
                              • 12. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                                689133
                                Are u using apex 3.2 o lower?
                                • 13. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                                  543302
                                  A couple of problems have been noted in this thread:

                                  1. ILMA installation scripts fail when installing on a clean APEX 3.2 system. The script gets fooled by the APEX user which changed from FLOWS_nnnnnn to APEX_nnnnnn. The only way to get around this is to edit the ilma_install.sql script and replace the version check with the correct mask.

                                  2. The installation guide still refers to the APEX ADMIN user as a method of logging into the Assistant. ILMA once required APEX credentials to operation, but with 1.2, that stopped. The documentation missed the required updates. All you need to install ILMA is the password to the APEX installation user account (FLOWS_nnnnnn for APEX 2.* and APEX_nnnnnn for APEX 3.2 and above). ILMA needs this in order to physically install the APEX application data. To use ILMA, you must use an Oracle username/password, which is used to connect ILMA to the database. The user must have the minimum privs as stated in the ILMA installation guide.

                                  3. I personally tried to upgrade my APEX 2.2 to 3.2 on a 10.2 database. No errors occurred during install script execution; however, I saw some of the strange HTTP behavior that is noted in this thread. I think what is happening is that APEX leaves the original FLOWS_nnnnnn account intact, which fools the ILMA installation. As a result, you don't get an ILMA installation that APEX 3.2 can deal with. To resolve this, I completely removed all APEX/FLOWS components from the database and re-installed 3.2. Then, I installed a patched version of ILMA as noted into item 1 above.

                                  I am preparing minor release ILMA 1.4 at this very moment, and I hope to get it posted at oracle.com by next week. The release will only address some of the know bugs and will not introduce any new features.

                                  Thanks,

                                  Greg
                                  • 14. Re: admin login  fails in http://host:7777/pls/apex/f?p=737
                                    689133
                                    Hi,

                                    I had no trouble instaling ILMA, i have a problem trying to loging. The version that we have at the company is oracle 9.2.0.8, the apex we use is APEX 3.2 and ILM 1.3, the instalations ends successfully, but whe i try to logging to the applications i get this error:

                                    ORA-22921: length of input buffer is smaller than amount requested
                                    A severe error has occurred. Possible causes may include moving directly to a page using the browser history or
                                    Back key, multiple users attempting to change the same data or an application defect. Please visit the Support page
                                    under the Help Tab to report the error.

                                    But inthe database there is a conexion of the apex, and when i check the logging in the apex_admin it says that there was a conection of my user and that it was succesfully, for some reason, i don't understand, i can load the information of the ilm.


                                    Thanks for answer.
                                    1 2 Previous Next