Solved

Oracle 11.2.0 Installation - ORA-12541: TNS:no listener

Posted on 2013-01-25
6
3,324 Views
Last Modified: 2013-01-31
Hi,

I have googled this error:  "ORA-12541: TNS:no listener" ---- and found many suggested solutions in forums but nothing has fixed my issue.
I've installed Oracle10g in the past and didn't have problems.  Not sure why it's an issue now.  I had to upgrade to receive dmps from oracle11.
I've tried 6 different Oracle installs and it's possible that installations are colliding.

I'm referencing my latest Oracle Installation:

Oracle Version:  11g Release 2 (11.2) for Microsoft Windows (32-Bit)

TOAD seems to be unable to cannot connect to 64bit database so I've used 32bit.

The goal:  install Oracle 11.2.0 and connect TOAD 11.0.0.116 to my local oracle database.

I have included 3 screenshots:
1) tnsnames.ora  
2) tnslistner.ora      
3) ToadHome Editor  - I am using my latest install named HOME2 but it's in the folder 11.2.0\dbhome_5

When I run the CMD:      c:\app\kkearney\product\11.2.0\dbhome_5\bin\lsnrctl start
it says listener has already been started.  

Environment Variables PATH:  C:\app\kkearney\product\11.2.0\dbhome_5\bin;C:\app\kkearney\product\11.2.0\dbhome_4\bin;

In TOAD I'm trying to login as User:  SYSTEM

I have tried many derivatives of this but nothing has worked.  Thanks for help in advance!

 Tnsnames
tnslistener
TOAD home
0
Comment
Question by:disbekearney
  • 2
  • 2
  • 2
6 Comments
 
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 325 total points
Comment Utility
first things first...

1. Check whether the database has been installed properly and is up and running


How to check this? logon to sqlplus from command prompt as

sqlplus "/ as sysdba"

if you get connected then we will go to listener part

do a tnsping of your local installed service

tnsping <database_sid> present in tnsnames.ora file of your installation..

if tnsping gets connected then we can check if your listener has got some problems in connecting..

also check out if this is the only database installed on that particular machine


check out these steps and get back with result...
0
 

Author Comment

by:disbekearney
Comment Utility
Hi thanks wasimibm!

sqlplus "/ as sysdba":    It says connected to an idle instance...

Unfortunately I replaced the installation tnsnames with an old tnsnames.  Is there another way I can find my SID?

I have 3 server databases installed and also a separate client db...
0
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 325 total points
Comment Utility
ok.. it means that your database is not up..

yes.. there's a way to find out..

just make sure that your database is up and running


for that after logging in as sysdba

execute this command

startup;

after it says database opened, execute this query to find the sid

select name from v$database

this would tell you to which instance you are connected on..

after that.. open up the tnsnames.ora and search for the database sid which you just found by the above query and after that give a username/<password>@tnsname entry of that database ..

this will help you to find out whether listener is up and running and is able to listen ..
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 175 total points
Comment Utility
>>it says listener has already been started.  

It is already running from one of the other homes.  Check the service that is running.  It will tell you what home to use.

>>TOAD seems to be unable to cannot connect to 64bit database so I've used 32bit.

TOAD will need the 32Bit client but it can connect to a 64Bit database.

>>dbhome_5

Looks like you have tried to install several times.

I suggest you remove all previous Oracle installs.  I suggest a manual remove:
Stop all Oracle services.
Delete the Oracle registry entries: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
Delete the Oracle services: HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services
also ControlSet002\Services

Delete the Oracle folder from under Program Files.
Delete all Oracle install folders (you might need to reboot to clean up the last few DLLs.

Then install the version you want to use.
0
 

Author Comment

by:disbekearney
Comment Utility
Thanks for the help so far, I'm going to deinstall my other oracle sessions and see if this then works but here is what it says with my 4 Oracle Installs still on the machine:

startup;

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_KEVIN9'
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>ORA-00132: syntax error or unresolved network name 'LISTENER_KEVIN9'

Likely looking at the wrong listener.ora file from the wrong ORACLE_HOME.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

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

11 Experts available now in Live!

Get 1:1 Help Now