Solved

TNSListener fails to start after Installing Oracle8i (8.1.6)

Posted on 2001-09-05
6
413 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
LDAP find expired users 8 73
MSSQL Convert Char To Date 4 54
Software (free or not) to catalog a collection of software and freeware 3 76
DBF to ... Converter 5 43
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
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…

895 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

18 Experts available now in Live!

Get 1:1 Help Now