Solved

TNSListener fails to start after Installing Oracle8i (8.1.6)

Posted on 2001-09-05
6
443 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Webinar: Security & Encryption in the MySQL world

Join Percona’s Solutions Engineer, Dimitri Vanoverbeke as he presents “Security and Encryption in the MySQL world” on Thursday, July 6, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7).

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
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…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

707 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