This content has been marked as final. Show 27 replies
I am copying/pasting from http://docs.oracle.com/cd/B28359_01/install.111/b32006/postcfg.htm
In a new installation or when upgrading the database, you configure the embedded PL/SQL gateway by running the configuration script apxconf.sql. Running this script enables you to configure the port for Oracle XML DB HTTP server and to specify a password for the Application Express ADMIN account. Then, you unlock the ANONYMOUS account.
To configure the embedded PL/SQL gateway:
Change your working directory to ORACLE_BASE\ORACLE_HOME\apex or whatever convention used to indicate the Oracle home.
Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
DRIVE_LETTER:\> sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
Run apxconf.sql as shown in the following example:
When prompted, enter a password for the Application Express Admin account.
Be sure to make a note of the password you enter. You will use this password to log in to Oracle Application Express Administration Services.
When prompted, enter the port for the Oracle XML DB HTTP server. The default port number is 8080.
Enter the following statement to unlock the ANONYMOUS account:
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
I do not have all those smart phones :-)
Incidentally Nokia Symbian phones also use Safari, though perhaps not the same versions as iPhones.
XDB user/password prompt is usually an installation wide thing, not application or device specific.
You cannot set it to "not display".
Getting this message is usually an indication of the setup being incomplete or incorrect.
Have you unlocked the APEX_PUBLIC_USER and ANONYMOUS accounts?
You will find many threads on this forum on how to address the XDB login from popping up.
What is baffling is that you do not get it all the time. Did you by any chance save the password in the browser after the first time you were prompted for the XDB password on the desktop and the phones where it works?