[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 604
  • Last Modified:

tnanames.ora

Hi,

I intalled desktop version of Oracle9i.
I am not able to connect to oracle Database through connection (name in tnsnames.ora), from 3rd party application tool.
How to access the oracle database?

thanks
0
yr_k
Asked:
yr_k
  • 5
  • 2
  • 2
  • +5
1 Solution
 
musduCommented:
Hi,

which tool do you use? Can you connect to database using sql plus? to check accessibility of database use tnsping.exe. (it's under \bin folder)

tnsping yourdatabase

0
 
annamalai77Commented:
hi there

if ur trying to connect to oracle thru 3 rd part tool say thru ur VB or access, then create a system dsn.

remember to install the oracle ODBC driver. try to download it from www.oracle.com and then install it for the specific version of ur OS.

then create the dsn. find the connect string and use it to connect to ur oracle database.

regards
annamalai
0
 
andertstCommented:
In Windows, use the Network Assistant (or whatever they are calling it these days) to test connectivity to your database.  You need to have your listener running and know a username and password to test connectivity.

Stephen
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
aalapsharmaCommented:
Hello yr_k,

To connect to any database from Oracle 9i, you need to have one entry in tnsnames.ora.

Example:

# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

<connection_name> =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <SERVER_IP>)(PORT = <SERVER_PORT>))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = <SERVICE _NAME>/<SID>)
    )
  )

Aalap Sharma
0
 
tonster081498Commented:
Try patching your third party application tool...
0
 
yr_kAuthor Commented:
Hi,

entry in my tnsnames.ora is as follows.

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = toshiba-user)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)

I am able to connect to Oracle through SQL*Plus by using the connection name ORCL.

I want to connect through Bussiness Objects, which i can not able to.

0
 
aalapsharmaCommented:
Hello yr_k,

It might be possible that the third party application that you are using, is looking for the file tnsnames.ora at some different location.
You configure the application to search at the place where the file resides i.e.,
                            c:\oracle\ora92\network\admin\tnsnames.ora

Follow the rules of the application. Read the manual carefully for connection.

Aalap Sharma :)

0
 
andertstCommented:
Look for all copies of your tnsnames.ora on your hard drive.  Rename all of them to .old and put a copy of your "known good" tnsnames.ora in all those places.

Stephen
0
 
KtoshniCommented:
Hi, have you set up Business Objects tool to access Oracle? Do u have the license to access Oracle? How are you trying to access the database? Directly through free hand sql? Or through a universe?
0
 
tonster081498Commented:
I'm actually you can connect using that connect string in your tnsnames.ora file?

    (CONNECT_DATA =
      (SERVICE_NAME = SID
      SERVER = DEDICATED)
    )

You should probably be including the SERVICE_NAME paramater in the CONNECT_DATA area.  Also, you're missing closing brackets.

Also, try removing the SERVER=DEDICATED option.  It adds complication...
0
 
andertstCommented:
IMHO,

SERVER = DEDICATED might be a good idea if the DB is setup for MTS (Multi-Threaded Server) as that will rule
out MTS problems.

How many tnsnames.ora files did you find on yout hard drive?
0
 
andertstCommented:
What makes the difference between a moderator recommending an answer or answer split and recommending No Refund?  I think aalapsharma, annamalai77 and myself all pointed this user in the right direction.

Just wondering...
0
 
yr_kAuthor Commented:
Hi,

Actually there is no near by answer. I got the solution from my friends.
The solution is
1. Create Scheme in Oracle
2. Create Repository in Bussiness Objects
3. Connect through that connection name created while creating repository.

Anyhow thanks all for your efforts

regards

Ravi
0
 
Helena Markováprogrammer-analystCommented:
0
 
andertstCommented:
Henka,

Thanks.  I had not read that before.  That is a useful page.

Stephen
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 5
  • 2
  • 2
  • +5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now