Which Tnsnames.ora file uses BO?

Whoever

Administrator

Reputation: +34/-0
Offline

Offline

Posts: 124

Which Tnsnames.ora file uses BO?

« on: June 13, 2007, 01:00:20 pm »

Hi ,

I am using BO client ver 5.1.7 and it seems that I have several tnsnames.ora files in my computer and recently I have a server that changed it's IP addr

But I cannot tell exactly which tnsnames.ora that BO is referencing to, in the end I have to change each and every tnsnames.ora on my computer

Does anyone know where to find it out ?
I have checked the path in the CMD and changed the tnsnames.ora in the specified path but it does not seems to be using the one specifed in the PATH.

Please suggest.


	Logged

If most people said what’s on their minds, they’d be speechless.

Raj2007

DW Apprentice

Reputation: +3/-0
Offline

Offline

Posts: 25

Lightning for DW Forum

Re: Which Tnsnames.ora file uses BO?

« Reply #1 on: June 13, 2007, 08:21:48 pm »

Is it possible to have several Tnsnames.ra files in a single system.
I never came across this kind of problem.

According to my experience in database level, I think there will be only one Tnsnames.ora file for a database.
If my assumption is wrong, Please somebody share your answer.

Raj


« Last Edit: June 26, 2007, 11:55:14 am by Sipra »	Logged

Sipra

Founder

Reputation: +59/-0
Offline

Offline

Posts: 323

Am the King...

Type of error?

« Reply #2 on: June 26, 2007, 11:51:05 am »

Hi,

Let me know what type of error you are getting when you are trying to connect to BO.

Is it "ORA-12203" something like that or any other....

Quote from: Raj2007 on June 13, 2007, 08:21:48 pm

Is it possible to have several Tnsnames.ora files in a single system.

Raj

It is possible to have more than one Tnsnames.ora file on a single PC, when you have more than one database on it.


« Last Edit: June 26, 2007, 11:53:39 am by Sipra »	Logged

Sipra
Founder

www.dwforum.net

Pages: [1] Go Up

« previous next »