-
Notifications
You must be signed in to change notification settings - Fork 795
Open
Description
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:~$
brightermatter and amizz
Metadata
Metadata
Assignees
Labels
No labels