Dear Experts,
1)We have installed Apex 21.1 in our existing RDBMS home using
SQL> @apexins.sql APEX APEX TEMP1 /i/
2)Changed password with @apxchpwd.sql
SQL> SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';
COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ --------------------------------------------
Oracle Application Express
21.1.0 VALID
ORDS:
===
Installed and configured ORDS
[orasupp@erpsupportdb ords]$ java -jar ords.war
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires to login with administrator privileges to verify Oracle REST Data Services schema.
Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA:
Confirm password:
Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@//erpsupportdb:1521/SUPPDB
Retrieving information.
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:
2021-09-07T08:34:23.286Z INFO reloaded pools: []
Installing Oracle REST Data Services version 21.2.4.r2431032
... Log file written to /home/orasupp/ords_install_core_2021-09-07_140423_00441.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /home/orasupp/ords_install_datamodel_2021-09-07_140519_00154.log
... Log file written to /home/orasupp/ords_install_apex_2021-09-07_140528_00340.log
Completed installation for Oracle REST Data Services version 21.2.4.r2431032. Elapsed time: 00:01:13.310
Enter 1 if using HTTP or 2 if using HTTPS [1]:1
2021-09-07T08:35:45.701Z INFO HTTP and HTTP/2 cleartext listening on host: localhost port: 8080
2021-09-07T08:35:45.750Z INFO Disabling document root because the specified folder does not exist: /u01/SUPPDB_HOME/ords/conf/ords/standalone/doc_root
2021-09-07T08:35:47.509Z INFO Configuration properties for: |apex|pu|
cache.caching=false
cache.directory=/tmp/apex/cache
cache.duration=days
cache.expiration=7
cache.maxEntries=500
cache.monitorInterval=60
cache.procedureNameList=
cache.type=lru
database.api.enabled=true
db.connectionType=basic
db.hostname=erpsupportdb
db.port=1521
db.servicename=SUPPDB
debug.debugger=false
debug.printDebugToScreen=false
error.keepErrorMessages=true
error.maxEntries=50
feature.sdw=true
jdbc.DriverType=thin
jdbc.InactivityTimeout=1800
jdbc.InitialLimit=3
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=10
jdbc.MaxStatementsLimit=10
jdbc.MinLimit=1
jdbc.statementTimeout=900
log.logging=false
log.maxEntries=50
misc.compress=
misc.defaultPage=apex
restEnabledSql.active=true
security.disableDefaultExclusionList=false
security.maxEntries=2000
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
security.validationFunctionType=plsql
db.password=******
db.username=ORDS_PUBLIC_USER
resource.templates.enabled=true
2021-09-07T08:35:47.512Z WARNING *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment ***
2021-09-07T08:35:47.512Z WARNING *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment ***
2021-09-07T08:35:56.863Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 21.2.4.r2431032
Oracle REST Data Services server info: jetty/9.4.43.v20210629
Now we have two links:
http://erpsupportdb.ttd.com:8080/apex/apex_admin
http://erpsupportdb.ttd.com:8080/ords
1)Both are working.Which of the above link, should we share it to developers?
2)We used existing oracle home to install apex.Is that fine?
Thank You,
SG