Thursday, January 03, 2008

APEX 3.0.1 Login problem solved



After installation of APEX 3.0.1, I can not login with the ADMIN user. Check file
error_log.1199361600 at C:\oraclexe\app\oracle\product\10.2.0\http_1\Apache\Apache\logs>
I can see some entries like that:

[Thu Jan 03 12:41:52 2008] [error] [client 192.168.2.2] [ecid: 1199382112:192.168.2.2
:3600:4072:7,0] File does not exist: c:/oraclexe/app/oracle/product/10.2.0/http_1/
apache/imageshtmldb/apex_logo.gif

Note there is no '/' between images and htmldb.

In the file dads.conf located at C:\oraclexe\app\oracle\product\10.2.0\http_1\Apache\modplsql\conf,
I change the follow line
Alias /i/ "C:\oraclexe\app\oracle\product\10.2.0\http_1\Apache\images"
to
Alias /i/ "C:\oraclexe\app\oracle\product\10.2.0\http_1\Apache\images/"

, then I stop/restart the Apache server, the problem is solved


The content of my dads.conf
-----------------------------

Alias /i/ "C:\oraclexe\app\oracle\product\10.2.0\http_1\Apache\images/"
AddType text/xml xbl
AddType text/x-component htc


Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString NTBK:1521:TEST10G ServiceNameFormat
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword oracle
Allow from all