This discussion is archived
6 Replies Latest reply: Nov 17, 2009 9:58 PM by gary myers RSS

Invalid Login Credentials

673820 Newbie
Currently Being Moderated
I installed XE about a year ago to create an application for a neighbor's charity event. Now it's nearing time to use the application and I cannot remember what I set the password to. I have done searches and tried each of the following all with no luck.

Re: I HAVE INSTALLED ORACLE 10G BUT FORGOT THE ADMIN PASSWORD.
Installed apex successfully but cannot login to apex_admin


I changed the password for sys, system and the flows_xxx passwords using the procedures called for. I do a commit; after each of these changes (not sure if it's required, but I do it anyway). I try to login at 127.0.0.1:8080/apex/apex_admin with sys and system and get invalid login credentials every time.

Any help would be appreciated.

Scott
  • 1. Re: Invalid Login Credentials
    AndyPol Expert
    Currently Being Moderated
    Reset password for Admin account (admin is internal apex account you can't see it in oracle)
    You can reset it via this script apxchpwd.sql (you can find it in Apex install directory)
    If you run it you can set new password for Admin user after this go to:
    http://127.0.0.1:8080/apex
    and login

    Workspace: INTERNAL
    User: Admin
    Password: Pass_from_apxchpwd_script

    If you login you can go to application user, find them and set new password and unlock account. And now you can login to your application
  • 2. Re: Invalid Login Credentials
    673820 Newbie
    Currently Being Moderated
    I have tried running the script already, but I get an error that it cannot be found. I am launching SQLPLUS from the oraclexe directory. I have searched my hard drive and I do not have a script named apxchpwd.sql or any SQL with apx* for that matter. Can I get the script somewhere?

    thanks

    Scott
  • 3. Re: Invalid Login Credentials
    AndyPol Expert
    Currently Being Moderated
    Go [http://www.oracle.com/technology/products/database/application_express/index.html] download APEX, unzip and find this script.
  • 4. Re: Invalid Login Credentials
    673820 Newbie
    Currently Being Moderated
    Still no luck. Downloaded and executed with the following results

    +"SQL> connect sys/ as sysdba+
    +Enter password:+
    +Connected.+
    +SQL> @apxchpwd+
    +Enter a value below for the password for the Application Express ADMIN user.+


    +Enter a password for the ADMIN user []+
    +ERROR:+
    +ORA-01435: user does not exist+


    +...changing password for ADMIN+
    +wwv_flow_security.g_security_group_id := 10;+
    +*+
    +ERROR at line 3:+
    +ORA-06550: line 3, column 5:+
    +PLS-00201: identifier 'WWV_FLOW_SECURITY.G_SECURITY_GROUP_ID' must be declared+
    +ORA-06550: line 3, column 5:+
    +PL/SQL: Statement ignored+
    +ORA-06550: line 4, column 5:+
    +PLS-00201: identifier 'WWV_FLOW_SECURITY.G_USER' must be declared+
    +ORA-06550: line 4, column 5:+
    +PL/SQL: Statement ignored+
    +ORA-06550: line 5, column 5:+
    +PLS-00201: identifier 'WWV_FLOW_SECURITY.G_IMPORT_IN_PROGRESS' must be declared+
    +ORA-06550: line 5, column 5:+
    +PL/SQL: Statement ignored+
    +ORA-06550: line 8, column 23:+
    +PL/SQL: ORA-00942: table or view does not exist+
    +ORA-06550: line 7, column 15:+
    +PL/SQL: SQL Statement ignored+
    +ORA-06550: line 13, column 32:+
    +PLS-00364: loop index variable 'C1' use is invalid+
    +ORA-06550: line 12, column 9:+
    +PL/SQL: Statement ignored+
    +ORA-06550: line 19, column 5:+
    +PLS-00201: identifier 'WWV_FLOW_SECURITY.G_IMPORT_IN_PROGRESS' must be declared+
    +ORA-06550: line 19, column 5:+
    +PL/SQL: Statement ignored+



    +Commit complete."+

    Any other ideas?
  • 5. Re: Invalid Login Credentials
    673820 Newbie
    Currently Being Moderated
    Here is the output of my all_users:

    SQL> select username from all_users;

    USERNAME
    ------------------------------
    TURKEY
    FLOWS_030100
    APEX_PUBLIC_USER
    FLOWS_020100
    FLOWS_FILES
    HR
    MDSYS
    ANONYMOUS
    XDB
    CTXSYS
    DBSNMP

    USERNAME
    ------------------------------
    TSMSYS
    DIP
    OUTLN
    SYSTEM
    SYS

    16 rows selected.

    Hope this helps.

    Thank You

    Scott
  • 6. Re: Invalid Login Credentials
    gary myers Explorer
    Currently Being Moderated
    I suspect you downloaded the 3.2 version.
    The list of users indicates that you have 3.1 installed.

    If you look at the apxchpwd.sql script, there's a line like
    alter session set current_schema = APEX_030200;

    Try changing that to APEX_030100 and see if it works. If not, you'll need the apex3.1 zip file.

Legend

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