Search the Site


bottom corner

TNS Listener service missing

You just installed a new Oracle database, fired everything up, and noticed the TNS Listener is missing. Here's a simple command to fix it.

This page is filed under keyword(s): oracle.

When installing a new Oracle database, by default a new database is installed, but that step is sometimes bypassed because you might not need it. When this initial database is not created, sometimes the install would fail to create the TNS Listener. To remedy this problem, all you have to do is run this command:

lsnrctl start

Before you run this command, you should take a look at the tnsnames.ora, listener.ora, and sqlnet.ora files to make sure they are properly configured.

Did you find this page useful? Please consider browsing other articles or subscribing to the RSS feed to keep up with latest.

This page is filed under keyword(s): oracle.
Author: C. Peter Chen
Last updated: 24 Mar 2008

bottom corner