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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Qlemo"Batchelor", 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Qlemo"Batchelor", 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.