# lsnrctl statusThis should show the status of the listener and the services it is listening for. Remember that when you run SQL*Plus on the database server, it does not need the listener to connect unless you specify the database tnsnames entry. Hope this helps.
Dig Deeper on Oracle Application Server
Related Q&A from John Garmany
I am facing the ORA-04076 error. I googled the error but was unable to understand it. What exactly do I need to do to solve this? I am using Toad. Continue Reading
We are using Oracle Database. In our client site, we have 500 users using the database at one time. Sometimes the database objects become invalid ... Continue Reading
Why is there an access violation in ora805.dll while connecting from Forms6i to Database9i? Continue Reading