Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> putting an alias in my tnsnames for a change to report server

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

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 2 Jul 2002 10:49:30 -0700
Message-ID: <1efdad5b.0207020949.7fd2a1d9@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)

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 - 12:49:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US