OK, the XDB component appears to be good, and you already checked the port - so, if you did the exact procedure that I recommended (ie, stop listener, shutdown database, start listener and only then start the database) and even then you don´t see the http protocol line in the listaner status output, as I said probably OR your APEX is not using EPG (and you don´t know what it is using/how it is configured), OR you have some config failure in APEX - in any case I would recommend to you an APEX removal and reinstall / reconfig of APEX, it would be easier than trying to debug the current APEX install ...
I think the "database listener" is started...but the APEX...has issue:
[root@oradev oracle]# tnsping 192.168.1.122:1522
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2016 11:48:20
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.122)(PORT=1522)))
OK (0 msec)
[root@oradev oracle]# tnsping 192.168.1.122:7172
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2016 11:48:48
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.122)(PORT=7172)))
TNS-12541: TNS:no listener
[root@oradev oracle]#
As I said, the most common interface to APEX is the one where it uses the SAME DATABASE LISTENER, being acessed by XML DB (this is called the EPG - Embedded Pl/sql Gateway) : so, if you are using this config BUT the http line is not showing in the Database listener status, Of Course no ping will work, obviously... NO APEX LISTENER would exists in this case, all right ? APEX and database both use the same and only Listener, in this config when EPG is in use...
So, let me repeat : IF you did the exact procedure that I recommended (ie, stop listener, shutdown database, start listener and only then start the database) and even then you don´t see the http protocol line in the listener status output, as I said probably OR your APEX is not using EPG (and you don´t know what it is the non-EPG gateway/config in use, or how it is configured), OR (another option) you have some config failure in APEX - in any case I would recommend to you an APEX removal and reinstall / reconfig of APEX, it would be easier than trying to debug the current APEX install ...
Regards,
J. Laurindo Chiappa
Originally Posted by Janning
I think the "database listener" is started...but the APEX...has issue:
[root@oradev oracle]# tnsping 192.168.1.122:1522
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2016 11:48:20
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.122)(PORT=1522)))
OK (0 msec)
[root@oradev oracle]# tnsping 192.168.1.122:7172
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2016 11:48:48
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.122)(PORT=7172)))
TNS-12541: TNS:no listener
[root@oradev oracle]#
Reply With Quote
Originally Posted by Janning
