Re: putting an alias in my tnsnames for a change to report server

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 3 Jul 2002 07:24:13 +1000
Message-ID: <aft5o1$e4p$1@lust.ihug.co.nz>

"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0207020949.7fd2a1d9_at_posting.google.com...
> I tried to add an alias to my tnsnames on both my oracle server and my
> developer server. This is what I added. Its not working.....
>
> Per note: 139546.1 at the end under known issues. It says to add an
> alias to my tnsnames to get around the issue with reports servers have
> numbers, etc... in its name.
>
> Here is the part of the tnsnames.ora file that has the instance that
> Im interested and what I added:
>
> APANDEV.MTMC.ARMY.MIL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 144.101.14.115)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = apandev.mtmc.army.mil)
> )
> )
>
> myserver Rep60_HQ73-dev6i=(ADDRESS=(PROTOCOL=tcp)(HOST=HQ73-dev6i)(PORT
> 1521)
>

I might be missing the point, but the syntax is just all over the place, isn't it. Were it to look like this:

MYSERVER=
(DESCRIPTION =

     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = HQ73-dev61)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = Rep60_HQ73-dev61)
     )

)

....then you might stand a chance.

However, since "it does not recognise this" is not a known Oracle error message, it's difficult to know for sure.

Regards
HJR
>
> There are 4-5 others instances listed in this tnsnames.. the
>
> Rep60_HQ73-dev6i comes directly out of my registry. What did I do
> wrong? It does not recognize this when I try to run the report with
> run_report_object?
Received on Tue Jul 02 2002 - 16:24:13 CDT