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

On 2 Jul 2002 10:49:30 -0700, rgaffuri_at_cox.net (Ryan Gaffuri) wrote:

>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)
>
>
>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?

The technical answer to your question has been answered. However, I would like to express some concern that you have exposed the IP address and other connect information of a military database. A good hacker (which I'm not) now knows the IP address, server DNS name, and listening port of a database server owned by the U.S. Army. Makes the hair stand up on the back of my neck.

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)