8 Replies Latest reply on Nov 7, 2018 5:42 PM by Bernd Eckenfels

oracle 18c xe on linux centos 7 problem with autentification required XDB

gorddanmilojevic-JavaNet Nov 2, 2018 2:23 PM

Hi all

I m installing oracle xe 18c on centos linux 7

I m installing centos 7 as vm on virtual box, then run all preinstall steps and load 3 package

and then I m installing oracle 18 c xe as oracle user

with @apexins sysaux sysaux temp /i/

then @apex_epg_config /home/oracle

and all pass with no any erorr

I can open on https://127.0.0.1:5500/em and working ok all

I m run on sqldeveloper ords and connect with oracle 18 c xe but theres still error login xdb and cant acces to apex

Any idea how can I acces to oracle apex 18 ?

Whats user name and password (I have unlock xdb on xe and change password but error stil exist)

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;
Like Show 0 Likes(0)

Actions
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 )
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
5. Re: oracle 18c xe on linux centos 7 problem with autentification required XDB

gorddanmilojevic-JavaNet Nov 3, 2018 7:01 AM (in response to cormaco)

WORK!!!
thanx

its need connect as oracle user as sqlplus / as sysdba not as xepdb1 or xe
and unlock anonymous account!
Like Show 0 Likes(0)

Actions
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?
Like Show 0 Likes(0)

Actions
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
Like Show 1 Likes(1)

Actions
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) and localaccess(false) should be mentioned in the quickstart faq. (And probably ~~flash~~ to avoid disapointed users:)
Like Show 0 Likes(0)

Actions

Go to original post