1 Reply Latest reply on Apr 8, 2019 9:50 AM by Marco Gralike

    cannot login  XDB by browser on Port 8080 : Unauthorized

    Norbert.Hein

      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>