Q

Why won't TNS listener connect with Oracle Database 11g 32-bit?

One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g.

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:

  1. Sqlplus system/password@orc11g64: working
  2. 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:

  1. Change local_listener of 32-bit instance to default name LISTENER by: Alter system set local_listener=’’ 
  2. 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.

This was last published in September 2012

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

2 comments

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

Without your full set up, I'm just guessing, but...
If you did the normal setup, you set up separate sqlnet.ora, tnsnames.ora, and listener.ora files in each of the $ORACLE_HOME/network/admin directories. In doing so, it is likely that you're using the same IP and port numbers for your listener. When starting the listeners the first succedes, but the second would fail due to the ip:port combo already in use.
I made $OH/network/admin, in each OH, a link to a common directory elsewhere that had a copy of the original files, and put all my config files there. I have one listener handling both databases.

Mike
Cancel
your 32 bit running on 1521 bit .re-Run 32 bit service and see whether able to login r not
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close