Solved

TNSListener fails to start after Installing Oracle8i (8.1.6)

Posted on 2001-09-05
6
399 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Expert Comment

by:kimprasad
Comment Utility
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
Comment Utility
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
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Creating and Managing Databases with phpMyAdmin in cPanel.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
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…

771 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now