OraFAQ Forum: Server Administration » Can not Log In Using the Webinterface

Home » RDBMS Server » Server Administration » Can not Log In Using the Webinterface (Oracle 23ai, Windows 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can not Log In Using the Webinterface [message #690389]

Thu, 14 August 2025 08:04

Fall and Winter
Messages: 3
Registered: August 2025

Junior Member

I have the problem that I cannot log in to the Oracle web interface. I have created the user like this:

create user ich identified by 6699 default tablespace mein_tablespace;

I cannot log in under SYSTEM, SYS or "ICH". I try to log in under 127.0.0.1:5050.

I have set the port like this:

begin
dbms_xdb.setHTTPport('5050');
end;
/

Report message to a moderator

Re: Can not Log In Using the Webinterface [message #690391 is a reply to message #690389]

Thu, 14 August 2025 09:49

John Watson
Messages: 8988
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

You'll need to a bit more than enabling the listening port. This little demo works for me in 19.x, I haven't tested in 23.x

exec dbms_xdb_config.sethttpport(8008)

exec dbms_epg.drop_dad('scott_dad')
exec dbms_epg.create_dad('scott_dad','/scott/*')
exec dbms_epg.set_dad_attribute('scott_dad','database-username','SCOTT')
exec dbms_epg.authorize_dad('scott_dad','SCOTT')
alter user anonymous account unlock;	--in both PDB and root


create or replace procedure scott.hello_world as begin
htp.print('Hello world at '||to_char(systimestamp));
end;
/

http://SCOTT:tiger@127.0.0.1:8008/scott/hello_world

Report message to a moderator

Re: Can not Log In Using the Webinterface [message #690392 is a reply to message #690391]

Thu, 14 August 2025 13:17

Fall and Winter
Messages: 3
Registered: August 2025

Junior Member

I created an user named scott with password tiger but the web interface still requieres an username and password. Whatever I entered was not accepted. In addition I can use sqlplus only as user SYSTEM.

Report message to a moderator

Re: Can not Log In Using the Webinterface [message #690393 is a reply to message #690392]

Fri, 15 August 2025 01:14

John Watson
Messages: 8988
Registered: January 2010
Location: Global Village

Senior Member

Please can you show what are you actually doing, and what you see?
Did you try my example?

And what do you mean by "the web interface"? Are we talking about the same thing?

Report message to a moderator

Re: Can not Log In Using the Webinterface [message #690394 is a reply to message #690393]

Fri, 15 August 2025 08:14

Fall and Winter
Messages: 3
Registered: August 2025

Junior Member

Hi,
Here is the in/-output

SQL> ALTER SESSION SET CONTAINER = FREEPDB1;

Session altered.

SQL> create user SCOTT identified by tiger;

User created.

SQL>
SQL> exec dbms_xdb_config.sethttpport(8008)

PL/SQL procedure successfully completed.

SQL>
SQL> exec dbms_epg.drop_dad('scott_dad')

PL/SQL procedure successfully completed.

SQL> exec dbms_epg.create_dad('scott_dad','/scott/*')

PL/SQL procedure successfully completed.

SQL> exec dbms_epg.set_dad_attribute('scott_dad','database-username','SCOTT')

PL/SQL procedure successfully completed.

SQL> exec dbms_epg.authorize_dad('scott_dad','SCOTT')

PL/SQL procedure successfully completed.

SQL> alter user anonymous account unlock;--in both PDB and root
2
SQL>
SQL> create or replace procedure scott.hello_world as begin
2 htp.print('Hello world at '||to_char(systimestamp));
3 end;
4 /

Procedure created.

Then I opened using a web browser
http://SCOTT:tiger@127.0.0.1:8008/scott/hello_world
Afterwards I am prompt to enter the user name and password but it doesn't work.

I mean by "web interface" the pages mentioned above wich should be shown by the webrowser

After starting sqlplus with username SCOTT and password tiger
I get the error ora-01017. I performed
sqlplus SCOTT/tiger@//localhost:8008/FREEPDB1
After a while I get the error
ORA-12537: TNS:connection closed

Report message to a moderator

Re: Can not Log In Using the Webinterface [message #690397 is a reply to message #690394]

Tue, 19 August 2025 11:51

John Watson
Messages: 8988
Registered: January 2010
Location: Global Village

Senior Member

Please use [code] tags to format your posts, I did ask you to do that before.

Your SCOTT user has no privileges, he won't be able to connect. And you can't connect to an http listening port with SQL*Plus, you have to go to a SQL*Net listening port. Probably 1521.
Lastly, it looks to me as though you have not unlocked the ANONYMOUS account.

[Updated on: Tue, 19 August 2025 11:53]

Report message to a moderator

Previous Topic:	What happened to our system and database?
Next Topic:	How To Find the cause of user locked

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 30 23:38:00 CDT 2025