# 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
Initially Oracle 8i was installed on my PC. Recently I installed Oracle Forms 6i, and from that day on I was not able to connect to the database. It ... Continue Reading