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:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

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.
SBSWIZARDAsked:
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
or
BusinessIntelligence = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = serernameOrIP)(PORT = 1521))(CONNECT_DATA = (service_name = instanceName)))

Open in new window

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

examples:
# sqlnet.ora Network Configuration File: 

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Open in new window

# tnsnames.ora; database connections
ORCL12=
   (DESCRIPTION =
     (ADDRESS = 
       (PROTOCOL = TCP)
       (HOST = myhost)
       (PORT = 1521)
      ) 
      (CONNECT_DATA = 
        (SERVICE_NAME = orcl12.mydomain.com)
      )
   )

Open in new window


Good luck!
0
 
SBSWIZARDAuthor Commented:
@MikeOM

Yes, I installed Oracle Database 11g Release 2 Client (11.2.0.1.0) 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.
0
 
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.
0
 
MikeOM_DBACommented:
Install directory: %ORACLE_HOME%
files are under: ..\network\Admin
0
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.