Password for Apex not being set

[PaulWalkerUK]

Hi,

I tried running the container as follows, but was unable to log into Apex (invalid username/password):

vagrant@vagrant:~$ sudo docker run -d -p 49161:1521 -p 8080:8080 wnameless/oracle-xe-11g

I tried running it in interactive mode and got the following output:

vagrant@vagrant:~$ sudo docker run -it -p 49161:1521 -p 8080:8080 wnameless/oracle-xe-11g
Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.

/usr/sbin/startup.sh: ignoring /docker-entrypoint-initdb.d/*

I've found that if I then run a bash session within the container, connect to SQLplus and execute the contents of apex-default-pwd.sql, then I can log into Apex OK:

vagrant@vagrant:~$ sudo docker container ls
CONTAINER ID        IMAGE                     COMMAND                  CREATED             STATUS              PORTS                                                     NAMES
26ee92a82786        wnameless/oracle-xe-11g   "/bin/sh -c '/usr/..."   22 minutes ago      Up 22 minutes       22/tcp, 0.0.0.0:8080->8080/tcp, 0.0.0.0:49161->1521/tcp   upbeat_brown

vagrant@vagrant:~$ sudo docker exec -it upbeat_brown bash
root@26ee92a82786:/# sqlplus sys/oracle as sysdba 

SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 17 08:32:04 2018

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> alter session set current_schema = APEX_040000;

begin

    wwv_flow_security.g_security_group_id := 10;
    wwv_flow_security.g_user := 'ADMIN';
    wwv_flow_security.g_import_in_progress := true;

    for c1 in (select user_id
                 from wwv_flow_fnd_user
                where security_group_id = wwv_flow_security.g_security_group_id
                  and user_name = wwv_flow_security.g_user) loop

        wwv_flow_fnd_user_api.edit_fnd_user(
            p_user_id       => c1.user_id,
            p_user_name     => wwv_flow_security.g_user,
            p_web_password  => 'admin',
            p_new_password  => 'admin');
    end loop;

    wwv_flow_security.g_import_in_progress := false;

end;
/
commit;
Session altered.

SQL> exit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
root@26ee92a82786:/# exit
exit
vagrant@vagrant:~$