# 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.
Related Q&A from John Garmany
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
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
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.