Hi Tom,
Here are the steps that we have followed for our application. we have build an application called mediconeed.com on apex 18.2 version (recent version available on apex.oracle.com). After installation of apex 18.2 on mediconeedDBCS instance on Dbaas, while i was accessing ords apex url :
https://129.154.73.73/ords/pmndb/ I was getting page error "129.154.73.73 refused to connect. ERR_CONNECTION_REFUSED".
When I checked the status of ords status whether it is up and running, i have found that ords was not up and running. while i was starting ords on 8080, i was getting an error "SEVERE: Could not start Standalone Mode because the listen port: 8080 is already in use by another process. Check if ano
ther instance of ords is already running"
Here are the steps that i have followed up
Using username "opc".
-- WARNING -- This system is for the use of authorized users only. Individuals
using this computer system without authority or in excess of their authority
are subject to having all their activities on this system monitored and
recorded by system personnel. Anyone using this system expressly consents to
such monitoring and is advised that if such monitoring reveals possible
evidence of criminal activity system personnel may provide the evidence of such
monitoring to law enforcement officials.
Authenticating with public key "imported-openssh-key"
Last login: Thu Dec 20 06:42:35 2018 from 124.123.134.35
*** ALERTS::INFO BEGIN ***
ALERTS:: System Alert: [Database User accounts check Failed]
ALERTS:: Please check /var/opt/oracle/log/monitor_alerts/monitor_alerts.log
*** ALERTS::INFO END ***
[opc@mediconeedDBCS ~]$
[opc@mediconeedDBCS ~]$
[opc@mediconeedDBCS ~]$ sudo -s
[root@mediconeedDBCS opc]# service iptables status
Table: filter
Chain INPUT (policy ACCEPT)
num target prot opt source destination
Chain FORWARD (policy DROP)
num target prot opt source destination
Chain OUTPUT (policy ACCEPT)
num target prot opt source destination
Table: nat
Chain PREROUTING (policy ACCEPT)
num target prot opt source destination
1 REDIRECT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:80 redir ports 8080
2 REDIRECT udp -- 0.0.0.0/0 0.0.0.0/0 udp dpt:80 redir ports 8080
3 REDIRECT tcp -- 0.0.0.0/0 0.0.0.0/0 tcp dpt:443 redir ports 8181
4 REDIRECT udp -- 0.0.0.0/0 0.0.0.0/0 udp dpt:443 redir ports 8181
Chain INPUT (policy ACCEPT)
num target prot opt source destination
Chain OUTPUT (policy ACCEPT)
num target prot opt source destination
Chain POSTROUTING (policy ACCEPT)
num target prot opt source destination
[root@mediconeedDBCS opc]# /etc/init.d/ords status
INFO: Obtaining Oracle REST Data Services status...
WARNING: Oracle REST Data Services is not running
[root@mediconeedDBCS opc]# /etc/init.d/ords start
INFO: Starting Oracle REST Data Services...
ERROR: There was an error starting ORDS. Please check the log under "/u01/app/oracle/product/ords/log/ords.log"
[root@mediconeedDBCS opc]# /etc/init.d/ords status
INFO: Obtaining Oracle REST Data Services status...
WARNING: Oracle REST Data Services is not running
[root@mediconeedDBCS opc]#
=================================
[oracle@mediconeedDBCS oracle]$ sqlplus '/as sysdba'
SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 19 09:23:08 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SQL> set pagesize 900 lines 1000
col name format a30
col value format a90
SQL> SQL> SQL>
SQL>
SQL> select name, value from v$diag_info where name='Diag Trace';
NAME VALUE
------------------------------ ------------------------------------------------- -----------------------------------------
Diag Trace /u01/app/oracle/diag/rdbms/mndb/MNDB/trace
SQL>
Using username "oracle".
-- WARNING -- This system is for the use of authorized users only. Individuals
using this computer system without authority or in excess of their authority
are subject to having all their activities on this system monitored and
recorded by system personnel. Anyone using this system expressly consents to
such monitoring and is advised that if such monitoring reveals possible
evidence of criminal activity system personnel may provide the evidence of such
monitoring to law enforcement officials.
Authenticating with public key "imported-openssh-key"
Last login: Thu Dec 20 08:49:33 2018
*** ALERTS::INFO BEGIN ***
ALERTS:: System Alert: [Database User accounts check Failed]
ALERTS:: Please check /var/opt/oracle/log/monitor_alerts/monitor_alerts.log
*** ALERTS::INFO END ***
[oracle@mediconeedDBCS oracle]$ view -- WARNING -- This system is for the use of authorized users only. Individuals
13 files to edit
-- WARNING -- This system is for the use of authorized users only. Individuals
[oracle@mediconeedDBCS oracle]$ more -- WARNING -- This system is for the use of authorized users only. Individuals
WARNING: No such file or directory
--: No such file or directory
This: No such file or directory
system: No such file or directory
is: No such file or directory
for: No such file or directory
the: No such file or directory
use: No such file or directory
of: No such file or directory
authorized: No such file or directory
users: No such file or directory
only.: No such file or directory
Individuals: No such file or directory
[oracle@mediconeedDBCS oracle]$ cd /u01/app/oracle/product/ords/log/
[oracle@mediconeedDBCS log]$ ls -lrt ord*
-rw-r-----. 1 oracle oinstall 705 Nov 13 10:15 ords_cdb_install_core_CDB_ROOT_ 2018-11-13_101555_00573.log
-rw-r-----. 1 oracle oinstall 15573 Nov 13 10:16 ords_cdb_install_core_PDB_SEED_ 2018-11-13_101557_00630.log
-rw-r-----. 1 oracle oinstall 1780 Nov 13 10:16 ords_cdb_install_datamodel_PDB_ SEED_2018-11-13_101609_00970.log
-rw-r-----. 1 oracle oinstall 1696 Nov 13 10:16 ords_cdb_install_apex_PDB_SEED_ 2018-11-13_101611_00586.log
-rw-r-----. 1 oracle oinstall 15573 Nov 13 10:16 ords_cdb_install_core_PMNDB_201 8-11-13_101614_00498.log
-rw-r-----. 1 oracle oinstall 1780 Nov 13 10:16 ords_cdb_install_datamodel_PMND B_2018-11-13_101623_00509.log
-rw-r-----. 1 oracle oinstall 1696 Nov 13 10:16 ords_cdb_install_apex_PMNDB_201 8-11-13_101625_00190.log
-rw-r--r--. 1 oracle oinstall 2204 Dec 7 02:30 ords_cdb_validate_core_PDB_SEED _2018-12-07_022954_00385.log
-rw-r--r--. 1 oracle oinstall 2204 Dec 7 02:30 ords_cdb_validate_core_PMNDB_20 18-12-07_023003_00375.log
-rw-r--r--. 1 oracle oinstall 2204 Dec 14 02:27 ords_cdb_validate_core_PDB_SEED _2018-12-14_022738_00912.log
-rw-r--r--. 1 oracle oinstall 2204 Dec 14 02:27 ords_cdb_validate_core_PMNDB_20 18-12-14_022745_00315.log
-rw-r--r--. 1 oracle oinstall 2204 Dec 19 05:13 ords_cdb_validate_core_PDB_SEED _2018-12-19_051318_00356.log
-rw-r--r--. 1 oracle oinstall 2204 Dec 19 05:13 ords_cdb_validate_core_PMNDB_20 18-12-19_051336_00919.log
-rw-r-----. 1 oracle oinstall 4390 Dec 20 08:49 ords.log
[oracle@mediconeedDBCS log]$ more ords.log
2018-12-20 08:49:35.343:INFO::main: Logging initialized @2209ms to org.eclipse.jetty.util.log.StdErrLog
Dec 20, 2018 8:49:35 AM
INFO: HTTP and HTTP/2 cleartext listening on port: 8080
Dec 20, 2018 8:49:35 AM
INFO: HTTPS listening on port: 8080
Dec 20, 2018 8:49:35 AM
INFO: The document root is serving static resources located in: /u01/app/oracle/product/ords/conf/ords/standalone/doc_ro
ot
2018-12-20 08:49:36.436:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f38
4329b122929e70a80934569428c; jvm 1.8.0_74-b02
2018-12-20 08:49:36.468:INFO:oejsh.ContextHandler:main: Started o.e.j.s.h.ContextHandler@24a35978{/,null,AVAILABLE}
2018-12-20 08:49:36.474:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2018-12-20 08:49:36.474:INFO:oejs.session:main: No SessionScavenger set, using defaults
2018-12-20 08:49:36.475:INFO:oejs.session:main: node0 Scavenging every 660000ms
Dec 20, 2018 8:49:38 AM
WARNING: The pool named: |apex|al| is invalid and will be ignored: The username or password for the connection pool name
d apex_al, are invalid, expired, or the account is locked
Dec 20, 2018 8:49:40 AM
WARNING: The pool named: |apex|| is invalid and will be ignored: The username or password for the connection pool named
apex, are invalid, expired, or the account is locked
Dec 20, 2018 8:49:42 AM
INFO: Creating Pool:|apex|pu|
Dec 20, 2018 8:49:42 AM
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
db.connectionType=basic
db.hostname=mediconeedDBCS.compute-612143172.oraclecloud.internal
db.password=******
db.port=1521
db.serviceNameSuffix=.612143172.oraclecloud.internal
db.servicename=MNDB.612143172.oraclecloud.internal
db.username=ORDS_PUBLIC_USER
debug.debugger=false
debug.printDebugToScreen=false
error.keepErrorMessages=true
error.maxEntries=50
jdbc.DriverType=thin
jdbc.InactivityTimeout=1800
jdbc.InitialLimit=3
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=400
jdbc.MaxStatementsLimit=10
jdbc.MinLimit=1
jdbc.statementTimeout=900
log.logging=false
log.maxEntries=50
misc.compress=
misc.defaultPage=apex
misc.pagination.maxRows=10000
restEnabledScript.active=true
restEnabledSql.active=true
restEnabledSqlExport.active=true
sdw.cdb.wallet=/scratch/db/ords/ords_wallet
sdw.cdb.wallet.password=******
security.disableDefaultExclusionList=false
security.maxEntries=2000
sqldev.name=apex
Dec 20, 2018 8:49:42 AM
WARNING: *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequatel
y for a production environment ***
Dec 20, 2018 8:49:43 AM
WARNING: The pool named: |apex|rt| is invalid and will be ignored: The username or password for the connection pool name
d apex_rt, are invalid, expired, or the account is locked
Dec 20, 2018 8:49:44 AM
INFO: Oracle REST Data Services initialized
Oracle REST Data Services version : 18.2.0.r1831332
Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT
2018-12-20 08:49:44.108:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@16f7c8c1{/ords,null,AVAILA
BLE,@Secured}
2018-12-20 08:49:44.109:INFO:oejsh.ContextHandler:main: Started o.e.j.s.h.ContextHandler@2f0a87b3{/,null,AVAILABLE,@Secu
red}
2018-12-20 08:49:44.126:INFO:oejs.AbstractConnector:main: Started ServerConnector@3276b56{HTTP/1.1,[http/1.1, h2c]}{0.0.
0.0:8080}
2018-12-20 08:49:44.130:INFO:oejs.AbstractConnector:main: Stopped ServerConnector@3276b56{HTTP/1.1,[http/1.1, h2c]}{0.0.
0.0:8080}
2018-12-20 08:49:44.130:INFO:oejs.AbstractConnector:main: Stopped Secured@14d3bc22{SSL,[ssl, http/1.1]}{0.0.0.0:8080}
2018-12-20 08:49:44.130:INFO:oejs.session:main: node0 Stopped scavenging
2018-12-20 08:49:44.131:INFO:oejsh.ContextHandler:main: Stopped o.e.j.s.h.ContextHandler@2f0a87b3{/,null,UNAVAILABLE,@Se
cured}
2018-12-20 08:49:44.135:INFO:oejsh.ContextHandler:main: Stopped o.e.j.s.ServletContextHandler@16f7c8c1{/ords,null,UNAVAI
LABLE,@Secured}
2018-12-20 08:49:44.136:INFO:oejsh.ContextHandler:main: Stopped o.e.j.s.h.ContextHandler@24a35978{/,null,UNAVAILABLE}
Dec 20, 2018 8:49:44 AM
SEVERE: Could not start Standalone Mode because the listen port: 8080 is already in use by another process. Check if ano
ther instance of ords is already running
[oracle@mediconeedDBCS log]$
Question:
1) I have verified port 8080 is not displaying on any of the process commands that I know. How to figure out which process is running on 8080 port and how to kill the process
2) what I came to know is ords default port is 8080. we cannot use 8080 port for any other application other than ords? is it correct ?
3) how to port ords to 8080 port and make ords to live and up& running. so that my application can be moved to production cloud.
I have raised SR with support.oracle.com but i have not got proper response
thanks,
Sreenivasulu Raju