Link to home
Start Free TrialLog in
Avatar of disbekearney
disbekearney

asked on

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

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!

 User generated image
User generated image
User generated image
SOLUTION
Avatar of Wasim Akram Shaik
Wasim Akram Shaik
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of disbekearney
disbekearney

ASKER

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...
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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'
>>ORA-00132: syntax error or unresolved network name 'LISTENER_KEVIN9'

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