also the user login as apexresprd resides on application .. so i assumed that the listener should be running from the database in order for the application server to communicate with the db server for Apex..... Sorry if i made a foool outta myself!!!There's often a confusion with database listener and APEX Listener... Of course, you can run APEX Listener on the same machine as your database, but in contrast to the database listener it's more an application server component than a database component. Similar to APEX Listener, which is deployed to a JEE container [app server] or uses an embedded JEE container, mod_plsql was "added" to Oracle HTTP Server to make it front your APEX instance in your database. To do that, they both connect to the database using the database listener using JDBC (APEX Listener) or OCI (mod_plsql).
OHS1 | OHS | 10697 | AliveI'm not sure about this. This means your Oracle HTTP Server (OHS) is up. It doesn't mean it has been configured properly to make APEX available. This is done in the dads.conf for mod_plsql you've already mentioned.
i believe the above says the apex is alive but i cant access it via the url so not sure what i have to do ..