This content has been marked as final. Show 22 replies
Did u resolve this issue?. I am also facing same issue. I am using apex 3.0 and 10g release2 enterprise edition.
It seems to be a IE7 warning. Don't know if you can get around this without using a secure connection.
I ad the exact same problem.
I used everything you wrote; no succcess
and then I did
alter user xdb unlock account;
It now works fine.
I installed Apex 3.1 into 10g and then did exec dbms_xdb.sethttpport(8080).
Also unlocked the xdb account and reset the password for xdb to "xdb".
So how when i do http://localhost:8080, I can see the default page ( the one that lists the folders home, public, sys, xmlconfig.xml).
However when I do http://localhost:8080/apex/apex_admin , again it pops up for the password .
I do not know what to put in for this so I can then access Apex.
Does anyone know how to get round this ?
I had the same problem until I could solve it through the tip of "tkres" in the following thread:
Configuring PL/SQL Gateway: value for imgupg ?
Running apex_epg_config.sql I had not set the proper parameter. The docu is not very clear at that point.
Make sure you don't get the error "The system cannot find the path specified".
When I got rid of that error my problem was solved.
If you wish to enable anonymous access to the ML DB repository, the following code creates the "<allow-repository-anonymous-access>" element if it is missing, or updates it if it is already present in the xdbconfig.xml file.
CONN sys/password AS SYSDBA
SET SERVEROUTPUT ON
l_value VARCHAR2(5) := 'true'; -- (true/false)
l_configxml := DBMS_XDB.cfg_get();
IF l_configxml.existsNode('/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access') = 0 THEN
-- Add missing element.
XMLType('<allow-repository-anonymous-access xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd">' ||
-- Update existing element.
Basically APEX images are stored within XMLDB, in order to access the XMLDB resources the appropriate ACL (Access Control List) assigned to the images directory need to have anonymous read-contents access otherwise (you guessed it) you are prompted for a username and password.
If you have note resolved this problem try this
Log into OEM,
select images and click edit
select the security tab
click edit (the file you should be editing is /sys/acls/ro_anonymous_acl.xml)
ensure you have the following:
restart the browser and retest APEX in this should resolve your XDB password problem.
I have the same problem too!
I'm doing a fresh install of apex on Oracle 10gR2
Have completed the steps, but when it comes to loggigng in, I am prompted for an XDB password.
I've run the apxchpwd script to set the admin user.
I've run the epg_config script as so: @apex_epg_config /home/oracle/apex_3.1.2
the apex_3.1.2 directory contains the apex directory.
I thought that people seemed to be having problems when doing an upgrade, but a fresh install seems fraught too!
any more suggestions? I'm just about to drop the entire database and start again.
>> I'm doing a fresh install of apex on Oracle 10gR2… I've run the epg_config script
Using EPG with APEX is only being supported on Oracle XE or Oracle 11g. For APEX on Oracle 10gR2 you should use the Oracle HTTP Server (OHS).
About version 10gR2 I think is not true. I use 10.2.0.3 OK I have the same problem with xdb user and password request, but after I give the username and password everything works fine.
>> I use 10.2.0.3 OK I have the same problem with xdb user and password request …
If you have a problem, it means that something is wrong in your system.
>> but after I give the username and password everything works fine.
Having a relatively simple solution to the problem still doesn’t make it right. You, or your users, shouldn’t have to enter any extra login credential, beside the APEX one. The only reason you need to enter a second password, to the XDB server, is that you are using it in an unsupported environment.
As I said before, using EPG is only supported on Oracle XE and Oracle 11g.
Did you solve this issue?
Could you please tell me the solution if you already fixed it?
It seems a lot of people got the same issue.
Would that be a bug of APEX?
I am running the APEX on top of Oracle Database 10g Release 10.2.0.1.0. But it always ask for the XDB username and Password before the APEX page is open.
And I have done a lot of research, and tried a lot of approach. None of them works.
So, I wonder if it is a bug for APEX.
db 10.2.0.3 + 3.1.2.00.20 apex
had the same problem. runned the script Pravednik posted above. working just fine now...