Then I went to the corresponding APEX-instance and tried to login with
create user testudo identified by testudo; grant connect, dba to testudo;
Result: I'm redirected to the login page with no error message, as Jari sees in XE. This happens in both IE7 and FF 3.6.
I also looked into the post values with firebug and saw that I did enter the correct password.
1 error has occurred * Incorrect password or user does not have required role.
If everything works as expected, it should print:
alter session set current_schema = apex_040000; variable P1_USERNAME varchar2(30) variable P1_PASSWORD varchar2(30) begin :P1_USERNAME := 'sys'; :P1_PASSWORD := 'your_case_sensitive_sys_password'; end; / declare l_auth boolean := false; begin l_auth := sys.wwv_flow_val.verify_user( username => :P1_USERNAME, password => :P1_PASSWORD) = sys.wwv_flow_val.valid_user; if l_auth then dbms_output.put_line('Authenticated'); else dbms_output.put_line('NOT Authenticated'); end if; if wwv_flow_login.user_is_dba(p_username => :P1_USERNAME) then dbms_output.put_line('Is a DBA'); else dbms_output.put_line('Is NOT a DBA'); end if; end; /
Obviously, you'll need to plug in your own username and password here.
Authenticated Is a DBA
I get the same result for sys on my XE running the current APEX version, where I can reproduce this behavoiur as well.
Authenticated Is a DBA
(non-dba with incorrect password)
Authenticated Is NOT a DBA
(dba with incorrect password}
NOT Authenticated Is NOT a DBA
Which seems to prove that we don't have a general authentication problem (we would see the error message otherwhise), but possibly a problem with the redirect or some value to be passed correctly. I'm currently pointing at the redirect, as I get two 302 where I would expect only one, before I'm redirected to the login page again. See the following log of the OHS in front of the 11gR2:
NOT Authenticated Is a DBA
507675735006036 is the correct session number. I get the same results in firebug for the XE instance.
192.168.0.53 - APEX_PUBLIC_USER [11/Nov/2010:01:39:33 +0100] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 42 192.168.0.53 - APEX_PUBLIC_USER [11/Nov/2010:01:39:33 +0100] "GET /pls/apex/f?p=4500:36:507675735006036 HTTP/1.1" 302 5 192.168.0.53 - APEX_PUBLIC_USER [11/Nov/2010:01:39:33 +0100] "GET /pls/apex/f?p=4500:DBA_LOGIN:507675735006036:4500,36:NO HTTP/1.1" 200 16535
As mentioned, I can then log into Home > SQL Workshop > Utilities > About Database without any trouble.
SQL> create user new_dba identified by new_dba; User created. SQL> grant connect,dba to new_dba; Grant succeeded.
(installed from RPM available on Oracle Software Downloads)
SQL> select * 2 from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for Linux: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production
# uname -a Linux galeru 2.6.18-194.17.1.el5 #1 SMP Wed Sep 29 12:51:33 EDT 2010 i686 i686 i386 GNU/Linux # cat /etc/redhat-release CentOS release 5.5 (Final)
My 11gR2, installed by regular install package for X86_64
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production "CORE 10.2.0.1.0 Production" TNS for Linux: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production #uname -a Linux <hostname> 2.6.18-028stab070.5 #1 SMP Fri Sep 17 15:37:23 MSD 2010 i686 GNU/Linux #cat /etc/debian_version lenny/sid
I'm going to install XE on one of our training PCs running XP and retest there. If I can't reproduce the error there, at least I get a chance to monitor the positive case and compare traces.
Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production PL/SQL Release 188.8.131.52.0 - Production "CORE 184.108.40.206.0 Production" TNS for Linux: Version 220.127.116.11.0 - Production NLSRTL Version 18.104.22.168.0 - Production #uname -a Linux <hostname> 2.6.24-28-xen #1 SMP Fri Jun 18 16:10:42 UTC 2010 x86_64 GNU/Linux #cat /etc/debian_version lenny/sid
****** Drop old Apex image folder, jobs, public synonyms, flows files objects ****** Remove SYS owned old Apex objects ****** Remove old Apex schemas ****** Set XDB listener access to localhost only. Close database HTTP and FTP ports. begin dbms_xdb.deleteresource('/i/', DBMS_XDB.DELETE_RECURSIVE_FORCE); FLOWS_020100.wwv_flow_upgrade.remove_jobs; FLOWS_020100.wwv_flow_upgrade.drop_public_synonyms; FLOWS_020100.wwv_flow_upgrade.flows_files_objects_remove('FLOWS_020100'); execute immediate 'drop package WWV_FLOW_VAL'; execute immediate 'drop library WWV_FLOW_VAL_LIB'; execute immediate 'drop package HTMLDB_SYSTEM'; execute immediate 'drop public synonym HTMLDB_SYSTEM'; execute immediate 'drop user flows_020100 cascade'; execute immediate 'drop user flows_files cascade'; dbms_xdb.setlistenerlocalaccess(true); dbms_xdb.sethttpport(0); dbms_xdb.setftpport(0); commit; end; /