Difference between revisions of "APEX Listener Database Configuration"
Jump to navigation
Jump to search
(Created page with "* Set up a custom path for configuration. <pre> 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.dbt...") |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 28: | Line 28: | ||
</pre> | </pre> | ||
− | * [OPTIONAL] Add more | + | * [OPTIONAL] Add more database |
<pre> | <pre> | ||
Line 46: | Line 46: | ||
</pre> | </pre> | ||
− | * Add MAP-URL (e.g., Database DEV added earlier) | + | * Add MAP-URL (e.g., of Database DEV added earlier) |
<pre> | <pre> | ||
E:\Download\apex_listener.2.0.2.133.14.47>java -jar apex.war map-url --type base -path /dev DEV | E:\Download\apex_listener.2.0.2.133.14.47>java -jar apex.war map-url --type base -path /dev DEV | ||
Line 62: | Line 62: | ||
* Switch to use TNS connection instead of basic | * Switch to use TNS connection instead of basic | ||
Go to E:\apex_listener_config\apex\conf | Go to E:\apex_listener_config\apex\conf | ||
− | There will be [db].xml, for example, dev.xml. The latter two exist if the RESTful Services database user is configured. | + | 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 | Open the xml file and add | ||
Line 73: | Line 73: | ||
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. | 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. | ||
+ | |||
+ | |||
+ | [[Category: APEX]] | ||
+ | [[Category: APEX Listener]] |
Latest revision as of 13:20, 4 August 2013
- 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.