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\dbhom e_5\bin\ls nrctl start
it says listener has already been started.
Environment Variables PATH: C:\app\kkearney\product\11 .2.0\dbhom e_5\bin;C: \app\kkear ney\produc t\11.2.0\d bhome_4\bi n;
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!
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
it says listener has already been started.
Environment Variables PATH: C:\app\kkearney\product\11
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!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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'
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.
Likely looking at the wrong listener.ora file from the wrong ORACLE_HOME.
ASKER
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...