Hey all,
cannot login XDB by browser on Port 8080 : Unauthorized
EM Express on Port 8080 works fine
Version 12.2.0.1.0
64-bit Windows
non-cdb
Browser Fiefox 32 also 64
when trying this :
http://MY_SERVERHOST_NAME:8080/sys/schemas/PUBLIC/project.com/namespace/
MESSAGE - Windows like: http://MY_SERVERHOST_NAME:8080 requires Username and Password. Output Website: "XDB" :
I do login
login DB-User 'XDB' / Password
but doesn't work:
Unauthorized
Do I need special access Rights by using DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE ?
If so, what and how ?
Norbert
-----------------------------------------------------------------------------------------------
check listener and xdb looks ok:
conn sys as sysdba ;
-----------------------------------------------------------------------------------------------
SQL> select count(*) from dba_objects where owner='XDB' and status='INVALID';
0
-------------------------------------------------------------------------------------------------
SQL> select comp_name, status, version from DBA_REGISTRY where comp_name='Oracle XML Database';
Oracle XML Database VALID 12.2.0.1.0
------------------------------------------------------------------------------------------------
SQL> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=ORCLXDB)
max_dispatchers integer
------------------------------------------------------------------------------------------------
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_ORCL
------------------------------------------------------------------------------------------------
C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 20-MRZ-2019 12:47:42
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MY_SERVERHOST_NAME)(PORT=1521)))
STATUS des LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Startdatum 20-MRZ-2019 12:38:15
Uptime 0 Tage 0 Std. 9 Min. 26 Sek.
Traceebene off
Sicherheit ON: Local OS Authentication
SNMP OFF
Parameterdatei des Listener C:\ORACLE12\product\12.2.0\dbhome_1\network\admin\listener.ora
Logdatei des Listener C:\ORACLE12\diag\tnslsnr\MY_SERVERHOST_NAME\listener\alert\log.xml
Zusammenfassung Listening-Endpunkte...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MY_SERVERHOST_NAME)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MY_SERVERHOST_NAME)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=MY_SERVERHOST_NAME)(PORT=5500))(Security=(my_wallet_directory=C:\ORACLE12\admin\ORCL\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services _bersicht...
Dienst "CLRExtProc" hat 1 Instanzen.
Instanz "CLRExtProc", Status UNKNOWN, hat 1 Handler f³r diesen Dienst...
Dienst "ORCL" hat 2 Instanzen.
Instanz "ORCL", Status UNKNOWN, hat 1 Handler f³r diesen Dienst...
Instanz "orcl", Status READY, hat 1 Handler f³r diesen Dienst...
Dienst "ORCLXDB" hat 1 Instanzen.
Instanz "orcl", Status READY, hat 1 Handler f³r diesen Dienst...
Der Befehl wurde erfolgreich ausgef³hrt.
C:\Windows\system32>
-------------------------------------------------------------------------------
Call EM Express OK :
http://MY_SERVERHOST_NAME:8080/em/login
OK => login system OK
-------------------------------------------------------------------------------
Call xdb Error
http://MY_SERVERHOST_NAME:8080/sys/schemas/PUBLIC/project.com/namespace/
MESSAGE like: http://MY_SERVERHOST_NAME:8080 requires Username and Password. Output Website: "XDB" :
login DB_user / Password:
Unauthorized
-------------------------------------------------------------------
log.xml:
<msg time='2019-03-21T09:46:25.533+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='MY_SERVERHOST_NAME'
host_addr='::1' pid='7576'>
<txt>21-MRZ-2019 09:46:25 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=<Client_host_IP>)(PORT=61617)) * handoff * http * 0
</txt>
</msg>