-
1. Re: oracle 18c xe on linux centos 7 problem with autentification required XDB
cormaco Nov 2, 2018 6:38 PM (in response to gorddanmilojevic-JavaNet)Most likely you haven't unlocked the ANONYMOUS account:
Installing Application Express and Configuring Embedded PL/SQL Gateway
- Enter the following statement to unlock the
ANONYMOUS
account:ALTER USER ANONYMOUS ACCOUNT UNLOCK;
- Enter the following statement to unlock the
-
2. Re: oracle 18c xe on linux centos 7 problem with autentification required XDB
gorddanmilojevic-JavaNet Nov 2, 2018 8:16 PM (in response to cormaco)I have pass all steps as:
https://www.oracledbwr.com/oracle-apex/oracle-application-express-18-1-installation/
only cant access on on apex ( http://127.0.0.1:8888/apex )
-
3. Re: oracle 18c xe on linux centos 7 problem with autentification required XDB
cormaco Nov 2, 2018 9:00 PM (in response to gorddanmilojevic-JavaNet)Have you unlocked the ANONYMOUS account in the CDB? If not try that.
Also I notice that you are trying to connect to APEX on port 8888, is that the port you have configured? The default would be 8080.
-
4. Re: oracle 18c xe on linux centos 7 problem with autentification required XDB
gorddanmilojevic-JavaNet Nov 3, 2018 6:22 AM (in response to cormaco)yes, I m connect as sys xepcdb1
ALTER USER anonymous ACCOUNT UNLOCK; connect as xepcb1
ALTER USER xdb ACCOUNT UNLOCK; connect as xe
ALTER USER apex_public_user ACCOUNT UNLOCK; connect as xepdb1
ALTER USER flows_files ACCOUNT UNLOCK; connect as xepdb1
Port 8080 was se on default from @apxcon f
select dbms_xdb.gethttpport from dual
8888
If I return to previous - default setting of http port- (yesterday I have change this port in sqldeveloper starting epg
trying to see other posibility to open apex pages and jump login page xdb)
no any changes, can not login
-
6. Re: oracle 18c xe on linux centos 7 problem with autentification required XDB
Bernd Eckenfels Nov 7, 2018 12:54 PM (in response to gorddanmilojevic-JavaNet)I have the same basic authentication dialog on XE 18c on the Enterprise Manager Express Dialog when I enter the name of a container database in the third login field. does that function (without Apex) really need anonymous user as well?
-
7. Re: oracle 18c xe on linux centos 7 problem with autentification required XDB
Markus Flechtner Nov 7, 2018 5:28 PM (in response to Bernd Eckenfels)Hi Bernd,
please connect to your root container CDB$ROOT as SYS and execute
execute dbms_xdb_config.setglobalportenabled(true);
This should solve your issue
HTH
Markus
-
8. Re: oracle 18c xe on linux centos 7 problem with autentification required XDB
Bernd Eckenfels Nov 7, 2018 5:42 PM (in response to Markus Flechtner)Thanks Markus Flechtner you are correct, That was confusing, I had the same problem with the OraEE Docker container. It should not show the field in the login mask if it is turned off.
I guess
setglobalportenabled(true)
andlocalaccess(false)
should be mentioned in the quickstart faq. (And probablyflashto avoid disapointed users:)