I successfully installed both Oracle Database 11g 64-bit and 32-bit on the same server machine. I can log in to...
both 64-bit and 32-bit instances directly. However, when going through TNS listener, only 64-bit works, as shown below:
- Sqlplus system/password@orc11g64: working
- Sqlplus system/password@orac11g32: ORA-12541 TNS:no listener
More on Oracle Database expert questions
Read all of Brian Peasland's expert answers
Send us your own expert question
I've done the following changes, to no avail:
- Change local_listener of 32-bit instance to default name LISTENER by: Alter system set local_listener=’’
- Change 32-bit instance listener.ora port to 1521
What do I need to do to make 32-bit Oracle 11g work with 64-bit TNS listener?
> ORA-12541 TNS:no listener
I'm not sure what the Transparent Network Substrate (TNS) definition for orac11g32 is, but the definition is pointing to a server that is not running any listener on that port. The session isn't yet to the point where it determines where the listener is. Verify that the TNS alias is pointing to a valid server with a listener on that port.
How to win the battle against common TNS errors
Dig Deeper on Oracle error messages
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.