Solved

TNSListener fails to start after Installing Oracle8i (8.1.6)

Posted on 2001-09-05
6
432 Views
Last Modified: 2010-05-18
On Windows 2000, I have not been able to get the TNSListener to start after installation. I've checked the Listener.ora, TNSNames.ora and they look fine.  After uninstalling Oracle 8i, I noticed that registry keys still exists in the registry. Also, notices registry keys from a previous Oracle Installation, I cannot delete the keys and I think this may be preventing the TNSListener service from starting.

Usually I get the error ORA-12541: TNS:no listener and I can't start the listener service.

Sample registry keys:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\Root\
LEGACY_ORACLEORAHOME81TNSLISTENER
note: after I install 8.1.6 there is also a LEGACY_ORACLEORAHOME816TNSLISTENER

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\Root\LEGACY_ORACLEORAHOMETNSLISTENER

0
Comment
Question by:dfell_us
6 Comments
 

Accepted Solution

by:
PhillipVest earned 50 total points
ID: 6458166
Make sure you are plugged into the network.  If Windows 2000 detects that you are not connected, it will not allow the listener service to start.
0
 

Author Comment

by:dfell_us
ID: 6458416
I'll try installing again while connected to our domain over VPN.  I noticed since they put me on a nt.domain i've had trouble getting the listener running and have tried it both ways.  But it is worth a try, I'll have to be connected to the VPN, during the time the listener is created and tested, as well as database connection.
0
 

Author Comment

by:dfell_us
ID: 6464786
I'm connected to the VPN and used Netconfig8 to delete the listener and then created a new one.  Still got the same results when I went to the lsntnr and tried to start it, here is the error mess:

LSNRCTL> start
Starting tnslsnr: please wait...

Failed to start service, error 1058.
TNS-12536: TNS:operation would block
 TNS-12560: TNS:protocol adapter error
  TNS-00506: Operation would block
   32-bit Windows Error: 997: Unknown error
LSNRCTL>
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:kimprasad
ID: 6477179
the application that you are running, is it 16-bit or 32-bit?  Also, which application did you install first? the Oracle8 or the listener?  You might try reloading listener first and then ORacle8.
0
 
LVL 1

Expert Comment

by:annu_vinayak
ID: 6489315
There is +vely a mistake in your tnsnames.ora file. Check all the entries, above all check the HOSTNAME, PROTOCOL  entries in the tnsnames.ora file.
0
 

Author Comment

by:dfell_us
ID: 6489390
I had to reinstall the Oracle 816 Personal Edition while connected to the network.  I gave the installation a different oracle home name so it would not interfere with previous installations.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question