By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
# 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.