APEX Listener Database Configuration

• Set up a custom path for 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

• Create Web Archive for Oracle APEX images

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

• Initial database setup

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

• [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

• Add MAP-URL (e.g., of Database DEV added earlier)

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

• Validate

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

• Switch to use TNS connection instead of basic

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.

Open the xml file and add

<entry key="db.connectionType">tns</entry>
<entry key="db.tnsAliasName">ORA11GR2</entry>
<entry key="db.tnsDirectory">D:\product\10.1.3.1\OracleAS_1\NETWORK\ADMIN</entry>

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.