I had to re register Oracle listener using "lsnrctl start". One new listener has been created and I am able to login in Apex user by PL/SQL developer.The port 8080 is open.
But if I try to open APEX application from URL(http://localhost:8080/apex/f?p=4550:1:0:::::) its not opening. It was working fine till yesterday.
I am using Oracle XE 11g and APEX 4.2
C:\Windows\system32>sqlplus sys as sysdba
SQL*Plus: Release 220.127.116.11.0 Production on Tue May 7 22:21:18 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Express Edition Release 18.104.22.168.0 - Production
SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
then not sure why APEX application is not opening from URL. Do I need to set something to APEX after creating new Listener. Can you please help?
Edited by: 1004608 on May 7, 2013 2:40 PM
Link to your listener thread would have been helpful: Oracle XE 11g with Apex No Listener Issue (ORA-12541: TNS:no listener)
It appears that your listener is using a static instance registration via the listener.ora file and missing the entries for the http service. Edit your listener.ora file (F:\Apex_Installed\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora) and add the following entries into the DESCRIPTION_LIST of the listener.ora file. Then restart the listenerer.
Resolved the issue. Got an idea from Couldn't login to the XE home page thread.
When I created the new Oracle DB listener I changed the HOSTNAME from my laptop hostname(Rocks-Lapi) to localhost. But 8080 was not registered in 8080 though Rocks-Lapi is the localhost as this was my personal laptop.
Again after creating the new listener I changed my hostname and restart the register and APEX worked fine.