This content has been marked as final. Show 22 replies
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 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.
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.