Re: Dimension processing TNS Names do Not Resolve
- From: Pasha <Pasha@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 20 Dec 2007 19:01:00 -0800
Great suggestion by Christophe - helped me with a completely different issue!
--
Thanks,
Pasha
"MarkFrank" wrote:
Thanks Christophe,.
I believe the issue (now resolved) had to do with the location of my TNS
file and/or the SQLNet.ORA file. I had two client installations , Oracle 9.1
and 9.2 on my machine, one of which had the TNS and SQLNet located in the
usual path to Admin, the other did not. When I copied these files over the
identical location for both, everything turned out ok.
But the suggestion below is a good idea - it would have resolved my issue
yesterday.
Thanks again,
Mark
"Christophe Niel" wrote:
I hihgly recommend that you do not use the tnsnames in your db
configuration, but instead use the full oracle string in place of the tns
name alias
your tns files should look like that :
DEV1ORA=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev1ora.devlin.com)
)
)
so in the connectring you can use "(DESCRIPTION
=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST = localhost.localdomain)(PORT =
1521)))(CONNECT_DATA=(SERVICE_NAME=dev1ora.devlin.com)))"
for the data source.
if you do this you can prevent any error in the tnsnames.ora files, NTFS
right to the file (probably your problem) or changes made by sysadmin you
don't know about.
"MarkFrank" <MarkFrank@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3E6EAF73-F9B5-42B5-9656-220E187D0406@xxxxxxxxxxxxxxxx
Hi all,
I have an Analysis Services DSV that exposes an Oracle database in the
relational view. However, when I try to process a dimension it fails
giving
me the following
Errors in the high-level relational engine. The following exception
occurred
while the managed IDbConnection interface was being used: ORA-12154:
TNS:could not resolve service name
.
I have checked my TNS_NAMES file and confirmed the entry of the server,
and
ODBC connection also tested out ok. Does anyone have any ideas of how the
DSV does show the table underneath on the Oracle server, but doesn't
process
a dimension?
Thanks,
Mark
- References:
- Re: Dimension processing TNS Names do Not Resolve
- From: Christophe Niel
- Re: Dimension processing TNS Names do Not Resolve
- From: MarkFrank
- Re: Dimension processing TNS Names do Not Resolve
- Prev by Date: Basic .MDX "test" Question - Any takers?
- Next by Date: RE: Missing Aggregations
- Previous by thread: Re: Dimension processing TNS Names do Not Resolve
- Next by thread: Re: Unable to restore PDW.abf
- Index(es):
Relevant Pages
|
