I tried unlocking the account of XDB user
alter user xdb accoun unlock;
Then I restarted the listener using
$ lsnrctl stop
Wait for 5 minutes
and then try to access the apex website at
The XDB popup goes away.
Now I dont know the password to this website.
The Embedded PL/SQL Gateway (EPG) is NOT supported on Oracle 10g. It is only supported on Express Edition (XE) or 11g. So, even if you do get this to work, you're going forward on an unsupported configuration. Even though the EPG is a bit more convenient, it also has a lot of limitations such as no GZip support and no "Expires Headers" (both of which make it substantially slower), no Apache module support, such as mod_rewrite, SSL is a pain to configure, port 80 on Unix / Linux is a pain to configure...
Go with a supported platform. If you need 10g, install the HTTP Server from the companion CD, or better yet the HTTP Server that ships with 11g based on Apache 2.0.
With apex 3.2 and 188.8.131.52 and having gone through this frustrating problem in three previous apex releases, this is what I have figured out for my current installation:
In OEM, I changed the images resource administered by the /sys/acls/ro_anonymous_acl.xml ACL file to grant 'dav:read' to ANONYMOUS rather than the default of 'read-contents'.
This is the sql OEM used:
UPDATE resource_view r
SET r.res=UPDATEXML(res, '/a:Resource/a:Contents/b:acl','
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/xdb/acl.xsd http://xmlns.oracle.com/xdb/acl.xsd">
'xmlns:a="http://xmlns.oracle.com/xdb/XDBResource.xsd" xmlns:b="http://xmlns.oracle.com/xdb/acl.xsd"') WHERE r.any_path = '/sys/acls/ro_anonymous_acl.xml';
Edited by: Bill on Apr 9, 2009 10:18 AM
1) DO NOT POST NEW MESSAGES TO A THREAD THAT IS THIS OLD!!
2) Change your forum handle to something more friendly.. We are a sociable group here and like to know who we are talking to..
Time flies like the wind, but fruit flies like bananas.
If this question is answered, please mark the thread as closed and assign points where earned..