Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

TNSListener fails to start after Installing Oracle8i (8.1.6)

Posted on 2001-09-05
6
Medium Priority
?
451 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 100 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
Independent Software Vendors: 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
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…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

618 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