APEX Listener Database Configuration

E:\Download\apex_listener.2.0.2.133.14.47> java -jar apex.war configdir E:\apex_listener_config Jul 22, 2013 6:10:56 PM oracle.dbtools.common.config.cmds.ConfigDir execute INFO: Set config.dir to E:\apex_listener_config in: E:\Download\apex_listener.2.0.2.133.14.47\apex.war
 * Set up a custom path for configuration.

E:\Download\apex_listener.2.0.2.133.14.47> java -jar apex.war static --context-path /iengdw E:\Download\apex_4.2.2\apex\images
 * Create Web Archive for Oracle APEX images

E:\Download\apex_listener.2.0.2.133.14.47> java -jar apex.war setup Jul 22, 2013 6:15:15 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder INFO: Using configuration folder: E:\apex_listener_config\apex Enter the name of the database server [localhost]: PROD_HOST Enter the database listen port [1521]: Enter 1 to specify the database service name, or 2 to specify the database SID [1]:1 Enter the database service name: PROD_DB Enter the database user name [APEX_PUBLIC_USER]: Enter the database password for APEX_PUBLIC_USER: Confirm password: Enter 1 to enter passwords for the RESTful Services database users (APEX_LISTENER,APEX_REST_PUBLIC_USER), 2 to use the same password as used for APEX_PUBLIC_USER or, 3 to skip this step [1]:2 Jul 22, 2013 6:16:18 PM oracle.dbtools.common.config.file.ConfigurationFiles update INFO: Updated configurations: defaults, apex, apex_al, apex_rt
 * Initial database setup


 * [OPTIONAL] Add more database

E:\Download\apex_listener.2.0.2.133.14.47>java -jar apex.war setup --database DEV Aug 4, 2013 11:03:34 AM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder INFO: Using configuration folder: E:\apex_listener_config\apex Enter the name of the database server [localhost]: DEV_HOST Enter the database listen port [1521]: Enter 1 to specify the database service name, or 2 to specify the database SID [1]:1 Enter the database service name: DEV_DB Enter the database user name [APEX_PUBLIC_USER]: Enter the database password for APEX_PUBLIC_USER: Confirm password: Enter 1 to enter passwords for the RESTful Services database users (APEX_LISTENER,APEX_REST_PUBLIC_USER), 2 to use the same password as used for APEX_PUBLIC_USER or, 3 to skip this step [1]:2 Aug 4, 2013 11:05:36 AM oracle.dbtools.common.config.file.ConfigurationFiles update INFO: Updated configurations: apex, apex_al, apex_rt, pmdw, pmdw_al, pmdw_rt

E:\Download\apex_listener.2.0.2.133.14.47>java -jar apex.war map-url --type base -path /dev DEV Aug 4, 2013 11:15:01 AM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder INFO: Using configuration folder: E:\apex_listener_config\apex
 * Add MAP-URL (e.g., of Database DEV added earlier)

http://host:port/apex			=> Point to PROD_HOST:1521:PROD_DB http://host:port/apex/dev		=> Point to DEV_HOST:1521:DEV_DB
 * Validate

Go to E:\apex_listener_config\apex\conf There will be [db].xml, for example, dev.xml, and [db]_al.xml & [db]_rt.xml The latter two exist if the RESTful Services database user is configured.
 * Switch to use TNS connection instead of basic

Open the xml file and add

tns ORA11GR2 D:\product\10.1.3.1\OracleAS_1\NETWORK\ADMIN

Repeat if needed. If there is no key="db.*..", this means that the default configuration in the E:\apex_listener_config\apex\defaults.xml is used.