Oracle Issue

I have a users that is trying to do the following:

“I am creating a Business Intelligence report using Reporting Services in Visual Studio.  The data source is coming from Oracle Database. I need the Oracle client component to connect to oracle.I have attached the screen print with the error message obtained when connecting to oracle using Microsoft Visual Studio 2010.”

The first error the user was getting was that the Oracle Client software needed to be installed. I installed this:

She is now getting an error:

ORA-12541 TNS :no listener

Everywhere I read, its stating to make sure the listener service is running. I’ve checked services and even the installation folders and don’t see anything relating to TNSListener. At this point im just spinning wheels and not sure if what I installed was the correct media.
Who is Participating?
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You've downloaded and installed the client-only part, hopefully.
The TNS listener is running on the remote, i.e. the database server. To connect to that, you have to either add an entry to the TNSNames.ora file on the client describing the connection data, or provide an EazyConnect String with the application.
EazyConnect looks like this:    servernameOrIP/instanceName
If the user has to stay with a simple connection name, e.g. BusinessIntelligence, the TNSNames.ora needs to get an entry like:
 BusinessIntelligence = servernameOrIP/instanceName
BusinessIntelligence = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = serernameOrIP)(PORT = 1521))(CONNECT_DATA = (service_name = instanceName)))

Open in new window

Ok you did install Oracle Database 11g Release 2 Client ( for Microsoft Windows (x64) ?
Now you need to customize the following configuration files:
%ORACLE_HOME%\network\Admin  <== path where you installed Oracle client
      sqlnet.ora         <= network info
      tnsnames.ora   <= alias to database

# sqlnet.ora Network Configuration File: 


Open in new window

# tnsnames.ora; database connections
     (ADDRESS = 
       (PROTOCOL = TCP)
       (HOST = myhost)
       (PORT = 1521)
      (CONNECT_DATA = 
        (SERVICE_NAME =

Open in new window

Good luck!
SBSWIZARDAuthor Commented:

Yes, I installed Oracle Database 11g Release 2 Client ( for Microsoft Windows (x64). It gave me an error that is needed to run in 32-bit, so I installed the 32 bit as well.

I looked in the install directory but do not see any of those config files.
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You can save yourself a lot of effort if you try to follow my advice. It is best to not having to use those files, but to provide all information with the connection string in the client.
Install directory: %ORACLE_HOME%
files are under: ..\network\Admin
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.